| account | VARCHAR(16777216) | The address of the account |
| token_id | VARCHAR(16777216) | The id of the token |
| token_type | VARCHAR(16777216) | Token standard for the asset (e.g. erc20, erc721, erc1155) or the native currency symbol. |
| token_name | VARCHAR(16777216) | Full name of the token (e.g. “USD Coin”, “Wrapped Ether”). |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”, “WETH”). |
| token_decimals | NUMBER(38,0) | Number of decimal places used to represent the token’s smallest unit. |
| raw_amount_str | VARCHAR(16777216) | The amount of the token in the raw format. This is negative for debits and positive for credits |
| raw_amount | FLOAT | The amount of the token in the raw format. This is negative for debits and positive for credits |
| amount_str | VARCHAR(16777216) | The amount of the token in the normalized format. This is negative for debits and positive for credits |
| amount | FLOAT | The amount of the token in the normalized format. This is negative for debits and positive for credits |
| usd_amount | FLOAT | The amount of the token in the normalized format, in $USD |
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. |
| is_approval | BOOLEAN | Whether the transaction is an approval |
| payer_account_id | VARCHAR(16777216) | The id of the payer account |
| entity_id | VARCHAR(16777216) | The id of the entity |
| nonce | NUMBER(38,0) | The nonce of the transaction |
| result | VARCHAR(16777216) | The result of the transaction |
| block_hash | VARCHAR(16777216) | The hash of the block |
| block_number | NUMBER(38,0) | The number of the block |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block |
| consensus_timestamp | TIMESTAMP_NTZ(9) | The consensus timestamp of the transaction |
| transaction_type | VARCHAR(16777216) | The type of the transaction |
| transaction_hash | VARCHAR(16777216) | The hash of the transaction |
| transaction_id | VARCHAR(16777216) | The id of the transaction |
| transfers_index | NUMBER(38,0) | The index of the transfer |
| unique_id | VARCHAR(16777216) | The unique id of the transaction |
| _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. |
