DATE(block_timestamp) as dayz,

pool_name,

COUNT(DISTINCT origin_from_address) as users,

- SUM(IFF(SYMBOL_IN IN ('stETH', 'wstETH'), amount_in_usd, 0)) as volume_FROM,

SUM(IFF(SYMBOL_OUT IN ('stETH', 'wstETH'), amount_out_usd, 0)) as volume_TO,

volume_from + volume_to as net_volume,

(- volume_from) + volume_to as total_volume,

sum(total_volume) over (partition by pool_name order by dayz asc rows between unbounded preceding and current row) cumulative_total_volume,

sum(net_volume) over (partition by pool_name order by dayz asc rows between unbounded preceding and current row) cumulative_net_volume,

sum(users) over (partition by pool_name order by dayz asc rows between unbounded preceding and current row) cumulative_users

FROM ethereum.core.ez_dex_swaps

WHERE pool_name LIKE '%stETH%' and dayz >= '2022-01-01' AND pool_name NOT IN ('∞-wlstETH-NYT-∞-stETH-xPYT 10000 200', 'steCRV-ePyvCurve-stETH-16SEP22 BLP', 'wstETH-rETH-WETH-aETH BLP') -- non-significant stETH pools

GROUP BY 1,2

ORDER BY 1 ASC