DATE_TRUNC('day', s.BLOCK_TIMESTAMP) AS "Date",

CASE

WHEN PLATFORM ILIKE '%jupiter%' THEN 'Jupiter'

WHEN PLATFORM ILIKE '%raydium%' THEN 'Raydium'

WHEN PLATFORM ILIKE '%meteora%' THEN 'Meteora'

WHEN PLATFORM ILIKE '%orca%' THEN 'Orca'

ELSE PLATFORM

END AS dex,

COUNT(*) AS swaps,

COUNT(DISTINCT s.SWAPPER) AS swapper,

SUM(

CASE

WHEN NOT s.SWAP_FROM_AMOUNT_USD IS NULL THEN s.SWAP_FROM_AMOUNT_USD

WHEN NOT s.SWAP_TO_AMOUNT_USD IS NULL THEN s.SWAP_TO_AMOUNT_USD

ELSE 0

END

) AS volume_usd

FROM

solana.marinade.ez_swaps s

WHERE

(s.SWAP_TO_SYMBOL ILIKE 'msol' OR s.SWAP_FROM_SYMBOL ILIKE 'msol') -- Filter for mSOL swaps

AND s.BLOCK_TIMESTAMP >= DATEADD(MONTH, -1, CURRENT_DATE) -- Last month's activity

GROUP BY

1, 2

ORDER BY

1, 2;