dannyamahNew and Existing Users
    Updated 2025-02-20
    with marinade as (
    select
    block_timestamp,
    from_address,
    to_address,
    row_number () over (partition by from_address order by block_timestamp asc) as rn
    from
    monad.testnet.fact_transactions
    where
    block_timestamp >= '2025-02-19'
    )

    select
    case when rn = '1' then 'New Users'
    else 'Existing Users'
    end as type,
    count (distinct from_address) as Users
    from marinade
    group by 1

    Last run: 27 days ago
    TYPE
    USERS
    1
    Existing Users144791
    2
    New Users225736
    2
    48B
    2s