Query editor
1SELECT2 date_trunc('day', block_time) AS day,3 SUM(amount_usd) AS volume4FROM dex.trades5WHERE block_time >= now() - interval '30' day6AND token_bought_symbol = 'ETH'7GROUP BY 18ORDER BY 1
SELECT
date_trunc('day', block_time) AS day,
SUM(amount_usd) AS volume
FROM dex.trades
WHERE block_time >= now() - interval '30' day
AND token_bought_symbol = 'ETH'
GROUP BY 1
ORDER BY 1