Spot Balances EOD (Unhydrated)

The hyperliquid.unhydrated.spot_balances_eod table contains end-of-day spot balance snapshots for every (user, coin, token) on Hyperliquid. One row per (block_date, user, coin, token), keeping the last snapshot of the day.

This table includes every coin and token observed on the network, including leverage tokens (+N) and unregistered tokens. For a stablecoin-only view see Stablecoins / Spot Balances EOD.

Table Columns

Column Name	Description
block_date	Calendar date of the balance snapshot.
user	User wallet address.
coin	Hyperliquid coin symbol.
token	Hyperliquid numeric token index.
total	Total balance.
hold	Held (locked) balance.
entry_ntl	Entry notional value.
timestamp	Timestamp of the last snapshot taken on this day.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Sample Query

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

Transfers Perpetual Positions EOD (Unhydrated)

⌘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