Ali3NTime Between Blocks (L1s Blocks Speed Comparison)
    Updated 2025-04-28
    with avalanchet1 as (select block_timestamp as date1,
    lag (block_timestamp) over (order by block_timestamp) as date2,
    datediff (second,date2,date1) as Diff
    from avalanche.core.fact_blocks
    where block_timestamp >= '2025-04-01'),

    avalanchet2 as (select avg(Diff),min(Diff),max(Diff),max(diff) - avg(diff) from avalanchet1),

    neart1 as (select block_timestamp as date1,
    lag (block_timestamp) over (order by block_timestamp) as date2,
    datediff (second,date2,date1) as Diff
    from near.core.fact_blocks
    where block_timestamp >= '2025-04-01'),

    neart2 as (select avg(Diff),min(Diff),max(Diff),max(diff) - avg(diff) from neart1),

    Flowt1 as (select block_timestamp as date1,
    lag (block_timestamp) over (order by block_timestamp) as date2,
    datediff (second,date2,date1) as Diff
    from flow.core.fact_blocks
    where block_timestamp >= '2025-04-01'),

    Flowt2 as (select avg(Diff),min(Diff),max(Diff),max(diff) - avg(diff) from Flowt1),

    Solt1 as (select block_timestamp as date1,
    lag (block_timestamp) over (order by block_timestamp) as date2,
    datediff (second,date2,date1) as Diff
    from solana.core.fact_blocks
    where block_timestamp >= '2025-04-01'),

    Solt2 as (select avg(Diff),min(Diff),max(Diff) ,max(diff) - avg(diff) from Solt1),

    Etht1 as (select block_timestamp as date1,
    lag (block_timestamp) over (order by block_timestamp) as date2,
    datediff (second,date2,date1) as Diff
    from ethereum.core.fact_blocks
    Last run: about 2 months ago
    BLOCKCHAIN
    AVG(DIFF)
    MIN(DIFF)
    MAX(DIFF)
    MAX(DIFF) - AVG(DIFF)
    1
    Near1.13196301210.868037
    2
    Avalanche1.52902902523.470971
    3
    Flow0.800411098.199589
    4
    Aptos0.131281043.868719
    5
    Solana0.398827065.601173
    6
    Ethereum12.056095123623.943905
    7
    Binance Smart Chain3.000728373.999272
    8
    Sei0.4962090341340.503791
    8
    287B
    13s