niloCopy of solana weekly
Updated 2022-12-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH new_T as (SELECT min (BLOCK_TIMESTAMP) as TIME,TX_SENDER as users FROM algorand.core.fact_transaction WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - interval'6 months' GROUP BY 2)
SELECT date_trunc ('week', TIME) as DATE,
COUNT (DISTINCT users) as New_Users,
CASE
WHEN New_Users < 100000 THEN 'Less than 100K New User'
WHEN New_Users BETWEEN 100000 and 200000 THEN 'Between 100K and 200K New User'
WHEN New_Users BETWEEN 200000 and 300000 THEN 'Between 200K and 300K New User'
WHEN New_Users BETWEEN 300000 and 400000 THEN 'Between 300K and 400K New User'
WHEN New_Users BETWEEN 400000 and 500000 THEN 'Between 400K and 500K New User'
ELSE 'More than 500K New User' end as type,
sum (New_Users) over (partition by type order by DATE) as Cum_New_Users
FROM new_T GROUP BY 1
Run a query to Download Data