siavashjLido ETH Stakes
Updated 2022-09-05
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
›
⌄
-- Q3. Find the following stETH metrics:
-- -Daily volume of stETH? -Average stake size? -Number of stakers over time? -Average time staked? -Staking/unstaking per day?
with base as (
select
block_timestamp::date as date,
tx_hash,
origin_from_address,
event_inputs:amount/1e18 as amount
from ethereum.core.fact_event_logs
where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and event_name = 'Submitted'
and tx_status = 'SUCCESS'
)
select
date,
count(tx_hash) as "Number Stakes",
--sum(stakes) as "Cumu Stakes",
count(distinct origin_from_address) as "Number Stakers",
sum("Number Stakers") over (order by date) as "Cumu Stakers",
sum(amount) as "ETH Amount",
sum("ETH Amount") over (order by date) as "Cumu Amount ETH"
from base
group by 1
--order by 2 desc
Run a query to Download Data