hyperliquid.predictions.trades_enriched table contains every Hyperliquid HIP-4 prediction-market trade with outcome, question, and market-resolution context attached on each row. Useful when you want one row per trade with everything needed to filter or label.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.predictions.trades_enriched |
| Table Status | Beta 🌱 |
| Unique Key | transaction_hash, unique_id |
Every column from
hyperliquid.predictions.trades is available on this table. The columns documented below are the additions beyond the base trades view.Additional Columns
Outcome metadata
| Column Name | Description |
|---|---|
| side_label | Display label for this row’s token_side (e.g. ‘Yes’, ‘No’, or a categorical label). |
| token_name | The fee-token symbol form (e.g. ‘+5476’) used in fee_token for opens. |
| outcome_name | Outcome display name from the HL API. The literal string ‘Recurring’ marks HL’s auto-generated price-binary outcomes. |
| outcome_description | Outcome description as a JSON object. |
| is_recurring | True for HL’s auto-generated price-binary outcomes. |
| class | The market class for Recurring outcomes (e.g. ‘priceBinary’). NULL for non-Recurring outcomes. |
| underlying | The asset whose price the outcome resolves against (e.g. ‘HYPE’, ‘BTC’). NULL for non-Recurring outcomes. |
| target_price | The target price for Recurring outcomes. Stored as VARCHAR. token_side=0 resolves YES iff underlying price >= target_price at expiry; token_side=1 resolves YES iff price < target_price. NULL for non-Recurring outcomes. |
| period | The recurrence cadence (e.g. ‘15m’, ‘1h’, ‘1d’). NULL for non-Recurring outcomes. |
| expiry_ts | Resolution timestamp (UTC). NULL for non-Recurring outcomes. |
Question metadata
| Column Name | Description |
|---|---|
| question_id | Parent question ID. NULL for Recurring / orphan outcomes. |
| question_name | Question name from the HL API. |
| question_description | Question description as a JSON object. |
| is_named | True when this outcome is one of the parent question’s named outcomes. |
| is_fallback | True when this outcome is the parent question’s fallback outcome. |
Resolution & Settlement
| Column Name | Description |
|---|---|
| is_winner | True for the winning side of a settled outcome. NULL while unsettled. |
| is_settled | True once the outcome has been resolved on-chain. |
| settled_at | Settlement timestamp (UTC). NULL while unsettled. |
| resolution_outcome | The winning side_label when is_settled. |
Market metadata
| Column Name | Description |
|---|---|
| market_title | Human-readable market title; never null. |
| category | Market type. One of ‘price_binary’, ‘categorical’, ‘binary’. |
| sub_category | Underlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise. |
| market_status | One of ‘active’ (open), ‘closed’ (expired, awaiting settlement), ‘settled’ (resolved). |
| active | True when the market is currently open for trading. |
| closed | True when the market is no longer accepting new trades. |
Venue and titles
| Column Name | Description |
|---|---|
| venue | Venue identifier (for example txyz, out, skew). Null when not published. |
| quote_token | Quote token symbol. |
| template_id | Template identifier (for example binaryPrice). |
| resolved_market_title | Display title for the market. |
| resolved_side_label | Display label for this side. |
| resolved_question_title | Display title for the question. |
| resolved_outcome_name | Display name for the outcome. |
Sample Query
SELECT
timestamp,
venue,
resolved_market_title,
side_label,
size,
price,
usd_collateral_amount,
buyer_address,
seller_address
FROM hyperliquid.predictions.trades_enriched
WHERE timestamp >= CURRENT_DATE - 7
ORDER BY timestamp DESC
LIMIT 100
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| event_name | VARCHAR(16777216) | Name of the smart contract event that triggered this bridge record (e.g. Deposit, Send, TransferInitiated). |
| project | VARCHAR(16777216) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| exchange_type | VARCHAR(16777216) | Exchange type where the trade occurred. Examples include ‘CTFExchange’, ‘NegRiskCTFExchange’, ‘CTFExchangeV2’, ‘NegRiskCTFExchangeV2’, ‘ComboExchange’ (V3 combos), ‘FPMM’ |
| coin | VARCHAR(16777216) | Hyperliquid asset identifier: perpetual symbol (BTC), HIP-3 market (xyz:SP500), spot pair index (@107), or HIP-4 side-token (#11070). |
| encoding | NUMBER(38,0) | 10 * outcome_id + token_side. |
| outcome_id | NUMBER(38,0) | HIP-4 outcome ID. Repeated across the two token_side rows. |
| token_side | NUMBER(38,0) | 0 or 1. Together with outcome_id forms a unique key. |
| asset_id | NUMBER(38,0) | Identifier for an asset. On Stellar, this is the issuer:code composite identifier for non-native assets. On other chains, may be a contract address or other unique key. |
| side_label | VARCHAR(16777216) | Display label for this row’s token_side (e.g. ‘Yes’, ‘No’, or a categorical label). |
| token_name | VARCHAR(16777216) | The fee-token symbol form (e.g. ‘+5476’) used in fee_token for opens. |
| outcome_name | VARCHAR(16777216) | Outcome display name from the HL API. The literal string ‘Recurring’ marks HL’s auto-generated price-binary outcomes. |
| outcome_description | VARIANT | Outcome description as a JSON object. |
| is_recurring | BOOLEAN | True for HL’s auto-generated price-binary outcomes. |
| class | VARCHAR(16777216) | The market class for Recurring outcomes (e.g. ‘priceBinary’). NULL for non-Recurring outcomes. |
| underlying | VARCHAR(16777216) | The asset whose price the outcome resolves against (e.g. ‘HYPE’, ‘BTC’). NULL for non-Recurring outcomes. |
| target_price | VARCHAR(16777216) | The target price for Recurring outcomes. Stored as VARCHAR. token_side=0 resolves YES iff underlying price >= target_price at expiry; token_side=1 resolves YES iff price < target_price. NULL for non-Recurring outcomes. |
| period | VARCHAR(16777216) | The recurrence cadence (e.g. ‘15m’, ‘1h’, ‘1d’). NULL for non-Recurring outcomes. |
| expiry_ts | TIMESTAMP_NTZ(9) | Resolution timestamp (UTC). NULL for non-Recurring outcomes. |
| question_id | NUMBER(38,0) | Parent question ID. NULL for Recurring / orphan outcomes. |
| question_name | VARCHAR(16777216) | Question name from the HL API. |
| question_description | VARIANT | Question description as a JSON object. |
| is_named | BOOLEAN | True when this outcome is one of the parent question’s named outcomes. |
| is_fallback | BOOLEAN | True when this outcome is the parent question’s fallback outcome. |
| is_winner | BOOLEAN | True for the winning side of a settled outcome. NULL while unsettled. |
| is_settled | BOOLEAN | True once the outcome has been resolved on-chain. |
| settled_at | TIMESTAMP_NTZ(9) | Settlement timestamp (UTC). NULL while unsettled. |
| resolution_outcome | VARCHAR(16777216) | The winning side_label when is_settled. |
| market_title | VARCHAR(16777216) | Human-readable market title; never null. |
| category | VARCHAR(16777216) | Market type. One of ‘price_binary’, ‘categorical’, ‘binary’. |
| sub_category | VARCHAR(16777216) | Underlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise. |
| market_status | VARCHAR(16777216) | One of ‘active’ (open), ‘closed’ (expired, awaiting settlement), ‘settled’ (resolved). |
| active | BOOLEAN | True when the market is currently open for trading. |
| closed | BOOLEAN | True when the market is no longer accepting new trades. |
| venue | VARCHAR(16777216) | Venue identifier (for example txyz, out, skew). Null when not published. |
| quote_token | VARCHAR(16777216) | Quote token symbol. |
| template_id | VARCHAR(16777216) | Template identifier (for example binaryPrice). |
| resolved_market_title | VARCHAR(16777216) | Display title for the market. |
| resolved_side_label | VARCHAR(16777216) | Display label for this side. |
| resolved_question_title | VARCHAR(16777216) | Display title for the question. |
| resolved_outcome_name | VARCHAR(16777216) | Display name for the outcome. |
| maker_address | VARCHAR(16777216) | Address of the maker. I.e. users who add liquidity to the order books for NFT trades. |
| taker_address | VARCHAR(16777216) | Address of the taker. I.e. users who execute orders. |
| side_name | VARCHAR(16777216) | ‘BUY’ or ‘SELL’ (maker perspective). Null for FPMM. |
| buyer_order_id | VARCHAR(16777216) | The order ID for the buyer’s order. |
| seller_order_id | VARCHAR(16777216) | The order ID for the seller’s order. |
| buyer_twap_id | VARCHAR(16777216) | The TWAP order ID if the buyer’s order was a TWAP order. |
| seller_twap_id | VARCHAR(16777216) | The TWAP order ID if the seller’s order was a TWAP order. |
| trade_id | VARCHAR(16777216) | Unique identifier for the trade. |
| price | NUMBER(22,10) | Price per unit of the asset at the time of this event, in USD or in the quote token’s units depending on context. |
| size | NUMBER(22,10) | HIP-4 contract quantity. |
| collateral_token | VARCHAR(16777216) | HIP-4 settlement stable for the trade, derived from the fee token (settlement / synthetic-mint rows that carry no fee token inherit the day’s prevailing stable). Migrated from USDH to USDC ~2026-05-23; both peg to $1. |
| collateral_token_decimals | NUMBER(38,0) | Number of decimals for the collateral token |
| collateral_amount | NUMBER(38,10) | Normalized collateral amount (divided by token decimals) |
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. |
| usd_collateral_amount | FLOAT | USD value of the collateral amount |
| fee_token | VARCHAR(16777216) | The token in which fees were paid. |
| seller_fee_token | VARCHAR(16777216) | The token in which the seller paid fees. |
| buyer_fee_token | VARCHAR(16777216) | The token in which the buyer paid fees. Often differs from seller_fee_token on spot trades. NULL on the rare fallback path where a trade lands in raw.trades but not raw.fills — i.e. the rolling 1–2 h ingestion-lag window where raw.trades arrives ahead of raw.fills. Steady-state contribution is 0 rows/day (30 d historical audit); typical in-flight cohort is a few hundred rows that drain once fills catches up. |
| buyer_fee | NUMBER(22,10) | The fee paid by the buyer in fee_token units. |
| seller_fee | NUMBER(22,10) | The fee paid by the seller in fee_token units. |
| buyer_fee_usd | FLOAT | Total fee paid by the buyer in this trade, in USD. Hydrated against the buyer’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). |
| seller_fee_usd | FLOAT | Total fee paid by the seller in this trade, in USD. Hydrated against the seller’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). |
| tx_fee | NUMBER(38,10) | Total transaction fee for this trade in native token units (sum of buyer and seller fees). |
| tx_fee_usd | FLOAT | Total transaction fee for this trade in USD (sum of buyer_fee_usd and seller_fee_usd). |
| builder_fee | NUMBER(22,10) | Total builder fees paid on the trade (buyer + seller), in fee-token units (NOT USD). For HL native perps the fee token is USDC so the value is numerically ≈ USD; on HIP-3 non-USDC and HIP-4 markets the unit is the per-side fee token. For a hydrated USD view, sum buyer_builder_fee_usd + seller_builder_fee_usd from marts_hyperliquid_predictions__trades (HIP-4) or hydrate per row via the hourly token price feed. Negative values are rebates and only occur on maker fills. |
| buyer_builder_fee | NUMBER(22,10) | Builder fee paid by the buyer, in buyer_fee_token units (NOT USD). For a hydrated USD value see buyer_builder_fee_usd. |
| seller_builder_fee | NUMBER(22,10) | Builder fee paid by the seller, in seller_fee_token units (NOT USD). For a hydrated USD value see seller_builder_fee_usd. |
| buyer_builder_fee_usd | FLOAT | Buyer’s builder fee converted to USD by hydrating buyer_builder_fee against buyer_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. |
| seller_builder_fee_usd | FLOAT | Seller’s builder fee converted to USD by hydrating seller_builder_fee against seller_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. |
| buyer_builder_address | VARCHAR(16777216) | The builder address that received the buyer’s builder fee. |
| seller_builder_address | VARCHAR(16777216) | The builder address that received the seller’s builder fee. |
| buyer_dir | VARCHAR(16777216) | The direction of the buyer’s trade (e.g., Open Long, Close Short). |
| seller_dir | VARCHAR(16777216) | The direction of the seller’s trade (e.g., Open Long, Close Short). |
| is_synthetic_mint | BOOLEAN | True when the row originates from an unpaired single-side fill (synthetic mint, burn, or cross-coin pairing). |
| buyer_address | VARCHAR(16777216) | Address of the buyer in this NFT trade. |
| seller_address | VARCHAR(16777216) | Address of the seller in this NFT trade. |
| buyer_crossed | BOOLEAN | Whether the buyer’s order was crossed. |
| seller_crossed | BOOLEAN | Whether the seller’s order was crossed. |
| buyer_start_position | NUMBER(22,10) | The buyer’s position before this trade. |
| seller_start_position | NUMBER(22,10) | The seller’s position before this trade. |
| buyer_closed_pnl | NUMBER(22,10) | The closed PnL for the buyer from this trade in USD. |
| seller_closed_pnl | NUMBER(22,10) | The closed PnL for the seller from this trade in USD. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| collateral_token_decimals | NUMBER(38,0) | Number of decimals for the collateral token | ||
|---|---|---|---|---|
| collateral_amount | NUMBER(38,10) | Normalized collateral amount (divided by token decimals) | ||
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. | ||
| usd_collateral_amount | FLOAT | USD value of the collateral amount | ||
| fee_token | VARCHAR(16777216) | The token in which fees were paid. | ||
| seller_fee_token | VARCHAR(16777216) | The token in which the seller paid fees. | LOAT | USD value of the collateral amount |
| fee_token | VARCHAR(16777216) | The token in which fees were paid. | ||
| seller_fee_token | VARCHAR(16777216) | The token in which the seller paid fees. | ||
NULL on the rare fallback path where a trade lands in raw.trades but not raw.fills — i.e. the rolling 1–2 h ingestion-lag window where raw.trades arrives ahead of raw.fills. Steady-state contribution is 0 rows/day (30 d historical audit); typical in-flight cohort is a few hundred rows that drain once fills catches up. | ||||
| buyer_fee | NUMBER(22,10) | The fee paid by the buyer in fee_token units. | ||
| ---------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ||
| seller_fee | NUMBER(22,10) | The fee paid by the seller in fee_token units. | ||
| buyer_fee_usd | FLOAT | Total fee paid by the buyer in this trade, in USD. Hydrated against the buyer’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). | ||
| seller_fee_usd | FLOAT | Total fee paid by the seller in this trade, in USD. Hydrated against the seller’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). | ||
| tx_fee | NUMBER(38,10) | Total transaction fee for this trade in native token units (sum of buyer and seller fees). | ||
| tx_fee_usd | FLOAT | Total transaction fee for this trade in USD (sum of buyer_fee_usd and seller_fee_usd). | ||
| builder_fee | NUMBER(22,10) | Total builder fees paid on the trade (buyer + seller), in fee-token units (NOT USD). For HL native perps the fee token is USDC so the value is numerically ≈ USD; on HIP-3 non-USDC and HIP-4 markets the unit is the per-side fee token. For a hydrated USD view, sum buyer_builder_fee_usd + seller_builder_fee_usd from marts_hyperliquid_predictions__trades (HIP-4) or hydrate per row via the hourly token price feed. Negative values are rebates and only occur on maker fills. | ||
| buyer_builder_fee | NUMBER(22,10) | Builder fee paid by the buyer, in buyer_fee_token units (NOT USD). For a hydrated USD value see buyer_builder_fee_usd. | ||
| seller_builder_fee | NUMBER(22,10) | Builder fee paid by the seller, in seller_fee_token units (NOT USD). For a hydrated USD value see seller_builder_fee_usd. | ||
| buyer_builder_fee_usd | FLOAT | Buyer’s builder fee converted to USD by hydrating buyer_builder_fee against buyer_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| seller_builder_fee_usd | FLOAT | Seller’s builder fee converted to USD by hydrating seller_builder_fee against seller_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| buyer_builder_address | VARCHAR(16777216) | The builder address that received the buyer’s builder fee. | ||
| seller_builder_address | VARCHAR(16777216) | The builder address that received the seller’s builder fee. | ||
| buyer_dir | VARCHAR(16777216) | The direction of the buyer’s trade (e.g., Open Long, Close Short). | ||
| seller_dir | VARCHAR(16777216) | The direction of the seller’s trade (e.g., Open Long, Close Short). | ||
| is_synthetic_mint | BOOLEAN | True when the row originates from an unpaired single-side fill (synthetic mint, burn, or cross-coin pairing). | ||
| buyer_address | VARCHAR(16777216) | Address of the buyer in this NFT trade. | ||
| seller_address | VARCHAR(16777216) | Address of the seller in this NFT trade. | ||
| buyer_crossed | BOOLEAN | Whether the buyer’s order was crossed. | ||
| seller_crossed | BOOLEAN | Whether the seller’s order was crossed. | ||
| buyer_start_position | NUMBER(22,10) | The buyer’s position before this trade. | ||
| seller_start_position | NUMBER(22,10) | The seller’s position before this trade. | ||
| buyer_closed_pnl | NUMBER(22,10) | The closed PnL for the buyer from this trade in USD. | ||
| seller_closed_pnl | NUMBER(22,10) | The closed PnL for the seller from this trade in USD. | ||
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. | ||
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. | ||
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. | ||
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. | ||
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. | ||
| seller_builder_fee | NUMBER(22,10) | Builder fee paid by the seller, in seller_fee_token units (NOT USD). For a hydrated USD value see seller_builder_fee_usd. | ||
| buyer_builder_fee_usd | FLOAT | Buyer’s builder fee converted to USD by hydrating buyer_builder_fee against buyer_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| seller_builder_fee_usd | FLOAT | Seller’s builder fee converted to USD by hydrating seller_builder_fee against seller_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| buyer_builder_address | VARCHAR(16777216) | The builder address that received the buyer’s builder fee. | ||
| seller_builder_address | VARCHAR(16777216) | The builder address that received the seller’s builder fee. | ||
| buyer_dir | VARCHAR(16777216) | The direction of the buyer’s trade (e.g., Open Long, Close Short). | ||
| seller_dir | VARCHAR(16777216) | The direction of the seller’s trade (e.g., Open Long, Close Short). | ||
| is_synthetic_mint | BOOLEAN | True when the row originates from an unpaired single-side fill (synthetic mint, burn, or cross-coin pairing). | ||
| buyer_address | VARCHAR(16777216) | Address of the buyer in this NFT trade. | ||
| seller_address | VARCHAR(16777216) | Address of the seller in this NFT trade. | ||
| buyer_crossed | BOOLEAN | Whether the buyer’s order was crossed. | ||
| seller_crossed | BOOLEAN | Whether the seller’s order was crossed. | ||
| buyer_start_position | NUMBER(22,10) | The buyer’s position before this trade. | ||
| seller_start_position | NUMBER(22,10) | The seller’s position before this trade. | ||
| buyer_closed_pnl | NUMBER(22,10) | The closed PnL for the buyer from this trade in USD. | ||
| seller_closed_pnl | NUMBER(22,10) | The closed PnL for the seller from this trade in USD. | ||
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. | ||
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. | ||
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. | ||
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. | ||
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| collateral_token_decimals | NUMBER(38,0) | Number of decimals for the collateral token | ||
|---|---|---|---|---|
| collateral_amount | NUMBER(38,10) | Normalized collateral amount (divided by token decimals) | ||
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. | ||
| usd_collateral_amount | FLOAT | USD value of the collateral amount | ||
| fee_token | VARCHAR(16777216) | The token in which fees were paid. | ||
| seller_fee_token | VARCHAR(16777216) | The token in which the seller paid fees. | LOAT | USD value of the collateral amount |
| fee_token | VARCHAR(16777216) | The token in which fees were paid. | ||
| seller_fee_token | VARCHAR(16777216) | The token in which the seller paid fees. | ||
NULL on the rare fallback path where a trade lands in raw.trades but not raw.fills — i.e. the rolling 1–2 h ingestion-lag window where raw.trades arrives ahead of raw.fills. Steady-state contribution is 0 rows/day (30 d historical audit); typical in-flight cohort is a few hundred rows that drain once fills catches up. | ||||
| buyer_fee | NUMBER(22,10) | The fee paid by the buyer in fee_token units. | ||
| ---------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ||
| seller_fee | NUMBER(22,10) | The fee paid by the seller in fee_token units. | ||
| buyer_fee_usd | FLOAT | Total fee paid by the buyer in this trade, in USD. Hydrated against the buyer’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). | ||
| seller_fee_usd | FLOAT | Total fee paid by the seller in this trade, in USD. Hydrated against the seller’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). | ||
| tx_fee | NUMBER(38,10) | Total transaction fee for this trade in native token units (sum of buyer and seller fees). | ||
| tx_fee_usd | FLOAT | Total transaction fee for this trade in USD (sum of buyer_fee_usd and seller_fee_usd). | ||
| builder_fee | NUMBER(22,10) | Total builder fees paid on the trade (buyer + seller), in fee-token units (NOT USD). For HL native perps the fee token is USDC so the value is numerically ≈ USD; on HIP-3 non-USDC and HIP-4 markets the unit is the per-side fee token. For a hydrated USD view, sum buyer_builder_fee_usd + seller_builder_fee_usd from marts_hyperliquid_predictions__trades (HIP-4) or hydrate per row via the hourly token price feed. Negative values are rebates and only occur on maker fills. | ||
| buyer_builder_fee | NUMBER(22,10) | Builder fee paid by the buyer, in buyer_fee_token units (NOT USD). For a hydrated USD value see buyer_builder_fee_usd. | ||
| seller_builder_fee | NUMBER(22,10) | Builder fee paid by the seller, in seller_fee_token units (NOT USD). For a hydrated USD value see seller_builder_fee_usd. | ||
| buyer_builder_fee_usd | FLOAT | Buyer’s builder fee converted to USD by hydrating buyer_builder_fee against buyer_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| seller_builder_fee_usd | FLOAT | Seller’s builder fee converted to USD by hydrating seller_builder_fee against seller_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| buyer_builder_address | VARCHAR(16777216) | The builder address that received the buyer’s builder fee. | ||
| seller_builder_address | VARCHAR(16777216) | The builder address that received the seller’s builder fee. | ||
| buyer_dir | VARCHAR(16777216) | The direction of the buyer’s trade (e.g., Open Long, Close Short). | ||
| seller_dir | VARCHAR(16777216) | The direction of the seller’s trade (e.g., Open Long, Close Short). | ||
| is_synthetic_mint | BOOLEAN | True when the row originates from an unpaired single-side fill (synthetic mint, burn, or cross-coin pairing). | ||
| buyer_address | VARCHAR(16777216) | Address of the buyer in this NFT trade. | ||
| seller_address | VARCHAR(16777216) | Address of the seller in this NFT trade. | ||
| buyer_crossed | BOOLEAN | Whether the buyer’s order was crossed. | ||
| seller_crossed | BOOLEAN | Whether the seller’s order was crossed. | ||
| buyer_start_position | NUMBER(22,10) | The buyer’s position before this trade. | ||
| seller_start_position | NUMBER(22,10) | The seller’s position before this trade. | ||
| buyer_closed_pnl | NUMBER(22,10) | The closed PnL for the buyer from this trade in USD. | ||
| seller_closed_pnl | NUMBER(22,10) | The closed PnL for the seller from this trade in USD. | ||
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. | ||
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. | ||
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. | ||
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. | ||
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. | ||
| seller_builder_fee | NUMBER(22,10) | Builder fee paid by the seller, in seller_fee_token units (NOT USD). For a hydrated USD value see seller_builder_fee_usd. | ||
| buyer_builder_fee_usd | FLOAT | Buyer’s builder fee converted to USD by hydrating buyer_builder_fee against buyer_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| seller_builder_fee_usd | FLOAT | Seller’s builder fee converted to USD by hydrating seller_builder_fee against seller_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. | ||
| buyer_builder_address | VARCHAR(16777216) | The builder address that received the buyer’s builder fee. | ||
| seller_builder_address | VARCHAR(16777216) | The builder address that received the seller’s builder fee. | ||
| buyer_dir | VARCHAR(16777216) | The direction of the buyer’s trade (e.g., Open Long, Close Short). | ||
| seller_dir | VARCHAR(16777216) | The direction of the seller’s trade (e.g., Open Long, Close Short). | ||
| is_synthetic_mint | BOOLEAN | True when the row originates from an unpaired single-side fill (synthetic mint, burn, or cross-coin pairing). | ||
| buyer_address | VARCHAR(16777216) | Address of the buyer in this NFT trade. | ||
| seller_address | VARCHAR(16777216) | Address of the seller in this NFT trade. | ||
| buyer_crossed | BOOLEAN | Whether the buyer’s order was crossed. | ||
| seller_crossed | BOOLEAN | Whether the seller’s order was crossed. | ||
| buyer_start_position | NUMBER(22,10) | The buyer’s position before this trade. | ||
| seller_start_position | NUMBER(22,10) | The seller’s position before this trade. | ||
| buyer_closed_pnl | NUMBER(22,10) | The closed PnL for the buyer from this trade in USD. | ||
| seller_closed_pnl | NUMBER(22,10) | The closed PnL for the seller from this trade in USD. | ||
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. | ||
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. | ||
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. | ||
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. | ||
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| collateral_token_decimals | NUMBER(38,0) | Number of decimals for the collateral token |
|---|---|---|
| collateral_amount | NUMBER(38,10) | Normalized collateral amount (divided by token decimals) |
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. |
| usd_collateral_amount | FLOAT | USD value of the collateral amount |
| fee_token | VARCHAR(16777216) | The token in which fees were paid. |
| seller_fee_token | VARCHAR(16777216) | The token in which the seller paid fees. |
NULL on the rare fallback path where a trade lands in raw.trades but not raw.fills — i.e. the rolling 1–2 h ingestion-lag window where raw.trades arrives ahead of raw.fills. Steady-state contribution is 0 rows/day (30 d historical audit); typical in-flight cohort is a few hundred rows that drain once fills catches up. | ||
| buyer_fee | NUMBER(22,10) | The fee paid by the buyer in fee_token units. |
| ---------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| seller_fee | NUMBER(22,10) | The fee paid by the seller in fee_token units. |
| buyer_fee_usd | FLOAT | Total fee paid by the buyer in this trade, in USD. Hydrated against the buyer’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). |
| seller_fee_usd | FLOAT | Total fee paid by the seller in this trade, in USD. Hydrated against the seller’s fee_token (the HIP-4 settlement stable, USDH/USDC post the ~2026-05-23 cutover). |
| tx_fee | NUMBER(38,10) | Total transaction fee for this trade in native token units (sum of buyer and seller fees). |
| tx_fee_usd | FLOAT | Total transaction fee for this trade in USD (sum of buyer_fee_usd and seller_fee_usd). |
| builder_fee | NUMBER(22,10) | Total builder fees paid on the trade (buyer + seller), in fee-token units (NOT USD). For HL native perps the fee token is USDC so the value is numerically ≈ USD; on HIP-3 non-USDC and HIP-4 markets the unit is the per-side fee token. For a hydrated USD view, sum buyer_builder_fee_usd + seller_builder_fee_usd from marts_hyperliquid_predictions__trades (HIP-4) or hydrate per row via the hourly token price feed. Negative values are rebates and only occur on maker fills. |
| buyer_builder_fee | NUMBER(22,10) | Builder fee paid by the buyer, in buyer_fee_token units (NOT USD). For a hydrated USD value see buyer_builder_fee_usd. |
| seller_builder_fee | NUMBER(22,10) | Builder fee paid by the seller, in seller_fee_token units (NOT USD). For a hydrated USD value see seller_builder_fee_usd. |
| buyer_builder_fee_usd | FLOAT | Buyer’s builder fee converted to USD by hydrating buyer_builder_fee against buyer_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. |
| seller_builder_fee_usd | FLOAT | Seller’s builder fee converted to USD by hydrating seller_builder_fee against seller_fee_token via the hourly DEX token-prices feed (marts_hyperliquid_dex__token_prices_hourly). Per-side hydration — HIP-4 buyer/seller can pay in different tokens. |
| buyer_builder_address | VARCHAR(16777216) | The builder address that received the buyer’s builder fee. |
| seller_builder_address | VARCHAR(16777216) | The builder address that received the seller’s builder fee. |
| buyer_dir | VARCHAR(16777216) | The direction of the buyer’s trade (e.g., Open Long, Close Short). |
| seller_dir | VARCHAR(16777216) | The direction of the seller’s trade (e.g., Open Long, Close Short). |
| is_synthetic_mint | BOOLEAN | True when the row originates from an unpaired single-side fill (synthetic mint, burn, or cross-coin pairing). |
| buyer_address | VARCHAR(16777216) | Address of the buyer in this NFT trade. |
| seller_address | VARCHAR(16777216) | Address of the seller in this NFT trade. |
| buyer_crossed | BOOLEAN | Whether the buyer’s order was crossed. |
| seller_crossed | BOOLEAN | Whether the seller’s order was crossed. |
| buyer_start_position | NUMBER(22,10) | The buyer’s position before this trade. |
| seller_start_position | NUMBER(22,10) | The seller’s position before this trade. |
| buyer_closed_pnl | NUMBER(22,10) | The closed PnL for the buyer from this trade in USD. |
| seller_closed_pnl | NUMBER(22,10) | The closed PnL for the seller from this trade in USD. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of this record. Alias for block_timestamp used in tables where the column is named timestamp rather than block_timestamp. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |