select

date(block_timestamp) as day,

sum(amount_in_usd) as daily_vol,

contract_address,

pool_name,

platform

from

avalanche.defi.ez_dex_swaps

where

token_in = lower('0xffff003a6bad9b743d658048742935fffe2b6ed7')

or

token_out = lower('0xffff003a6bad9b743d658048742935fffe2b6ed7')

group by

day,

platform,

pool_name,

contract_address

order by

day desc,

daily_vol desc