flipside

    average daily block time
    hessaverage daily block time
    Updated 2024-07-17
    select date(a.block_timestamp) as date,
    avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time
    from sei.core_evm.fact_blocks a, sei.core_evm.fact_blocks b
    where a.BLOCK_NUMBER = b.BLOCK_NUMBER-1
    group by 1


    QueryRunArchived: QueryRun has been archived