0xHaM-dTotal agents creation in Ttl
Updated 2025-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from Total agents creation Over Time @ https://flipsidecrypto.xyz/studio/queries/36bc2ae2-ac40-4fb8-b857-c5af13ceb785
-- forked from MLDZMN / Total agents creation 2 @ https://flipsidecrypto.xyz/MLDZMN/q/oRtz5mx8KUP0/total-agents-creation-2
select
case
when NAME ilike '%market_maker%' then 'Creator'
when NAME ilike '%Trader%' then 'Trader'
when NAME ilike '%Mech%' then 'Mech'
else 'Other' end as service_type,
count(distinct TX_HASH) as no_services,
from crosschain.olas.ez_service_registrations
WHERE NAME is not null
group by 1
ORDER by 2
QueryRunArchived: QueryRun has been archived