0xHaM-dTrader Breakdown by # of Mech request's
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
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Mech request's traders @ https://flipsidecrypto.xyz/studio/queries/5e44c6a1-c9cf-4963-a605-f2874ffeca52
-- forked from Mech request by traders copy @ https://flipsidecrypto.xyz/studio/queries/d2112306-34d5-4c55-a1b3-776ac40900d4
-- forked from MLDZMN / Mech request by traders @ https://flipsidecrypto.xyz/MLDZMN/q/5Bclrrbzhrwa/mech-request-by-traders
with t1 as (
select
BLOCK_TIMESTAMP,
tx_hash,
SERVICE_ID,
NAME,
MULTISIG_ADDRESS,
AGENT_IDS[0] as agent_Id
from crosschain.olas.ez_service_registrations
where NAME ilike '%Trader%'
)
, breakdown as (
select
-- count(DISTINCT SENDER_ADDRESS) as n_traders,
SENDER_ADDRESS,
count(*) as n_requests,
from crosschain.olas.fact_mech_activity ac
JOIN t1 on SENDER_ADDRESS = MULTISIG_ADDRESS
group by 1
)
SELECT
CASE
when n_requests = 1 then 'Only 1 Req'
when n_requests > 1 and n_requests <=10 then '2 ~ 10 Req'
when n_requests > 10 and n_requests <=50 then '11 ~ 50 Req'
when n_requests > 50 and n_requests <=100 then '51 ~ 100 Req'
when n_requests > 100 and n_requests <=250 then '101 ~ 250 Req'
when n_requests > 250 and n_requests <=500 then '250 ~ 500 Req'
when n_requests > 500 then '> 500 Req'
end as brekdown,
QueryRunArchived: QueryRun has been archived