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. 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.
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.

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

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)	HL-canonical numeric encoding for the side-token.
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. 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.
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 stablecoin for the trade. 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. May be NULL for a small number of trades from the last 1-2 hours; these fill in once the fee details are available.
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. The fee token is the HIP-4 settlement stablecoin (USDH, or USDC after the ~2026-05-23 cutover).
seller_fee_usd	FLOAT	Total fee paid by the seller in this trade, in USD. The fee token is the HIP-4 settlement stablecoin (USDH, or USDC after 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 HIP-4 USD values use `buyer_builder_fee_usd` + `seller_builder_fee_usd` in `hyperliquid.predictions.trades`. 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 the 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 the USD value see `seller_builder_fee_usd`.
buyer_builder_fee_usd	FLOAT	Buyer’s builder fee in USD, valued in the buyer’s fee token. HIP-4 buyer and seller can pay in different tokens.
seller_builder_fee_usd	FLOAT	Seller’s builder fee in USD, valued in the seller’s fee token. HIP-4 buyer and 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 is a synthetic mint, burn, or cross-coin pairing rather than a two-sided trade in a single side-token.
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.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

Table Details

Additional Columns

Outcome metadata

Question metadata

Resolution & Settlement

Market metadata

Venue and titles

Sample Query

Table Columns

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

​Table Details

​Additional Columns

​Outcome metadata

​Question metadata

​Resolution & Settlement

​Market metadata

​Venue and titles

​Sample Query

​Table Columns

Table Details

Additional Columns

Outcome metadata

Question metadata

Resolution & Settlement

Market metadata

Venue and titles

Sample Query

Table Columns