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