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.stablecoins.spot_balances_daily view contains daily Hyperliquid stablecoin balances at end-of-day. One row per (timestamp, user, coin, token).

​
Table Columns

Column NameDescription
timestampDay bucket (start of day, UTC).
userUser wallet address.
coinHyperliquid coin symbol (e.g. ‘USDC’).
tokenHyperliquid numeric token index.
totalTotal balance for the day.
holdHeld (locked) balance.
entry_ntlEntry notional value.

​
Sample Query

SELECT
  timestamp,
  user,
  coin,
  total
FROM hyperliquid.stablecoins.spot_balances_daily
WHERE timestamp >= CURRENT_DATE - 7
  AND coin = 'USDC'
ORDER BY timestamp DESC, total DESC
LIMIT 100