Query editor
WITH cost AS (SELECTday,SUM(data_fee_usd + blob_fee_usd) AS cost_usd,SUM(data_fee_native + blob_fee_native) AS costFROM rollup_economics_ethereum.l1_feesWHERE name = 'arbitrum'-- AND block_time >= timestamp '2023-03-01'GROUP BY 1),rev AS (SELECTDATE_TRUNC('day', day) AS day,SUM(l2_rev_usd) AS rev_usd,SUM(l2_rev) AS revFROM rollup_economics_ethereum.l2_revenueWHERE name = 'arbitrum'-- AND day >= timestamp '2023-03-01'GROUP BY 1)SELECT *,SUM(profit_usd) OVER (ORDER BY day) AS overall_profit_usd,SUM(rev_usd) OVER (ORDER BY day) AS overall_revenue_usd,SUM(cost_usd) OVER (ORDER BY day) AS overall_cost_usd,SUM(profit) OVER (ORDER BY day) AS overall_profit_eth,SUM(rev) OVER (ORDER BY day) AS overall_revenue_eth,SUM(cost) OVER (ORDER BY day) AS overall_cost_eth,SUM(profit * (SELECT priceFROM prices.usd_latestWHERE symbol = 'ETH'AND contract_address IS NULLAND blockchain IS NULL)) OVER (ORDER BY day) AS overall_profit_usd_latest,SUM(rev * (SELECT priceFROM prices.usd_latestWHERE symbol = 'ETH'AND contract_address IS NULLAND blockchain IS NULL)) OVER (ORDER BY day) AS overall_revenue_usd_latest,SUM(cost * (SELECT priceFROM prices.usd_latestWHERE symbol = 'ETH'AND contract_address IS NULLAND blockchain IS NULL)) OVER (ORDER BY day) AS overall_cost_usd_latestFROM (SELECTc.day,rev_usd,rev,cost_usd,cost,rev_usd-cost_usd AS profit_usd,