address

, signer_id

, sum(iff(action = 'staking', amount, 0)) AS total_staked

, sum(iff(action = 'unstaking', amount, 0)) AS total_unstaked

, total_staked - total_unstaked AS delta

FROM near.core.fact_staking_actions

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

AND signer_id = 'binancecold3.near'

GROUP BY 1, 2