Mrfti2024-07-25 01:01 AM copy
    Updated 14 hours 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: about 14 hours agoAuto-refreshes every 12 hours
    DATE
    Total blocks
    cumulative blocks
    1
    2024-12-12 00:00:00.00043200675648
    2
    2024-12-21 00:00:00.000432001064448
    3
    2024-12-20 00:00:00.000432001021248
    4
    2025-01-21 00:00:00.000432002403648
    5
    2025-02-08 00:00:00.000432003181248
    6
    2025-01-23 00:00:00.000432002490048
    7
    2025-02-04 00:00:00.000432003008448
    8
    2024-12-25 00:00:00.000432001237248
    9
    2025-02-12 00:00:00.000432003354048
    10
    2024-12-13 00:00:00.00043200718848
    11
    2025-03-01 00:00:00.000432004088448
    12
    2025-03-04 00:00:00.000432004218048
    13
    2024-12-24 00:00:00.000432001194048
    14
    2024-11-28 00:00:00.0004320070848
    15
    2024-12-30 00:00:00.000432001453248
    16
    2025-02-06 00:00:00.000432003094848
    17
    2025-02-10 00:00:00.000432003267648
    18
    2025-03-15 00:00:00.000432004693248
    19
    2025-01-05 00:00:00.000432001712448
    20
    2024-12-10 00:00:00.00043200589248
    ...
    110
    4KB
    2s