Skip to main content
The hip4_hyperliquid.ohlcv_hourly table holds hourly price candles (open, high, low, close and volume) for Hyperliquid HIP-4 markets. It has one row per (hour, market_id, outcome_id), unique on (block_month, hour, market_id, outcome_id). The Yes and No sides of a market each have their own candle, because each side trades on its own order book. Filter outcome_index = 0 for the Yes series. An hour without trades gets a flat bar at the last close, with zero volume and trade_count and is_forward_filled = TRUE. Some bars have real prices but zero volume: in those hours the side only traded as the resting order in a match against the other side. Use is_forward_filled to tell filled-in bars from real ones. Settlement. When a market settles, the bar in its settlement hour closes at what that side paid: 1 on the winning token, 0 on the losing one, or the fraction on a scalar market. high and low stretch to include it. No flat bars are added after that bar, and real trades after settlement keep their actual prices. Until a market settles, its candles run to its expected expiration. Compared with v1, market_end_time is removed. For settlement_ts and expected_expiration_time, join hip4_hyperliquid.market_details on market_id.
market_outcome shows the state at the time of each bar. The other market columns, such as market_name and category, keep the values they had when the bar was written. For a market’s current state, use hip4_hyperliquid.market_details.

Table Schema

Table sample

Query performance

The table is partitioned by block_month. Always filter on block_month or hour.

Example query

Hourly Yes price path for a single market:

Previous version

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