samnew chain analysis
Updated 2025-03-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
⌄
/*
1. unique chain information - fees, sequencing
2. ez decoded event logs
*/
select
decoded_log:key::string as oracle_name,
to_timestamp(decoded_log:timestamp::string) as oracle_timestamp,
decoded_log:value / pow(10,8) as oracle_value,
tx_hash,
block_timestamp
from boba.core.ez_decoded_event_logs
where block_timestamp::date >= '2025-01-01'
and event_name in (
'OracleUpdate'
)
and contract_address = lower('0xB3519a1760F3A16934a890F19E67A98cBF1e0859')
limit 10
-- 0x2f01160e68a4c0fea014233f9f27b7f61b3852ca2ef20087a72b977af94c9de0 - oracle
-- 0x365e8c170af2ea3f6050e1877ec3b21a4737a26039814bd8f6ca102cc8be9bc0 protocol funding
◘
QueryRunArchived: QueryRun has been archived