hip4_hyperliquid.market_details

The hip4_hyperliquid.market_details table is the Hyperliquid HIP-4 market reference table. Grain: one row per market_id. Every market is a binary 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. Join hip4_hyperliquid.market_trades on market_id for its fills, or on outcome_id = yes_outcome_id / no_outcome_id for one side. Hyperliquid publishes most market descriptions as pipe-delimited key:value template parameters rather than prose. title and event_title are readable statements built from those parameters. The raw values are kept in template, description and template_fields.

Markets listed before the venue published a market registry have no name or description (template is null, so title is null too). They are real markets, not an ingestion gap.

Table Schema

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

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
WHERE status = 'active'
ORDER BY expected_expiration_time
LIMIT 20

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

hip4_hyperliquid.market_details

Table Schema

Table sample

Example query

​Table Schema

​Table sample

​Example query

Table Schema

Table sample

Example query