WEEK | ACTIVE_USERS | NEW_USERS | |
|---|---|---|---|
1 | 2025-01-07 00:00:00.000 | 8 | 8 |
2 | 2025-01-08 00:00:00.000 | 25 | 19 |
3 | 2025-01-09 00:00:00.000 | 37 | 25 |
4 | 2025-01-10 00:00:00.000 | 39 | 16 |
5 | 2025-01-11 00:00:00.000 | 18 | 5 |
6 | 2025-01-12 00:00:00.000 | 15 | 3 |
7 | 2025-01-13 00:00:00.000 | 55 | 32 |
8 | 2025-01-14 00:00:00.000 | 49 | 14 |
9 | 2025-01-15 00:00:00.000 | 68 | 25 |
10 | 2025-01-16 00:00:00.000 | 86 | 35 |
11 | 2025-01-17 00:00:00.000 | 94 | 37 |
12 | 2025-01-18 00:00:00.000 | 30 | 5 |
13 | 2025-01-19 00:00:00.000 | 142 | 116 |
14 | 2025-01-20 00:00:00.000 | 223 | 198 |
15 | 2025-01-21 00:00:00.000 | 78 | 37 |
16 | 2025-01-22 00:00:00.000 | 77 | 33 |
17 | 2025-01-23 00:00:00.000 | 119 | 52 |
18 | 2025-01-24 00:00:00.000 | 2138 | 2060 |
19 | 2025-01-25 00:00:00.000 | 41 | 9 |
20 | 2025-01-26 00:00:00.000 | 39 | 14 |
0xHaM-dMonad Testen stats: active users (over time by day)
Updated 2025-03-21
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
news as (
SELECT
distinct FROM_ADDRESS as users,
min(trunc(block_timestamp,'d')) as debut
from monad.testnet.fact_transactions
-- WHERE block_timestamp < trunc(current_date,'hour')
group by 1
),
news2 as (
select distinct debut,
count(distinct users) as new_users
from news group by 1
),
actives as (
SELECT
trunc(block_timestamp,'d') as week,
count(distinct FROM_ADDRESS) as active_users
from monad.testnet.fact_transactions x
-- WHERE block_timestamp < trunc(current_date,'hour')
group by 1 order by 1 desc
)
select
week,
active_users,
new_users
from actives a
join news2 n on a.week=n.debut
-- WHERE week <
order by 1 asc
Last run: 3 months ago
74
3KB
44s