DAY | COUNTER_INSTANTAPR | COUNTER_MA7APR | COUNTER_PROTOCOLAPR | Lido staking APR(instant) | Lido staking APR(ma_7) | Protocol APR | |
|---|---|---|---|---|---|---|---|
1 | 2025-06-03 00:00:00.000 | 2.787560472 | 2.815451605 | 3.097289413 | 0.02787560472 | 2.815451605 | 0.03097289413 |
2 | 2025-06-02 00:00:00.000 | 2.725236414 | 2.809083274 | 3.02804046 | 0.02725236414 | 2.809083274 | 0.0302804046 |
3 | 2025-06-01 00:00:00.000 | 2.707889313 | 2.808474117 | 3.008765903 | 0.02707889313 | 2.808474117 | 0.03008765903 |
4 | 2025-05-31 00:00:00.000 | 2.885416663 | 2.804259312 | 3.206018514 | 0.02885416663 | 2.804259312 | 0.03206018514 |
5 | 2025-05-30 00:00:00.000 | 2.90350407 | 2.791957244 | 3.226115633 | 0.0290350407 | 2.791957244 | 0.03226115633 |
6 | 2025-05-29 00:00:00.000 | 2.870001259 | 2.797102889 | 3.188890288 | 0.02870001259 | 2.797102889 | 0.03188890288 |
7 | 2025-05-28 00:00:00.000 | 2.828553046 | 2.806899144 | 3.142836718 | 0.02828553046 | 2.806899144 | 0.03142836718 |
8 | 2025-05-27 00:00:00.000 | 2.742982151 | 2.80063509 | 3.047757945 | 0.02742982151 | 2.80063509 | 0.03047757945 |
9 | 2025-05-26 00:00:00.000 | 2.720972315 | 2.827315328 | 3.023302572 | 0.02720972315 | 2.827315328 | 0.03023302572 |
10 | 2025-05-25 00:00:00.000 | 2.678385683 | 2.875501853 | 2.975984092 | 0.02678385683 | 2.875501853 | 0.02975984092 |
11 | 2025-05-24 00:00:00.000 | 2.799302182 | 2.867667825 | 3.110335758 | 0.02799302182 | 2.867667825 | 0.03110335758 |
12 | 2025-05-23 00:00:00.000 | 2.939523585 | 2.861465664 | 3.266137317 | 0.02939523585 | 2.861465664 | 0.03266137317 |
13 | 2025-05-22 00:00:00.000 | 2.938575044 | 2.850650463 | 3.265083383 | 0.02938575044 | 2.850650463 | 0.03265083383 |
14 | 2025-05-21 00:00:00.000 | 2.784704667 | 2.832546143 | 3.094116296 | 0.02784704667 | 2.832546143 | 0.03094116296 |
15 | 2025-05-20 00:00:00.000 | 2.929743823 | 2.849126045 | 3.255270915 | 0.02929743823 | 2.849126045 | 0.03255270915 |
16 | 2025-05-19 00:00:00.000 | 3.058277988 | 2.849300925 | 3.398086653 | 0.03058277988 | 2.849300925 | 0.03398086653 |
17 | 2025-05-18 00:00:00.000 | 2.623547484 | 2.830561796 | 2.91505276 | 0.02623547484 | 2.830561796 | 0.0291505276 |
18 | 2025-05-17 00:00:00.000 | 2.755887055 | 2.903833052 | 3.062096728 | 0.02755887055 | 2.903833052 | 0.03062096728 |
19 | 2025-05-16 00:00:00.000 | 2.863817182 | 2.937438592 | 3.182019091 | 0.02863817182 | 2.937438592 | 0.03182019091 |
20 | 2025-05-15 00:00:00.000 | 2.811844805 | 3.024999279 | 3.124272006 | 0.02811844805 | 3.024999279 | 0.03124272006 |
lidoLido Staking User APR 7days MA
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
›
⌄
⌄
/*
Calculation details:
1. Combine APR data for Legacy Oracle and V2 Oracle:
Legacy (from 2022-09-01 to 2023-05-16):
- calculate protocol APR: (postTotalPooledEther - preTotalPooledEther) * SECONDS_IN_YEAR / preTotalPooledEther / timeElapsed * 100
- calculate Lido staking APR (Instant): (postTotalPooledEther - preTotalPooledEther) * SECONDS_IN_YEAR / preTotalPooledEther / timeElapsed * 100 * 0.9
V2:
- calculate PRE and POST rebase share rates for the stETH for every Oracle event
- calculate protocol APR: SECONDS_IN_YEAR * (post_share_rate - pre_share_rate) / pre_share_rate / timeElapsed * 100 / 0.9
- calculate Lido staking APR (Instant): SECONDS_IN_YEAR * (post_share_rate - pre_share_rate) / pre_share_rate / timeElapsed * 100
2. Calculate 7 days MA Lido protocol APR, 7 days MA Lido staking APR, 30 days MA Lido staking APR
*/
-- calculates PRE and POST rebase share rates
with shares AS (
SELECT
DECODED_LOG:preTotalEther *1e27 / DECODED_LOG:preTotalShares as pre_share_rate
, DECODED_LOG:postTotalEther * 1e27 / DECODED_LOG:postTotalShares as post_share_rate
, *
FROM ethereum.core.ez_decoded_event_logs
where EVENT_NAME = 'TokenRebased'
)
-- combines legacy Oracle end new V2 Oracle data
, oracles_data AS (
--legacy oracle
SELECT
date_trunc('minute', BLOCK_TIMESTAMP) as time
, ((DECODED_LOG:postTotalPooledEther - DECODED_LOG:preTotalPooledEther) * 365 * 86400 / DECODED_LOG:preTotalPooledEther ) / DECODED_LOG:timeElapsed * 100 AS protocol_apr
, ((DECODED_LOG:postTotalPooledEther - DECODED_LOG:preTotalPooledEther) * 365 * 86400 / DECODED_LOG:preTotalPooledEther ) / DECODED_LOG:timeElapsed * 0.9 * 100 AS "Lido staking APR(instant)"
, DECODED_LOG:postTotalPooledEther as postTotalPooledEther
, DECODED_LOG:preTotalPooledEther as preTotalPooledEther
FROM ethereum.core.ez_decoded_event_logs
WHERE event_name = 'PostTotalShares'
AND BLOCK_TIMESTAMP BETWEEN '2022-09-01 00:00' AND '2023-05-16 00:00'
AND postTotalPooledEther > ''
UNION all
--new V2 oracle
Last run: about 16 hours agoAuto-refreshes every 24 hours
95
10KB
328s