TIME | PRICE | LIDO_DEPOSITED | TVL | |
---|---|---|---|---|
1 | 2025-05-27 00:00:00.000 | 2665.45 | 8994573.23331053 | 23974585224.7275 |
2 | 2025-05-26 00:00:00.000 | 2557.24 | 8994139.82856667 | 23000174135.2038 |
3 | 2025-05-25 00:00:00.000 | 2519.98 | 8995882.2354034 | 22669443315.5719 |
4 | 2025-05-24 00:00:00.000 | 2537.72 | 8997458.70688586 | 22833030909.6384 |
5 | 2025-05-23 00:00:00.000 | 2543.72 | 9002599.5842667 | 22900092614.4909 |
6 | 2025-05-22 00:00:00.000 | 2635.06 | 9019068.40944108 | 23765786402.9818 |
7 | 2025-05-21 00:00:00.000 | 2511.14 | 9023867.94477585 | 22660195750.8444 |
8 | 2025-05-20 00:00:00.000 | 2508.02 | 9023870.55381649 | 22632047826.3828 |
9 | 2025-05-19 00:00:00.000 | 2517.36 | 9079421.50314097 | 22856172515.147 |
10 | 2025-05-18 00:00:00.000 | 2418.64 | 9119070.43815782 | 22055748524.546 |
11 | 2025-05-17 00:00:00.000 | 2467.32 | 9118437.09411911 | 22498102211.062 |
12 | 2025-05-16 00:00:00.000 | 2569.74 | 9123228.37595328 | 23444324886.8222 |
13 | 2025-05-15 00:00:00.000 | 2534.49 | 9121536.56816967 | 23118443216.6604 |
14 | 2025-05-14 00:00:00.000 | 2599.04 | 9127579.00528166 | 23722942937.8873 |
15 | 2025-05-13 00:00:00.000 | 2680.91 | 9123497.39871476 | 24459275411.1884 |
16 | 2025-05-12 00:00:00.000 | 2477.02 | 9138123.2170386 | 22635313971.069 |
17 | 2025-05-11 00:00:00.000 | 2516.68 | 9129071.75341358 | 22974952300.3809 |
18 | 2025-05-10 00:00:00.000 | 2518.07 | 9142554.57625215 | 23021592401.8233 |
19 | 2025-05-09 00:00:00.000 | 2336.72 | 9168647.09528798 | 21424561040.5013 |
20 | 2025-05-08 00:00:00.000 | 2170.9 | 9172672.77061796 | 19912955317.7345 |
lidoLido TVL
Updated 16 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 16 hours agoAuto-refreshes every 24 hours
...
1669
113KB
16s