DrsimonActive Users
Updated 2022-11-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH day1 AS
(SELECT DATE_TRUNC('DAY', block_timestamp) as day, TX_SIGNER as user_address
FROM NEAR.core.fact_transactions
WHERE block_timestamp >= '2022-01-01'
GROUP BY day, TX_SIGNER),
week AS
(SELECT DATE_TRUNC('WEEK', day) as week, user_address, COUNT(*) as num_days
FROM day1
GROUP BY week, user_address
),
active_users AS (
SELECT week, COUNT(*) as num_active_users
FROM week
GROUP BY week
), t1 as(
SELECT * , 'NEAR' as laybel
FROM active_users
order by WEEK desc),
--UNION
day2 AS
(SELECT DATE_TRUNC('DAY', block_timestamp) as day, FROM_ADDRESS as user_address
FROM polygon.core.fact_transactions
WHERE block_timestamp >= '2022-01-01'
GROUP BY day, FROM_ADDRESS),
week2 AS
(SELECT DATE_TRUNC('WEEK', day) as week, user_address, COUNT(*) as num_days
FROM day2
GROUP BY week, user_address
),
active_users2 AS (
SELECT week, COUNT(*) as num_active_users
Run a query to Download Data