Get Company Earnings

A company's sales over a trailing window, bucketed by UTC day.

Exists because the delta and the sparkline are numbers ABOUT MONEY and the transactions list is capped — summing a capped page would silently under-report the moment a company outgrew the page size.

total_cents is the window's sales net of customer refunds (EARNING rows plus the negative REFUND row a refund writes), the same definition as the revenue total it sits beside. payment_count counts sales only.

There is deliberately NO previous-window total. The obvious definition — the N calendar days before this window — compares N COMPLETE days against a window whose last day is still in progress, so a flat business reads as a decline every morning and recovers by evening. Day buckets cannot express a phase-aligned previous window, and no caller renders a delta today, so the field is left out rather than shipped biased: a wrong number about money is worse than no number. Add it when a caller needs it, with a query that compares equal elapsed spans.