SELECT

origin_from_address,

SUM(amount_in_usd) AS total_swap_volume_usd,

COUNT(DISTINCT tx_hash) AS total_swap_count

FROM

kaia.defi.ez_dex_swaps

WHERE

platform = 'capybara'

GROUP BY

origin_from_address

),

categorized_traders AS (

SELECT

origin_from_address,

total_swap_volume_usd,

total_swap_count,

CASE

WHEN total_swap_volume_usd > 100000 THEN 'Whale'

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

WHEN total_swap_volume_usd >= 1000 AND total_swap_volume_usd < 10000 THEN 'Shark'

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

WHEN total_swap_volume_usd < 1 THEN 'Micro-Plankton'

END AS trader_category

FROM

trader_categories

),

swaps_with_categories AS (

SELECT

s.origin_from_address,

s.symbol_in,

s.amount_in_usd,

s.tx_hash,

c.trader_category

FROM

kaia.defi.ez_dex_swaps s