Mrfti2024-07-25 01:10 AM copy
    Updated 12 hours 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: about 12 hours agoAuto-refreshes every 12 hours
    DATE
    Total addresses
    cumulative addresses
    1
    2025-02-13 00:00:00.00035723237
    2
    2025-03-09 00:00:00.00024130340
    3
    2025-02-07 00:00:00.00035420748
    4
    2024-12-18 00:00:00.00054705
    5
    2025-02-17 00:00:00.00031624623
    6
    2024-11-27 00:00:00.00011
    7
    2024-12-17 00:00:00.00051651
    8
    2025-01-10 00:00:00.0002875835
    9
    2025-02-16 00:00:00.00033124307
    10
    2025-03-02 00:00:00.00026628400
    11
    2025-01-12 00:00:00.0002766332
    12
    2024-12-22 00:00:00.0001681226
    13
    2024-12-31 00:00:00.0002363033
    14
    2024-12-03 00:00:00.000212233
    15
    2024-12-09 00:00:00.00031369
    16
    2024-12-29 00:00:00.0001792603
    17
    2025-03-10 00:00:00.00023130571
    18
    2025-01-06 00:00:00.0002644572
    19
    2025-01-11 00:00:00.0002216056
    20
    2024-12-26 00:00:00.0002072108
    ...
    110
    4KB
    2s