Ali3NDately Monad Users Evolution Over Time (New Monad TestNet Users)
    Updated 8 hours ago
    select date_trunc (day,mindate) as date,
    count (distinct from_address) as New_users,
    sum (new_users) over (order by date) as Total_Users
    from (
    select from_address,
    min (block_timestamp) as mindate
    from monad.testnet.fact_transactions
    where block_timestamp >= '2025-02-19'
    group by 1)
    group by 1
    order by 1 desc
    Last run: about 8 hours agoAuto-refreshes every 12 hours
    DATE
    NEW_USERS
    TOTAL_USERS
    1
    2025-04-16 00:00:00.0003583974185571683
    2
    2025-04-15 00:00:00.0008342570181987709
    3
    2025-04-14 00:00:00.0007246390173645139
    4
    2025-04-13 00:00:00.0004412107166398749
    5
    2025-04-12 00:00:00.0006039093161986642
    6
    2025-04-11 00:00:00.0007290812155947549
    7
    2025-04-10 00:00:00.0004178564148656737
    8
    2025-04-09 00:00:00.0004551668144478173
    9
    2025-04-08 00:00:00.0006206249139926505
    10
    2025-04-07 00:00:00.0007078701133720256
    11
    2025-04-06 00:00:00.0006372792126641555
    12
    2025-04-05 00:00:00.0005896017120268763
    13
    2025-04-04 00:00:00.0006581098114372746
    14
    2025-04-03 00:00:00.0006834005107791648
    15
    2025-04-02 00:00:00.0006593064100957643
    16
    2025-04-01 00:00:00.000573269594364579
    17
    2025-03-31 00:00:00.000641785088631884
    18
    2025-03-30 00:00:00.000519345082214034
    19
    2025-03-29 00:00:00.000476489677020584
    20
    2025-03-28 00:00:00.000345647972255688
    57
    2KB
    105s