Afonso_Diaz2023-02-03 03:04 PM
    Updated 2023-02-03
    with t1 as (
    select tx_sender,
    min (date_trunc(week, blocK_timestamp))::date as min_date
    from terra.core.fact_transactions
    group by 1
    )

    select min_date as week,
    count (distinct tx_sender) as new_users_count,
    sum (new_users_count) over (order by min_date) as cumulative_new_users_count
    from t1
    group by 1
    order by 1
    Run a query to Download Data