negin-khNumber of new users on Gnosis over last three months
    Updated 2022-10-17
    with tab1 as (
    select min(block_timestamp::date) as min_date,
    from_address as new_users
    from gnosis.core.fact_transactions
    where block_timestamp >= current_date-90
    group by new_users)

    select date_trunc('day',min_date)as date,
    count(new_users) as total_new_users
    from tab1
    group by date order by date asc
    Run a query to Download Data