DEBUT | NEW_USER | TOTAL_USERS | |
|---|---|---|---|
1 | 2024-12-31 00:00:00.000 | 268292 | 33544823 |
2 | 2024-12-30 00:00:00.000 | 284808 | 33276531 |
3 | 2024-12-29 00:00:00.000 | 132999 | 32991723 |
4 | 2024-12-28 00:00:00.000 | 219144 | 32858724 |
5 | 2024-12-27 00:00:00.000 | 260308 | 32639580 |
6 | 2024-12-26 00:00:00.000 | 323398 | 32379272 |
7 | 2024-12-25 00:00:00.000 | 156654 | 32055874 |
8 | 2024-12-24 00:00:00.000 | 133017 | 31899220 |
9 | 2024-12-23 00:00:00.000 | 210930 | 31766203 |
10 | 2024-12-22 00:00:00.000 | 231712 | 31555273 |
11 | 2024-12-21 00:00:00.000 | 284556 | 31323561 |
12 | 2024-12-20 00:00:00.000 | 278437 | 31039005 |
13 | 2024-12-19 00:00:00.000 | 219179 | 30760568 |
14 | 2024-12-18 00:00:00.000 | 201591 | 30541389 |
15 | 2024-12-17 00:00:00.000 | 216621 | 30339798 |
16 | 2024-12-16 00:00:00.000 | 197134 | 30123177 |
17 | 2024-12-15 00:00:00.000 | 242978 | 29926043 |
18 | 2024-12-14 00:00:00.000 | 230182 | 29683065 |
19 | 2024-12-13 00:00:00.000 | 220165 | 29452883 |
20 | 2024-12-12 00:00:00.000 | 206908 | 29232718 |
aureasarsanedesaptos in 2024 2
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with
users as (
select distinct sender, min(date_trunc('day',block_timestamp)) as debut
from aptos.core.fact_transactions group by 1
)
SELECT
debut,
COUNT(DISTINCT sender) AS new_user,
sum(new_user) over (order by debut) as total_users
FROM users where debut between '2024-01-01' and '2024-12-31'
GROUP BY 1
ORDER BY 1 desc
Last run: 3 days ago
...
366
15KB
73s