Query editor
WITH Prices1 AS (SELECTDATE_TRUNC('month', minute) AS Month, contract_address, symbol, AVG(price) AS PriceFROM prices.usdWHERE blockchain = 'base'GROUP BY 1,2,3),Base AS (SELECTDATE_TRUNC('month', a.Date) AS Month, 'Base' AS Chain, SUM(ABS(a.Amount * b.Price)) AS VolumeFROM query_4071645 aLEFT JOIN Prices1 b ON DATE_TRUNC('month', a.Date) = b.Month AND a.Replace_Asset = b.contract_addressWHERE a.Date >= CAST('2026-01-01 00:00' AS TIMESTAMP)GROUP BY 1,2),Btcfi AS (SELECTDATE_TRUNC('month', a.Date) AS Month, 'BTCfi' AS Chain, SUM(ABS(a.Amount * b.Price)) AS VolumeFROM query_4396445 aLEFT JOIN Prices1 b ON DATE_TRUNC('month', a.Date) = b.Month AND a.Replace_Asset = b.contract_addressWHERE a.Date >= CAST('2026-01-01 00:00' AS TIMESTAMP)GROUP BY 1,2),Prices2 AS (SELECTDATE_TRUNC('month', minute) AS Month, contract_address, symbol, AVG(price) AS PriceFROM prices.usdWHERE blockchain = 'optimism'GROUP BY 1,2,3),Optimism AS (SELECTDATE_TRUNC('month', a.Date) AS Month, 'Optimism' AS Chain, SUM(ABS(a.Amount * b.Price)) AS VolumeFROM query_4206358 aLEFT JOIN Prices2 b ON DATE_TRUNC('month', a.Date) = b.Month AND a.Replace_Asset = b.contract_addressWHERE a.Date >= CAST('2026-01-01 00:00' AS TIMESTAMP)GROUP BY 1,2),Prices3 AS (SELECTDATE_TRUNC('month', minute) AS Month, contract_address, symbol, AVG(price) AS PriceFROM prices.usdWHERE blockchain = 'ethereum'GROUP BY 1,2,3),