Spot Balances Latest

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 Name	Description
user	User wallet address.
coin	Hyperliquid coin symbol.
token	Hyperliquid numeric token index.
total	Total balance. Always positive.
hold	Held (locked) balance.
entry_ntl	Entry notional value.
last_activity_timestamp	Sub-second timestamp of the most recent observed activity for this (user, coin, token).
block_date	Calendar date for this row (midnight UTC).
_created_at	Row creation timestamp.
_updated_at	Row 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

Staking 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