DATE | ACTIVE_PROGRAMS | |
|---|---|---|
1 | 2024-09-27 00:00:00.000 | 20 |
2 | 2024-10-02 00:00:00.000 | 30 |
3 | 2024-09-10 00:00:00.000 | 17 |
4 | 2024-10-12 00:00:00.000 | 34 |
5 | 2024-12-26 00:00:00.000 | 68 |
6 | 2024-10-09 00:00:00.000 | 43 |
7 | 2024-10-30 00:00:00.000 | 44 |
8 | 2024-09-14 00:00:00.000 | 6 |
9 | 2024-12-23 00:00:00.000 | 46 |
10 | 2024-12-15 00:00:00.000 | 45 |
11 | 2024-10-01 00:00:00.000 | 29 |
12 | 2024-10-14 00:00:00.000 | 38 |
13 | 2024-10-23 00:00:00.000 | 31 |
14 | 2024-12-07 00:00:00.000 | 39 |
15 | 2024-11-20 00:00:00.000 | 42 |
16 | 2025-01-08 00:00:00.000 | 48 |
17 | 2024-10-06 00:00:00.000 | 23 |
18 | 2024-09-06 00:00:00.000 | 16 |
19 | 2024-10-17 00:00:00.000 | 36 |
20 | 2024-12-05 00:00:00.000 | 43 |
Pine Analyticsaleo - 5 copy
Updated 2025-01-09
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: 3 months ago
...
128
4KB
28s