jon_pendleeuler_collateral_address
    Updated 2025-02-03
    with vault_address as (
    select 'Euler' as mm_protocol, chain,
    substr(input, 0, 10) as func_sign,
    to_address as vault,
    concat('0x', substr(input, length(input)-40*3+1, 40)) as asset,
    origin_from_address,
    tx_hash,
    from
    (
    select input, to_address, origin_from_address, tx_hash, 'ethereum' as chain
    from ethereum.core.fact_traces
    where from_address = '0x29a56a1b8214d9cf7c5561811750d5cbdb45cc8e'
    and substr(input, 0, 10) = '0x61014060' and TX_SUCCEEDED

    union all

    select input, to_address, origin_from_address, tx_hash, 'base' as chain
    from base.core.fact_traces
    where from_address = '0x7f321498a801a191a93c840750ed637149ddf8d0'
    and substr(input, 0, 10) = '0x61014060' and TX_SUCCEEDED
    )
    )
    -- vault_with_debt_token as (
    -- select 'Euler' as mm_protocol,
    -- 'ethereum' as chain,
    -- contract_address as vault,
    -- decoded_log['dToken'] as debt_token,
    -- decoded_log['asset'] as asset
    -- from ethereum.core.ez_decoded_event_logs
    -- where event_name = 'EVaultCreated' and contract_address in (select distinct vault from vault_address)
    -- union all
    -- select 'Euler' as mm_protocol,
    -- 'base' as chain,
    -- contract_address as vault,
    Last run: 3 months ago
    MM_PROTOCOL
    CHAIN
    VAULT
    ASSET
    1
    Eulerethereum0xc7de6cca1f2af5faae1c098cc382287df9c0c3f90x5bae9a5d67d1ca5b09b14c91935f635cfbf3b685
    2
    Eulerethereum0x37223b40d2cbf6b87eed891ac02bc1670d03fa8b0xe00bd3df25fb187d6abbb620b3dfd19839947b81
    3
    Eulerethereum0xf57f64426efb4f39ccbcf8ec3280f37578f1c7920x5bae9a5d67d1ca5b09b14c91935f635cfbf3b685
    4
    Eulerethereum0x29847715a8d621bbd34db7380ce8164f69be88a70xf696fe29ef85e892b5926313897d178288faa07e
    5
    Eulerethereum0xcf47fbe97aae77b8abea5e1f59c9bcb808a8d47d0xe00bd3df25fb187d6abbb620b3dfd19839947b81
    6
    Eulerethereum0x81fa50cbe6c7ed61961fe601b7c5ac334c2c84bb0xa8c8861b5ccf8cce0ade6811cd2a7a7d3222b0b8
    7
    Eulerbase0xedcc195ca09c9fcc1dd30b152c0b82045ff2f91f0xec443e7e0e745348e500084892c89218b3ba4683
    8
    Eulerethereum0xc31e04858b43aaf7695d91e36ad7ae179951d3cd0xe00bd3df25fb187d6abbb620b3dfd19839947b81
    9
    Eulerethereum0x396fd980c0463ccb285d3ec6830978d5d97976ec0x44a7876ca99460ef3218bf08b5f52e2dbe199566
    10
    Eulerethereum0xbc99605074737d36266f45e0d192dde6cfdfd72a0xec5a52c685cc3ad79a6a347abace330d69e0b1ed
    11
    Eulerethereum0x3535295273603b0286d385aa2b5e6a4dfabb5cd20xb997b3418935a1df0f914ee901ec83927c1509a0
    12
    Eulerethereum0x6707fe1a8a2f9b8a10441778ac6f6be2ed991ae70xa8c8861b5ccf8cce0ade6811cd2a7a7d3222b0b8
    13
    Eulerethereum0x6e0705396110fd9dbb2829a8d7c5eaa56997cc610x44a7876ca99460ef3218bf08b5f52e2dbe199566
    14
    Eulerbase0x24ca296ae1c935aea6916de0fa0fb92ae47f66370x5d746848005507da0b1717c137a10c30ad9ee307
    15
    Eulerbase0xbc02160f3afdbb2fa77154b552504d7d01bfdc2f0x5d746848005507da0b1717c137a10c30ad9ee307
    16
    Eulerethereum0x60afe4a20afe982e522246223ac50955c88fd0410x7aa68e84bcd8d1b4c9e10b1e565db993f68a3e09
    17
    Eulerethereum0xcc3f4c0aa2867be66551b1c01cdca393a3b01d880x8a47b431a7d947c6a3ed6e42d501803615a97eaa
    18
    Eulerethereum0x6296156d2eacdab2a999f9a0298595c48c7f9fe40xd1a1984cc5cacbd36f6a511877d13662c950fd62
    19
    Eulerbase0x5ce15fc058e762a6f9722fc6521a0c0f5eecd9ba0x5d746848005507da0b1717c137a10c30ad9ee307
    20
    Eulerethereum0xa8610a2faf63b7a73b6fde41012a2fcf5c80e5f50x332a8ee60edff0a11cf3994b1b846bbc27d3dcd6
    32
    3KB
    10s