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

# Balances Latest

> Current stablecoin balance for every holder address.

The `stablecoins.core.balances_latest` table gives the current balance of every address that has held a tracked stablecoin. For daily history, use [`stablecoins.core.balances_daily`](https://docs.allium.so/historical-data/stablecoins/balances-daily).

**Unique Key**: `chain`, `address`, `token_address`, `token_account`

### Sample Query

**Top 20 current USDC holders on Base**

```sql theme={null}
select
    address,
    balance,
    usd_balance
from stablecoins.core.balances_latest
where chain = 'base'
    and product_id = 'usdc'
    and balance > 0
order by balance desc
limit 20
```

### Table Columns

| Column Name | Description |
| - | - |
| `chain` | Blockchain of the balance. |
| `address` | Holder address. |
| `token_account` | Token account holding the balance, on chains that use one (e.g. Solana). Null elsewhere. |
| `product_id` | Identifier of the stablecoin product. Join key to `stablecoins.registry.catalog`. |
| `token_address` | Contract or mint address of the stablecoin. |
| `currency` | Currency the stablecoin is pegged to. |
| `token_name` | Name of the token. |
| `token_symbol` | Symbol of the token. |
| `token_decimals` | Decimals of the token. |
| `raw_balance_str` | Raw balance, as a string. |
| `raw_balance` | Raw balance. |
| `balance_str` | Normalized balance, as a string. |
| `balance` | Normalized balance. |
| `multiplier` | Rebase factor for rebasing tokens. 1 otherwise. |
| `usd_balance` | Balance in USD. |
| `usd_exchange_rate` | USD price used for `usd_balance`. |
| `price_source` | Source of the price. |
| `is_circulating` | True if the balance counts toward circulating supply. |
| `block_date` | Date of the last activity that changed this balance. |
| `last_activity_block_timestamp` | Timestamp of the last activity that changed this balance. |
| `last_activity_block_number` | Block number of the last activity that changed this balance. |
| `last_activity_block_hash` | Block hash of the last activity that changed this balance. |
| `unique_id` | Unique identifier for the row. |
| `_created_at` | Timestamp this row was first created. |
| `_updated_at` | Timestamp this row was last updated. |
