symbol_in,

count(origin_from_address) count_swappers,

COUNT(DISTINCT tx_hash) count_swaps,

sum(amount_in_usd) total_volume,

row_number() over (order by count_swaps DESC) as row_number

FROM optimism.sushi.ez_swaps

where block_timestamp::date >= CURRENT_DATE -30

group by 2

order by 6 ASC

limit 10