symbol_in || ' ➡ ' || symbol_out as "Route",

count(distinct tx_hash) as "🔄Swap Count",

sum(amount_in_usd) as "💰Swap Volume (USD)",

count(distinct origin_from_address) as "👨‍💻Trader Count"

avalanche.core.ez_dex_swaps

block_timestamp::date >= '{{Start_Date}}'

and block_timestamp::date <= '{{End_Date}}'

and platform = 'pangolin'

and amount_in_usd > 0

group by

1

order by

1