mlhNew NEAR Users3
Updated 2022-09-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select count (distinct new_user) as new_users_count,
date_trunc('week', join_date) as week
from (select tx_signer as new_user,
min (block_timestamp) as join_date
from near.core.fact_transactions
where block_timestamp::date >= CURRENT_DATE - 90
and tx_signer not in (select new_user
from (select tx_signer as new_user,
min (block_timestamp) as join_date
from near.core.fact_transactions
where block_timestamp::date <= CURRENT_DATE - 90
group by 1
)
)
group by 1
)
group by 2
Run a query to Download Data