| chain | VARCHAR(16777216) | The blockchain the stablecoin resides on. |
| address | VARCHAR(16777216) | Wallet or contract address holding the non-circulating balance. |
| token_address | VARCHAR(16777216) | 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 address in the Non-Circulating Supply framework (e.g. issuer, bridge, contract). |
| ncs_address_label | VARCHAR(16777216) | Human-readable label for the address in the NCS framework (e.g. the name of an exchange, protocol, or issuer). |
| ncs_supply_layer | VARCHAR(16777216) | Supply layer classification in the NCS framework indicating which exclusion category this balance belongs to. |
| raw_balance_str | VARCHAR(16777216) | End-of-day non-circulating balance in the smallest unit, stored as a string for full precision. |
| raw_balance | FLOAT | End-of-day non-circulating balance in the token’s smallest unit (not decimal-adjusted). |
| balance_str | VARCHAR(16777216) | Normalized end-of-day non-circulating balance stored as a string for full precision. |
| balance | FLOAT | End-of-day non-circulating balance normalized by the token’s decimal precision (raw_balance / 10^decimals). |
| block_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this end-of-day balance snapshot covers. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the last block on this date from which the balance was sourced. |
| block_number | NUMBER(38,0) | Block number of the last block on this date from which the balance was sourced. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block from which this balance was sourced. |
| _ncs_seed_updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the NCS seed data that enriches this record. |
| _short_address | VARCHAR(4) | Truncated version of the address column used as a clustering/partition key. |
| _short_token_address | VARCHAR(4) | Truncated version of the token_address column used as a clustering/partition 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. |
