date(block_timestamp) as dates,

count(distinct(block_id)) 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

from solana.core.fact_blocks

group by dates

order by dates DESC