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

# Supply Non Circulating Daily

### Table Details

| Property     | Value                                           |
| ------------ | ----------------------------------------------- |
| Table Name   | `vana.stablecoins.supply_non_circulating_daily` |
| Table Status | Production-Ready                                |

### Table Columns

| Column Name                     | Data Type         | Description                                                             |
| ------------------------------- | ----------------- | ----------------------------------------------------------------------- |
| chain                           | VARCHAR(16777216) | The blockchain the stablecoin resides on                                |
| address                         | VARCHAR(42)       | The non-circulating address holding the balance                         |
| token\_address                  | VARCHAR(42)       | Contract address of the stablecoin token                                |
| token\_name                     | VARCHAR(16777216) | Name of the stablecoin                                                  |
| token\_symbol                   | VARCHAR(16777216) | Symbol of the stablecoin                                                |
| token\_decimals                 | NUMBER(38,0)      | Decimal precision of the stablecoin                                     |
| product\_id                     | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt)                  |
| ncs\_address\_type              | VARCHAR(16777216) | Classification of the non-circulating address (e.g. treasury, bridge)   |
| ncs\_address\_label             | VARCHAR(16777216) | Human-readable label for the address                                    |
| ncs\_supply\_layer              | VARCHAR(16777216) | Which supply layer this exclusion applies to (e.g. base, adjusted)      |
| raw\_balance\_str               | VARCHAR(16777216) | Balance, unnormalized, as string for precision                          |
| raw\_balance                    | FLOAT             | Balance, unnormalized                                                   |
| balance\_str                    | VARCHAR(16777216) | 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                   | NUMBER(38,0)      | Block number at which the balance was captured                          |
| block\_hash                     | VARCHAR(16777216) | Block hash at which the balance was captured                            |
| \_has\_error                    | NUMBER(38,0)      | Internal flag indicating whether balance retrieval encountered an error |
| \_short\_address                | VARCHAR(4)        | Short (4-char) prefix of `address`, used for clustering                 |
| \_short\_token\_address         | VARCHAR(4)        | 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            |
| \_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.           |
| \_changed\_since\_full\_refresh | BOOLEAN           | Indicates if the record has changed since the last full data refresh.   |

### Related Docs

* [EVM Stablecoins Supply Non Circulating Daily](/historical-data/supported-blockchains/evm/core-schemas/stablecoins/supply-non-circulating-daily)