SELECT

date(block_timestamp) as dates,

tx_hash,

to_address as staker,

raw_amount / POW(10, 18) as ETH_amount_staked

FROM ethereum.core.fact_token_transfers

WHERE from_address = '0x0000000000000000000000000000000000000000'

AND contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' --stETH

AND ETH_amount_staked != 0

SELECT

AVG(ETH_amount_staked) as average_ETH_staked,

MIN(ETH_amount_staked) as minimum_ETH_staked,

MAX(ETH_amount_staked) as maximum_ETH_staked,

MEDIAN(ETH_amount_staked) as median_ETH_staked

FROM ETH_staked