SELECT *
  , SUM(wert) OVER (ORDER BY zeit
  ROWS BETWEEN UNBOUNDED PRECEDING
  AND CURRENT ROW)

  , AVG(wert) OVER (ORDER BY zeit
  ROWS BETWEEN 3 PRECEDING
  AND 3 FOLLOWING)
  FROM [...]