Query editor
WITH GroupedCosts AS (SELECTdate_trunc('day', eth_block_time) AS hr,SUM(blob_cost_eth) AS sum_blob_cost,SUM(blob_cost_usd) AS sum_blob_usd,SUM(eth_tx_base_fee_usd) AS sum_execution_base_usd,SUM(eth_tx_priority_fee_usd) AS sum_execution_priority_usd,SUM(eth_tx_base_fee_eth) AS sum_execution_base_eth,SUM(eth_tx_priority_fee_eth) AS sum_execution_priority_ethFROMquery_3520865GROUP BY1),CumulativeCosts AS (SELECThr,sum_blob_cost,sum_blob_usd,SUM(sum_execution_base_usd) OVER (ORDER BY hr ASC) AS cumulative_execution_base_usd,SUM(sum_execution_priority_usd) OVER (ORDER BY hr ASC) AS cumulative_execution_priority_usd,SUM(sum_execution_base_eth) OVER (ORDER BY hr ASC) AS cumulative_execution_base_eth,SUM(sum_execution_priority_eth) OVER (ORDER BY hr ASC) AS cumulative_execution_priority_eth,SUM(sum_blob_usd) OVER (ORDER BY hr ASC) AS cumulative_consensus_usd,SUM(sum_blob_cost) OVER (ORDER BY hr ASC) AS cumulative_consensus_ethFROMGroupedCosts)SELECT *FROM CumulativeCostsORDER BY hr;