select node_id,

sum (amount) as Staked_Volume

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE'

and action in ('DelegatorTokensCommitted','TokensCommitted')

group by 1),

unstaketable as (

select node_id,

sum (amount) as UnStaked_Volume

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE'

and action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn')

group by 1)

select t1.node_id,

Staked_Volume - UnStaked_Volume as "Net Staked Volume"

from staketable t1 join unstaketable t2 on t1.node_id = t2.node_id

order by 2 DESC

limit 10