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.

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 pipe-separated payload (`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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Additional Columns

Outcome metadata

Question metadata

Resolution & Settlement

Market metadata

Sample Query

​Additional Columns

​Outcome metadata

​Question metadata

​Resolution & Settlement

​Market metadata

​Sample Query

Additional Columns

Outcome metadata

Question metadata

Resolution & Settlement

Market metadata

Sample Query