| date | TIMESTAMP_NTZ(9) | End-of-day date (UTC) of the balance snapshot. |
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| coin_type | VARCHAR(16777216) | Fully-qualified Aptos coin type identifier (e.g. 0x1::aptos_coin::AptosCoin). Alias for aptos_coin_type used in Aptos models that name the column coin_type. |
| coin_name | VARCHAR(16777216) | Full name of this coin. Short alias for token_name in Aptos/Cosmos-style tables. |
| coin_symbol | VARCHAR(16777216) | Ticker symbol of this coin. Short alias for token_symbol in Aptos/Cosmos-style tables. |
| coin_decimals | NUMBER(38,0) | Decimal precision of this coin. Short alias for token_decimals in Aptos/Cosmos-style tables. |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances. |
| raw_balance | FLOAT | Token balance in the token’s smallest unit (not decimal-adjusted). Use balance for the human-readable normalized value. |
| balance_str | VARCHAR(16777216) | Normalized token balance stored as a string for full precision. Equivalent to balance but avoids floating-point truncation. |
| balance | FLOAT | Sum of end-of-day token balances for this address_type. |
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. |
| usd_balance | FLOAT | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot. |
| last_activity_checkpoint_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the checkpoint at which this address last had activity. |
| last_activity_checkpoint_sequence | NUMBER(38,0) | Checkpoint sequence number of the most recent checkpoint in which this address had activity. |
| last_activity_checkpoint_digest | VARCHAR(16777216) | Checkpoint digest of the most recent checkpoint in which this address had activity. |
| last_activity_transaction_block_digest | VARCHAR(16777216) | Transaction block digest of the most recent transaction for this address. |
| last_activity_transaction_block_index | NUMBER(38,0) | Index within the checkpoint of the most recent transaction for this address. |
