| 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. For most trades, this comes from the transaction_from_address field in dex.trades / dex.aggregator_trades. However, for UniswapX and CowProtocol swaps, it comes from the sender field instead. |
| 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 volume of the transaction in USD |
| total_usd_volume | FLOAT | The total volume of the transaction in USD |
| 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) | Address of the token the user is selling |
| user_token_input_symbol | VARCHAR(16777216) | Symbol of the token the user is selling |
| user_token_output | VARCHAR(42) | Address of the token the user is buying |
| user_token_output_symbol | VARCHAR(16777216) | Symbol of the token the user is buying |
| 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 transaction |
| _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. |
