DATE | TRANSACTIONS | USERS | NEW_USERS | OLD_USERS | |
|---|---|---|---|---|---|
1 | 2024-09-01 00:00:00.000 | 1411851 | 153399 | 153399 | 0 |
2 | 2024-10-01 00:00:00.000 | 2179054 | 354564 | 333448 | 21116 |
3 | 2024-11-01 00:00:00.000 | 2773871 | 542490 | 481457 | 61033 |
4 | 2024-12-01 00:00:00.000 | 3615212 | 935281 | 867473 | 67808 |
5 | 2025-01-01 00:00:00.000 | 2149993 | 467674 | 414115 | 53559 |
6 | 2025-02-01 00:00:00.000 | 635092 | 66167 | 35295 | 30872 |
7 | 2025-03-01 00:00:00.000 | 2881721 | 235748 | 176067 | 59681 |
8 | 2025-04-01 00:00:00.000 | 3269361 | 262315 | 192075 | 70240 |
9 | 2025-05-01 00:00:00.000 | 80912 | 35003 | 3215 | 31788 |
Afonso_DiazOvertime (users and txns)
Updated 2025-05-02
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
main as (
select
tx_id,
block_timestamp,
f.value['value'] as user
from
aleo.core.fact_transitions
join
lateral flatten(input => inputs) f
where
f.value['value'] ilike 'aleo%'
),
overtime as (
select
date_trunc('{{ period }}', block_timestamp) as date,
count(distinct tx_id) as transactions,
count(distinct user) as users
from main
group by 1
),
min_users as (
select
date_trunc('{{ period }}', min_date) as date,
count(distinct user) as new_user
from (
select
user,
min(block_timestamp) as min_date
from main
group by 1
)
group by 1
Last run: 21 days ago
9
493B
13s