Trades
The DEX trades table contains swaps made on decentralized exchanges, consolidated into a single table.
Project Coverage:
Currently, we support the following projects.
Projects | Protocols |
---|---|
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
Column | Description |
---|---|
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