hip4_hyperliquid.open_interest_hourly

The hip4_hyperliquid.open_interest_hourly table provides hourly open interest and traded volume per Hyperliquid HIP-4 market. Grain: one row per (hour, market_id), with a row for every hour from the market’s first activity to its settlement. Open interest is a level at the end of the hour; volume is the flow within it. Open interest is built from the full token ledger (trades, splits, merges, negations and settlements) and excludes the venue’s settlement counterparty. It is counted per side. On standalone markets the Yes and No sides are equal. On event members they can diverge once No tokens are converted into Yes tokens of sibling outcomes. event_oi_contracts gives the collateral locked behind the whole event.

event_oi_contracts is repeated on every member row of an event. Summing it across members overstates event open interest. Take it once per event_id and hour.

Per-token prices are in hip4_hyperliquid.ohlcv_hourly.

Table Schema

Column	Type	Description
`block_month`	`DATE`	First day of the UTC month of `hour`. Partition key
`hour`	`TIMESTAMP`	UTC hour the figures describe. Open interest is the level at the end of it, volume the flow within it
`market_id`	`VARCHAR`	Market identifier. Joins `hip4_hyperliquid.market_details`
`event_id`	`VARCHAR`	Event this market is one outcome of. NULL for standalone markets and where the venue has not published the grouping
`market_oi_yes_contracts`	`DOUBLE`	Yes tokens outstanding at the end of the hour. Zero once the market settles and every holder has been paid
`market_oi_no_contracts`	`DOUBLE`	No tokens outstanding at the end of the hour. Equal to the Yes side except on event members
`event_oi_contracts`	`DOUBLE`	Collateral locked behind the market’s event: the Yes tokens of one member plus the No tokens of every other member. Equal to the Yes side on a standalone market. One contract pays 1 unit of the quote stablecoin
`volume_contracts`	`DOUBLE`	Outcome tokens traded in the hour, both sides together, each match counted once
`volume_usd`	`DOUBLE`	Cash traded in the hour in the quote stablecoin, each match counted once from the aggressor’s side
`trade_count`	`BIGINT`	Matches in the hour, both sides together
`_updated_at`	`TIMESTAMP`	When this row was last written by the pipeline

Table sample

Query performance

block_month is the partition key. Always include a block_month or hour filter.

Example query

-- Standalone markets with the most open interest at the latest hour
SELECT
  o.market_id,
  m.title,
  o.market_oi_yes_contracts,
  o.volume_usd
FROM hip4_hyperliquid.open_interest_hourly o
JOIN hip4_hyperliquid.market_details m
  ON m.market_id = o.market_id
WHERE o.block_month = DATE_TRUNC('month', CURRENT_DATE)
  AND o.hour = (
    SELECT MAX(hour)
    FROM hip4_hyperliquid.open_interest_hourly
    WHERE block_month = DATE_TRUNC('month', CURRENT_DATE)
  )
  AND m.market_type = 'standalone'
ORDER BY o.market_oi_yes_contracts DESC
LIMIT 20

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

hip4_hyperliquid.open_interest_hourly

Table Schema

Table sample

Query performance

Example query

​Table Schema

​Table sample

​Query performance

​Example query

Table Schema

Table sample

Query performance

Example query