Compute a 7-day trailing moving average of total daily billing. First aggregate billing by billed_at date, then compute the moving average over the preceding 6 rows and the current row.