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

> End-of-day Hyperliquid spot balances for stablecoins.

The `hyperliquid.stablecoins.spot_balances_eod` table contains end-of-day spot balances for Hyperliquid stablecoin holders. One row per (block\_date, user, coin, token).

<Info>
  This table covers stablecoin balances. Hyperliquid leverage tokens (coin identifiers matching `+N` such as `+10`, `+20`) are not in scope here.
</Info>

## Table Columns

| Column Name        | Description                                                          |
| ------------------ | -------------------------------------------------------------------- |
| block\_date        | Calendar date.                                                       |
| user               | User wallet address.                                                 |
| coin               | Hyperliquid coin symbol (e.g. 'USDC').                               |
| token              | Hyperliquid numeric token index (e.g. 0 for USDC).                   |
| decimals           | Always 0 — Hyperliquid spot balances are already decimal-normalised. |
| total\_str         | Total balance as VARCHAR.                                            |
| total              | Total balance as FLOAT. Already in human-readable units.             |
| hold\_balance\_str | Held (locked) balance as VARCHAR.                                    |
| hold               | Held (locked) balance as FLOAT.                                      |
| entry\_ntl\_str    | Entry notional value as VARCHAR.                                     |
| entry\_ntl         | Entry notional value as FLOAT.                                       |
| timestamp          | End-of-day timestamp.                                                |
| \_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.stablecoins.spot_balances_eod
WHERE block_date >= CURRENT_DATE - 7
  AND coin = 'USDC'
ORDER BY block_date DESC, total DESC
LIMIT 100
```