TIME | TOTAL_DEPOSITED | LIDO_DEPOSITED | OTHERS | LIDO_SHARE | |
|---|---|---|---|---|---|
1 | 2025-05-29 00:00:00.000 | 34517305.6208057 | 8979292.84186993 | 25538012.7789358 | 26.013886891 |
2 | 2025-05-28 00:00:00.000 | 34513699.9208057 | 8980892.84186993 | 25532807.0789358 | 26.021240442 |
3 | 2025-05-27 00:00:00.000 | 34445774.1324893 | 8992892.84186993 | 25452881.2906194 | 26.107390727 |
4 | 2025-05-26 00:00:00.000 | 34434978.5576707 | 8992892.84186993 | 25442085.7158007 | 26.115575553 |
5 | 2025-05-25 00:00:00.000 | 34568228.7493057 | 8992924.84186993 | 25575303.9074357 | 26.015000384 |
6 | 2025-05-24 00:00:00.000 | 34578195.7317429 | 8993660.84186993 | 25584534.889873 | 26.009630206 |
7 | 2025-05-23 00:00:00.000 | 34597108.6597413 | 9001500.84186993 | 25595607.8178714 | 26.018072581 |
8 | 2025-05-22 00:00:00.000 | 34565116.4167771 | 9001500.84186993 | 25563615.5749072 | 26.042153984 |
9 | 2025-05-21 00:00:00.000 | 34601386.0380479 | 9022556.84186993 | 25578829.196178 | 26.075709314 |
10 | 2025-05-20 00:00:00.000 | 34552043.2389167 | 9022556.84186993 | 25529486.3970468 | 26.112947299 |
11 | 2025-05-19 00:00:00.000 | 34537401.8382571 | 9054140.84186993 | 25483260.9963872 | 26.215466016 |
12 | 2025-05-18 00:00:00.000 | 34561372.9926763 | 9117564.84186993 | 25443808.1508063 | 26.380794663 |
13 | 2025-05-17 00:00:00.000 | 34537964.9226011 | 9117564.84186993 | 25420400.0807311 | 26.398674219 |
14 | 2025-05-16 00:00:00.000 | 34551634.8379757 | 9117884.84186993 | 25433749.9961058 | 26.389156069 |
15 | 2025-05-15 00:00:00.000 | 34669466.4201284 | 9118268.83399685 | 25551197.5861316 | 26.300574469 |
16 | 2025-05-14 00:00:00.000 | 34651792.2256284 | 9119708.83399685 | 25532083.3916316 | 26.318144743 |
17 | 2025-05-13 00:00:00.000 | 34653157.6016284 | 9121436.83399685 | 25531720.7676316 | 26.322094335 |
18 | 2025-05-12 00:00:00.000 | 34626031.8125828 | 9123420.83399685 | 25502610.9785859 | 26.348444671 |
19 | 2025-05-11 00:00:00.000 | 34537449.8985255 | 9124444.83399685 | 25413005.0645286 | 26.41898826 |
20 | 2025-05-10 00:00:00.000 | 34514162.4843173 | 9126012.83399685 | 25388149.6503205 | 26.441356757 |
lidoETH Deposited to BeaconChain through Lido middleware
Updated 15 hours ago
999
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
›
⌄
⌄
/*
Calculation details:
- Gather all deposit and withdrawal txs with project labels:
- Get all deposit txs and assign project labels to them (using dune.lido.result_eth_depositors_labels)
- Get all withdrawal txs with project labels to them from dune.lido.result_withdrawals_transactions_assigned_to_projects
- Calculate ETH deposits for Lido (daily and cumulative)
- Calculate Total ETH deposits for all projects (daily and cumulative)
- Finally we get a resulting table with daily and cumulative deposits for Lido, Other Projects and Total.
*/
-- generates a calendar from '2020-11-03' to the current date
WITH recursive calendar AS (
SELECT CAST('2020-11-03' AS DATE) AS day
UNION ALL
SELECT DATEADD(day, 1, day)
FROM calendar
WHERE day < CURRENT_DATE
)
-- calculates daily ETH withdrawals + assigns principal withdrawals
, all_withdrawals_daily AS (
SELECT
BLOCK_TIMESTAMP AS time
, WITHDRAWAL_ADDRESS_NAME AS name
, SUM(WITHDRAWAL_AMOUNT) AS amount
, SUM(CASE
WHEN WITHDRAWAL_AMOUNT BETWEEN 20 AND 32 THEN WITHDRAWAL_AMOUNT
WHEN WITHDRAWAL_AMOUNT > 32 THEN 32
ELSE 0
END) AS withdrawn_principal
FROM ethereum.beacon_chain.ez_withdrawals
GROUP BY 1,2
)
-- calculates daily deposits/withdrawals by projects
, all_txns AS (
Last run: about 15 hours agoAuto-refreshes every 12 hours
...
1669
125KB
113s