| from_address | VARCHAR(16777216) | The source address of the fungible token transfer |
| to_address | VARCHAR(16777216) | The destination address of the fungible token transfer |
| token_type | VARCHAR(14) | Type of token - either ‘coin’ or ‘fungible_asset’ |
| coin_address | VARCHAR(16777216) | Contract address of the coin (applicable when token_type is ‘coin’) |
| coin_name | VARCHAR(16777216) | Name of the coin (applicable when token_type is ‘coin’) |
| coin_symbol | VARCHAR(16777216) | Symbol of the coin (applicable when token_type is ‘coin’) |
| coin_decimals | NUMBER(38,0) | Decimal precision of the coin (applicable when token_type is ‘coin’) |
| fa_address | VARCHAR(16777216) | Contract address of the fungible asset (applicable when token_type is ‘fungible_asset’) |
| fa_name | VARCHAR(16777216) | Name of the fungible asset (applicable when token_type is ‘fungible_asset’) |
| fa_symbol | VARCHAR(16777216) | Symbol of the fungible asset (applicable when token_type is ‘fungible_asset’) |
| fa_decimals | NUMBER(38,0) | Decimal precision of the fungible asset (applicable when token_type is ‘fungible_asset’) |
| token_address | VARCHAR(16777216) | Coalesced address from either coin_address or fa_address |
| token_name | VARCHAR(16777216) | Coalesced name from either coin_name or fa_name |
| token_symbol | VARCHAR(16777216) | Coalesced symbol from either coin_symbol or fa_symbol |
| token_decimals | NUMBER(38,0) | Coalesced decimals from either coin_decimals or fa_decimals |
| match_type | VARCHAR(16777216) | Classification of how the transfer was matched/identified |
| transfer_type | VARCHAR(16777216) | Type of transfer operation |
| withdraw_metadata | OBJECT | JSON metadata for the withdrawal event |
| deposit_metadata | OBJECT | JSON metadata for the deposit event |
| raw_amount_str | VARCHAR(16777216) | Raw transfer amount as a string |
| raw_amount | FLOAT | Raw transfer amount as a float |
| amount_str | VARCHAR(16777216) | Normalized transfer amount as a string (adjusted for token decimals) |
| amount | FLOAT | Normalized transfer amount as a float |
| usd_amount | FLOAT | USD value of the transfer at the time of transaction |
| usd_exchange_rate | FLOAT | USD exchange rate of the token at the time of transaction |
| tx_sender | VARCHAR(16777216) | Address that sent the transaction |
| tx_payload | VARIANT | Full payload details of the transaction |
| block_hash | VARCHAR(16777216) | Hash of the block containing the transfer |
| block_height | NUMBER(38,0) | Block number/height of the transfer |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the block was created |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction containing the transfer |
| transaction_index | NUMBER(38,0) | Index of the transaction within the block |
| transaction_version | NUMBER(38,0) | Version number of the transaction |
| event_index | NUMBER(38,0) | Index of the event within the transaction |
| unique_id | VARCHAR(16777216) | Unique identifier for the transfer event |
| _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. |
| tx_function | VARCHAR(16777216) | Function called in the transaction (currently null in the example) |
