Skip to main content
The 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

Table sample

Example query

Active markets closest to expiry:

Previous version

Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.