datavortexavg block speed ms
    Updated 2025-04-30
    WITH ethereum_blocks AS (
    SELECT
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_TIMESTAMP) AS prev_block_timestamp
    FROM
    ethereum.core.fact_blocks
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(year, -1, CURRENT_TIMESTAMP)
    ),
    solana_blocks AS (
    SELECT
    BLOCK_ID,
    BLOCK_TIMESTAMP,
    LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_TIMESTAMP) AS prev_block_timestamp
    FROM
    solana.core.fact_blocks
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(year, -1, CURRENT_TIMESTAMP)
    ),
    bsc_blocks AS (
    SELECT
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_TIMESTAMP) AS prev_block_timestamp
    FROM
    bsc.core.fact_blocks
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(year, -1, CURRENT_TIMESTAMP)
    ),
    near_blocks AS (
    SELECT
    BLOCK_ID,
    BLOCK_TIMESTAMP,
    LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_TIMESTAMP) AS prev_block_timestamp
    FROM
    Last run: 29 days ago
    BLOCKCHAIN
    AVG_BLOCK_SPEED_MS
    1
    ethereum12065.477978
    2
    solana437.413834
    3
    bsc2995.392169
    4
    near1148.877452
    5
    avalanche1929.401068
    6
    aptos198.585374
    6
    137B
    91s