distinct PLATFORM,

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_timestamp::date between '2022-12-17' and '2022-12-31'

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