Spot Balances EOD

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 Name	Description
block_date	Calendar date.
user	User wallet address.
coin	Hyperliquid coin symbol (e.g. ‘USDC’).
token	Hyperliquid numeric token index (e.g. 0 for USDC).
decimals	Always 0 — Hyperliquid spot balances are already decimal-normalised.
total_str	Total balance as VARCHAR.
total	Total balance as FLOAT. Already in human-readable units.
hold_balance_str	Held (locked) balance as VARCHAR.
hold	Held (locked) balance as FLOAT.
entry_ntl_str	Entry notional value as VARCHAR.
entry_ntl	Entry notional value as FLOAT.
timestamp	End-of-day timestamp.
_created_at	Row creation timestamp.
_updated_at	Row 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

Summaries Daily Spot Balances Daily

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query