headitmanagerAverage Block time on Polygon(minutes) each day 2
    Updated 2022-07-25
    with avg_block_time as (select datediff('minute' , min(block_timestamp), max(block_timestamp))/count(*) from polygon.core.fact_blocks)
    , avg_block_time_overtime as (select datediff('minute' , min(block_timestamp), max(block_timestamp))/count(*), block_timestamp::date
    from polygon.core.fact_blocks
    group by block_timestamp::date )
    , avg_tx as (select avg(tx_count) from polygon.core.fact_blocks)
    , avg_tx_overtime as (select avg(tx_count),block_timestamp::date from polygon.core.fact_blocks
    group by block_timestamp::date)
    select * from avg_block_time_overtime
    Run a query to Download Data