DAY | New Users | Cumulative New Users | |
---|---|---|---|
1 | 2024-06-22 00:00:00.000 | 56791 | 706568 |
2 | 2024-06-13 00:00:00.000 | 16921 | 56890 |
3 | 2024-07-03 00:00:00.000 | 42647 | 1329607 |
4 | 2024-10-04 00:00:00.000 | 899652 | 17659253 |
5 | 2024-08-22 00:00:00.000 | 25954 | 3209612 |
6 | 2024-11-08 00:00:00.000 | 3489 | 30227476 |
7 | 2024-11-04 00:00:00.000 | 1899 | 30212505 |
8 | 2024-07-08 00:00:00.000 | 24210 | 1551679 |
9 | 2024-07-17 00:00:00.000 | 42117 | 1849082 |
10 | 2024-09-29 00:00:00.000 | 1273679 | 12195094 |
11 | 2024-09-04 00:00:00.000 | 11318 | 3319706 |
12 | 2024-12-30 00:00:00.000 | 291881 | 31822584 |
13 | 2024-11-14 00:00:00.000 | 1224 | 30238166 |
14 | 2024-12-09 00:00:00.000 | 1666 | 30309276 |
15 | 2024-06-24 00:00:00.000 | 79941 | 843650 |
16 | 2024-09-03 00:00:00.000 | 12516 | 3308388 |
17 | 2024-10-19 00:00:00.000 | 4752 | 30143843 |
18 | 2025-01-31 00:00:00.000 | 87917 | 34081811 |
19 | 2024-07-05 00:00:00.000 | 70456 | 1458806 |
20 | 2024-09-22 00:00:00.000 | 263446 | 4271373 |
Bera TeamDaily Number of New Addresses
Updated 5 days agoCopy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
-- Daily New Users Based on the first Transaction date
with new as ( select min(block_timestamp::date) as day,
from_address
from berachain.testnet.fact_transactions
group by 2)
select day,
count(DISTINCT from_address) as "New Users",
sum("New Users") over (order by day asc) as "Cumulative New Users"
from new
group by 1
Last run: 5 days ago
246
10KB
23s