SniperMax and min time between tow blocks
    Updated 2022-07-27
    with cte as ( select block_timestamp , lead(block_timestamp) over(order by block_number) as block , datediff('second',block_timestamp,block) as diff
    from polygon.core.fact_blocks
    )
    select max(diff) as max_ , min(diff) as min_ , avg(diff) as avg_
    from cte

    Run a query to Download Data