rezarwzCumulative Supplied Value
    Updated 7 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: 7 days ago
    DATE
    ASSET
    Net Flow
    Cumulative Value
    ASSET_AMOUNT
    1
    2025-04-02 00:00:00.000ezETH0812711.560042194415.259992408
    2
    2025-02-14 00:00:00.000swETH0231599.18803502879.21306132
    3
    2025-02-23 00:00:00.000swETH0273362.70841972190.309173849
    4
    2025-04-12 00:00:00.000swETH0512032.385393305295.319530745
    5
    2025-02-11 00:00:00.000pzETH-165039.032097491159499.87242122365.30956718
    6
    2025-03-31 00:00:00.000rswETH-5783.157188179320375.984120549170.818451333
    7
    2025-01-29 00:00:00.000rswETH94994.917967675157063.08109572348.906379126
    8
    2025-02-24 00:00:00.000WETH-56643.3876957519286019.278169273452.244280599
    9
    2025-03-31 00:00:00.000wstETH302.76467738540443.38342045249.211309255
    10
    2025-03-05 00:00:00.000weETH0.441416481006882.0031883428.83269016
    11
    2025-03-07 00:00:00.000WETH-6212.2866108487944517.900530823643.889819208
    12
    2025-04-17 00:00:00.000pzETH021397.05080377711.236087939
    13
    2025-03-27 00:00:00.000ezETH0861577.516071334410.390307787
    14
    2025-03-28 00:00:00.000ezETH9679.775875687824530.251502381415.265418399
    15
    2025-02-01 00:00:00.000rswETH-2234.513665698171685.71919189351.145040929
    16
    2025-04-09 00:00:00.000000
    17
    2025-02-13 00:00:00.000rUSDC000
    18
    2025-02-17 00:00:00.000ezETH0986583.742801611350.923204602
    19
    2025-02-10 00:00:00.000weETH-24018.0608222262715054.86044516969.316265778
    20
    2025-01-30 00:00:00.000WETH1075585.173400766388739.733641541996.605954635
    ...
    902
    60KB
    5s