SELECT

s.trader,

SUM(s.amount_in_usd) AS total_volume

FROM

near.defi.ez_dex_swaps s

WHERE

s.block_timestamp >= '2024-01-01'

AND s.block_timestamp <= '2024-12-31'

GROUP BY

s.trader

),

categorized_traders AS (

SELECT

trader,

total_volume,

CASE

WHEN total_volume > 100000 THEN 'Whale'

WHEN total_volume > 10000 AND total_volume <= 99999 THEN 'Dolphin'

WHEN total_volume > 1000 AND total_volume <= 9999 THEN 'Crab'

WHEN total_volume > 1 AND total_volume <= 1000 THEN 'Plankton'

ELSE 'Micro Plankton'

END AS trader_category

FROM

trader_volumes

),

total_volume AS (

SELECT

SUM(total_volume) AS total_traded_volume

FROM

trader_volumes

trader_category,

COUNT(DISTINCT trader) AS number_of_traders,