Mrfti2024-07-25 12:47 AM copy
    Updated 20 hours ago
    -- forked from 2024-07-25 12:47 AM @ https://flipsidecrypto.xyz/studio/queries/33d39e25-bb8d-4f6d-941c-96ded7331dca

    with tbl AS
    (
    SELECT
    date_trunc(day, block_timestamp) as date,
    count(DISTINCT block_number) as "Daily blocks",
    sum(tx_count) as "Daily tx"
    from swell.core.fact_blocks
    GROUP by 1
    )

    SELECT
    date,
    "Daily tx"/"Daily blocks" as "Daily avg tx per block"
    from tbl
    where "Daily tx" is not null
    --GROUP by 1,2


    Last run: about 20 hours agoAuto-refreshes every 12 hours
    DATE
    Daily avg tx per block
    1
    2025-01-04 00:00:00.0001.077546
    2
    2024-12-27 00:00:00.0001.081042
    3
    2025-01-08 00:00:00.0001.106412
    4
    2025-01-07 00:00:00.0001.101389
    5
    2025-01-27 00:00:00.0001.136829
    6
    2025-02-03 00:00:00.0001.177523
    7
    2024-12-23 00:00:00.0001.103981
    8
    2025-01-03 00:00:00.0001.082986
    9
    2025-01-18 00:00:00.0001.106991
    10
    2025-02-20 00:00:00.0001.083241
    11
    2025-01-30 00:00:00.0001.122153
    12
    2025-02-18 00:00:00.0001.117153
    13
    2025-02-22 00:00:00.0001.08831
    14
    2025-03-11 00:00:00.0001.138912
    15
    2025-03-06 00:00:00.0001.150671
    16
    2025-01-02 00:00:00.0001.092986
    17
    2025-01-26 00:00:00.0001.100255
    18
    2025-01-14 00:00:00.0001.098056
    19
    2025-02-09 00:00:00.0001.097431
    20
    2024-12-24 00:00:00.0001.090972
    ...
    110
    4KB
    2s