rezarwzcontracts with selected Yield modes
    Updated 2024-03-22
    SELECT
    tx_hash,
    'configureClaimableYieldOnBehalf' as Function,
    ORIGIN_FUNCTION_SIGNATURE,
    '0x' || SUBSTRING(input_data, 35, 42) AS address,
    input_data
    from
    blast.core.fact_transactions
    where
    to_Address = '0x4300000000000000000000000000000000000002'
    and ORIGIN_FUNCTION_SIGNATURE = '0x37ebe3a8'
    UNION
    all
    SELECT
    tx_hash,
    'configureAutomaticYield' as Function,
    ORIGIN_FUNCTION_SIGNATURE,
    from_Address AS address,
    input_data
    from
    blast.core.fact_transactions
    where
    to_Address = '0x4300000000000000000000000000000000000002'
    and ORIGIN_FUNCTION_SIGNATURE = '0x7114177a'
    UNION
    all
    SELECT
    tx_hash,
    'configureAutomaticYieldOnBehalf' as Function,
    ORIGIN_FUNCTION_SIGNATURE,
    '0x' || SUBSTRING(input_data, 35, 42) AS address,
    input_data
    from
    blast.core.fact_transactions
    where
    to_Address = '0x4300000000000000000000000000000000000002'
    QueryRunArchived: QueryRun has been archived