Trades

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

Project Coverage:

Currently, we support the following projects.

Protocol
Projects

algebra

skullswap, spiritswap

balancer_v2

beethoven_x

curve_v1, curve_v2

curve

kyberswap_elastic

kyberswap

uniswap_v2

jetswap, wigoswap, makiswap, spookyswap, runic, defyswap, hyperjump, knightswap, excalibur, skullswap, morpheusswap, magik_finance, liquidbolt, mageswap, tombswap, radioshackswap, degenhaus, alium_finance, spiritswap, pyreswap, elkfinance, sushiswap, paintswap, zoodex, soulswap, wingswap, bombfinance, protofi, shibaswap, yoshiexchange, farmtom, redemption

uniswap_v3

solidly, thick, sushiswap, wagmi, lif3, spookyswap

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