lidoLido TVL
    Updated 16 hours ago


    -- retrieves the data from the ETH Staked through Lido middleware query
    WITH base AS (
    SELECT
    time
    , lido_deposited_cumu
    , lido_buffer
    , lido_withdrawals_cumu
    FROM (
    SELECT
    value[0]::date AS time,
    value[1]::real AS lido_deposited_daily,
    value[2]::real AS lido_deposited_cumu,
    value[3]::real AS lido_buffer,
    value[4]::real AS lido_withdrawals_daily,
    value[5]::real AS lido_withdrawals_cumu,
    value[6]::real AS lido_amount
    FROM (
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/0fee3d56-39aa-43d9-a8a6-f22f8b75b599/latest-run') as response
    ), lateral FLATTEN (input => response:data:result:rows)
    )
    )

    -- gets the daily closing(last) value of ETH price
    , eth_prices as (
    SELECT
    distinct HOUR::date as time
    , LAST_VALUE(PRICE) OVER (PARTITION BY HOUR::date ORDER BY HOUR range BETWEEN unbounded preceding AND unbounded following) AS price
    FROM ethereum.price.ez_prices_hourly
    WHERE SYMBOL = 'WETH'
    AND BLOCKCHAIN = 'ethereum'

    )
    -- calculates cumulative daily amount deposited by Lido + TVL
    Last run: about 16 hours agoAuto-refreshes every 24 hours
    TIME
    PRICE
    LIDO_DEPOSITED
    TVL
    1
    2025-05-27 00:00:00.0002665.458994573.2333105323974585224.7275
    2
    2025-05-26 00:00:00.0002557.248994139.8285666723000174135.2038
    3
    2025-05-25 00:00:00.0002519.988995882.235403422669443315.5719
    4
    2025-05-24 00:00:00.0002537.728997458.7068858622833030909.6384
    5
    2025-05-23 00:00:00.0002543.729002599.584266722900092614.4909
    6
    2025-05-22 00:00:00.0002635.069019068.4094410823765786402.9818
    7
    2025-05-21 00:00:00.0002511.149023867.9447758522660195750.8444
    8
    2025-05-20 00:00:00.0002508.029023870.5538164922632047826.3828
    9
    2025-05-19 00:00:00.0002517.369079421.5031409722856172515.147
    10
    2025-05-18 00:00:00.0002418.649119070.4381578222055748524.546
    11
    2025-05-17 00:00:00.0002467.329118437.0941191122498102211.062
    12
    2025-05-16 00:00:00.0002569.749123228.3759532823444324886.8222
    13
    2025-05-15 00:00:00.0002534.499121536.5681696723118443216.6604
    14
    2025-05-14 00:00:00.0002599.049127579.0052816623722942937.8873
    15
    2025-05-13 00:00:00.0002680.919123497.3987147624459275411.1884
    16
    2025-05-12 00:00:00.0002477.029138123.217038622635313971.069
    17
    2025-05-11 00:00:00.0002516.689129071.7534135822974952300.3809
    18
    2025-05-10 00:00:00.0002518.079142554.5762521523021592401.8233
    19
    2025-05-09 00:00:00.0002336.729168647.0952879821424561040.5013
    20
    2025-05-08 00:00:00.0002170.99172672.7706179619912955317.7345
    ...
    1669
    113KB
    16s