SELECT *
  , AVG(wert) OVER (ORDER BY datum
  RANGE BETWEEN INTERVAL '3' DAYS PRECEDING
  AND INTERVAL '3' DAYS FOLLOWING)
  FROM [...]