dan-smithmissed slots
    Updated 2023-09-16
    /**
    ###
    ### Test for latest blocks
    ###

    SELECT
    slot_timestamp
    ,slot_number
    FROM ethereum.beacon_chain.fact_blocks
    ORDER BY 2 DESC
    LIMIT 10

    **/

    SELECT
    dt
    ,DATE_PART(epoch_second, dt) AS epoch
    ,missed_percent
    FROM (
    SELECT
    dt
    ,SUM(missed_slots) AS missed
    ,COUNT(DISTINCT slot_number) AS attested
    ,missed + attested AS total
    ,missed / total AS missed_percent
    FROM (
    SELECT
    slot_timestamp
    ,date_trunc('day',slot_timestamp) AS dt
    ,slot_number
    ,LAG(slot_number,1) OVER(ORDER BY slot_number) AS prev_slot
    ,slot_number - prev_slot - 1 AS missed_slots
    FROM ethereum.beacon_chain.fact_blocks
    WHERE slot_timestamp >= '2020-06-20'
    ORDER BY slot_number
    )
    Run a query to Download Data