count(DISTINCT tx_hash) as swaps,

count(DISTINCT origin_from_address) as swappers,

sum(amount_out_usd) as usd_volume

from ethereum.core.ez_dex_swaps

where block_timestamp::date >= '2022-06-01'

group by 1

order by 2 DESC