nitsDaily New Users
Updated 2022-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with a as
(SELECT date(f_u) as day , COUNT(DISTINCT tx_signer)as total_signers,
sum(total_signers) over (order by day) as cumulative_new_users
from
(SELECT tx_signer , min(block_timestamp) as f_u from mdao_near.transactions
GROUP by 1)
where day >= CURRENT_DATE -90
GROUP by 1 )
SELECT *,
cumulative_new_users_-cumulative_new_users_ as net_joiners_in_past_30_days
from
(SELECT date(f_u) as day_ , COUNT(DISTINCT tx_signer)as total_signers_,
sum(total_signers_) over (order by day_) as cumulative_new_users_ from
(SELECT tx_signer , min(block_timestamp) as f_u from mdao_near.transactions
GROUP by 1)
where day_ >= CURRENT_DATE -90
GROUP by 1 )
inner join a
on day = day_+30
-- LIMIT 10
Run a query to Download Data