WEEK | SERVICE_TYPE | NO_SERVICES | |
|---|---|---|---|
1 | 2023-08-14 00:00:00.000 | Trader | 13 |
2 | 2024-02-12 00:00:00.000 | Trader | 6 |
3 | 2024-06-03 00:00:00.000 | Trader | 8 |
4 | 2023-11-06 00:00:00.000 | Trader | 12 |
5 | 2024-04-08 00:00:00.000 | Trader | 32 |
6 | 2024-04-22 00:00:00.000 | Trader | 13 |
7 | 2024-07-08 00:00:00.000 | Trader | 5 |
8 | 2023-12-18 00:00:00.000 | Trader | 6 |
9 | 2024-12-30 00:00:00.000 | Trader | 24 |
10 | 2025-03-10 00:00:00.000 | Mech | 5 |
11 | 2024-04-15 00:00:00.000 | Trader | 12 |
12 | 2024-11-11 00:00:00.000 | Mech | 1 |
13 | 2025-03-03 00:00:00.000 | Trader | 21 |
14 | 2025-01-20 00:00:00.000 | Trader | 34 |
15 | 2024-10-21 00:00:00.000 | Trader | 130 |
16 | 2024-05-06 00:00:00.000 | Trader | 15 |
17 | 2024-10-28 00:00:00.000 | Trader | 79 |
18 | 2023-08-07 00:00:00.000 | Trader | 24 |
19 | 2024-05-27 00:00:00.000 | Trader | 19 |
20 | 2024-06-10 00:00:00.000 | Trader | 15 |
MLDZMNTotal agents creation 2
Updated 2025-03-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
...
102
4KB
4s