| frontend | VARCHAR(16777216) | The frontend interface used for the transaction. |
| block_number | NUMBER(38,0) | The block number in which the transaction was included. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block in which the transaction was included. |
| transaction_hash | VARCHAR(66) | The hash of the transaction. |
| transaction_index | NUMBER(38,0) | The index of the transaction within the block. |
| swapper_address | VARCHAR(42) | The address of the user performing the swap. |
| from_address | VARCHAR(42) | The address initiating the transaction (msg.sender). |
| to_address | VARCHAR(42) | The address receiving the transaction. |
| is_aggregator | BOOLEAN | Flag indicating if the transaction is an aggregator. |
| usd_volume | FLOAT | The max usd_amount of the swap within the entire transaction. |
| total_usd_volume | FLOAT | The sum of the usd_amount of all swaps within the transaction. |
| senders | VARIANT | Array of addresses sending tokens in the transaction. |
| recipients | VARIANT | Array of addresses receiving tokens in the transaction. |
| user_token_input | VARCHAR(42) | First token sold in chronological order. |
| user_token_input_symbol | VARCHAR(16777216) | Symbol of the first token sold in chronological order. |
| user_token_output | VARCHAR(42) | Last token bought in chronological order. |
| user_token_output_symbol | VARCHAR(16777216) | Symbol of the last token bought in chronological order. |
| tokens_sold | VARIANT | Array of tokens sold in the transaction. |
| tokens_bought | VARIANT | Array of tokens bought in the transaction. |
| integrators | VARIANT | Array of integrator names involved in the transaction. |
| integrator_tags | VARIANT | Array of integrator contract addresses. |
| aggregator_source | VARIANT | Source of the aggregator. |
| aggregator_usd_volume | FLOAT | USD volume of the aggregator portion. |
| aggregators | VARIANT | Array of aggregator contracts involved. |
| aggregators_count | NUMBER(38,0) | Count of aggregators involved. |
| aggregator_details | VARIANT | JSON details of aggregator swaps. |
| liquidity_source | VARIANT | Array of liquidity sources used. |
| liquidity_usd_volume | FLOAT | USD volume from liquidity sources. |
| liquidity_pools | VARIANT | Array of liquidity pool addresses used. |
| liquidity_pools_count | NUMBER(38,0) | Count of liquidity pools involved. |
| liquidity_details | VARIANT | JSON details of liquidity pool swaps. |
| total_trades | NUMBER(38,0) | Total number of trades in the transaction. |
| unique_id | VARCHAR(16777216) | Unique identifier for the orderflow record. |
| _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. |
