Query editor
1SELECT 2 DATE(block_time) as day,3 SUM(amount_usd) as total_usd4FROM dex.trades5WHERE block_time >= NOW() - INTERVAL '7' day6GROUP BY 17ORDER BY 1
SELECT
DATE(block_time) as day,
SUM(amount_usd) as total_usd
FROM dex.trades
WHERE block_time >= NOW() - INTERVAL '7' day
GROUP BY 1
ORDER BY 1