Open Interest Hourly 🌱 - Allium Documentation Hub

The hyperliquid.predictions.open_interest_hourly table contains supply-based open interest for every Hyperliquid HIP-4 side-token at hourly grain. One row per (block_hour, coin). Settled outcomes are excluded from the settlement hour onward.

Table Details

Property	Value
Table Name	`hyperliquid.predictions.open_interest_hourly`
Table Status	Beta 🌱
Unique Key	`block_hour`, `coin`

For per-user open interest see Open Interest Daily. When summing across YES + NO sides at the same outcome, prefer oi_usd — market_oi_usd and oi_tokens repeat their value on each side.

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Top-level project namespace (`hyperliquid`).
protocol	VARCHAR(16777216)	Protocol within the project (`hyperliquid_hip4`).
chain	VARCHAR(16777216)	The blockchain network (`hyperliquid`).
block_hour	TIMESTAMP_NTZ(9)	Hour bucket (UTC).
coin	VARCHAR(16777216)	HL-native side-token identifier (e.g. ‘#54760’).
encoding	NUMBER(38,0)	HL-canonical numeric encoding for the side-token.
outcome_id	NUMBER(38,0)	HIP-4 outcome identifier (shared by both token sides).
token_side	NUMBER(38,0)	Which side of the outcome’s YES/NO pair the row represents (0 or 1).
side_label	VARCHAR(16777216)	Display label for this row’s token_side (e.g. ‘Yes’, ‘No’).
oi_tokens	NUMBER(38,10)	Open interest in side-tokens for this coin.
holders	NUMBER(38,0)	Distinct users with a positive position on this side-token.
last_price	NUMBER(22,10)	Last observed price as a 0..1 probability.
oi_usd	FLOAT	USD value of the open interest on this coin.
market_oi_usd	FLOAT	Collateral locked at the outcome level, in USD. Repeats on both `token_side` rows of a given (block_hour, outcome_id).
outcome_name	VARCHAR(16777216)	Outcome display name from the HL API.
market_title	VARCHAR(16777216)	Human-readable market title.
category	VARCHAR(16777216)	Market type. One of ‘price_binary’, ‘categorical’, ‘binary’.
sub_category	VARCHAR(16777216)	Underlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise.
is_recurring	BOOLEAN	True for HL’s auto-generated price-binary outcomes.
question_id	NUMBER(38,0)	Parent question ID. NULL for Recurring / orphan outcomes.
question_name	VARCHAR(16777216)	Question name from the HL API.
is_winner	BOOLEAN	True for the winning side of a settled outcome. NULL while unsettled.
expiry_ts	TIMESTAMP_NTZ(9)	Resolution timestamp (UTC) for Recurring outcomes. NULL otherwise.
unique_id	VARCHAR(16777216)	Deterministic unique identifier per row.
_created_at	TIMESTAMP_NTZ(9)	Row creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Row last update timestamp.

Sample Query

SELECT
  block_hour,
  SUM(oi_usd) AS total_oi_usd
FROM hyperliquid.predictions.open_interest_hourly
WHERE block_hour >= CURRENT_DATE - 7
GROUP BY block_hour
ORDER BY block_hour DESC
LIMIT 100