cilo-pNEW USERS WEEKLY
Updated 2022-09-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with NEW_USERS as
(SELECT TX_SIGNER ,
MIN(block_timestamp) as DATE
from near.core.fact_transactions
where BLOCK_TIMESTAMP > CURRENT_DATE -90
GROUP BY TX_SIGNER )
SELECT
date_trunc('WEEK',DATE ) as WEEK ,
COUNT(DISTINCT TX_SIGNER) as NUMBER_WALEETS
FROM NEW_USERS
GROUP BY 1
ORDER BY 2
Run a query to Download Data