The Stablecoins Supply Non Circulating Daily table itemizes the addresses excluded from circulating supply, classified into one of four methodology categories: pre-minted/unissued (issuer-held but not yet backed), bridge-locked (locked in bridge contracts on the source chain), stablecoin-backed (collateral locked to mint another tracked stablecoin), and permanently inaccessible (burn addresses and other unrecoverable contracts). Each row is one (date, chain, stablecoin, address) tuple with its daily closing balance and category. See Supply Distribution Methodology on the stablecoins overview for the full methodology.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
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR | The blockchain the stablecoin resides on |
| address | VARCHAR | The non-circulating address holding the balance |
| token_address | VARCHAR | Contract address of the stablecoin token |
| token_name | VARCHAR | Name of the stablecoin |
| token_symbol | VARCHAR | Symbol of the stablecoin |
| token_decimals | INTEGER | Decimal precision of the stablecoin |
| product_id | VARCHAR | Allium stablecoin product identifier (e.g. usdc, usdt) |
| ncs_address_type | VARCHAR | Which methodology category the exclusion falls into: pre-minted/unissued, bridge-locked, stablecoin-backed, or permanently inaccessible |
| ncs_address_label | VARCHAR | Human-readable label for the address (e.g. issuer or bridge name) |
| ncs_supply_layer | VARCHAR | Which supply view this exclusion feeds into (non_circulating_supply vs. adjusted_non_circulating_supply) |
| raw_balance_str | VARCHAR | Balance, unnormalized, as string for precision |
| raw_balance | FLOAT | Balance, unnormalized |
| balance_str | VARCHAR | Balance, normalized, as string for precision |
| balance | FLOAT | Balance, normalized by token decimals |
| block_date | TIMESTAMP_NTZ(9) | The UTC date this balance snapshot covers |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp at which the balance was captured |
| block_number | INTEGER | Block number at which the balance was captured |
| block_hash | VARCHAR | Block hash at which the balance was captured |
| _has_error | INTEGER | Internal flag indicating whether balance retrieval encountered an error |
| _short_address | VARCHAR | Short (4-char) prefix of address, used for clustering |
| _short_token_address | VARCHAR | Short (4-char) prefix of token_address, used for clustering |
| _ncs_seed_updated_at | TIMESTAMP_NTZ(9) | When the non-circulating-address seed list was last updated |
| _balances_created_at | TIMESTAMP_NTZ(9) | When the underlying balances entry was created |
| _ncs_eod_created_at | TIMESTAMP_NTZ(9) | When the upstream end-of-day non-circulating row was created |