Query editor
WITH trades_filtered AS (SELECTproject,DATE_TRUNC('day', block_time) AS day,SUM(CAST(amount_usd AS DOUBLE)) AS usd_volumeFROMdex."trades" AS tWHEREblock_time >= DATE_TRUNC('day', NOW()) - INTERVAL '2' yearAND block_time < DATE_TRUNC('day', NOW())GROUP BYproject,DATE_TRUNC('day', block_time))SELECTday,SUM(usd_volume) AS daily_total_volumeFROMtrades_filteredGROUP BYdayORDER BYday;