| project | Top-level project namespace (hyperliquid). |
| protocol | Protocol within the project (hyperliquid_hip4). |
| chain | The blockchain network (hyperliquid). |
| block_hour | Hour bucket (UTC). |
| coin | HL-native side-token identifier (e.g. ‘#54760’). |
| encoding | HL-canonical numeric encoding for the side-token. |
| outcome_id | HIP-4 outcome identifier (shared by both token sides). |
| token_side | Which side of the outcome’s YES/NO pair the row represents (0 or 1). |
| side_label | Display label for this row’s token_side (e.g. ‘Yes’, ‘No’). |
| oi_tokens | Open interest in side-tokens for this coin. |
| holders | Distinct users with a positive position on this side-token. |
| last_price | Last observed price as a 0..1 probability. |
| oi_usd | USD value of the open interest on this coin. Safe to SUM across both sides of an outcome. |
| market_oi_usd | Collateral locked at the outcome level, in USD. Repeats on both token_side rows of a given (block_hour, outcome_id). |
| outcome_name | Outcome display name from the HL API. |
| market_title | Human-readable market title. |
| category | Market type. One of ‘price_binary’, ‘categorical’, ‘binary’. |
| sub_category | Underlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise. |
| is_recurring | True for HL’s auto-generated price-binary outcomes. |
| question_id | Parent question ID. NULL for Recurring / orphan outcomes. |
| question_name | Question name from the HL API. |
| is_winner | True for the winning side of a settled outcome. NULL while unsettled. |
| expiry_ts | Resolution timestamp (UTC) for Recurring outcomes. NULL otherwise. |
| unique_id | Deterministic unique identifier per row. |
| _created_at | Row creation timestamp. |
| _updated_at | Row last update timestamp. |
