Query editor
WITH staked AS (SELECTDATE_TRUNC('hour', block_time) AS time,SUM(SUM(amount_staked) - SUM(amount_full_withdrawn)) OVER (ORDER BY DATE_TRUNC('hour', block_time) RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_deposited_eth,SUM((SUM(amount_staked) - SUM(amount_full_withdrawn)) / 32) OVER (ORDER BY DATE_TRUNC('hour', block_time) RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_validatorsFROM query_2393816WHEREvalidator_index >= 0AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '5' yearGROUP BY1), validator_flows AS (SELECTDATE_TRUNC('hour', block_time) AS time,validator_index,SUM(SUM(amount_staked) - SUM(amount_full_withdrawn)) OVER (PARTITION BY validator_index ORDER BY DATE_TRUNC('hour', block_time) RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_deposited_ethFROM query_2393816WHEREblock_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '5' yearGROUP BY1,2), validator_changes AS (SELECTtime,validator_index,cum_deposited_eth,LAG(cum_deposited_eth) OVER (PARTITION BY validator_index ORDER BY time) AS cum_deposited_eth_oldFROM validator_flowsWHEREvalidator_index < 1000), validators AS (SELECTtime,SUM(SUM(CASEWHEN cum_deposited_eth >= 32AND (cum_deposited_eth_old < 32 OR cum_deposited_eth_old IS NULL)THEN 1WHEN cum_deposited_eth < 32 AND cum_deposited_eth_old >= 32THEN -1END)) OVER (ORDER BY time) AS staked_validatorsFROM validator_changesWHEREcum_deposited_eth <> cum_deposited_eth_oldGROUP BY1)SELECTs.time,s.cum_deposited_eth,s.cum_deposited_eth * pu.price AS economic_security,s.cum_validators,