> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Spot Balances EOD (Unhydrated)

> End-of-day Hyperliquid spot balance snapshots, unfiltered.

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.

<Info>
  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](/historical-data/supported-blockchains/hyperliquid/stablecoins/spot-balances-eod).
</Info>

## 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

```sql theme={null}
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
```