SELECT

swapper,

SUM(amount_in_usd) AS total_amount

FROM

aptos.defi.ez_dex_swaps

WHERE

token_in = '0x1::aptos_coin::AptosCoin'

AND block_timestamp >= '2024-12-01'

AND block_timestamp <= '2025-01-31'

GROUP BY

swapper

CASE

WHEN total_amount >= 100000 THEN 'Whale'

WHEN total_amount BETWEEN 50000 AND 99999 THEN 'Dolphin'

WHEN total_amount BETWEEN 10000 AND 49999 THEN 'Shark'

END AS category,

COUNT(DISTINCT swapper) AS total_users

user_totals

total_amount >= 10000

GROUP BY

category

ORDER BY

category;