SELECT

symbol_in,

COUNT(DISTINCT swapper) AS swapper_count,

COUNT(DISTINCT tx_id) AS swap_count,

SUM(amount_in_usd) AS total_volume,

ROW_NUMBER() OVER (ORDER BY COUNT(DISTINCT tx_id) DESC, SUM(amount_in_usd) DESC) AS rank

FROM

sei.defi.ez_dex_swaps

GROUP BY

symbol_in

symbol_in,

swapper_count,

swap_count,

total_volume

overall_swapper_activity

rank <= 10

ORDER BY

swap_count DESC, total_volume DESC;