DEX Trades
Last updated
Last updated
The dex_trades table contains swaps made on decentralized exchanges for the chain, consolidated into a single table. All DEX trades table follows the schema presented below.
Currently, we support over 20 DEX projects on Ethereum.
| Protocol | Projects |
|---|---|
Query DEX trades by block number.
Query DEX trades by transaction hash.
| Column Name | Type | Description | Example |
|---|---|---|---|
*field is only available via the API, and are not in the underlying table.
uniswap_v3
uniswap, kyberswap, pancakeswap
uniswap_v2
original: uniswap
forks: sushiswap, bitberryswap, cityswap, convergence, defiswap, dooar, equalizerfinance, fraxswap, gemswap, integralsize, linkswap, luaswap, mintyswap, nomiswap, orionprotocol, pancakeswap, plasmafinance, radioshackswap, safeswap, saitaswap, sakeswap, sashimiswap, shibaswap, sumswap, swapr, swipeswap, unicly, verse, vulcandex, wallstreetbetsdex, whiteswap
project
varchar
The project (decentralized exchange) of the liquidity pool that the swap occurred from.
uniswap
protocol
varchar
Version of the protocol.
uniswap_v2
liquidity_pool_address
varchar(42)
Contract address of the liquidity pool holding the asset.
0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc
sender_address
varchar(42)
The address of the sender emitted on the swap event logs.
This can be a router or pool address, which is different from the transaction initiator transaction_from_address that initiated the swap.
0x7a250d5630b4cf539739df2c5dacb4c659f2488d
to_address
varchar(42)
Address of the recipient emitted on the swap event logs.
For example, we use the to_address from the uniswap v2 swap event log and the recipient_address from the uniswap v3 swap event log.
0xcbb2534c6898655d50fdac79d6e4b23b18a25b97
token_bought_address*
varchar(42)
Token address of the token bought, i.e. the asset acquired from the trade.
0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
token_bought_name*
varchar
Name of the token bought.
USD Coin
token_bought_symbol*
varchar
Symbol of the token bought.
USDC
token_bought_decimals*
bigint
Decimals of the token bought.
1
token_bought_amount_raw
numeric(512)
Raw amount of tokens bought (unnormalized).
3,000,000,000
token_bought_amount*
float
Amount of tokens bought.
3000000000
token_sold_address*
varchar(42)
Token address of the token sold.
0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2
token_sold_name*
varchar
Name of the token sold.
Wrapped Ether
token_sold_symbol*
varchar
Symbol of the token sold.
WETH
token_sold_decimals*
bigint
Decimals of the token sold.
18
token_sold_amount_raw
numeric(512)
Raw amount of tokens sold (unnormalized).
2,288,149,153,584,170,000
token_sold_amount*
float
Amount of tokens sold.
2.28814915358417
transaction_from_address
varchar(42)
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).
0xcbb2534c6898655d50fdac79d6e4b23b18a25b97
transaction_to_address
varchar(42)
Transaction receiver. (to_address in the raw.transactions field for the transaction_hash of this swap).
0x7a250d5630b4cf539739df2c5dacb4c659f2488d
transaction_hash
varchar(66)
Transaction hash that this swap belongs to.
0x5e2efbb5a7cd468a2bf89b732e42c9c48bd311e0bec50a5de0beead059d1d220
log_index
bigint
The position of the swap event log in the transaction.
191
block_timestamp
timestamp
Block timestamp of the swap event.
2021-01-25 22:28:07
block_number
bigint
Block number of the swap event.
11,727,610
block_hash
varchar(66)
Block hash of the swap event.
0xff32ce4497bfad832878d069ce956f4eac5a6518c89fe8c4268af5f27c2cc1a5