Table Details
| Property | Value |
|---|---|
| Table Name | stellar.stablecoins.supply_non_circulating_eod |
| Table Status | Production-Ready |
| Unique Key | block_date, token_address, 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) | Blockchain this record belongs to (always stellar). |
| address | VARCHAR(16777216) | Address of the non-circulating holder on Stellar. |
| token_address | VARCHAR(16777216) | Address of the stablecoin token on Stellar. |
| token_name | VARCHAR(16777216) | Full name of the token. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token. |
| token_decimals | NUMBER(38,0) | Number of decimal places used to represent the token’s smallest unit. |
| product_id | VARCHAR(16777216) | Internal Allium identifier for the stablecoin product. |
| ncs_address_type | VARCHAR(16777216) | Classification of the non-circulating supply address. |
| ncs_address_label | VARCHAR(16777216) | Human-readable label for the non-circulating supply address. |
| ncs_supply_layer | VARCHAR(16777216) | Supply layer this non-circulating balance belongs to (e.g. treasury, bridge escrow). |
| raw_balance_str | VARCHAR(16777216) | End-of-day balance in the token’s smallest unit, as a string. |
| raw_balance | FLOAT | End-of-day balance in the token’s smallest unit, not decimal-adjusted. |
| balance_str | VARCHAR(16777216) | Normalized end-of-day balance as a string for full precision. |
| balance | FLOAT | End-of-day balance normalized by the token’s decimal precision. |
| block_date | TIMESTAMP_NTZ(9) | Ledger date (UTC) of this end-of-day balance snapshot. |
| block_timestamp | TIMESTAMP_NTZ(9) | Ledger close time (UTC) of this end-of-day balance snapshot. |
| block_number | NUMBER(38,0) | Ledger sequence number of this balance snapshot. |
| block_hash | VARCHAR(16777216) | Ledger hash of this balance snapshot. |
| _ncs_seed_updated_at | TIMESTAMP_NTZ(9) | Timestamp of the most recent update to the non-circulating seed data. |
| _short_address | VARCHAR(4) | Truncated form of the address used as a clustering key. |
| _short_token_address | VARCHAR(4) | Truncated form of the token address used as a clustering key. |
| _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. |