distinct POOL_NAME,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT origin_from_address) as swappers,

sum (amount_out_usd) as Volume

FROM ethereum.core.ez_dex_swaps

where event_name ='Swap'

and block_number < 15537351

and block_timestamp::date >='2022-09-01'

and (SYMBOL_IN ilike 'WETH' or SYMBOL_OUT ilike 'WETH' )

and SYMBOL_IN != SYMBOL_OUT

GROUP BY 1

having volume is not null

order by 3 desc

limit 10