Mrfti2024-07-25 12:40 AM copy
    Updated 20 hours ago
    -- forked from 2024-07-25 12:40 AM @ https://flipsidecrypto.xyz/studio/queries/e0f95acb-083f-460b-b2f3-0ee063bbb547

    with tbl AS
    (
    SELECT date_trunc (day, block_timestamp) as date,
    count (DISTINCT block_number) as "Block count"
    FROM swell.core.fact_blocks
    group by 1
    )

    SELECT sum ("Block count")/count (DISTINCT date) as "Avg Daily blocks"
    from tbl


    Last run: about 20 hours agoAuto-refreshes every 12 hours
    Avg Daily blocks
    1
    42686.427273
    1
    16B
    36s