Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The hyperliquid.predictions.open_interest_daily table contains one row per (day, user, coin) for every user holding a non-zero balance on a Hyperliquid HIP-4 side-token. Settled outcomes are excluded from the settlement day onward.
For supply-based, per-coin open interest at hourly grain see Open Interest Hourly.

​
Table Columns

Column NameDescription
projectAlways ‘hyperliquid’.
protocolAlways ‘hyperliquid_hip4’.
chainAlways ‘hyperliquid’.
dayDate bucket (UTC).
user_addressUser wallet address.
coinHL-native side-token identifier (e.g. ‘#54760’).
encodingHL-canonical numeric encoding for the side-token.
outcome_idHIP-4 outcome ID.
token_side0 or 1.
side_labelDisplay label for this row’s token_side (e.g. ‘Yes’, ‘No’).
token_balanceUser’s end-of-day balance in this side-token. Always positive.
last_priceLast observed price for the day as a 0..1 probability.
open_interest_usdUSD value of the user’s position on this coin. Safe to SUM across users / coins / days.
outcome_nameOutcome display name from the HL API.
market_titleHuman-readable market title.
categoryOne of ‘price_binary’, ‘categorical’, ‘binary’.
sub_categoryUnderlying asset for Recurring outcomes (e.g. ‘BTC’). NULL otherwise.
is_recurringTrue for HL’s auto-generated price-binary outcomes.
question_idParent question ID. NULL for Recurring / orphan outcomes.
question_nameQuestion name from the HL API.
event_tickerStable cross-side event identifier. Use for COUNT(DISTINCT) when reporting markets/events with OI.
is_winnerTrue for the winning side of a settled outcome. NULL while unsettled.
expiry_tsResolution timestamp (UTC) for Recurring outcomes. NULL otherwise.
unique_idDeterministic unique identifier per row.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

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