SELECT

DATE_TRUNC('week', block_timestamp) AS week,

COUNT(block_number) AS total_blocks,

SUM(tx_count) AS total_transactions,

SUM(gas_used) AS total_gas_used,

AVG(size) AS avg_block_size

FROM

blast.core.fact_blocks

WHERE

block_timestamp >= '2024-01-01'

GROUP BY

week

week,

total_blocks,

total_transactions,

total_gas_used,

avg_block_size,

SUM(total_blocks) OVER (ORDER BY week) AS cumulative_total_blocks,

SUM(total_transactions) OVER (ORDER BY week) AS cumulative_total_transactions,

SUM(total_gas_used) OVER (ORDER BY week) AS cumulative_total_gas_used,

AVG(avg_block_size) OVER (ORDER BY week) AS cumulative_avg_block_size

weekly_stats

ORDER BY

week;