JhanlycnHyperliquid TVL
    Updated 2025-04-08
    with daily_changes as (
    select
    date_trunc('day', block_timestamp) as date,
    sum(case
    when to_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7' then amount_usd
    else 0
    end) as deposits,
    sum(case
    when from_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7' then -amount_usd
    else 0
    end) as withdrawals
    from
    arbitrum.core.ez_token_transfers
    where
    contract_address = '0xaf88d065e77c8cc2239327c5edb3a432268e5831'
    and (
    to_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7'
    or from_address = '0x2df1c51e09aecf9cacb7bc98cb1742757f163df7'
    )
    group by
    date
    having
    date is not null and (deposits != 0 or withdrawals != 0)
    )
    select
    date,
    deposits,
    withdrawals,
    sum(deposits + withdrawals) over (order by date asc rows between unbounded preceding and current row) as cumulative_tvl
    from
    daily_changes
    order by
    date desc
    Last run: 17 days agoAuto-refreshes every 12 hours
    DATE
    DEPOSITS
    WITHDRAWALS
    CUMULATIVE_TVL
    1
    2025-04-08 00:00:00.00044813493.8497855-57876848.1414361960855879.83279
    2
    2025-04-07 00:00:00.000146578045.472401-169176450.6201841973919234.12444
    3
    2025-04-06 00:00:00.00099678230.2546584-87673290.95802111996517639.27222
    4
    2025-04-05 00:00:00.00033888567.3429523-40078238.98632221984512699.97559
    5
    2025-04-04 00:00:00.00082474352.9179685-87479472.68693911990702371.61896
    6
    2025-04-03 00:00:00.00070761134.1902497-77293675.61559411995707491.38793
    7
    2025-04-02 00:00:00.00064461180.0258022-66849744.85834642002240032.81327
    8
    2025-04-01 00:00:00.00060521522.5324487-54129549.95024332004628597.64582
    9
    2025-03-31 00:00:00.00074398416.7755612-66428994.59179141998236625.06361
    10
    2025-03-30 00:00:00.00031750178.4669946-33332319.3388681990267202.87984
    11
    2025-03-29 00:00:00.00055244457.781251-45923464.0237941991849343.75171
    12
    2025-03-28 00:00:00.00052228905.407324-90310009.82573871982528349.99426
    13
    2025-03-27 00:00:00.00064423334.8795587-70338836.27911272020609454.41267
    14
    2025-03-26 00:00:00.000150795892.61473-334795661.7789272026524955.81223
    15
    2025-03-25 00:00:00.00039721956.7022468-46670654.81561632210524724.97642
    16
    2025-03-24 00:00:00.00070797674.6324088-64728880.82175132217473423.08979
    17
    2025-03-23 00:00:00.00020461647.2883077-24333350.86832052211404629.27913
    18
    2025-03-22 00:00:00.00028061578.3521433-28580361.52648862215276332.85915
    19
    2025-03-21 00:00:00.00048339707.3718204-60992130.87704372215795116.03349
    20
    2025-03-20 00:00:00.00081981661.6698276-96717778.57586282228447539.53872
    ...
    493
    38KB
    272s