Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

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