pimi1356-HdnUm3NEW users
Updated 2022-10-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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