KaskoazulBlock_authors 3 Validators
    Updated 2022-08-04
    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


    Run a query to Download Data