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

> Daily Hyperliquid spot balances for stablecoins.

The `hyperliquid.stablecoins.spot_balances_daily` view contains daily Hyperliquid stablecoin balances at end-of-day. One row per (timestamp, user, coin, token).

## Table Columns

| Column Name | Description                            |
| ----------- | -------------------------------------- |
| timestamp   | Day bucket (start of day, UTC).        |
| user        | User wallet address.                   |
| coin        | Hyperliquid coin symbol (e.g. 'USDC'). |
| token       | Hyperliquid numeric token index.       |
| total       | Total balance for the day.             |
| hold        | Held (locked) balance.                 |
| entry\_ntl  | Entry notional value.                  |

## Sample Query

```sql theme={null}
SELECT
  timestamp,
  user,
  coin,
  total
FROM hyperliquid.stablecoins.spot_balances_daily
WHERE timestamp >= CURRENT_DATE - 7
  AND coin = 'USDC'
ORDER BY timestamp DESC, total DESC
LIMIT 100
```