Query editor
-- Aerodrome Daily Volume, Single Time SeriesSELECTDATE_TRUNC('day', block_time) AS day,SUM(amount_usd) AS daily_volume_usdFROM dex.tradesWHERE project IN ('aerodrome', 'aerodrome_slipstream')AND block_time >= TIMESTAMP '2023-08-01'AND amount_usd > 0AND amount_usd < 100000000GROUP BY 1ORDER BY 1 DESC