MLDZMNtxn5
    Updated 2023-07-21
    select
    date_trunc('{{Time_basis}}', first_transaction_stamp) as date,
    count(distinct sender) as new_users,
    sum(new_users) over (order by date) as cum_new_users
    from (
    select
    distinct FROM_ADDRESS as sender,
    min(block_timestamp) as first_transaction_stamp
    from aurora.core.fact_transactions
    group by 1
    )
    group by 1
    Run a query to Download Data