rezarwzKey metrics
    Updated 2 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'
    ),
    assets_price as (
    select
    symbol,
    median(price) as price
    from
    crosschain.price.ez_prices_hourly
    where
    symbol in (
    select
    distinct upper(extracted_token)
    from
    vaults
    )
    and date_trunc('day', HOUR) >= current_Date
    group by
    1
    ),
    asset_data as (
    select
    distinct extracted_token
    from
    vaults
    Last run: 2 days ago
    Utilization Rate
    Borrowed Value
    TVL
    Total Available
    1
    50.4135632445503784.7996717410917269.9676555413485.16798327
    1
    66B
    6s