block_timestamp::date date,

sum(amount_in_usd) as volume_usd

from ethereum.defi.ez_dex_swaps

where (token_in = '0x4c9edd5852cd905f086c759e8383e09bff1e68b3' or token_out = '0x4c9edd5852cd905f086c759e8383e09bff1e68b3')

and block_timestamp >= current_date() - 30

group by date

order by date