samnew chain analysis
    Updated 2025-03-02
    /*
    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