Spot Balances Daily

HIP-4 prediction-market positions are excluded — those are denominated in USDH and live in Hyperliquid Predictions.To filter to currently-positive balances use WHERE NOT is_tombstone. Use last_activity_timestamp rather than time_slice for freshness.

Table Columns

Column Name	Description
time_slice	Calendar day for this row.
user	User wallet address.
coin	Hyperliquid coin symbol.
token	Hyperliquid numeric token index.
timestamp	End-of-day timestamp (midnight TIMESTAMP_NTZ).
total	Total balance for the day. ‘0’ on tombstone rows.
hold	Held (locked) balance. ‘0’ on tombstone rows.
entry_ntl	Entry notional value. ‘0’ on tombstone rows.
last_activity_timestamp	Sub-second timestamp of the most recent observed activity for this (user, coin, token).
is_tombstone	True when the balance for this day is known to be zero. Use `WHERE NOT is_tombstone` to filter to non-zero balances.
closure_ts	For tombstone rows, the earliest event timestamp at which the balance reached zero. NULL otherwise.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

SELECT time_slice, user, coin, total, is_tombstone FROM hyperliquid.assets.spot_balances_daily WHERE user = '<user_address_to_search>' AND time_slice >= CURRENT_DATE - 30 AND NOT is_tombstone ORDER BY time_slice DESC, coin LIMIT 100

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