Optimizing Window Functions at Scale

How do you optimize a query that utilizes a window function on a massive, distributed dataset at Plaid?

Use the provided PostgreSQL tables and write the query for completed January transactions. The solution should reduce the data processed by the window calculation while producing deterministic results.

Output

1. One row per account and transaction date with completed transactions
2. Columns: account_label, transaction_date, daily_net_amount, running_balance, and prior_running_balance
3. Order by account_label, then transaction_date