DEX Trades

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.

Project Coverage

Currently, we support over 20 DEX projects on Ethereum.

Sample Query

Query DEX trades by block number.

PSQL

select * from ethereum.dex_trades 
where block_number = 18443152 

API (cURL)

curl 'https://api.allium.so/api/v1/developer/ethereum/dex/trades/?block_number=18443152' \
  -X GET \
  -H 'X-API-KEY: <API KEY>'

Query DEX trades by transaction hash.

PSQL

select * from ethereum.dex_trades 
where transaction_hash = '0x973652a33e1662c4f559b447eb267024e758ade68845a7b582ca8c8d3c2981f3' 

API (cURL)

curl 'https://api.allium.so/api/v1/developer/ethereum/dex/trades/?transaction_hash=0x973652a33e1662c4f559b447eb267024e758ade68845a7b582ca8c8d3c2981f3' \
  -X GET \
  -H 'X-API-KEY: <API KEY>'

Table Columns

*field is only available via the API, and are not in the underlying table.