date(block_timestamp) as dates,

count(distinct(block_number)) as block_transaction,

sum(block_transaction) over(order by dates) as cum_blocks,

block_transaction/86400 as time_per_block,

sum(time_per_block) over(order by dates) as cum_time_per_block,

avg(difficulty)

from optimism.core.fact_blocks

group by dates

order by dates DESC