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_hourly table contains an hourly price for every Hyperliquid HIP-4 side-token. One row per (block_hour, coin). Settled outcomes are excluded from the settlement hour onward.

​
Table Columns

Column NameDescription
projectAlways ‘hyperliquid’.
protocolAlways ‘hyperliquid_hip4’.
chainAlways ‘hyperliquid’.
block_hourHour 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 hour.
trade_countNumber of trades in the hour.
unique_idDeterministic unique identifier per row.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

SELECT
  block_hour,
  coin,
  side_label,
  last_price,
  vwap_price,
  trade_count
FROM hyperliquid.predictions.token_prices_hourly
WHERE block_hour >= CURRENT_DATE - 7
ORDER BY block_hour DESC, coin
LIMIT 200