SELECT

tx_hash,

block_timestamp,

origin_from_address AS swapper,

NVL(amount_in_usd, amount_out_usd) AS amount_usd,

symbol_in,

symbol_out,

token_in,

token_out

FROM base.defi.ez_dex_swaps

WHERE platform = 'alienbase'

concat(extract(year from block_timestamp), ' - Q', extract(quarter from block_timestamp)) as quarter,

CASE

WHEN amount_usd < 10 THEN 'Micro (< $10)'

WHEN amount_usd <= 50 THEN 'Small ($10 - $50)'

WHEN amount_usd <= 100 THEN 'Medium-Small ($50 - $100)'

WHEN amount_usd <= 500 THEN 'Medium ($100 - $500)'

WHEN amount_usd <= 1000 THEN 'Large ($500 - $1K)'

WHEN amount_usd <= 5000 THEN 'High Roller ($1K - $5K)'

WHEN amount_usd <= 10000 THEN 'Whale ($5K - $10K)'

WHEN amount_usd <= 100000 THEN 'Mega Whale ($10K - $100K)'

ELSE 'Titan Whale ($100K+)'

END AS type,

COUNT(DISTINCT tx_hash) AS transactions

FROM main

GROUP BY 1, 2

order by 1, 2