satsihDaily New Users (30 Days)
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with
users_first as (
SELECT
tx_signer as user,
min(block_timestamp) as first_time
FROM
near.core.fact_transactions
GROUP BY
1
)
SELECT
date_trunc('day', first_time) as first_time,
count(user) as new_users
FROM
users_first
WHERE
first_time > dateadd(day, -30, current_date())
GROUP BY
1
ORDER BY
1 DESC