Compute per-account running transaction totals with a partitioned SQL window ordered by date and transaction ID.
