Date | Day Name | New Users | LAG_AUS | NUs Change % | |
|---|---|---|---|---|---|
1 | 2025-03-23 00:00:00.000 | Sun | 7967 | 10049 | -20.72 |
2 | 2025-03-22 00:00:00.000 | Sat | 10049 | 6817 | 47.41 |
3 | 2025-03-21 00:00:00.000 | Fri | 6817 | 5944 | 14.69 |
4 | 2025-03-20 00:00:00.000 | Thu | 5944 | 7387 | -19.53 |
5 | 2025-03-19 00:00:00.000 | Wed | 7387 | 8692 | -15.01 |
6 | 2025-03-18 00:00:00.000 | Tue | 8692 | 8004 | 8.6 |
7 | 2025-03-17 00:00:00.000 | Mon | 8004 |
0xHaM-dDaily report - new users[Past Week]
Updated 9 days ago
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
›
⌄
select
trunc(BLOCK_TIMESTAMP, 'day') as "Date",
dayname(BLOCK_TIMESTAMP::date) as "Day Name",
count(distinct user) as "New Users",
lag("New Users") over (order by "Date") as lag_AUs,
round(100*("New Users"-lag_AUs)/lag_AUs,2) as "NUs Change %"
from (
select
SIGNERS[0] as user,
min(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP
from eclipse.core.fact_transactions
group by 1
)
WHERE "Date" BETWEEN date_trunc(week, current_date())-7 AND date_trunc(week, current_date())-1
group by 1,2
order by 1 desc
Last run: 9 days ago
7
353B
446s