frontend | VARCHAR | The frontend interface used for the transaction |
block_number | BIGINT | 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 | The hash of the transaction |
transaction_index | BIGINT | The index of the transaction within the block |
swapper_address | VARCHAR | 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 | The address initiating the transaction (msg.sender) |
to_address | VARCHAR | The address receiving the transaction |
is_aggregator | BOOLEAN | Flag indicating if the transaction is an aggregator |
usd_volume | NUMERIC | The max usd_amount of the swap within the entire transaction |
total_usd_volume | NUMERIC | 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 | Address of the token the user is selling |
user_token_input_symbol | VARCHAR | Symbol of the token the user is selling |
user_token_output | VARCHAR | Address of the token the user is buying |
user_token_output_symbol | VARCHAR | 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 | VARCHAR | Source of the aggregator |
aggregator_usd_volume | NUMERIC | USD volume of the aggregator portion |
aggregators | VARIANT | Array of aggregator contracts involved |
aggregators_count | BIGINT | 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 | BIGINT | Count of liquidity pools involved |
liquidity_details | VARIANT | JSON details of liquidity pool swaps |
total_trades | BIGINT | Total number of trades in the transaction |
unique_id | STRING | Unique identifier for the transaction |