SELECT

SWAPPER,

COUNT(TX_HASH) AS total_swaps,

CASE

WHEN COUNT(TX_HASH) = 1 THEN '1 swap'

WHEN COUNT(TX_HASH) BETWEEN 2 AND 5 THEN '2-5 swaps'

WHEN COUNT(TX_HASH) BETWEEN 6 AND 10 THEN '6-10 swaps'

WHEN COUNT(TX_HASH) BETWEEN 11 AND 25 THEN '11-25 swaps'

WHEN COUNT(TX_HASH) BETWEEN 26 AND 50 THEN '11-50 swaps'

WHEN COUNT(TX_HASH) BETWEEN 51 AND 70 THEN '51-70 swaps'

WHEN COUNT(TX_HASH) BETWEEN 71 AND 100 THEN '71-100 swaps'

ELSE '100+ swaps'

END AS swap_group

FROM aptos.defi.ez_dex_swaps

WHERE block_timestamp >= DATEADD(DAY, -7, CURRENT_DATE) -- Last 7 days

GROUP BY SWAPPER

SELECT

swap_group,

COUNT(DISTINCT SWAPPER) AS swappers

FROM swapper_groups

GROUP BY swap_group

ORDER BY MIN(total_swaps);