Trades Enriched 🌱

The 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 string. For Recurring outcomes this is a structured payload of class / underlying / expiry / targetPrice / period. For named outcomes this is free-form prose.
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 from the HL API.
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.

For all base trade columns (price, size, fees, counterparties, PnL, etc.) see Trades.

Sample Query

SELECT
  timestamp,
  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’, ‘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)	Label for this row’s token_side (e.g. ‘Yes’, ‘No’, ‘Hypurr’).
token_name	VARCHAR(16777216)	Full name of the token (e.g. “USD Coin”, “Wrapped Ether”).
outcome_name	VARCHAR(16777216)	Outcome display name from the API. The literal string ‘Recurring’ is HL’s marker for standalone price-binary outcomes (auto-generated, not part of a question). Named outcomes carry the human-readable label set by the question creator.
outcome_description	VARCHAR(16777216)	Raw description string from the API. For Recurring outcomes, this is a structured pipe-separated payload that gets parsed into the typed columns below (class, underlying, target_price, period, expiry_ts). Example: ‘class:priceBinary/underlying:HYPE/expiry:20260428-1430/targetPrice:37.86/period:15m’ For named outcomes, this is free-form prose.
is_recurring	BOOLEAN	True when outcome_name = ‘Recurring’ (HL’s auto-generated price-binary outcomes). False for named outcomes that belong to a question.
class	VARCHAR(16777216)	Parsed from the `class:` token in outcome_description. NULL for non-Recurring outcomes. Today only ‘priceBinary’ is observed.
underlying	VARCHAR(16777216)	Parsed from the `underlying:` token in outcome_description. The asset whose price the outcome resolves against (e.g. ‘HYPE’, ‘BTC’). NULL for non-Recurring outcomes.
target_price	VARCHAR(16777216)	Parsed from the `targetPrice:` token in outcome_description. Stored as varchar to preserve API precision. 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.
period	VARCHAR(16777216)	Parsed from the `period:` token in outcome_description. The recurrence cadence (e.g. ‘15m’, ‘1h’, ‘1d’). NULL for non-Recurring outcomes.
expiry_ts	TIMESTAMP_NTZ(9)	Parsed from the `expiry:` token (format YYYYMMDD-HHMI) in outcome_description. UTC. NULL for non-Recurring outcomes.
question_id	NUMBER(38,0)	Unique question identifier
question_name	VARCHAR(16777216)	Human-readable name of the prediction market question that groups its named outcomes (e.g. “Will BTC reach $100k?”). Null for standalone Recurring (price-binary) outcomes.
question_description	VARCHAR(16777216)	Market description from API
is_named	BOOLEAN	True when this outcome is in the parent question’s named_outcomes.
is_fallback	BOOLEAN	True when this outcome is the parent question’s fallback_outcome.
is_winner	BOOLEAN	Whether this outcome won the market
is_settled	BOOLEAN	True when contract_status is ‘settled’ or ‘resolved’. Derived from status, not from the source-of-origin row.
settled_at	TIMESTAMP_NTZ(9)	Earliest snapshot timestamp at which settled_named_outcomes became non-empty.
resolution_outcome	VARCHAR(16777216)	Market resolution outcome if resolved
market_title	VARCHAR(16777216)	Synthesized non-null human-readable title. Built from question_name + outcome_name + side_label for named outcomes; templated from parsed Recurring fields otherwise.
category	VARCHAR(16777216)	Category or classification label for this record. The specific taxonomy depends on the model context (e.g. token category, transfer category, metric category).
sub_category	VARCHAR(16777216)	Specific subcategory
market_status	VARCHAR(16777216)	Current market status.
active	BOOLEAN	Whether the market is accepting orders.
closed	BOOLEAN	Whether the market has closed.
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.
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 (UTC) when this row was first written to the Allium platform. Set once on insert and never changed.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration).

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Additional Columns

Outcome metadata

Question metadata

Resolution & Settlement

Market metadata

Sample Query

Table Columns

​Table Details

​Additional Columns

​Outcome metadata

​Question metadata

​Resolution & Settlement

​Market metadata

​Sample Query

​Table Columns

Table Details

Additional Columns

Outcome metadata

Question metadata

Resolution & Settlement

Market metadata

Sample Query

Table Columns