cloudr3nTransactions by service type
Updated 2024-05-29
999
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
›
⌄
with
-- gnosis
gnosis as (
select
decoded_log:multisig as multisig,
decoded_log:serviceId as serviceId
from
gnosis.core.ez_decoded_event_logs
where
1=1
and event_name='CreateMultisigWithAgents'
and contract_address='0x9338b5153ae39bb89f50468e608ed9d764b755fd' -- Service Registry L2 (AUTONOLAS-SERVICE-L2-V1)
group by
multisig,
serviceid
),
gnosis_tx as (
select
to_address as service_multisig_address,
serviceId,
count(distinct tx_hash) as transaction_number,
'gnosis' as chain
from
gnosis.core.fact_transactions
left join
gnosis on multisig=service_multisig_address
where
to_address in (select distinct multisig from gnosis)
group by
to_address, serviceId
),
service_and_agent_inf_last_gno as (
select
time,
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived