count(DISTINCT tx_hash) as swaps,

count(DISTINCT sender) as swappers,

sum(amount1_usd) as usd_volume

from ethereum.uniswapv3.ez_swaps

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

and pool_name is not null

and amount1_usd>0

group by 1

order by 2 DESC

limit 10