Mrfti2024-07-25 01:01 AM copy
    Updated 1 day ago
    -- forked from 2024-07-25 01:01 AM @ https://flipsidecrypto.xyz/studio/queries/3737f134-fde6-4bb6-bb69-1f41db98a659

    SELECT
    date_trunc (day, block_timestamp) as date,
    count (DISTINCT block_number) as "Total blocks",
    sum ("Total blocks") over (order by date) as "cumulative blocks"
    from swell.core.fact_blocks
    GROUP by 1


    Last run: 1 day agoAuto-refreshes every 12 hours
    DATE
    Total blocks
    cumulative blocks
    1
    2024-12-17 00:00:00.00043200891648
    2
    2025-01-10 00:00:00.000432001928448
    3
    2024-12-22 00:00:00.000432001107648
    4
    2025-03-02 00:00:00.000432004131648
    5
    2025-01-12 00:00:00.000432002014848
    6
    2025-02-16 00:00:00.000432003526848
    7
    2025-01-08 00:00:00.000432001842048
    8
    2025-01-04 00:00:00.000432001669248
    9
    2024-12-27 00:00:00.000432001323648
    10
    2025-01-07 00:00:00.000432001798848
    11
    2025-02-03 00:00:00.000432002965248
    12
    2025-01-27 00:00:00.000432002662848
    13
    2024-12-18 00:00:00.00043200934848
    14
    2024-11-27 00:00:00.0002764827648
    15
    2025-02-07 00:00:00.000432003138048
    16
    2025-02-13 00:00:00.000432003397248
    17
    2025-02-17 00:00:00.000432003570048
    18
    2025-03-09 00:00:00.000432004434048
    19
    2025-02-11 00:00:00.000432003310848
    20
    2024-12-16 00:00:00.00043200848448
    ...
    112
    5KB
    2s