mp000ber pyth - tot copy
Updated 2024-10-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with all_txs as (
SELECT
a.TX_HASH as tx,
a.BLOCK_TIMESTAMP :: date as time,
b.FROM_ADDRESS as sender
from
berachain.testnet.fact_event_logs a
join berachain.testnet.fact_transactions b on a.TX_HASH = b.TX_HASH
where
a.CONTRACT_ADDRESS = '0xacc0a0cf13571d30b4b8637996f5d6d774d4fd62'
and a.TX_SUCCEEDED = 'TRUE'
)
select
count(DISTINCT tx) as "Oracle calls",
count(tx) as "feed updates",
round("feed updates" / "Oracle calls") as avgupd,
round("Oracle calls" / count(DISTINCT time)) as av,
count(DISTINCT sender) as callers
from
all_txs
QueryRunArchived: QueryRun has been archived