Query editor
-- Fork of Query 7602382 (Lido stETH Staking APR — Daily)-- Change: V2 end bound TIMESTAMP '2026-01-01' -> rolling CURRENT_DATE (complete days only).WITHv1_raw AS (SELECTcall_block_time AS ts,CAST(_beaconBalance AS DOUBLE) AS bal,CAST(_beaconValidators AS DOUBLE) AS val,LAG(CAST(_beaconBalance AS DOUBLE))OVER (ORDER BY call_block_time) AS prev_bal,LAG(CAST(_beaconValidators AS DOUBLE))OVER (ORDER BY call_block_time) AS prev_val,LAG(call_block_time)OVER (ORDER BY call_block_time) AS prev_tsFROM lido_ethereum.steth_call_pushbeaconWHERE call_success = trueAND call_block_time >= TIMESTAMP '2020-12-18'AND call_block_time < TIMESTAMP '2023-05-12'),v1_rates AS (SELECTts,date_trunc('day', ts) AS dt,((bal - prev_bal - GREATEST(val - prev_val, 0) * 32e18)/ NULLIF(prev_bal, 0)) * (365.0 * 86400.0/ NULLIF(CAST(date_diff('second', prev_ts, ts) AS DOUBLE), 0))AS rate_annual,'v1' AS sourceFROM v1_rawWHERE prev_bal IS NOT NULLAND prev_ts IS NOT NULLAND date_diff('second', prev_ts, ts) > 3600),v2_rates AS (SELECTevt_block_time AS ts,date_trunc('day', evt_block_time) AS dt,((CAST(postTotalEther AS DOUBLE) / CAST(postTotalShares AS DOUBLE))/ (CAST(preTotalEther AS DOUBLE) / CAST(preTotalShares AS DOUBLE))- 1.0) * (365.0 * 86400.0 / CAST(timeElapsed AS DOUBLE))AS rate_annual,'v2' AS sourceFROM lido_ethereum.steth_evt_tokenrebasedWHERE evt_block_time >= TIMESTAMP '2023-05-12'AND evt_block_time < CURRENT_DATEAND CAST(preTotalEther AS DOUBLE) > 0AND CAST(preTotalShares AS DOUBLE) > 0AND CAST(timeElapsed AS DOUBLE) > 0),all_rates AS (SELECT * FROM v1_rates WHERE rate_annual IS NOT NULL AND rate_annual > -0.5