CASE WHEN swap_program ILIKE '%raydium%' THEN 'Raydium'

WHEN swap_program ILIKE '%meteora%' THEN 'Meteora'

WHEN swap_program ILIKE '%orca%' THEN 'Orca'

WHEN swap_program ILIKE '%phoenix%' THEN 'Phoenix'

ELSE swap_program END AS "Platform"

, count(DISTINCT swapper) AS "Traders"

, SUM(CASE WHEN swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

THEN swap_from_amount_usd

ELSE swap_to_amount_usd

END)

AS "Volume"

, COUNT(DISTINCT tx_id) AS "Transactions"

FROM solana.defi.ez_dex_swaps

WHERE swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

OR swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

GROUP BY 1

ORDER BY "Volume" desc