The avalanche.dex.trades contains successful swaps made on major decentralized exchanges (DEXs), consolidated into a single table.

Project Coverage:

Sample Query

Finding the swap volume of indexed projects on Avax in the last 7 days.

  date(block_timestamp) as date,
  sum(usd_amount) as usd_volume 
from avalanche.dex.trades
  where current_date - date(block_timestamp) < 7
  group by date, project
  order by date desc 

Table Columns

_str columns are numeric fields casted as varchar to retain precision when summing.

Last updated