Query editor
SELECTdate_trunc('day', block_time) AS day,SUM(amount_usd) AS volumeFROM dex.tradesWHERE block_time >= now() - interval '30' dayAND project = 'uniswap'GROUP BY 1ORDER BY 1
Query editor
1SELECT2date_trunc('day', block_time) AS day,3SUM(amount_usd) AS volume4FROM dex.trades5WHERE block_time >= now() - interval '30' day6AND project = 'uniswap'7GROUP BY 18ORDER BY 1