fallback_orders (order_id, ordered_at, amount) holds a New York store's orders; ordered_at is a TIMESTAMPTZ (an exact instant, shown in UTC).
On 2024-11-03 New York left daylight saving time: at 02:00 local the clocks went back to 01:00, so 01:00–01:59 happened twice. For the New York calendar day 2024-11-03 — local midnight to the next local midnight — return:
- •
orders: how many orders were placed that local day - •
revenue: their total amount - •
day_hours: how many hours of real time the local day lasted
One row. Columns: orders, revenue, day_hours.