pool_name,

sum(amount_out_usd) as swap_volume,

count(DISTINCT tx_hash) as swaps,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM optimism.velodrome.ez_swaps

WHERE block_timestamp > '2022-06-01'

AND not amount_out_usd is NULL

GROUP BY 1

ORDER BY 4 DESC

LIMIT 10