mamad-5XN3k3Euler Vaults
    Updated 2025-05-19
    with pools as (
    select
    CONTRACT_ADDRESS as pool,
    concat('0x', substr(topics[2], 24 + 3, 32 + 8)) as asset
    from swell.core.fact_event_logs
    where topics[0] = '0x0cd345140b9008a43f99a999a328ece572a0193e8c8bf5f5755585e6f293b85e'
    ),
    pricet as (
    select
    distinct asset as TOKEN_ADDRESS,
    c.SYMBOL as sym,
    c.decimals,
    max_by(price, hour) as price
    from pools
    left join crosschain.price.ez_prices_hourly p on asset = p.TOKEN_ADDRESS
    left join swell.core.dim_contracts c on ADDRESS = asset
    where asset not in ('0xc3eacf0612346366db554c991d7858716db09f58','0x09341022ea237a4db1644de7ccf8fa0e489d85b7','0x9cb41cd74d01ae4b4f640ec40f7a60ca1bcf83e7','0x7c98e0779eb5924b3ba8ce3b17648539ed5b0ecc')
    --where BLOCKCHAIN = 'swellchain'
    group by 1,2,3
    union
    select
    '0xc3eacf0612346366db554c991d7858716db09f58' as TOKEN_ADDRESS,
    'rsETH' as sym,
    '18' as decimals,
    max_by(price, hour) as price
    from crosschain.price.ez_prices_hourly
    where BLOCKCHAIN = 'ethereum'
    and token_address = '0xa1290d69c65a6fe4df752f95823fae25cb99e5a7'
    group by 1,2,3
    union
    select
    '0x09341022ea237a4db1644de7ccf8fa0e489d85b7' as TOKEN_ADDRESS,
    'swETH' as sym,
    '18' as decimals,
    max_by(price, hour) as price
    Last run: 12 days ago
    Asset
    Total Supplied
    Total Supplied $
    Total Borrowed
    Total Borrowed $
    Net Supply
    Utilization %
    Paid Fee
    Token Contract
    Vault Address
    1
    WETH 3,915.59 $9,390,920.12 3,319.96 $7,962,398.17 607.4984.790.03690x42000000000000000000000000000000000000060x49c077b74292aa8f589d39034bf9c1ed1825a608
    2
    weETH 2,784.72 $7,125,736.36 547.30 $1,400,468.73 2,245.1119.650.00910xa6cb988942610f6731e664379d15ffcfbf282b440x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3
    3
    rUSDC 5,022,039.68 $5,067,238.04 599,993.20 $605,393.14 4,423,019.8211.9517.95720x9ab96a4668456896d45c301bc3a15cee76aa7b8d0xc5976e0356f0a3ce8307ff08c88bb05933f88761
    4
    swETH 296.55 $762,575.10 14.33 $36,841.65 282.554.8300x09341022ea237a4db1644de7ccf8fa0e489d85b70xf34253ec3dd0cb39c29cf5eeb62161fb350a9d14
    5
    wstETH 206.31 $588,224.33 37.06 $105,659.82 169.8617.9600x7c98e0779eb5924b3ba8ce3b17648539ed5b0ecc0x3c12aa52b014acf7957308808362909b5757cca8
    6
    rswETH 224.25 $557,510.94 12.25 $30,460.03 212.195.4600x18d33689ae5d02649a859a1cf16c9f05639752580x1773002742a2bcc7666e38454f761ce8fe613de5
    7
    ezETH 114.95 $285,100.86 5.21 $12,921.11 110.084.5300x2416092f143378750bb29b79ed961ab195cceea50x4a5c95a0e3fca4148f91ceb637fba0e1080be40e
    8
    pzETH 12.05 $34,455.77 0.10 $291.11 12.140.8400x9cb41cd74d01ae4b4f640ec40f7a60ca1bcf83e70x29c85c752e854b0cf2372e6b6c56f260755f5120
    9
    rsETH 5.17 $12,722.91 1.18 $2,907.31 4.0422.8500xc3eacf0612346366db554c991d7858716db09f580x46e3c018798d6de4517a3c98358e4bd8d334b79c
    10
    SWELL 50.00 $0.56 39.43 $0.44 10.5778.8600x2826d136f5630ada89c1678b64a61620aab77aea0x522d58aefb7b4f54fc1bd31b5063e55c7984badd
    10
    2KB
    28s