select price

from ethereum.core.fact_hourly_token_prices

where hour::date=CURRENT_DATE-1

and symbol ='WETH'

, lst_lido as (

select

TX_HASH

,BLOCK_TIMESTAMP

,ORIGIN_FROM_ADDRESS

,AMOUNT

,AMOUNT_USD

from ethereum.core.ez_eth_transfers

-- where tx_hash='0xa61e28d0623990b9eae7510f621e646dd80e55665b9dcc1b7c3c58838b34920f'

where ORIGIN_TO_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

,lst_lido_sum(

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_stkr

group by 1

order by 1