PLATFORM,

SUM(AMOUNT_IN_USD) AS total_volume_usd

FROM aptos.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP >= DATE_TRUNC('day', CURRENT_DATE - 7)

GROUP BY PLATFORM

ORDER BY total_volume_usd DESC;