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

> Latest spot balance per (user, coin, token) on Hyperliquid.

The `hyperliquid.assets.spot_balances_latest` view contains the latest spot balance per (user, coin, token) on Hyperliquid. Every row represents a currently-positive balance.

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

  Use `last_activity_timestamp` for freshness checks.
</Info>

## Table Columns

| Column Name               | Description                                                                             |
| ------------------------- | --------------------------------------------------------------------------------------- |
| user                      | User wallet address.                                                                    |
| coin                      | Hyperliquid coin symbol.                                                                |
| token                     | Hyperliquid numeric token index.                                                        |
| total                     | Total balance. Always positive.                                                         |
| hold                      | Held (locked) balance.                                                                  |
| entry\_ntl                | Entry notional value.                                                                   |
| last\_activity\_timestamp | Sub-second timestamp of the most recent observed activity for this (user, coin, token). |
| block\_date               | Calendar date for this row (midnight UTC).                                              |
| \_created\_at             | Row creation timestamp.                                                                 |
| \_updated\_at             | Row last update timestamp.                                                              |

## Sample Query

```sql theme={null}
SELECT
  user,
  coin,
  total,
  hold,
  last_activity_timestamp
FROM hyperliquid.assets.spot_balances_latest
WHERE coin = 'USDC'
ORDER BY total DESC
LIMIT 100
```