Trades

The DEX trades table contains swaps made on decentralized exchanges, consolidated into a single table.

Project Coverage:

Currently, we support the following projects.

ProjectsProtocols

zipswap, uniswap, sushiswap, openxswap, elkfinance

uniswap_v2

velodrome

velodrome_v2, velodrome_v1

uniswap, sushiswap, solidly

uniswap_v3

kyberswap

kyberswap_elastic

dodo

dodo_v2

curve

curve_v2, curve_v1

balancer

balancer_v2

Table Columns

_str columns are numeric fields cast varchar to retain precision when summing.

Unique Key: unique_id

ColumnDescription

project

The project (decentralized exchange) of the liquidity pool that the swap occurred from.

protocol

DEX protocol (& version, if applicable) of the contract address facilitating the swap.

liquidity_pool_address

Contract address of the liquidity pool holding the asset. For protocol without the concept of LP such as airswap, this will be null.

sender_address

The address of the sender emitted on the swap event logs. This can be a router or pool address.

to_address

Address of the recipient emitted on the swap event logs. For example, recipient_address from the uniswap v3 swap event log.

token_sold_address

Token address of the token sold.

token_sold_name

Name of the token sold.

token_sold_symbol

Symbol of the token sold.

token_sold_decimals

Token decimals of the token sold.

token_sold_amount_raw_str

Raw amount of tokens sold (unnormalized) in string.

token_sold_amount_raw

Raw amount of tokens sold (unnormalized).

token_sold_amount_str

Amount of tokens sold in string.

token_sold_amount

Amount of tokens sold.

usd_sold_amount

Amount of token sold in USD value.

token_bought_address

Token address of the token bought, i.e. the asset acquired from the trade.

token_bought_name

Name of the token bought.

token_bought_symbol

Symbol of the token bought.

token_bought_decimals

Token decimals of the token bought.

token_bought_amount_raw_str

Raw amount of tokens bought (unnormalized) in string.

token_bought_amount_raw

Raw amount of tokens bought (unnormalized).

token_bought_amount_str

Amount of tokens bought in string.

token_bought_amount

Amount of tokens bought.

usd_bought_amount

Amount of token bought in USD value.

usd_amount

USD value of the swap. This field preferentially selects the USD value of ETH and Stablecoin (USDT/USDC) tokens, as spam token prices may conflate the true swap value.

extra_fields

This field contains all the extra columns emitted from the event/function call that were not part of the convetional DEX trades columns.

swap_count

Swap count within the transaction.

transaction_fees

Fees paid at the transaction level.

transaction_fees_usd

Fees paid in USD.

fee_details

Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction.

transaction_from_address

Transaction sender address. I.e. the address of the transaction initiator. (from_address in the raw.transactions field for the transaction_hash of this swap).

transaction_to_address

Transaction receiver. (to_address in the raw.transactions field for the transaction_hash of this swap).

transaction_hash

Transaction hash that this swap belongs to.

transaction_index

The position of this transaction in the block that it belongs to. The first transaction has index 0.

selector

4byte selector of the transaction.

log_index

The position of the swap event log in the transaction.

block_timestamp

Block timestamp of the swap event.

block_number

Block number of the swap event.

block_hash

Block hash of the swap event.

unique_id

Unique ID of each trade.

Last updated