hip4_hyperliquid.market_details table has one row per Hyperliquid HIP-4 market, unique on market_id. Every market is a Yes/No pair. Use this table to look up what a market asks, which event it belongs to, when it expires and how it settled. To get its trades, join hip4_hyperliquid.market_trades on market_id. For one side only, join outcome_id to yes_outcome_id or no_outcome_id.
Hyperliquid publishes most market descriptions as key:value fields separated by pipes, not as sentences. title and event_title turn those fields into readable text. The raw values are kept in template, description and template_fields.
Compared with v1, source_updated_at is removed. Use _updated_at instead.
Markets listed before Hyperliquid started publishing market names have no name or description:
template and title are null. They are real markets, not missing data.Table Schema
| Column | Type | Description |
|---|---|---|
market_id | VARCHAR | Market identifier. One binary Yes/No contract. |
event_id | VARCHAR | The event this market is one outcome of, where the venue groups markets into mutually exclusive sets. Null for a standalone market, and null while the venue has not published the grouping. |
yes_outcome_id | VARCHAR | Token that pays out when the market settles yes. Joins hip4_hyperliquid.market_trades on outcome_id. |
no_outcome_id | VARCHAR | Token that pays out when the market settles no. Joins hip4_hyperliquid.market_trades on outcome_id. |
title | VARCHAR | Readable one-line statement of what the market asks, composed from the venue’s parameters. Null where the venue published no name, where it published a template whose parameters are incomplete, and on the venue’s fallback templates, which carry no parameters at all. |
yes_outcome_name | VARCHAR | What the Yes side is called on this market — Yes on a plain binary, a team or a range on the others. |
no_outcome_name | VARCHAR | What the No side is called on this market. |
event_title | VARCHAR | Name of the event this market belongs to: composed from the venue’s parameters where the event is templated, otherwise the venue’s own name. Null for standalone markets. |
template_id | VARCHAR | Which of the venue’s market templates the market was created from, in the venue’s own spelling. manual on a hand-written market, fallback on an event’s catch-all outcome, recurring on a recurring market whose product the venue has not yet described. Null where the venue published no name. |
is_fallback | BOOLEAN | TRUE on an event’s fallback outcome, the venue’s catch-all for none of the named outcomes happening |
market_type | VARCHAR | standalone for a market that stands alone, question_outcome for one of the mutually exclusive outcomes of an event. |
is_mutually_exclusive_event | BOOLEAN | TRUE where the market is one outcome of an event whose outcomes are mutually exclusive: exactly one of them settles yes. FALSE for a standalone market, and where no grouping is known. |
event_outcome_count | INTEGER | How many named outcomes make up this market’s event, as the venue lists it. The event’s fallback outcome carries this event_id but is not counted. Null for a standalone market. |
outcome_position | INTEGER | The market’s published slot within its event, counting from 0. Null where the venue publishes no ordering, which is every event except the price-range ones. |
quote_token | VARCHAR | Stablecoin the market is collateralised and paid out in: USDC, or USDH on the earliest markets. Read from the payout once the market settles and from the venue’s listing before that. |
deployer | VARBINARY | Account that listed the market, or its event where the market is one of its outcomes. Null on markets the venue’s validators listed before permissionless listing existed. |
deployer_venue | VARCHAR | Namespace the deployer listed under. One account lists under one namespace; a namespace can hold several accounts. |
frequency | VARCHAR | Cadence of the recurring series this market is an instance of: fifteen_min, hourly, daily, weekly, monthly or annual. Null on one-off markets. |
underlying | VARCHAR | Symbol the market settles against, on markets that resolve off a price. Null on every other kind. |
underlying_dex | VARCHAR | Builder venue listing the underlying, where it is not a first-party Hyperliquid market. Null on first-party underlyings and on markets that do not resolve off a price. |
strike_type | VARCHAR | How the market’s strike is read: greater_or_equal and greater resolve yes above the floor, less below the cap, between inside the two, structured for markets settled on an identity rather than a number, custom for everything else. Null where the venue published no metadata. |
floor_strike | DOUBLE | Lower bound of the range the market resolves yes in, in the units of underlying. Null where the market is open below its cap, and on markets with no numeric strike. |
cap_strike | DOUBLE | Upper bound of the range the market resolves yes in, in the units of underlying. Null where the market is open above its floor, and on markets with no numeric strike. |
observation_seconds | INTEGER | How long the underlying has to hold the strike for the market to resolve yes. Null where resolution is a single reading rather than a sustained one. |
listed_at | TIMESTAMP | Earliest the venue is known to have listed the market: its registration where that is published, otherwise its first appearance in the registry, in a trader action or in a settlement. A member created with its question is dated by the question; one added to an existing question later is dated by its own registration. Not its first trade, which can come earlier on markets whose registration the venue does not publish. |
scheduled_start_time | TIMESTAMP | When the underlying event is scheduled to begin, on markets whose subject has a start time. |
expected_expiration_time | TIMESTAMP | When the market is due to stop trading and resolve. Null where the venue published no deadline. |
status | VARCHAR | active while the market is open, closed once its expiration has passed without the venue recording a settlement, settled once it has. A market that expired with no open positions still settles: the venue records the result even when there is nothing to pay out. |
result | VARCHAR | How the market settled: yes, no, void where both sides were paid equally, scalar where the payout is a fraction. Null until it settles. |
settlement_value_usd | DOUBLE | What one Yes token paid, in the market’s quote stablecoin, on a 0 to 1 scale. Null until the market settles. |
settlement_details | VARCHAR | The reference value the venue settled on, where it published one. |
settlement_ts | TIMESTAMP | When the market settled: the payout where anyone held a token, otherwise the venue’s settlement instruction. Null until it settles. |
settlement_block_number | BIGINT | Block the payout was made in. Null until the market settles, and on a market that settled with no holder to pay. |
category | VARCHAR | Unified prediction-market category, one of sports, crypto, politics, finance, technology, culture, weather, world, health, other. other where the venue’s descriptors do not place the market. |
category_native | ARRAY(VARCHAR) | The venue’s own descriptors for this market, as published |
template | VARCHAR | The venue’s name for the market. On templated markets this is the template label rather than a readable question; title is the readable form. |
description | VARCHAR | The venue’s description, verbatim. Templated markets carry pipe-delimited key:value parameters rather than prose. |
event_description | VARCHAR | Description of the event this market belongs to. Templated events carry pipe-delimited key:value parameters rather than prose. Null where the venue has published neither the event’s registration nor its settlement. |
template_fields | MAP(VARCHAR, VARCHAR) | The market’s template parameters as a key to value map. Empty where the description is prose or absent. |
event_template_fields | MAP(VARCHAR, VARCHAR) | The event’s template parameters as a key to value map. Empty where the event has no templated description. |
_updated_at | TIMESTAMP | When the row was last written by the pipeline |
Table sample
Example query
Active markets closest to expiry:SELECT
market_id,
event_title,
title,
yes_outcome_name,
no_outcome_name,
category,
expected_expiration_time
FROM hip4_hyperliquid.market_details_v2
WHERE status = 'active'
ORDER BY expected_expiration_time
LIMIT 20
Previous version
Previous version (v1)
Previous version (v1)
Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.
| Column | Type | Description |
|---|---|---|
market_id | VARCHAR | Market identifier (Hyperliquid’s outcome index). One binary Yes/No contract |
event_id | VARCHAR | Event this market is one outcome of, where the venue groups markets into mutually exclusive sets. NULL for standalone markets and while the venue has not published the grouping |
yes_outcome_id | VARCHAR | Token that pays out when the market settles yes. Joins market_trades.outcome_id |
no_outcome_id | VARCHAR | Token that pays out when the market settles no. Joins market_trades.outcome_id |
title | VARCHAR | Readable one-line statement of what the market asks, built from the venue’s parameters. NULL where the venue published no name, incomplete parameters, or a fallback template |
yes_outcome_name | VARCHAR | What the Yes side is called: Yes on a plain binary, a team or range on others |
no_outcome_name | VARCHAR | What the No side is called |
event_title | VARCHAR | Name of the event this market belongs to. NULL for standalone markets |
template_id | VARCHAR | Venue template the market was created from (e.g. priceBinary, priceTouch, sportsTournamentParticipant). manual for hand-written markets, fallback for an event’s catch-all outcome, recurring for a recurring market the venue has not yet described. NULL where the venue published no name |
is_fallback | BOOLEAN | TRUE on an event’s fallback outcome, which settles yes when none of the named outcomes happens |
market_type | VARCHAR | standalone or question_outcome (one of the mutually exclusive outcomes of an event) |
is_mutually_exclusive_event | BOOLEAN | TRUE where exactly one of the event’s outcomes settles yes. FALSE for standalone markets and where no grouping is known |
event_outcome_count | INTEGER | Number of named outcomes in the event, excluding the fallback outcome. NULL for standalone markets |
outcome_position | INTEGER | Published slot within the event, counting from 0. Only set on price-range events |
quote_token | VARCHAR | Stablecoin the market is collateralised and paid out in: USDC, or USDH on the earliest markets |
deployer | VARBINARY | Account that listed the market (or its event). NULL on markets listed by validators before permissionless listing |
deployer_venue | VARCHAR | Namespace the deployer listed under |
frequency | VARCHAR | Cadence of a recurring series: fifteen_min, hourly, daily, weekly, monthly, annual. NULL on one-off markets |
underlying | VARCHAR | Symbol the market settles against, on price-based markets |
underlying_dex | VARCHAR | HIP-3 builder dex listing the underlying, where it is not a first-party Hyperliquid market |
strike_type | VARCHAR | How the strike is read: greater, greater_or_equal, less, less_or_equal, between, structured, custom |
floor_strike | DOUBLE | Lower bound of the range the market resolves yes in, in units of underlying |
cap_strike | DOUBLE | Upper bound of the range the market resolves yes in, in units of underlying |
observation_seconds | INTEGER | How long the underlying must hold the strike to resolve yes. NULL where resolution is a single reading |
listed_at | TIMESTAMP | Earliest the venue is known to have listed the market (registration, or first appearance in the registry, a trader action, or a settlement). Not the first trade |
scheduled_start_time | TIMESTAMP | When the underlying event is scheduled to begin, where applicable |
expected_expiration_time | TIMESTAMP | When the market is due to stop trading and resolve |
status | VARCHAR | active while open, closed once expiration passed without a recorded settlement, settled once settled |
result | VARCHAR | yes, no, void (both sides paid equally), or scalar (fractional payout). NULL until settled |
settlement_value_usd | DOUBLE | What one Yes token paid, on a 0 to 1 scale. NULL until settled |
settlement_details | VARCHAR | Reference value the venue settled on, where published |
settlement_ts | TIMESTAMP | When the market settled. NULL until settled |
settlement_block_number | BIGINT | Block the payout was made in. NULL until settled, and on markets settled with no holder to pay |
category | VARCHAR | Unified prediction-market category: sports, crypto, politics, finance, technology, culture, weather, world, health, other |
category_native | ARRAY(VARCHAR) | The venue’s own descriptors for the market |
template | VARCHAR | The venue’s name for the market. On templated markets this is the template label; title is the readable form |
description | VARCHAR | The venue’s description, verbatim. Templated markets carry pipe-delimited key:value parameters |
event_description | VARCHAR | Description of the parent event, verbatim |
template_fields | MAP(VARCHAR, VARCHAR) | The market’s template parameters as a key-value map |
event_template_fields | MAP(VARCHAR, VARCHAR) | The event’s template parameters as a key-value map |
source_updated_at | TIMESTAMP | Latest the venue changed anything this row reports |
_updated_at | TIMESTAMP | When this row was last written by the pipeline |