kiacryptoKamino new users
    Updated 2022-10-11
    with base as (
    select *
    from solana.core.fact_transactions
    where instructions[0]:programId = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc'
    ),
    first_user as (
    select
    signers[0] as wallet,
    min(block_timestamp) as min_date
    from base
    group by 1
    ),
    info as (
    select
    date_trunc('day', min_date) as date,
    count(distinct wallet) as new_user,
    avg(new_user) over (order by date, date rows between 6 preceding and current row) as ma7_new_user
    from first_user
    group by 1
    ),
    avg_info as (
    select avg(new_user) as avg_new_user
    from info
    )
    select *
    from info, avg_info
    Run a query to Download Data