> ## 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 per (user, coin, token).

The `hyperliquid.assets.spot_balances_daily` view contains daily Hyperliquid spot balances per (user, coin, token). Days where the balance is known to be zero are flagged via `is_tombstone = true`.

<Info>
  HIP-4 prediction-market positions are excluded — those are denominated in USDH and live in [Hyperliquid Predictions](/historical-data/supported-blockchains/hyperliquid/predictions/user-positions-daily).

  To filter to currently-positive balances use `WHERE NOT is_tombstone`. Use `last_activity_timestamp` rather than `time_slice` for freshness.
</Info>

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

## Sample Query

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