Spot Balances Daily

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 Name	Description
timestamp	Day bucket (start of day, UTC).
user	User wallet address.
coin	Hyperliquid coin symbol (e.g. ‘USDC’).
token	Hyperliquid numeric token index.
total	Total balance for the day.
hold	Held (locked) balance.
entry_ntl	Entry 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

Spot Balances EOD Supply Non-Circulating EOD

⌘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