lido**drft Lido Buffer copy
Updated 2024-06-14
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
›
⌄
⌄
SELECT *
from ethereum.core.ez_token_transfers
where SYMBOL = 'wstETH'
and FROM_ADDRESS = '0xb948a93827d68a82f6513ad178964da487fe2bd9'
or FROM_ADDRESS = '0xb948a93827d68a82f6513ad178964da487fe2bd9'
/*-- forked from kema_san / **drft Lido Buffer @ https://flipsidecrypto.xyz/kema_san/q/cWLSXx7snOFG/drft-lido-buffer
/*
query_2481449
The buffer is formed by partial withdrawals, new ETH deposits, and execution layer rewards
*/
-- Lido Blocks with Burn
WITH blocks AS (
SELECT
BLOCK_NUMBER
, BLOCK_TIMESTAMP
, GAS_USED
, block_header_json:baseFeePerGas
, block_header_json:baseFeePerGas * GAS_USED/ 1e18 AS total_burn
FROM ethereum.core.fact_blocks
WHERE MINER = '0x388c818ca8b9251b393131c08a736a67ccb19297' -- EL vault
)
-- daily fee cost for each Lido block
, eth_tx AS (
SELECT
BLOCK_TIMESTAMP
, BLOCK_NUMBER
, GAS_USED
, GAS_USED * GAS_PRICE/1e9 AS fee
FROM ethereum.core.fact_transactions
WHERE BLOCK_NUMBER in (SELECT DISTINCT BLOCK_NUMBER from blocks )
QueryRunArchived: QueryRun has been archived