TIME | PRICE | LIDO_DEPOSITED | TVL | |
|---|---|---|---|---|
1 | 2025-04-23 00:00:00.000 | 1792.31 | 9247444.40207427 | 16574287076.2817 |
2 | 2025-04-22 00:00:00.000 | 1747 | 9251810.25412907 | 16162912513.9635 |
3 | 2025-04-21 00:00:00.000 | 1577.11 | 9263909.91745445 | 14610204969.9166 |
4 | 2025-04-20 00:00:00.000 | 1588.49 | 9272926.40883311 | 14729950871.1673 |
5 | 2025-04-19 00:00:00.000 | 1619.77 | 9276808.35398988 | 15026295867.5422 |
6 | 2025-04-18 00:00:00.000 | 1596.69 | 9285501.86000898 | 14826067964.8577 |
7 | 2025-04-17 00:00:00.000 | 1587.72 | 9288548.52449469 | 14747614263.3107 |
8 | 2025-04-16 00:00:00.000 | 1587.19 | 9295282.34865432 | 14753379190.9607 |
9 | 2025-04-15 00:00:00.000 | 1603.41 | 9296735.41006839 | 14906478523.8578 |
10 | 2025-04-14 00:00:00.000 | 1619.85 | 9304481.53661413 | 15071864417.0844 |
11 | 2025-04-13 00:00:00.000 | 1579.79 | 9304871.87122549 | 14699743533.4433 |
12 | 2025-04-12 00:00:00.000 | 1648.74 | 9322548.7821401 | 15370459079.0657 |
13 | 2025-04-11 00:00:00.000 | 1569.26 | 9366281.19672928 | 14698130430.7794 |
14 | 2025-04-10 00:00:00.000 | 1522.52 | 9391660.96794938 | 14298991656.9223 |
15 | 2025-04-09 00:00:00.000 | 1666.88 | 9362259.73262776 | 15605763503.1226 |
16 | 2025-04-08 00:00:00.000 | 1472.69 | 9364050.15296698 | 13790343019.7729 |
17 | 2025-04-07 00:00:00.000 | 1567.9 | 9384584.79081286 | 14714090493.5155 |
18 | 2025-04-06 00:00:00.000 | 1590.98 | 9366166.48321517 | 14901383551.4657 |
19 | 2025-04-05 00:00:00.000 | 1788.66 | 9368128.80407117 | 16756397266.6899 |
20 | 2025-04-04 00:00:00.000 | 1820.97 | 9372246.39225075 | 17066579512.8969 |
lidoLido TVL
Updated 11 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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 11 hours agoAuto-refreshes every 24 hours
...
1635
111KB
156s