| token_type | VARCHAR(16777216) | Identifies whether the balance record is for a native or erc20 token |
| address | VARCHAR(42) | The wallet address holding the tokens |
| token_address | VARCHAR(42) | Contract address of the token |
| token_name | VARCHAR(16777216) | Name of the token |
| token_symbol | VARCHAR(16777216) | Symbol of the token |
| token_id | VARCHAR(16777216) | Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Null for fungible tokens. Each unique token_id within a collection represents a distinct asset. |
| raw_balance | FLOAT | Token balance, unnormalized |
| raw_balance_str | VARCHAR(16777216) | Token balance, unnormalized, as string to retain precision |
| balance_str | VARCHAR(16777216) | Token balance as string to retain precision |
| balance | FLOAT | Token balance, normalized |
| usd_balance_current | FLOAT | The current USD value of the balance, based on the latest available exchange rate. |
| usd_balance_at_block_timestamp | FLOAT | The USD value of the balance at the time of the block that resulted in the balance update. |
| usd_exchange_rate_current | FLOAT | The current USD exchange rate of the token, based on the latest available rate. |
| usd_exchange_rate_at_block_timestamp | FLOAT | The USD exchange rate of the token at the time of the block that resulted in the balance update. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | The last timestamp of the block that resulted in the balance update |
| last_activity_block_number | NUMBER(38,0) | The last block number that resulted in the balance update |
| last_activity_block_hash | VARCHAR(66) | The last hash of the block that resulted in the balance update |
| unique_id | VARCHAR(16777216) | Unique identifier combining block, address, token address |
| _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. |