Mrftipreferred-turquoise copy
    Updated 6 hours ago
    -- forked from preferred-turquoise @ https://flipsidecrypto.xyz/studio/queries/e893dfbc-ecbe-45a3-9aec-8820266e9080

    WITH first_appearance AS (
    SELECT
    from_address,
    MIN(DATE_TRUNC('day', block_timestamp)) AS first_appearance_date
    FROM monad.testnet.fact_transactions
    GROUP BY 1
    ),
    daily_new_users AS (
    SELECT
    DATE_TRUNC('day', t.block_timestamp) AS date,
    COUNT(DISTINCT t.from_address) AS daily_new_addresses
    FROM monad.testnet.fact_transactions t
    JOIN first_appearance fa ON t.from_address = fa.from_address
    WHERE DATE_TRUNC('day', t.block_timestamp) = fa.first_appearance_date
    GROUP BY 1
    ),
    cumulative_users AS (
    SELECT
    date,
    daily_new_addresses,
    SUM(daily_new_addresses) OVER (ORDER BY date) AS cumulative_addresses
    FROM daily_new_users
    )

    SELECT
    date,
    daily_new_addresses AS "Daily New Addresses",
    cumulative_addresses AS "Cumulative Unique Addresses"
    FROM cumulative_users
    where date > '2025-02-18 00:00:00.000 '
    ORDER BY 1


    Last run: about 6 hours agoAuto-refreshes every 12 hours
    DATE
    Daily New Addresses
    Cumulative Unique Addresses
    1
    2025-02-19 00:00:00.000124861131164
    2
    2025-02-20 00:00:00.000222148353312
    3
    2025-02-21 00:00:00.000328306681618
    4
    2025-02-22 00:00:00.000225960907578
    5
    2025-02-23 00:00:00.0002748351182413
    6
    2025-02-24 00:00:00.0003677721550185
    7
    2025-02-25 00:00:00.0006283162178501
    8
    2025-02-26 00:00:00.00012407633419264
    9
    2025-02-27 00:00:00.0004157543835018
    10
    2025-02-28 00:00:00.0002583394093357
    11
    2025-03-01 00:00:00.0002498874343244
    12
    2025-03-02 00:00:00.0001896524532896
    13
    2025-03-03 00:00:00.0003053284838224
    14
    2025-03-04 00:00:00.0005048915343115
    15
    2025-03-05 00:00:00.0006452005988315
    16
    2025-03-06 00:00:00.0004845756472890
    17
    2025-03-07 00:00:00.0005468937019783
    18
    2025-03-08 00:00:00.0004135037433286
    19
    2025-03-09 00:00:00.0003525167785802
    20
    2025-03-10 00:00:00.0001792697965071
    28
    1KB
    170s