rezarwzTVL Over Time
    Updated 5 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
    date_trunc('day', HOUR) as date,
    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) >= '2025-01-15 00:00:00.000'
    group by
    1,
    2
    ),
    asset_data as (
    select
    distinct extracted_token
    Last run: 5 days ago
    DATE
    TVL
    Borrowed
    Available
    Utilization Rate
    1
    2025-03-10 00:00:00.00010511517.40283252770391.620442587741125.782389926.355772571
    2
    2025-03-28 00:00:00.0009185020.003385273154751.270113346030268.7332719434.34670005
    3
    2025-02-07 00:00:00.00020471517.68391785268993.7752451115202523.908672725.738168789
    4
    2025-04-09 00:00:00.0009919735.228590395036251.25743134883483.9711590850.770016955
    5
    2025-03-24 00:00:00.0009483894.716523832932149.208490196551745.5080336430.917142125
    6
    2025-01-31 00:00:00.00019935079.24766996467240.1297746813467839.117895232.441507001
    7
    2025-02-01 00:00:00.00024025241.27492377337125.1178520916688116.157071630.539235939
    8
    2025-03-11 00:00:00.0009323590.017997412367037.08536726956552.9326302125.387614436
    9
    2025-02-28 00:00:00.0009951197.477764132204295.700156637746901.777607522.15105976
    10
    2025-03-23 00:00:00.0009345221.767758072970374.713821156374847.0539369331.784956929
    11
    2025-02-05 00:00:00.00014889366.55417255349842.735290149539523.8188823335.930626839
    12
    2025-03-18 00:00:00.0008825879.632755612779526.109130296046353.5236253231.492907504
    13
    2025-02-23 00:00:00.00012217353.72799822496146.553527669721207.1744705220.431155626
    14
    2025-02-06 00:00:00.00016152605.7003254899363.081526811253242.618798230.331719677
    15
    2025-01-30 00:00:00.00019373811.90201336128415.0787472913245396.82326631.632469179
    16
    2025-02-22 00:00:00.00012071358.34420512479930.735562189591427.6086429620.543924427
    17
    2025-02-18 00:00:00.00012107756.6956352454932.764983369652823.9306515920.275702813
    18
    2025-01-28 00:00:00.0003588170.570565091192406.887798032395763.6827670633.231611049
    19
    2025-02-11 00:00:00.00016166565.69780673128891.064823613037674.632983119.354086225
    20
    2025-03-01 00:00:00.00010163505.67711042252771.653475057910734.0236353722.165301275
    83
    7KB
    8s