> ## 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 per (address, token), with USD valuation.

The Stablecoins Balances Latest table contains one row per (address, stablecoin) holding the latest known balance for every address that has ever held a tracked stablecoin on this chain. It is refreshed hourly by merging the newest end-of-day balances over the existing table, so a dormant holder keeps its last known balance instead of disappearing.

A `balance` of 0 is meaningful: the address held this stablecoin and is now empty, rather than the data being missing. Filter with `balance > 0` for current holders.

`usd_balance` values the balance at the current price from the hourly stablecoin price feed, not at the price when the balance last changed.

### Table Columns

Unique Key: `token_address`, `address`

| Column Name                      | Data Type         | Description                                                                               |
| -------------------------------- | ----------------- | ----------------------------------------------------------------------------------------- |
| address                          | VARCHAR           | The wallet or contract address holding the stablecoin                                     |
| token\_address                   | VARCHAR           | Contract address of the stablecoin token                                                  |
| product\_id                      | VARCHAR           | Allium stablecoin product identifier, grouping canonical and bridged variants (e.g. usdc) |
| currency                         | VARCHAR           | The reference currency the stablecoin is pegged to, as a lowercase ISO 4217 code          |
| token\_name                      | VARCHAR           | Name of the stablecoin                                                                    |
| token\_symbol                    | VARCHAR           | Symbol of the stablecoin                                                                  |
| token\_decimals                  | NUMBER(38,0)      | Number of decimals used to convert raw amounts (normalized = raw / 10^decimals)           |
| raw\_balance\_str                | VARCHAR           | Balance, unnormalized, as string to retain precision                                      |
| raw\_balance                     | FLOAT             | Balance in the token's smallest unit, not decimal-adjusted                                |
| balance\_str                     | VARCHAR           | Balance, normalized, as string to retain precision                                        |
| balance                          | FLOAT             | Balance, normalized by token decimals                                                     |
| usd\_balance                     | FLOAT             | Balance in USD, valued at the current price                                               |
| usd\_exchange\_rate              | FLOAT             | Exchange rate used for USD conversion                                                     |
| price\_source                    | VARCHAR           | Source used to determine the USD price (e.g. coingecko, peg)                              |
| block\_date                      | DATE              | UTC date of the block that last changed this balance                                      |
| last\_activity\_block\_timestamp | TIMESTAMP\_NTZ(9) | Block timestamp of the most recent balance-changing activity                              |
| last\_activity\_block\_number    | NUMBER(38,0)      | Block number of the most recent balance-changing activity                                 |
| last\_activity\_block\_hash      | VARCHAR           | Block hash of the most recent balance-changing activity                                   |
| unique\_id                       | VARCHAR           | Unique identifier for the (address, token) row                                            |