select percent_holding_sETH, count( distinct user_address) as n_address from ( select price_range, user_address, case when percent_stETH_Hold<10 then 'less than 10% ' -- when percent_stETH_Hold>=1 and percent_stETH_Hold<10 then ' Between 1% and 10% ' --when percent_stETH_Hold>=5 and percent_stETH_Hold<10 then ' Between 5% and 10% ' when percent_stETH_Hold>=10 and percent_stETH_Hold<50 then ' Between 10% and 50% ' when percent_stETH_Hold>=50 and percent_stETH_Hold<75 then ' Between 50% and 75% ' -- when percent_stETH_Hold>=50 and percent_stETH_Hold<75 then ' Between 50% and 75% ' when percent_stETH_Hold>=75 and percent_stETH_Hold<=100 then ' Between 75% and 100% ' else 'more than 100%' end as percent_holding_sETH from ( with stx as (select price_range,addr, sum(eth_staked) as tot_eth_staked from (with st as (select date(block_timestamp) as dt, origin_from_address as addr, raw_amount/10e17 as eth_staked from ethereum.core.fact_token_transfers where --tx_hash='0xf472b1a9283b863c5b8e7e01751603acd703e03cc04f105477aa92a3cf0145a0' and origin_to_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and contract_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' -- block_timestamp>='2022-03-01' -- group by 1 order by 1 group by 1,2,3 order by 1), pr as ( select date(hour) as dt2, avg(price ) as avg_price, case when avg_price<1000 then 'less than 1000 USD' when avg_price>=1000 and avg_price<2000 then 'between 1000 and 2000 USD' when avg_price>=2000 and avg_price<3000 then 'between 2000 and 3000 USD' when avg_price>=3000 and avg_price<4000 then 'between 3000 and 4000 USD' else '4000 USD and above ' end as price_range from ethereum.core.fact_hourly_token_prices where symbol = 'WETH' --and hour>='2020-12-18' group by 1 order by 1 ) select dt, price_range,avg_price, addr,eth_staked from st inner join pr on st.dt=pr.dt2 order by 1 ) group by 1,2 order by 3 desc), bal as ( select user_address,balance from ethereum.erc20_balances where contract_address=lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') and balance_date='2022-06-10' ) select price_range, user_address, tot_eth_staked as tot_stETH_minted,balance, (((balance)/tot_stETH_minted)*100) as percent_stETH_Hold from stx inner join bal on bal.user_address=stx.addr where tot_stETH_minted>0 )) group by 1

stETH/ETH Fluctuations