eth as (

select

date(block_timestamp) as date,

count(tx_hash) as swaps,

count(distinct sender) as users,

sum(

case

when amount_out_usd is not null then amount_out_usd

when amount_in_usd is not null then amount_in_usd

else 0 end

) as usd_vol

from ethereum.core.ez_dex_swaps

where platform = 'sushiswap'

group by 1

select * from eth

where date >= '2022-06-01'