MLDZMNnewusersj
    Updated 2023-05-12
    with t1 as (select
    distinct SWAPPER as users,
    min(block_timestamp) as first_appear
    from solana.core.fact_swaps
    where SUCCEEDED='TRUE'
    and PROGRAM_ID ilike 'JUP%'
    group by 1
    )
    SELECT
    date_trunc('{{Time_basis}}', first_appear) as date,
    count(distinct users) as new_users,
    sum(new_users) over (order by date) as Total_new_users
    from t1
    where first_appear>=current_date-{{Time_period_days}}
    group by 1
    order by 1
    Run a query to Download Data