DATE | ACTIVE_WALLETS | DAY | NEW_WALLETS | TOTAL_WALLETS | RETURNING_WALLETS | |
|---|---|---|---|---|---|---|
1 | 2025-02-28 00:00:00.000 | 10506 | 2025-02-28 00:00:00.000 | 5542 | 1513694 | 4964 |
2 | 2024-09-27 00:00:00.000 | 2806 | 2024-09-27 00:00:00.000 | 540 | 10368 | 2266 |
3 | 2024-10-02 00:00:00.000 | 3955 | 2024-10-02 00:00:00.000 | 851 | 14443 | 3104 |
4 | 2025-02-01 00:00:00.000 | 4626 | 2025-02-01 00:00:00.000 | 726 | 1486305 | 3900 |
5 | 2024-10-12 00:00:00.000 | 5021 | 2024-10-12 00:00:00.000 | 654 | 37040 | 4367 |
6 | 2025-03-11 00:00:00.000 | 8120 | 2025-03-11 00:00:00.000 | 3957 | 1596747 | 4163 |
7 | 2024-09-10 00:00:00.000 | 283 | 2024-09-10 00:00:00.000 | 170 | 468 | 113 |
8 | 2024-11-19 00:00:00.000 | 19536 | 2024-11-19 00:00:00.000 | 11674 | 449943 | 7862 |
9 | 2024-12-06 00:00:00.000 | 23280 | 2024-12-06 00:00:00.000 | 15222 | 690313 | 8058 |
10 | 2025-04-08 00:00:00.000 | 15678 | 2025-04-08 00:00:00.000 | 11351 | 1759500 | 4327 |
11 | 2025-02-13 00:00:00.000 | 4361 | 2025-02-13 00:00:00.000 | 370 | 1489880 | 3991 |
12 | 2024-09-29 00:00:00.000 | 3270 | 2024-09-29 00:00:00.000 | 813 | 12067 | 2457 |
13 | 2025-05-12 00:00:00.000 | 3834 | 2025-05-12 00:00:00.000 | 1433 | 1839962 | 2401 |
14 | 2024-12-30 00:00:00.000 | 30056 | 2024-12-30 00:00:00.000 | 18659 | 1154457 | 11397 |
15 | 2024-11-14 00:00:00.000 | 19105 | 2024-11-14 00:00:00.000 | 11298 | 396911 | 7807 |
16 | 2025-02-14 00:00:00.000 | 4164 | 2025-02-14 00:00:00.000 | 588 | 1490468 | 3576 |
17 | 2024-09-04 00:00:00.000 | 3 | 2024-09-04 00:00:00.000 | 3 | 3 | 0 |
18 | 2024-12-09 00:00:00.000 | 21301 | 2024-12-09 00:00:00.000 | 14060 | 733719 | 7241 |
19 | 2025-05-14 00:00:00.000 | 4090 | 2025-05-14 00:00:00.000 | 1667 | 1843142 | 2423 |
20 | 2025-04-11 00:00:00.000 | 7292 | 2025-04-11 00:00:00.000 | 4005 | 1772552 | 3287 |
Pine Analyticsaleo - 3
Updated 10 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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with tab1 as (
SELECT
date(block_timestamp) as date,
count(DISTINCT TRIM(SPLIT_PART(SPLIT_PART(fee_msg['transition']['outputs'][0]['value'], '[', 2), ',', 1))) as active_wallets
from aleo.core.fact_transactions
where tx_succeeded
GROUP BY 1
), tab2 as (
SELECT
day,
count(*) as new_wallets,
sum(new_wallets) over (ORDER by day) as total_wallets
from (
SELECT
TRIM(SPLIT_PART(SPLIT_PART(fee_msg['transition']['outputs'][0]['value'], '[', 2), ',', 1)) as wallet,
min(date(block_timestamp)) as day
from aleo.core.fact_transactions
where tx_succeeded
GROUP BY 1
)
group by 1
)
SELECT
*,
active_wallets - new_wallets as returning_wallets
from tab1
left outer join tab2
on day = date
Last run: 10 days ago
...
259
19KB
6s