Mrfti2024-07-25 01:10 AM copy
    Updated 1 day ago
    -- forked from 2024-07-25 01:10 AM @ https://flipsidecrypto.xyz/studio/queries/cef5341d-0f6a-433c-b796-709156fcc4b0

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


    Last run: 1 day agoAuto-refreshes every 12 hours
    DATE
    Total addresses
    cumulative addresses
    1
    2024-12-12 00:00:00.00039486
    2
    2025-02-12 00:00:00.00043322880
    3
    2024-12-25 00:00:00.0002401901
    4
    2025-02-08 00:00:00.00038621134
    5
    2025-02-04 00:00:00.00038219649
    6
    2024-12-21 00:00:00.0001241058
    7
    2024-12-20 00:00:00.000121934
    8
    2025-01-23 00:00:00.000125013427
    9
    2025-01-21 00:00:00.0002729021
    10
    2024-12-22 00:00:00.0001681226
    11
    2025-01-12 00:00:00.0002766332
    12
    2025-02-16 00:00:00.00033124307
    13
    2025-03-02 00:00:00.00026628400
    14
    2025-01-10 00:00:00.0002875835
    15
    2024-12-17 00:00:00.00051651
    16
    2024-12-16 00:00:00.00045600
    17
    2025-01-24 00:00:00.00092914356
    18
    2025-01-28 00:00:00.00054516721
    19
    2025-02-24 00:00:00.00025026824
    20
    2024-12-02 00:00:00.0001021
    ...
    112
    4KB
    2s