Query editor
SELECTdate_trunc('day', block_time) AS day,SUM(amount_usd) AS volume,COUNT(*) AS tradesFROM dex.tradesWHERE block_time >= now() - interval '30' dayAND project = 'uniswap'GROUP BY 1ORDER BY 1
Query editor
1SELECT2date_trunc('day', block_time) AS day,34SUM(amount_usd) AS volume,56COUNT(*) AS trades78FROM dex.trades910WHERE block_time >= now() - interval '30' day11AND project = 'uniswap'1213GROUP BY 114ORDER BY 1