Afonso_DiazAutomatic Yield on Behalf
    Updated 2024-04-15
    with

    authomatic_yield_on_behalf as (
    select
    tx_hash,
    block_timestamp,
    from_address,
    '0x' || substring(input_data, 35) as contract_address
    from blast.core.fact_transactions
    where to_address = '0x4300000000000000000000000000000000000002' --ETH Address
    and origin_function_signature = '0x3ba5713e' -- Authomatic Yield On Behalf Function Signature
    and status = 'SUCCESS'
    )


    select * from authomatic_yield_on_behalf
    QueryRunArchived: QueryRun has been archived