WITH swap_stats AS (
SELECT
platform,
COUNT(*) AS total_swaps
FROM base.defi.ez_dex_swaps
WHERE block_timestamp >= DATEADD(DAY, -30, CURRENT_DATE)
GROUP BY platform
)
SELECT
platform,
SUM(total_swaps) AS total_swaps
FROM swap_stats
GROUP BY platform
ORDER BY platform;