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_latest view contains the latest spot balance per (user, coin, token) on Hyperliquid. Every row represents a currently-positive balance.
HIP-4 prediction-market positions are not in scope here — those are denominated in USDH and live in Hyperliquid Predictions.Use last_activity_timestamp for freshness checks.

​
Table Columns

Column NameDescription
userUser wallet address.
coinHyperliquid coin symbol.
tokenHyperliquid numeric token index.
totalTotal balance. Always positive.
holdHeld (locked) balance.
entry_ntlEntry notional value.
last_activity_timestampSub-second timestamp of the most recent observed activity for this (user, coin, token).
block_dateCalendar date for this row (midnight UTC).
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

SELECT
  user,
  coin,
  total,
  hold,
  last_activity_timestamp
FROM hyperliquid.assets.spot_balances_latest
WHERE coin = 'USDC'
ORDER BY total DESC
LIMIT 100