nsa2000hossein The total number of swings of mined blocks from June to September 17
    Updated 2022-09-17
    select
    date_trunc('week', block_timestamp) as week,
    count(BLOCK_NUMBER) as blocks_number,
    lag( blocks_number) ignore nulls over(order by week asc) as delay_block_numbers,
    ((blocks_number-delay_block_numbers)/ delay_block_numbers)*100 as blocks_numbers_swing
    from ethereum.core.fact_blocks
    where week >='2022-06-01'
    group by 1

    Run a query to Download Data