CASE

WHEN paired_token = 'SOL' THEN 'Native Token'

WHEN paired_token IN ('MSOL', 'STSOL', 'JSOL', 'JITOSOL', 'SSOL', 'DSOL', 'YSOL', 'OSOL', 'STRONGSOL', 'HUBSOL', 'BNSOL', 'COMPASSSOL', 'GST-SOL', 'WFRAGSOL', 'CGNTSOL', 'LAINESOL', 'PWRSOL')

THEN 'Staked SOL / Liquid Staking'

WHEN paired_token IN ('USDC', 'USDT', 'USDS', 'USDH', 'USDY', 'USDE', 'USDTET', 'USDTBS', 'AUSD', 'EURC', 'USDG', 'PYUSD', 'FDUSD')

THEN 'Stablecoin'

WHEN paired_token LIKE '%BTC%' OR paired_token LIKE '%CBTC%' OR paired_token LIKE '%WBTC%' OR paired_token = 'ZBTC'

THEN 'Bitcoin-related'

WHEN paired_token LIKE '%ETH%' OR paired_token = 'SOETH'

THEN 'Ethereum-related'

WHEN paired_token IN ('BONK', 'DOGE', 'PEPE', 'WIF', 'SAMO', 'SLERF') OR paired_token LIKE '%FART%' OR paired_token LIKE '%MEME%' OR paired_token LIKE '%RIZZ%'

THEN 'Meme Token'

WHEN paired_token LIKE '%AI%' OR paired_token LIKE '%GPT%'

THEN 'AI-related'

WHEN paired_token IN ('ORCA', 'RAY', 'JUP', 'MNDE', 'PYTH', 'SAROS', 'GOFX')

THEN 'DEX / Protocol Token'

WHEN paired_token LIKE '$%'

THEN 'Community / $-prefix'

ELSE 'Other'

END AS token_category,

SUM(volume_usd) AS total_volume_usd,

COUNT(*) AS swap_count

FROM (

SELECT

CASE

WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_symbol

ELSE swap_from_symbol

END AS paired_token,

COALESCE(

CASE

WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_from_amount_usd

WHEN swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_amount_usd