DAY | New Users | Cumulative New Users | |
|---|---|---|---|
1 | 2025-02-05 00:00:00.000 | 9215 | 140420 |
2 | 2025-02-14 00:00:00.000 | 10739 | 222200 |
3 | 2025-02-08 00:00:00.000 | 7111 | 163822 |
4 | 2025-02-13 00:00:00.000 | 10801 | 211461 |
5 | 2025-02-16 00:00:00.000 | 8331 | 239693 |
6 | 2025-01-24 00:00:00.000 | 6725 | 16752 |
7 | 2025-01-25 00:00:00.000 | 13855 | 30607 |
8 | 2025-02-15 00:00:00.000 | 9162 | 231362 |
9 | 2025-01-29 00:00:00.000 | 7147 | 57441 |
10 | 2025-02-07 00:00:00.000 | 7738 | 156711 |
11 | 2025-02-10 00:00:00.000 | 10314 | 183211 |
12 | 2025-01-30 00:00:00.000 | 5840 | 63281 |
13 | 2025-02-18 00:00:00.000 | 10024 | 262894 |
14 | 2025-01-27 00:00:00.000 | 6211 | 43917 |
15 | 2025-02-01 00:00:00.000 | 25316 | 94380 |
16 | 2025-02-19 00:00:00.000 | 8969 | 271863 |
17 | 2025-02-03 00:00:00.000 | 12390 | 119951 |
18 | 2025-01-26 00:00:00.000 | 7099 | 37706 |
19 | 2025-02-21 00:00:00.000 | 9271 | 290675 |
20 | 2025-01-31 00:00:00.000 | 5783 | 69064 |
SniperDaily Number of New Users [last 30 days]
Updated 2025-02-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with users as ( select block_timestamp,
tx_hash,
FROM_ADDRESS as user
from avalanche.core.fact_transactions
where status = 'SUCCESS'
)
,
new_user as ( select min(block_timestamp::date) as date,
user
from users
group by 2)
select trunc(date,'day') as day,
count(DISTINCT user) as "New Users",
sum("New Users") over (order by day asc) as "Cumulative New Users"
from new_user
where
date between (current_date - 31) and (current_date - 1)
group by 1
-- select sum("New Users") as new_users,
-- avg("New Users") as avg_monthly
-- from tbl
Last run: 2 months agoAuto-refreshes every 12 hours
31
1KB
142s