SELECT

SWAPPER,

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS swap_volume

FROM aptos.defi.ez_dex_swaps

WHERE EVENT_ADDRESS = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'

GROUP BY SWAPPER

CASE

WHEN swap_volume < 10 THEN 'a.Less than $10'

WHEN swap_volume <= 50 THEN 'b.$10 - $50'

WHEN swap_volume <= 500 THEN 'c.$50 - $500'

WHEN swap_volume <= 5000 THEN 'd.$500 - $5,000'

WHEN swap_volume <= 10000 THEN 'e.$5,000 - $10,000'

WHEN swap_volume <= 50000 THEN 'f.$10,000 - $50,000'

WHEN swap_volume <= 100000 THEN 'g.$50,000 - $100,000'

ELSE 'h.More than $100,000'

END AS swappers_category,

COUNT(DISTINCT SWAPPER) AS swappers_count,

SUM(swap_volume) AS total_volume_usd

FROM categorized_swappers

GROUP BY 1

ORDER BY swappers_category ASC