rezarwzUtilization Rate
    Updated 4 days ago
    with vaults as (
    select
    distinct contract_address as v_a,
    REGEXP_REPLACE(
    contract_name,
    '^EVK Vault e(.*)-\\d+$',
    '\\1'
    ) as extracted_token
    from
    swell.core.ez_decoded_event_logs
    where
    ORIGIN_TO_ADDRESS = '0x08739cbede6e28e387685ba20e6409bd16969cde'
    AND Event_name = 'Deposit'
    ),
    Base_tx as (
    select
    block_timestamp :: date as date,
    REGEXP_REPLACE(
    contract_name,
    '^EVK Vault e(.*)-\\d+$',
    '\\1'
    ) AS extracted_token,
    contract_address as vault_address,
    DECODED_LOG:assets / pow(10, 18) as Amount,
    Event_name,
    origin_from_address as user_Address
    from
    swell.core.ez_decoded_event_logs
    where
    contract_address in (
    select
    v_a
    from
    vaults
    )
    AND Event_name in ('Deposit', 'Withdraw', 'Repay', 'Borrow')
    Last run: 4 days ago
    ASSET
    Available
    Utilization Rate
    1
    wstETH168.4202263117.546249382
    2
    Wrapped Ether
    3
    WETH492.60694724185.154118387
    4
    weETH1589.80952701620.462765255
    5
    pzETH11.903938954-2.134687806
    6
    7
    rsETH59.40908955321.354518415
    8
    ezETH323.42157205221.187772311
    9
    swETH292.5434144380.9400381682
    10
    rswETH186.2959741110.09338702651
    10
    342B
    4s