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