DATE | ACTIVE_WALLETS | DAY | NEW_WALLETS | TOTAL_WALLETS | RETURNING_WALLETS | |
|---|---|---|---|---|---|---|
1 | 2025-01-08 00:00:00.000 | 17609 | 2025-01-08 00:00:00.000 | 9109 | 1258197 | 8500 |
2 | 2024-10-14 00:00:00.000 | 6428 | 2024-10-14 00:00:00.000 | 1448 | 39029 | 4980 |
3 | 2024-10-23 00:00:00.000 | 36804 | 2024-10-23 00:00:00.000 | 20898 | 171709 | 15906 |
4 | 2024-12-07 00:00:00.000 | 22376 | 2024-12-07 00:00:00.000 | 14699 | 705012 | 7677 |
5 | 2024-12-23 00:00:00.000 | 29725 | 2024-12-23 00:00:00.000 | 20690 | 1005269 | 9035 |
6 | 2024-12-15 00:00:00.000 | 29863 | 2024-12-15 00:00:00.000 | 21000 | 835994 | 8863 |
7 | 2025-01-09 00:00:00.000 | 16992 | 2025-01-09 00:00:00.000 | 8321 | 1266518 | 8671 |
8 | 2024-09-16 00:00:00.000 | 867 | 2024-09-16 00:00:00.000 | 322 | 1861 | 545 |
9 | 2024-10-30 00:00:00.000 | 15469 | 2024-10-30 00:00:00.000 | 7857 | 251684 | 7612 |
10 | 2024-12-26 00:00:00.000 | 43464 | 2024-12-26 00:00:00.000 | 29267 | 1079474 | 14197 |
11 | 2024-10-09 00:00:00.000 | 6100 | 2024-10-09 00:00:00.000 | 2020 | 21804 | 4080 |
12 | 2024-09-14 00:00:00.000 | 599 | 2024-09-14 00:00:00.000 | 232 | 1382 | 367 |
13 | 2024-09-19 00:00:00.000 | 1360 | 2024-09-19 00:00:00.000 | 722 | 3965 | 638 |
14 | 2024-12-24 00:00:00.000 | 31638 | 2024-12-24 00:00:00.000 | 22081 | 1027350 | 9557 |
15 | 2024-10-26 00:00:00.000 | 21096 | 2024-10-26 00:00:00.000 | 10574 | 210764 | 10522 |
16 | 2024-12-29 00:00:00.000 | 21611 | 2024-12-29 00:00:00.000 | 11779 | 1135798 | 9832 |
17 | 2024-11-03 00:00:00.000 | 13552 | 2024-11-03 00:00:00.000 | 7229 | 284577 | 6323 |
18 | 2024-09-27 00:00:00.000 | 2806 | 2024-09-27 00:00:00.000 | 540 | 10368 | 2266 |
19 | 2024-10-12 00:00:00.000 | 5021 | 2024-10-12 00:00:00.000 | 654 | 37040 | 4367 |
20 | 2024-10-02 00:00:00.000 | 3955 | 2024-10-02 00:00:00.000 | 851 | 14443 | 3104 |
Pine Analyticsaleo - 3
Updated 2025-01-09
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: 3 months ago
...
128
10KB
18s