Skip to main content
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

Column NameDescription
coinHL-native side-token identifier (e.g. ‘#54760’).
outcome_idHIP-4 outcome ID.
token_side0 or 1.
side_labelDisplay label for this row’s token_side (e.g. ‘Yes’, ‘No’).
market_titleHuman-readable market title. Always non-null.
question_idParent question ID. NULL for Recurring / orphan outcomes.
question_nameQuestion name from the HL API.
is_winnerTrue for the winning side of a settled outcome. NULL while unsettled.
is_settledTrue once the outcome has been resolved.
market_statusOne of ‘active’, ‘closed’, ‘settled’.
timestampUTC timestamp of the fill.
unique_idDeterministic unique identifier per row.
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