Alir3zaUntitled Query
    Updated 2022-07-23

    select
    max(maximum) as average,
    min(minimum) as minimum,
    avg(average) as maximum
    from (select date(mx) as dt,
    max(maxmin) as maximum,
    min(maxmin) as minimum,
    avg(maxmin) as average
    from(
    select block_number,mx, maxmin from (
    select
    block_number,
    block_timestamp as mx,
    lead(block_timestamp,1) over (order by block_timestamp asc ) as mn,
    datediff('second', mx,mn) as maxmin
    from polygon.core.fact_blocks))
    group by 1)
    Run a query to Download Data