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