DATE | ACTIVE_PROGRAMS | |
|---|---|---|
1 | 2024-10-23 00:00:00.000 | 31 |
2 | 2024-10-14 00:00:00.000 | 38 |
3 | 2024-12-07 00:00:00.000 | 39 |
4 | 2025-01-14 00:00:00.000 | 46 |
5 | 2025-02-18 00:00:00.000 | 37 |
6 | 2024-12-23 00:00:00.000 | 46 |
7 | 2024-10-30 00:00:00.000 | 44 |
8 | 2024-12-26 00:00:00.000 | 68 |
9 | 2024-09-14 00:00:00.000 | 6 |
10 | 2024-10-09 00:00:00.000 | 43 |
11 | 2025-04-21 00:00:00.000 | 42 |
12 | 2024-12-24 00:00:00.000 | 39 |
13 | 2025-02-21 00:00:00.000 | 33 |
14 | 2024-12-29 00:00:00.000 | 50 |
15 | 2025-03-12 00:00:00.000 | 39 |
16 | 2024-10-26 00:00:00.000 | 30 |
17 | 2025-02-03 00:00:00.000 | 43 |
18 | 2024-09-27 00:00:00.000 | 20 |
19 | 2024-10-02 00:00:00.000 | 30 |
20 | 2025-02-01 00:00:00.000 | 35 |
Pine Analyticsaleo - 5 copy
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date(block_timestamp) as date,
count(DISTINCT program_id) as active_programs
from aleo.core.fact_transitions
GROUP BY 1
Last run: 10 days ago
...
259
8KB
2s