> ## 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        | `stable.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                              |
| 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)