ins as (

SELECT

trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as staking,

avg(amount_in_usd) as avg_staked_size,

count(distinct origin_from_address) as n_stakers,

sum(amount_in_usd) as volume_in

from ethereum.core.ez_dex_swaps

where symbol_in like '%stETH%'

group by 1

),

outs as (

SELECT

trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as unstaking,

avg(amount_out_usd) as avg_unstaked_size,

count(distinct origin_from_address) as n_unstakers,

sum(amount_out_usd) as volume_out

from ethereum_core.ez_dex_swaps

where symbol_out like '%stETH%'

group by 1

)

SELECT

x.date,

staking, unstaking,

avg_staked_size,avg_unstaked_size,

n_stakers, n_unstakers,

volume_in+volume_out as volume

from ins x

left join outs y on x.date=y.date

order by 1 asc