| 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) | Non-circulating balance in the smallest unit, stored as a string for full precision. |
| raw_balance | FLOAT | Non-circulating balance in the token’s smallest unit (not decimal-adjusted). |
| balance_str | VARCHAR(16777216) | Normalized non-circulating balance stored as a string for full precision. |
| balance | FLOAT | Non-circulating balance normalized by the token’s decimal precision (raw_balance / 10^decimals). |
| block_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this forward-filled balance snapshot covers. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block from which this balance was sourced. |
| block_number | NUMBER(38,0) | Block number from which this balance was sourced. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block from which this balance was sourced. |
| _has_error | NUMBER(38,0) | Flag indicating whether an error occurred when this balance was captured (e.g. an RPC failure during snapshot). |
| _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. |
| _ncs_seed_updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the NCS seed data that enriches this record. |
| _balances_created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the underlying balance snapshot row that feeds this record was first created. |
| _ncs_eod_created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the NCS end-of-day record that feeds this row was first 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. |
