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

### Table Details

| Property | Value |
| - | - |
| Table Name | `berachain.stablecoins.supply_non_circulating_eod` |
| Table Status | Production-Ready |
| Unique Key | `block_date`, `address`, `token_address` |
| Clustering Key(s) | `block_date, _short_address, _short_token_address` |
| Search Optimization | `address`, `token_address` |

### 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) | Which methodology category the exclusion falls into: pre-minted/unissued, bridge-locked, stablecoin-backed, or permanently inaccessible |
| ncs\_address\_label | VARCHAR(16777216) | Human-readable label for the address (e.g. issuer or bridge name) |
| ncs\_supply\_layer | VARCHAR(16777216) | Which supply view this exclusion feeds into (`non_circulating_supply` vs. `adjusted_non_circulating_supply`) |
| 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 end-of-day balance 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 |
| \_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 Eod](/historical-data/supported-blockchains/evm/core-schemas/stablecoins/supply-non-circulating-eod)