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

### Table Details

| Property | Value |
| - | - |
| Table Name | `plasma.stablecoins.balances_daily` |
| Table Status | Production-Ready |
| Unique Key | `date`, `address`, `token_address` |
| Clustering Key(s) | `date, token_address` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| date | DATE | The UTC date this daily balance snapshot covers |
| address | VARCHAR(42) | The wallet address holding the stablecoin |
| token\_address | VARCHAR(42) | Contract address of the stablecoin token |
| product\_id | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt) |
| currency | VARCHAR(16777216) | The reference currency the stablecoin is pegged to (e.g. USD, EUR) |
| token\_name | VARCHAR(16777216) | Name of the stablecoin |
| token\_symbol | VARCHAR(16777216) | Symbol of the stablecoin |
| raw\_balance\_str | VARCHAR(16777216) | Balance, unnormalized, as string to retain precision |
| balance\_str | VARCHAR(16777216) | Balance, normalized, as string to retain precision |
| balance | FLOAT | Balance, normalized by token decimals |
| usd\_balance | FLOAT | Balance in USD |
| usd\_exchange\_rate | FLOAT | Exchange rate used for USD conversion |
| holder\_rank | NUMBER(38,0) | Rank of this holder by `balance`, among all holders of the same `token_address` on the same `date` (1 = largest balance). |
| price\_source | VARCHAR(16777216) | Source used to determine the USD price (e.g. coingecko, peg) |
| 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 |
| unique\_id | VARCHAR(16777216) | Unique identifier for the (date, address, token) row |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database. |

### Related Docs

* [EVM Stablecoins Balances Daily](/historical-data/supported-blockchains/evm/core-schemas/stablecoins/balances-daily)