binhachonDaily stETH Metrics - #3
Updated 2022-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with stETH_stake as (
select
min(block_timestamp) as block_timestamp,
to_address as staker
from flipside_prod_db.ethereum_core.fact_token_transfers
where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and from_address = '0x0000000000000000000000000000000000000000'
group by 2
)
select
date_trunc('day', block_timestamp) as time,
count(*) as number_of_daily_stakers,
sum(number_of_daily_stakers) over (order by time) as number_of_stakers_over_time
from stETH_stake
group by 1
Run a query to Download Data