kiacryptoKamino new users
Updated 2022-10-11Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
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