DAY | NO_REQUESTS | TOTAL_REQUESTS | |
|---|---|---|---|
1 | 2025-03-14 00:00:00.000 | 3147 | 3014134 |
2 | 2025-03-13 00:00:00.000 | 18685 | 3010987 |
3 | 2025-03-12 00:00:00.000 | 19430 | 2992302 |
4 | 2025-03-11 00:00:00.000 | 21103 | 2972872 |
5 | 2025-03-10 00:00:00.000 | 19901 | 2951769 |
6 | 2025-03-09 00:00:00.000 | 16973 | 2931868 |
7 | 2025-03-08 00:00:00.000 | 18955 | 2914895 |
8 | 2025-03-07 00:00:00.000 | 19073 | 2895940 |
9 | 2025-03-06 00:00:00.000 | 19704 | 2876867 |
10 | 2025-03-05 00:00:00.000 | 19898 | 2857163 |
11 | 2025-03-04 00:00:00.000 | 18400 | 2837265 |
12 | 2025-03-03 00:00:00.000 | 19520 | 2818865 |
13 | 2025-03-02 00:00:00.000 | 20867 | 2799345 |
14 | 2025-03-01 00:00:00.000 | 22127 | 2778478 |
15 | 2025-02-28 00:00:00.000 | 19413 | 2756351 |
16 | 2025-02-27 00:00:00.000 | 22600 | 2736938 |
17 | 2025-02-26 00:00:00.000 | 12850 | 2714338 |
18 | 2025-02-25 00:00:00.000 | 20625 | 2701488 |
19 | 2025-02-24 00:00:00.000 | 19546 | 2680863 |
20 | 2025-02-23 00:00:00.000 | 19311 | 2661317 |
MLDZMNMech request by traders
Updated 2025-03-14
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
›
⌄
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%'
)
select
date_trunc('day',BLOCK_TIMESTAMP) as day,
count(*) as no_requests,
sum(no_requests) over (order by day) as total_requests
from crosschain.olas.fact_mech_activity
where SENDER_ADDRESS in (select MULTISIG_ADDRESS from t1)
group by 1
order by 1 desc
Last run: about 1 month ago
...
501
19KB
6s