symbol_in,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users,

sum(amount_in_usd) as swap_volume_usd

FROM ethereum.core.ez_dex_swaps

WHERE platform LIKE 'sushiswap'

and block_timestamp>= CURRENT_DATE - 180

and symbol_in is not null

GROUP BY 1

order by 3 DESC

limit 10