select price

from ethereum.core.fact_hourly_token_prices

where hour::date=CURRENT_DATE-1

and symbol ='WETH'

,lst_direct_stake as (

select

TX_HASH

,BLOCK_TIMESTAMP

,ORIGIN_FROM_ADDRESS

,AMOUNT

,AMOUNT_USD

from ethereum.core.ez_eth_transfers

where ORIGIN_TO_ADDRESS='0x00000000219ab540356cbb839cbe05303d7705fa'

,lst_direct_sum as(

select

date_trunc(week,block_timestamp)::date as date

,count(tx_hash) as stakes_count

,count(DISTINCT ORIGIN_FROM_ADDRESS) as stakers_count

,sum(amount) as stake_ETH

,sum(amount_usd) as stake_USD_in_time_staking

,sum(amount*(select avg(price) from price)) as stake_usd_currently

,avg(amount) as stake_ETH_AVG

,avg(amount_usd) as stake_USD_AVG

,median(amount) as stake_ETH_median

,median(amount_usd) as stake_USD_median

,min(amount) as stake_ETH_MIN

,max(amount_usd) as stake_USD_MAX

,min(amount) as stake_ETH_MIN

,max(amount_usd) as stake_USD_MAX

from lst_direct_stake

group by 1

order by 1