WEEK | SERVICE_TYPE | NO_SERVICES | |
|---|---|---|---|
1 | 2024-08-12 00:00:00.000 | Trader | 15 |
2 | 2024-01-29 00:00:00.000 | Trader | 15 |
3 | 2024-12-02 00:00:00.000 | Trader | 139 |
4 | 2024-12-09 00:00:00.000 | Trader | 27 |
5 | 2023-12-25 00:00:00.000 | Mech | 1 |
6 | 2024-03-11 00:00:00.000 | Mech | 2 |
7 | 2025-02-03 00:00:00.000 | Trader | 37 |
8 | 2024-10-14 00:00:00.000 | Trader | 40 |
9 | 2025-02-03 00:00:00.000 | Mech | 2 |
10 | 2025-05-05 00:00:00.000 | Trader | 5 |
11 | 2024-11-11 00:00:00.000 | Trader | 82 |
12 | 2023-10-23 00:00:00.000 | Trader | 2 |
13 | 2025-03-17 00:00:00.000 | Mech | 3 |
14 | 2025-01-13 00:00:00.000 | Mech | 1 |
15 | 2024-05-27 00:00:00.000 | Trader | 19 |
16 | 2024-05-06 00:00:00.000 | Trader | 15 |
17 | 2024-10-21 00:00:00.000 | Trader | 130 |
18 | 2023-07-10 00:00:00.000 | Trader | 1 |
19 | 2024-03-11 00:00:00.000 | Trader | 4 |
20 | 2025-03-03 00:00:00.000 | Trader | 21 |
MLDZMNTotal agents creation 2
Updated 2025-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date_trunc('week',BLOCK_TIMESTAMP) as week,
case
when NAME ilike '%market_maker%' then 'Creator'
when NAME ilike '%Trader%' then 'Trader'
when NAME ilike '%Mech%' then 'Mech'
else null
end as service_type,
count(distinct TX_HASH) as no_services
from crosschain.olas.ez_service_registrations
group by 1,2 having service_type is not null
Last run: about 1 month ago
...
118
5KB
6s