ETH_change,

sETH_change,

SUM(ETH_change) OVER (order by date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cum_eth,

SUM(sETH_change) OVER (order by date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cum_seth FROM (

SELECT to_date(block_timestamp) as date,

SUM(IFF(event_name LIKE '%Remove%',-event_inputs:token_amounts[0]::float / POW(10,18),event_inputs:token_amounts[0]::float / POW(10,18))) as ETH_change,

SUM(IFF(event_name LIKE '%Remove%',-event_inputs:token_amounts[1]::float / POW(10,18),event_inputs:token_amounts[1]::float / POW(10,18))) as sETH_change

FROM ethereum.events_emitted

where (tx_from_address = lower('0xDC24316b9AE028F1497c275EB9192a3Ea0f67022') or tx_to_address = lower('0xDC24316b9AE028F1497c275EB9192a3Ea0f67022'))

AND event_name IN('RemoveLiquidity','RemoveLiquidityImbalance','AddLiquidity','RemoveLiquidityOne')

GROUP BY 1)