select

from_address,

sum(amount) as staked_amount,

sum(amount_usd) / sum(amount) as staked_avg_price

from ethereum.udm_events

where block_timestamp > getdate() - interval'365 days' --tx_id = '0xee0915eb747cb1eb85f8ebfe8c77154a694d03a061e235c30c1c70c4ee2c9517'

and origin_function_signature = '0xa1903eab'

and symbol = 'ETH'

and amount_usd is not null

group by 1

),

current_balance as (

select

user_address,

non_adjusted_balance/1e18 as current_amount,

price

from ethereum.erc20_balances

where balance_date in (select max(balance_date) from ethereum.erc20_balances)

and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

and user_address in (select from_address from stETH_stake)

),

ETH_price as (

select

max(price) as current_price

from current_balance

),

summary_table as (

select

coalesce(current_amount, 0) as non_null_current_amount,

current_price,

staked_amount,

staked_avg_price,

round(100 * (current_price / staked_avg_price - 1), -1) as increase_from_staked_price,

case

when non_null_current_amount >= staked_amount then staked_amount