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_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.
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 NameDescription
projectAlways ‘hyperliquid’.
protocolAlways ‘hyperliquid_hip4’.
chainAlways ‘hyperliquid’.
block_hourHour bucket (UTC).
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’).
oi_tokensOpen interest in side-tokens for this coin.
holdersDistinct users with a positive position on this side-token.
last_priceLast observed price as a 0..1 probability.
oi_usdUSD value of the open interest on this coin. Safe to SUM across both sides of an outcome.
market_oi_usdUSDH locked at the outcome level. Repeats on both token_side rows of a given (block_hour, outcome_id).
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.
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
  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