flipside

    average block time
    BlockTrackeraverage block time
    Updated 2024-09-09
    SELECT
    date_trunc('{{granularity}}', a.block_timestamp) as date,
    avg(datediff(second, a.block_timestamp,b.block_timestamp)) as avg_time_diff
    FROM flow.core_evm.fact_blocks a, flow.core_evm.fact_blocks b
    WHERE a.block_number = b.block_number-1
    GROUP BY date


    QueryRunArchived: QueryRun has been archived