The Stablecoins Balances Daily table contains one row per (address, stablecoin, date) capturing the address’s closing balance for each day. Use it for holder segmentation, treasury and issuer balance monitoring, and time-series of who is holding what.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.
Table Columns
Unique Key:date, address, token_address
| Column Name | Data Type | Description |
|---|---|---|
| date | DATE | The UTC date this daily balance snapshot covers |
| address | VARCHAR | The wallet address holding the stablecoin |
| token_address | VARCHAR | Contract address of the stablecoin token |
| product_id | VARCHAR | Allium stablecoin product identifier (e.g. usdc, usdt) |
| currency | VARCHAR | The reference currency the stablecoin is pegged to (e.g. USD, EUR) |
| token_name | VARCHAR | Name of the stablecoin |
| token_symbol | VARCHAR | Symbol of the stablecoin |
| raw_balance_str | VARCHAR | Balance, unnormalized, as string to retain precision |
| balance_str | VARCHAR | 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 | 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 | INTEGER | Block number of the most recent balance-changing activity |
| unique_id | VARCHAR | Unique identifier for the (date, address, token) row |