MahrooUntitled Query
Updated 2023-11-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT COUNT (distinct new_user) AS Count_of_new_users,
date_trunc('day', join_date) AS DAY
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