mamad-5XN3k3Euler Vaults
    Updated 8 days ago
    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: 8 days ago
    Asset
    Total Supplied
    Total Supplied $
    Total Borrowed
    Total Borrowed $
    Net Supply
    Utilization %
    Paid Fee
    Token Contract
    Vault Address
    1
    WETH 3,389.63 $8,466,515.67 3,019.49 $7,541,987.94 383.6189.080.03350x42000000000000000000000000000000000000060x49c077b74292aa8f589d39034bf9c1ed1825a608
    2
    weETH 2,534.27 $6,774,538.28 284.13 $759,518.03 2,257.8511.210.00650xa6cb988942610f6731e664379d15ffcfbf282b440x10d0d11a8b693f4e3e33d09bbab7d4afc3c03ef3
    3
    rUSDC 5,002,149.71 $5,037,164.75 750,336.66 $755,589.02 4,255,224.311525.62330x9ab96a4668456896d45c301bc3a15cee76aa7b8d0xc5976e0356f0a3ce8307ff08c88bb05933f88761
    4
    swETH 234.47 $637,637.48 14.33 $38,978.98 220.416.1100x09341022ea237a4db1644de7ccf8fa0e489d85b70xf34253ec3dd0cb39c29cf5eeb62161fb350a9d14
    5
    rswETH 229.21 $595,996.07 14.07 $36,574.40 215.366.1400x18d33689ae5d02649a859a1cf16c9f05639752580x1773002742a2bcc7666e38454f761ce8fe613de5
    6
    wstETH 180.07 $540,875.82 10.83 $32,535.48 169.816.020.00030x7c98e0779eb5924b3ba8ce3b17648539ed5b0ecc0x3c12aa52b014acf7957308808362909b5757cca8
    7
    ezETH 110.05 $288,411.90 0.30 $775.89 110.080.2700x2416092f143378750bb29b79ed961ab195cceea50x4a5c95a0e3fca4148f91ceb637fba0e1080be40e
    8
    pzETH 12.05 $36,079.33 0.10 $304.85 12.140.8400x9cb41cd74d01ae4b4f640ec40f7a60ca1bcf83e70x29c85c752e854b0cf2372e6b6c56f260755f5120
    9
    rsETH 4.76 $12,383.59 1.04 $2,697.50 3.7721.7800xc3eacf0612346366db554c991d7858716db09f580x46e3c018798d6de4517a3c98358e4bd8d334b79c
    10
    SWELL 50.00 $0.43 39.43 $0.34 10.5778.8600x2826d136f5630ada89c1678b64a61620aab77aea0x522d58aefb7b4f54fc1bd31b5063e55c7984badd
    10
    2KB
    34s