SELECT

date_trunc('month', block_timestamp) as month,

address as validator,

sum(case when action = 'staking' then amount else -1 * amount end) as net_staking

from near.gov.fact_staking_actions

where action in ('staking', 'unstaking')

group by 1 , 2

,

ranked_stake as (

select

month,

validator,

net_staking,

sum(net_staking) over (partition by validator order by month) as validator_stake,

sum(net_staking) over (order by month) as total_monthly_staked

from monthly_staked

where not net_staking is null

,

rank_order as (

select

*,

row_number() over (partition by month order by validator_stake desc) as rn

from ranked_stake

),

result as (

select

*,

sum(validator_stake) over (partition by month order by rn) as validator_cum_m

from rank_order

select

month,