Total ETH Staked

gistfile1.txt

WITH deposits as 
(
SELECT
evt_block_time as block_time,
amount
FROM keep_v110."KeepBonding_evt_UnbondedValueDeposited"
),

withdrawals as
(
SELECT
evt_block_time as block_time,
-amount
FROM keep_v110."KeepBonding_evt_UnbondedValueWithdrawn"
),

unbonded_events as
(
SELECT * FROM deposits
UNION 
SELECT * FROM withdrawals
)

SELECT
sum(amount / 1e18)
FROM unbonded_events