SELECT

s.trader,

s.token_in_contract,

s.token_out_contract,

s.symbol_in,

s.symbol_out,

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'

AND s.symbol_in IS NOT NULL

AND s.symbol_out IS NOT NULL

GROUP BY

s.trader, s.token_in_contract, s.token_out_contract, s.symbol_in, s.symbol_out

),

categorized_traders AS (

SELECT

trader,

token_in_contract,

token_out_contract,

symbol_in,

symbol_out,

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

),