Open Interest Daily

For supply-based, per-coin open interest at hourly grain see Open Interest Hourly.

Table Columns

Column Name	Description
project	Top-level project namespace (`hyperliquid`).
protocol	Protocol within the project (`hyperliquid_hip4`).
chain	The blockchain network (`hyperliquid`).
day	Date bucket (UTC).
user_address	User wallet address.
coin	HL-native side-token identifier (e.g. ‘#54760’).
encoding	HL-canonical numeric encoding for the side-token.
outcome_id	HIP-4 outcome identifier (shared by both token sides).
token_side	Which side of the outcome’s YES/NO pair the row represents (0 or 1).
side_label	Display label for this row’s token_side (e.g. ‘Yes’, ‘No’).
token_balance	User’s end-of-day balance in this side-token. Only non-zero (positive) holdings are included.
last_price	Last observed price for the day as a 0..1 probability.
open_interest_usd	USD value of the user’s position on this coin. Safe to SUM across users / coins / days.
outcome_name	Outcome display name from the HL API.
market_title	Human-readable market title.
category	Market type. One of ‘price_binary’, ‘categorical’, ‘binary’.
sub_category	Underlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise.
is_recurring	True for HL’s auto-generated price-binary outcomes.
question_id	Parent question ID. NULL for Recurring / orphan outcomes.
question_name	Question name from the HL API.
event_ticker	Stable cross-side event identifier. Use for COUNT(DISTINCT) when reporting markets/events with OI.
is_winner	True for the winning side of a settled outcome. NULL while unsettled.
expiry_ts	Resolution timestamp (UTC) for Recurring outcomes. NULL otherwise.
unique_id	Deterministic unique identifier per row.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

SELECT day, SUM(open_interest_usd) AS total_oi_usd, COUNT(DISTINCT user_address) AS holders, COUNT(DISTINCT event_ticker) AS markets_with_oi FROM hyperliquid.predictions.open_interest_daily WHERE day >= CURRENT_DATE - 30 GROUP BY day ORDER BY day DESC

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query