Query editor
1SELECT2 evt_block_date AS day,3 sum(cast(delta AS double)) / 1e18 AS net_change_stonx,4 sum(sum(cast(delta AS double)) / 1e18) OVER (ORDER BY evt_block_date) AS stonx_staked5FROM stonx_robinhood.ve33_evt_stakechanged6GROUP BY 17ORDER BY 1
SELECT
evt_block_date AS day,
sum(cast(delta AS double)) / 1e18 AS net_change_stonx,
sum(sum(cast(delta AS double)) / 1e18) OVER (ORDER BY evt_block_date) AS stonx_staked
FROM stonx_robinhood.ve33_evt_stakechanged
GROUP BY 1
ORDER BY 1