count(distinct tx_hash) as "Swaps",

sum(coalesce(amount_in_usd,amount_out_usd)) as "USD Volume",

count(distinct block_timestamp::date) as "Active Days"

from avalanche.defi.ez_dex_swaps

where (token_in = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')

or token_out = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E'))

group by 1

order by 3 desc