| from_address | VARCHAR(16777216) | The sender address of the transfer. |
| to_address | VARCHAR(16777216) | The recipient address of the transfer. |
| currency | VARCHAR(16777216) | Token denomination identifier of the asset transferred (e.g., nhash, ibc/…). |
| token_name | VARCHAR(16777216) | The name of the token. |
| token_symbol | VARCHAR(16777216) | The symbol of the token. |
| raw_amount_str | VARCHAR(16777216) | The raw token amount as a string. |
| raw_amount | FLOAT | The raw token amount before decimal normalization. |
| amount_str | VARCHAR(16777216) | The normalized token amount as a string. |
| amount | FLOAT | The normalized token amount of the transfer. |
| usd_amount | FLOAT | The USD value of the transfer. |
| usd_exchange_rate | FLOAT | The exchange rate used to calculate the USD value. |
| event_type | VARCHAR(16777216) | The type of transfer event (e.g., transfer, ibc_transfer, coin_spent). |
| tx_sender | VARCHAR(16777216) | The address that initiated the transaction. |
| transaction_hash | VARCHAR(64) | The hash of the transaction containing this transfer. |
| transaction_index | NUMBER(38,0) | The index of the transaction within the block. |
| event_index | NUMBER(38,0) | The index of the event within the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block containing this transfer. |
| block_number | NUMBER(38,0) | The height of the block containing this transfer. |
| block_hash | VARCHAR(64) | The hash of the block containing this transfer. |
| code | NUMBER(38,0) | The transaction result code (0 indicates success). |
| tx_success | BOOLEAN | Whether the transaction was successful. |
| authz_msg_index | NUMBER(38,0) | The index of the authorized message within an authz grant execution. |
| memo | VARCHAR(16777216) | The memo field attached to the transaction. |
| src_channel | VARCHAR(16777216) | The source IBC channel for cross-chain transfers. |
| dst_channel | VARCHAR(16777216) | The destination IBC channel for cross-chain transfers. |
| unique_id | VARCHAR(16777216) | A unique identifier for the transfer. |
| _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. |
