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_eod table contains end-of-day spot balances for Hyperliquid stablecoin holders. One row per (block_date, user, coin, token).
This table covers stablecoin balances. Hyperliquid leverage tokens (coin identifiers matching +N such as +10, +20) are not in scope here.

​
Table Columns

Column NameDescription
block_dateCalendar date.
userUser wallet address.
coinHyperliquid coin symbol (e.g. ‘USDC’).
tokenHyperliquid numeric token index (e.g. 0 for USDC).
decimalsAlways 0 — Hyperliquid spot balances are already decimal-normalised.
total_strTotal balance as VARCHAR.
totalTotal balance as FLOAT. Already in human-readable units.
hold_balance_strHeld (locked) balance as VARCHAR.
holdHeld (locked) balance as FLOAT.
entry_ntl_strEntry notional value as VARCHAR.
entry_ntlEntry notional value as FLOAT.
timestampEnd-of-day timestamp.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

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