Query editor
WITH cte1AS (SELECT date_trunc('day', block_time) AS DATE,sum(fee) AS Daily_feesFROM bitcoin.transactionsWHERE 1 = 1AND block_height > 767429AND cast(hex AS VARCHAR) LIKE '%0063036f726401%'GROUP BY 1),cte2AS (SELECT date_trunc('day', minute) AS DATE,avg(price) AS PriceFROM prices.usdWHERE 1 = 1AND symbol = 'BTC'AND contract_address IS NULLGROUP BY 1)SELECT cte1.DATE,Daily_fees,sum(cte1.Daily_fees) OVER (ORDER BY cte1.DATE range unbounded preceding) AS Total_fees,cte2.Price,cte1.Daily_fees * cte2.Price AS Daily_fees_USD,cte2.Price * sum(cte1.Daily_fees) OVER (ORDER BY cte1.DATE range unbounded preceding) AS Total_fees_USDFROM cte1LEFT JOIN cte2 ON cte1.DATE = cte2.DATEORDER BY 1 DESC;