flipside

    Daily Block Spped
    datavortexDaily Block Spped
    Updated 2025-04-30
    WITH block_times AS (
    SELECT
    BLOCK_ID,
    BLOCK_TIMESTAMP,
    BLOCK_AUTHOR,
    LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_ID) AS prev_block_timestamp
    FROM
    near.core.fact_blocks
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(hour, -1, CURRENT_TIMESTAMP)
    )
    SELECT
    BLOCK_ID,
    BLOCK_TIMESTAMP,
    BLOCK_AUTHOR,
    TIMESTAMPDIFF(MILLISECOND, prev_block_timestamp, BLOCK_TIMESTAMP) AS block_speed_ms,
    TIMESTAMPDIFF(MILLISECOND, prev_block_timestamp, BLOCK_TIMESTAMP) / 1000.0 AS block_speed_seconds
    FROM
    block_times
    WHERE
    prev_block_timestamp IS NOT NULL
    ORDER BY
    block_speed_seconds;



    /*
    WITH block_times AS (
    SELECT
    BLOCK_ID,
    BLOCK_TIMESTAMP,
    BLOCK_AUTHOR,
    LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_ID) AS prev_block_timestamp
    FROM
    near.core.fact_blocks
    WHERE
    Last run: 23 days ago
    BLOCK_ID
    BLOCK_TIMESTAMP
    BLOCK_AUTHOR
    BLOCK_SPEED_MS
    BLOCK_SPEED_SECONDS
    1
    		1454051132025-04-30 05:22:54.689inotel.poolv1.near00
    2
    		1454044962025-04-30 05:11:39.729inotel.poolv1.near00
    3
    		1454047272025-04-30 05:15:50.845inotel.poolv1.near40.004
    4
    		1454058622025-04-30 05:36:51.517inotel.poolv1.near940.094
    5
    		1454042972025-04-30 05:08:02.861inotel.poolv1.near980.098
    6
    		1454044052025-04-30 05:10:01.080inotel.poolv1.near2170.217
    7
    		1454060332025-04-30 05:40:00.421inotel.poolv1.near2210.221
    8
    		1454054652025-04-30 05:29:26.702figment.poolv1.near6250.625
    9
    		1454043962025-04-30 05:09:50.784galaxydigital.poolv1.near6590.659
    10
    		1454054052025-04-30 05:28:15.187figment.poolv1.near6780.678
    11
    		1454041162025-04-30 05:04:47.225stake1.poolv1.near7190.719
    12
    		1454054452025-04-30 05:29:03.108bitcoinsuisse.poolv1.near7190.719
    13
    		1454054382025-04-30 05:28:55.117nearone.pool.near7230.723
    14
    		1454053922025-04-30 05:27:59.775sweat_validator.poolv1.near7240.724
    15
    		1454040762025-04-30 05:04:01.086dsrvlabs.poolv1.near7700.77
    16
    		1454039942025-04-30 05:02:29.942flipside.pool.near7880.788
    17
    		1454060482025-04-30 05:40:17.681figment.poolv1.near7950.795
    18
    		1454055982025-04-30 05:32:00.936figment.poolv1.near7990.799
    19
    		1454041242025-04-30 05:04:56.432cosmose.poolv1.near8030.803
    20
    		1454054332025-04-30 05:28:49.928astro-stakers.poolv1.near8060.806
    ...
    2116
    151KB
    2s