mlhNew NEAR Users3
    Updated 2022-09-07
    select count (distinct new_user) as new_users_count,
    date_trunc('week', join_date) as week
    from (select tx_signer as new_user,
    min (block_timestamp) as join_date
    from near.core.fact_transactions
    where block_timestamp::date >= CURRENT_DATE - 90
    and tx_signer not in (select new_user
    from (select tx_signer as new_user,
    min (block_timestamp) as join_date
    from near.core.fact_transactions
    where block_timestamp::date <= CURRENT_DATE - 90
    group by 1
    )
    )
    group by 1
    )
    group by 2
    Run a query to Download Data