Updated 2022-10-09
    with mindateee as (
    select signers[0] as user,
    min (block_timestamp) as mindate
    from solana.core.fact_transactions
    where instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and succeeded = 'TRUE'
    group by 1)

    select date_trunc('{{date_range}}', mindate) as date,
    count (distinct user) as New_Users,
    sum (new_users) over (order by date) as Total_New_Users
    from mindateee
    group by 1


    Run a query to Download Data