select date_trunc('week', block_timestamp) as fecha,
block_author,
count (distinct block_id) as created_blocks,
sum (created_blocks) over (partition by block_author order by fecha) as cumulative_blocks
from near.core.fact_blocks
where block_author in ('meta-pool.near', 'staked.poolv1.near', 'astro-stakers.poolv1.near', 'bisontrails.poolv1.near', 'aurora.pool.near')
group by 1, 2
order by 1 desc