Query editor
SELECTDATE_TRUNC('month', block_time) AS month,SUM(SUM(amount_usd)) OVER (ORDER BY DATE_TRUNC('month', block_time)) AS cumulative_volume, projectFROM dex.tradesWHERE project = 'aerodrome'AND blockchain IN ('base')AND block_time >= CAST('2023-01-01' AS DATE)GROUP BY DATE_TRUNC('month', block_time), projectUNIONSELECTDATE_TRUNC('month', block_time) AS month,SUM(SUM(amount_usd)) OVER (ORDER BY DATE_TRUNC('month', block_time)) AS cumulative_volume, projectFROM dex.tradesWHERE project = 'uniswap'AND blockchain IN ('base')AND block_time >= CAST('2023-01-01' AS DATE)GROUP BY DATE_TRUNC('month', block_time), project