| BLOCKCHAIN | TEXT | BLOCKCHAIN column |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this transaction in UTC |
| BLOCK_NUMBER | NUMBER | The block number at which the transaction is finalized. |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| ORIGIN_FROM_ADDRESS | TEXT | The address of the user who initiates the swap. If a swap action generates multiple swaps, all of them will have the same address as originfromaddress. |
| ORIGIN_TO_ADDRESS | TEXT | The person who initiates the swap has to interact with this address. This address belongs to the decentralized exchange and/or is a router. |
| POOL_ADDRESS | TEXT | The contract address for the liquidity pool. |
| PLATFORM | TEXT | This field denotes which application the liquidity pool belongs to. |
| EVENT_INDEX | FLOAT | Event number within a transaction. |
| AMOUNT_IN | FLOAT | The amount of tokens put into the swap. |
| AMOUNT_OUT | FLOAT | The amount of tokens taken out of or received from the swap. |
| SENDER | TEXT | The address of the wallet or contract that creates the swap. The Router is usually the Sender in the swap function. |
| LOG_ID | TEXT | This is the primary key for this table. This is a concatenation of the transaction hash and the event index at which the event occurred. This field can be used within other event based tables such as & . |
| TOKEN_IN | TEXT | The address of the token sent for swap. |
| TOKEN_OUT | TEXT | The address of the token being swapped to. |
| SYMBOL_IN | TEXT | The symbol of the token sent for swap. |
| SYMBOL_OUT | TEXT | The symbol of the token being swapped to. |
| TX_TO | TEXT | The tx_to is the address who receives the swapped token. This corresponds to the “to” field in the swap function. |
| AMOUNT_IN_USD | FLOAT | The amount of tokens put into the swap converted to USD using the price of the token. |
| AMOUNT_OUT_USD | FLOAT | The amount of tokens taken out of or received from the swap converted to USD using the price of the token. |
| POOL_NAME | TEXT | POOL_NAME column |
