Query editor
WITH staked AS (SELECT date_trunc('day', block_time) AS time, SUM(SUM(amount_staked)-SUM(amount_full_withdrawn)) OVER (ORDER BY date_trunc('day', block_time) RANGE UNBOUNDED PRECEDING) AS cum_deposited_eth, SUM((SUM(amount_staked)-SUM(amount_full_withdrawn))/32) OVER (ORDER BY date_trunc('day', block_time) RANGE UNBOUNDED PRECEDING) AS cum_validatorsFROM query_2393816WHERE validator_index >= 0AND block_time >= date_add('year', -2, current_date)GROUP BY 1)SELECT s.time, s.cum_deposited_eth, s.cum_deposited_eth*pu.price AS economic_security, s.cum_validatorsFROM staked sINNER JOIN prices.usd pu ON pu.blockchain IS NULLAND pu.symbol='ETH'AND pu.minute=s.timeWHERE s.time >= date_add('year', -2, current_date)