Moetxs 5
Updated 2023-09-04
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
27
›
⌄
select
date_trunc(day, block_timestamp) as day,
count (distinct case when n=1 then signers[0] end as "New user",
count (distinct case when n>1 then signers[0] end as "Existing user"
from
(
select
*,
row_number() over(
partition by signers[0]
order by
block_timestamp
) as n
from solana.core.fact_events
where
program_id = 'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'
)
where
block_timestamp >= current_date - 14
group by
1,
2
Run a query to Download Data