SENDER_ADDRESS | SERVICEID | Avg daily request | |
|---|---|---|---|
1 | 0x04430ebfb7d088960233b7353cb4cefb528dc31e | 520 | 22.571429 |
2 | 0x37bab68f9ae4f9c7ce915d9e1f3404e7cd1794cc | 569 | 1 |
3 | 0xc0de1041eaef133b72e22697a497db4f266c9584 | 502 | 6.157895 |
4 | 0xe0113a139f591efa8bf5e19308c7c27199682d77 | 486 | 9.017647 |
5 | 0x51b86fccc3d92d6d2459b7a2bc6498e18bd0afa2 | 522 | 6.69697 |
6 | 0x36660fec571bb4d5849a433f9ec64622416f1dbb | 482 | 10.907216 |
7 | 0xb48d22fff4b438f84522c68df37c2a539be87cc2 | 548 | 7.153846 |
8 | 0x8b4666cba14b32ed50818c5684b5ced912627ebd | 510 | 90 |
9 | 0x6ed28d3d8996dccc661559cd34a160b18cd3c7a8 | 514 | 9.952381 |
10 | 0x3a2d7bf095988f30daf308b5484cd74903d82c22 | 573 | 23.5 |
11 | 0x2604cb57b88a3d1be9301b5e786d92961ea4a1d1 | 518 | 18.555556 |
12 | 0x7011de27693bd17bfc248722488aec71f8941137 | 500 | 7.326316 |
13 | 0x358e58683e54b2b1b0536727df52a001df5acdf8 | 493 | 5.824176 |
14 | 0x63a55f6158010c4c1439de1b7a6bf78a7fbac462 | 517 | 5 |
15 | 0x3dcc00904249d796a89943de15c85ac11afc5d66 | 519 | 6.693694 |
16 | 0x29e9576633cafd8b0040cd3054c190d85a97a95b | 565 | 7.119403 |
17 | 0xfd5f7d27f31aea2fdba38ced1c2a3ace4bf41c64 | 494 | 9.129032 |
18 | 0xd5fcb0db8af1c19655103c499ab7e20c58b888d4 | 529 | 29.75 |
19 | 0x360e606b22df1f808366255ef0bbefa425f570f4 | 580 | 10.106195 |
20 | 0xa046e62ae47c5d2f744d25498349c1c0a4be639c | 481 | 10.4 |
Flipside TeamAverage daily requests count by all participants
Updated 10 days ago
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
›
⌄
with tb1 as (select
BLOCK_TIMESTAMP,
tx_hash,
MULTISIG_ADDRESS as multisig,
OWNER_ADDRESS as owner,
SERVICE_ID as serviceId,
row_number() OVER (partition BY serviceId order by BLOCK_TIMESTAMP desc) as r_no
from crosschain.olas.ez_service_staking
where PROGRAM_NAME = 'Alpha'
and EVENT_NAME = 'ServiceStaked'
),
tb2 as (select
date_trunc('day',BLOCK_TIMESTAMP) as day,
DECODED_LOG:sender as SENDER_ADDRESS,
count(*) as request_number
from gnosis.core.ez_decoded_event_logs r
where CONTRACT_ADDRESS = '0x77af31de935740567cf4ff1986d04b2c964a786a'
and EVENT_NAME = 'Request'
and DECODED_LOG:sender in (select multisig from tb1)
group by 1,2)
select
SENDER_ADDRESS,
serviceId,
avg(request_number) as "Avg daily request"
from tb2
left join tb1 on tb2.SENDER_ADDRESS = tb1.multisig
group by 1,2
Last run: 10 days ago
62
4KB
31s