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.token_prices_daily table contains a daily price for every Hyperliquid HIP-4 side-token. One row per (day, coin). Settled outcomes are excluded from the settlement day onward.

​
Table Columns

Column NameDescription
projectAlways ‘hyperliquid’.
protocolAlways ‘hyperliquid_hip4’.
chainAlways ‘hyperliquid’.
dayDate bucket (UTC).
coinHL-native side-token identifier (e.g. ‘#54760’).
outcome_idHIP-4 outcome ID.
token_side0 or 1.
side_labelDisplay label for this row’s token_side (e.g. ‘Yes’, ‘No’).
last_priceLast observed price for the coin as a 0..1 probability. Resolves to 0 or 1 post-settlement.
vwap_priceVolume-weighted price across the day.
trade_countNumber of trades in the day.
unique_idDeterministic unique identifier per row.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

SELECT
  day,
  coin,
  side_label,
  last_price,
  vwap_price,
  trade_count
FROM hyperliquid.predictions.token_prices_daily
WHERE day >= CURRENT_DATE - 30
ORDER BY day DESC, coin
LIMIT 200