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.assets.spot_balances_daily view contains daily Hyperliquid spot balances per (user, coin, token). Days where the balance is known to be zero are flagged via is_tombstone = true.
HIP-4 prediction-market positions are excluded — those are denominated in USDH and live in Hyperliquid Predictions.To filter to currently-positive balances use WHERE NOT is_tombstone. Use last_activity_timestamp rather than time_slice for freshness.

​
Table Columns

Column NameDescription
time_sliceCalendar day for this row.
userUser wallet address.
coinHyperliquid coin symbol.
tokenHyperliquid numeric token index.
timestampEnd-of-day timestamp (midnight TIMESTAMP_NTZ).
totalTotal balance for the day. ‘0’ on tombstone rows.
holdHeld (locked) balance. ‘0’ on tombstone rows.
entry_ntlEntry notional value. ‘0’ on tombstone rows.
last_activity_timestampSub-second timestamp of the most recent observed activity for this (user, coin, token).
is_tombstoneTrue when the balance for this day is known to be zero. Use WHERE NOT is_tombstone to filter to non-zero balances.
closure_tsFor tombstone rows, the earliest event timestamp at which the balance reached zero. NULL otherwise.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

SELECT
  time_slice,
  user,
  coin,
  total,
  is_tombstone
FROM hyperliquid.assets.spot_balances_daily
WHERE user = '<user_address_to_search>'
  AND time_slice >= CURRENT_DATE - 30
  AND NOT is_tombstone
ORDER BY time_slice DESC, coin
LIMIT 100