CASE

WHEN swap_from_symbol = 'SOL' AND swap_to_symbol = 'SOL' THEN 'SOL-SOL'

WHEN swap_from_symbol = 'SOL' THEN 'SOL-' || swap_to_symbol

WHEN swap_to_symbol = 'SOL' THEN swap_from_symbol || '-SOL'

ELSE 'Other'

END AS pair,

SUM(swap_from_amount_usd) AS volume_swapped

solana.defi.ez_dex_swaps

block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 day'

GROUP BY

pair

ORDER BY

volume_swapped DESC

LIMIT 15;