sum(case when amount_in_usd is not null then amount_in_usd else 0 end) as tx_vol

from ethereum.core.ez_dex_swaps

where 1=1

and contract_address ilike ('0xB4e16d0168e52d35CaCD2c6185b44281Ec28C9Dc')

and block_timestamp > '2022-08-20'

group by date