| from_address | VARCHAR(134217728) | The address of the sender of the TON transfer |
| from_address_b | VARCHAR(134217728) | Bounceable user-friendly format of from_address. |
| from_address_nb | VARCHAR(134217728) | Non-bounceable user-friendly format of from_address. |
| to_address | VARCHAR(134217728) | The address of the recipient of the TON transfer |
| to_address_b | VARCHAR(134217728) | Bounceable user-friendly format of to_address. |
| to_address_nb | VARCHAR(134217728) | Non-bounceable user-friendly format of to_address. |
| token_address | VARCHAR(134217728) | The address of the token contract (always ‘0’ for native TON) |
| token_name | VARCHAR(134217728) | The name of the token (always ‘Toncoin’ for native TON) |
| token_symbol | VARCHAR(134217728) | The symbol of the token (always ‘TON’ for native TON) |
| raw_amount_str | VARCHAR(134217728) | The raw transfer amount as a string to retain precision |
| raw_amount | FLOAT | The raw transfer amount as a float |
| amount_str | VARCHAR(134217728) | The normalized transfer amount as a string (9 decimal places), in string format to retain precision |
| amount | FLOAT | The normalized transfer amount as a float |
| usd_amount | FLOAT | The USD value of the transfer at the hour of the transaction |
| usd_exchange_rate | FLOAT | The USD/TON exchange rate at the time of the transaction |
| transfer_type | VARCHAR(134217728) | The type of transfer, can be fees or value_transfer |
| opcode | VARCHAR(134217728) | The operation code associated with the transfer |
| utime | TIMESTAMP_NTZ(9) | The timestamp of the transfer |
| transaction_hash | VARCHAR(134217728) | The hash of the transaction containing this transfer |
| transaction_hash_hex | VARCHAR(134217728) | Hex-encoded lowercase hash of the transaction. |
| message_hash | VARCHAR(134217728) | The hash of the message associated with this transfer |
| message_hash_hex | VARCHAR(134217728) | Hex-encoded hash of the TON message associated with this transfer. |
| transaction_index | NUMBER(38,0) | The index of the transaction within the block |
| message_index | NUMBER(38,0) | The index of the message within the transaction |
| seqno | NUMBER(38,0) | The sequence number of the transaction |
| shard | VARCHAR(134217728) | The shard identifier for this transaction |
| workchain | NUMBER(38,0) | The workchain identifier for this transaction |
| unique_id | VARCHAR(134217728) | A unique identifier for this transfer |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block containing this 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. |
