rezarwzUtilization Rate
    Updated 8 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
    wstETH169.0573380517.594638628
    2
    Wrapped Ether
    3
    rUSDC0.0000048995960592.330101667
    4
    WETH665.28560002481.796442677
    5
    weETH1826.58291721517.618036232
    6
    rsETH3.79274801719.543120499
    7
    ezETH325.21853179921.09539811
    8
    swETH284.3407370573.718616977
    9
    pzETH11.903938818-2.134687831
    10
    rswETH223.7523544194.659805607
    10
    360B
    17s