🗃️Dex Trades
Transaction level information for all Decentralized Exchange (Dex) trades.
Last updated
Transaction level information for all Decentralized Exchange (Dex) trades.
Last updated
The dex trades table uses the following nomenclature: dex_$chain
Transaction level information for all Dex trades on a chain. Table names are: dex_all_trades_with_volume_on_$chain
Currently, we support Arbitrum, Avalanche, BSC, Celo, Ethereum, Fantom, Optimism, Polygon, and Ronin chains.
| Field Name | Data Type | Description |
|---|---|---|
transaction_hash
STRING
Hash of the transaction
block_timestamp
TIMESTAMP
Timestamp of the block where the transaction happened
log_index
INTEGER
Index of the log event
taker
STRING
The wallet initating the trade
maker
STRING
The DEX facilitating the trade
taker_token
STRING
The token the user wallet is using to swap
taker_token_amount
FLOAT
The amount the user is using to swap
taker_token_symbol
STRING
The symbol of the taker token
taker_token_price_usd
FLOAT
The market price of the taker token at time of the trade
taker_token_decimals
INTEGER
The decimals (usually 18) of the taker token
taker_token_volume
FLOAT
The approximate volume of the take tokens
maker_token
STRING
The token that the user is swapping for / the DEX is supplying
maker_token_amount
FLOAT
The amount the user is receiving for in the swap
maker_token_symbol
STRING
The symbol of the maker token
maker_token_price_usd
FLOAT
The market price of the maker token at time of the trade
maker_token_decimals
INTEGER
The decimals (usually 18) of the maker token
maker_token_volume
FLOAT
The approximate volume of the maker tokens
contract_address
STRING
The address of the contract where the trade is taking place
dex
STRING
The name of the DEX
volume_usd
FLOAT
The approximate volume of the trade in USD
