nsa2000hossein Maximum time between blocks from June 1 to September 17 (weekly)
    Updated 2022-09-17
    SELECT
    date_trunc('week', a.block_timestamp) as week,
    max(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MAX_block_time_defference
    FROM ethereum.core.fact_blocks a
    JOIN ethereum.core.fact_blocks b
    on a.BLOCK_NUMBER= b.BLOCK_NUMBER - 1
    where week >= '2022-06-01'
    group by 1
    Run a query to Download Data