| address | VARCHAR(16777216) | The wallet address involved in the credit or debit. |
| counterparty_address | VARCHAR(16777216) | The counterparty address in the credit or debit transaction. |
| currency | VARCHAR(16777216) | Token denomination identifier of the asset (e.g., uatom, 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 credit or debit. |
| usd_amount | FLOAT | The USD value of the credit or debit. |
| 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. |
| 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 entry. |
| block_height | NUMBER(38,0) | The height of the block containing this entry. |
| block_hash | VARCHAR(64) | The hash of the block containing this entry. |
| block_event_kind | VARCHAR(16777216) | The phase in which the block event was emitted. Possible values are: begin (before transactions are processed), end (after all transactions are processed), finalize (immediately before block commit). |
| block_event_index | NUMBER(38,0) | The index of the block event. |
| block_event_type | VARCHAR(16777216) | The type of the block event. |
| 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 entry. |
| _created_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was created. |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was updated. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
