SELECT

Block_timestamp,

tx_id,

swapper,

swap_from_symbol,

swap_to_symbol,

swap_from_amount_usd,

platform

FROM solana.marinade.ez_swaps

WHERE (swap_from_symbol = 'MSOL' OR swap_to_symbol = 'MSOL')

AND Block_timestamp >= '2024-01-01'

AND succeeded = 1

),

top_10_platforms AS (

SELECT

platform,

SUM(swap_from_amount_usd) AS total_volume_usd

FROM msol_swaps

GROUP BY platform

ORDER BY total_volume_usd DESC

LIMIT 10

SELECT

DATE_TRUNC('month', Block_timestamp) AS date,

m.platform,

COUNT(DISTINCT m.tx_id) AS swap_count,

SUM(m.swap_from_amount_usd) AS total_volume_usd

FROM msol_swaps m

JOIN top_10_platforms t ON m.platform = t.platform

GROUP BY date, m.platform

ORDER BY date DESC;