trunc(block_timestamp,'week') as week,

sum(case when event_name='Deposit' then amount_usd else 0 end) as staked,

sum(case when event_name='Withdrawn' then amount_usd else 0 end) as unstaked,

staked-unstaked as netflow,

sum(netflow) over (order by week) as tvl,

count(distinct origin_from_address) as active_users,

count(distinct tx_hash) as actions

from crosschain.olas.ez_olas_staking

group by 1 order by 1 desc , tvl desc