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.unhydrated.spot_balances_eod table contains end-of-day spot balance snapshots for every (user, coin, token) on Hyperliquid. One row per (block_date, user, coin, token), keeping the last snapshot of the day.
This table includes every coin and token observed on the network, including leverage tokens (+N) and unregistered tokens. For a stablecoin-only view see Stablecoins / Spot Balances EOD.

​
Table Columns

Column NameDescription
block_dateCalendar date of the balance snapshot.
userUser wallet address.
coinHyperliquid coin symbol.
tokenHyperliquid numeric token index.
totalTotal balance.
holdHeld (locked) balance.
entry_ntlEntry notional value.
timestampTimestamp of the last snapshot taken on this day.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

SELECT
  block_date,
  user,
  coin,
  total,
  hold
FROM hyperliquid.unhydrated.spot_balances_eod
WHERE block_date >= CURRENT_DATE - 7
ORDER BY block_date DESC, total DESC
LIMIT 100