Query editor
1SELECT2project,3SUM(amount_usd) AS total_volume4FROM dex_solana.trades5WHERE block_time >= CURRENT_DATE - INTERVAL '7' DAY6GROUP BY project7ORDER BY total_volume DESC 8
SELECT
project,
SUM(amount_usd) AS total_volume
FROM dex_solana.trades
WHERE block_time >= CURRENT_DATE - INTERVAL '7' DAY
GROUP BY project
ORDER BY total_volume DESC