| token_type | VARCHAR(16777216) | Type of the token (‘NATIVE’ or ‘ERC20’), converted to uppercase |
| address | VARCHAR(42) | Address of the account that was credited or debited |
| counterparty_address | VARCHAR(42) | Counterparty address of this credit debit row |
| token_address | VARCHAR(42) | Token address of the token |
| token_name | VARCHAR(16777216) | Name of the token |
| token_symbol | VARCHAR(16777216) | Token symbol |
| raw_amount_str | VARCHAR(16777216) | Amount of tokens moved (unnormalized) in string |
| raw_amount | FLOAT | Amount of tokens moved (unnormalized) |
| amount_str | VARCHAR(16777216) | Amount of tokens moved, normalized in string |
| amount | FLOAT | Amount of tokens moved, normalized by the decimal points defined in the token contract |
| usd_amount | FLOAT | The amount of tokens moved, in $USD |
| usd_exchange_rate | FLOAT | The price of a single token, in USD |
| transaction_from_address | VARCHAR(42) | The address that initiated the transaction |
| transaction_to_address | VARCHAR(42) | The address that received the transaction |
| transaction_hash | VARCHAR(66) | Transaction hash that this transfer belongs to |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block. The first transaction has index 0 |
| log_index | NUMBER(38,0) | The position of this log within the block (null for native tokens) |
| call_type | VARCHAR(16777216) | Type of the call that generated this transfer (null for ERC20 tokens and Tron chain) |
| transfer_type | VARCHAR(16777216) | Type of the transfer (‘value_transfer’ for ERC20 tokens) |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that contains this transfer |
| block_number | NUMBER(38,0) | The block number that contains this transfer |
| block_hash | VARCHAR(66) | The block hash that contains this transfer |
| unique_id | VARCHAR(16777216) | Unique id for each transfer |
| _tokens_updated_at | TIMESTAMP_NTZ(9) | Timestamp when token metadata was last updated (null for native tokens) |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full refresh |
