SELECT

swap_from_symbol,

swap_to_symbol,

tx_id,

swapper,

swap_from_amount_usd

FROM

solana.marinade.ez_swaps

WHERE

swap_from_symbol = 'MSOL'

AND block_timestamp >= CURRENT_DATE - INTERVAL '1 MONTH'

LEFT(sd.swapper, 6) || '...' || RIGHT(sd.swapper, 4) AS TraderAddress,

SUM(sd.swap_from_amount_usd) AS total_swap_volume_usd,

LISTAGG(DISTINCT sd.swap_from_symbol || '-' || sd.swap_to_symbol, ', ') AS swap_pairs

swap_data sd

GROUP BY

sd.swapper

ORDER BY

total_swap_volume_usd DESC

LIMIT 10;