January 31's rolling 3 day average of total transaction amount processed per day
WITH DailyTransactions AS ( SELECT transaction_time, SUM(transaction_amount) AS total_transaction_amount FROM transactions GROUP BY transaction_time ) SELECT transaction_time, AVG(total_transaction_amount) OVER ( ORDER BY transaction_time ROWS BETWEEN 2 PRECEDING AND CURRENT ROW ) AS rolling_3_day_avg FROM DailyTransactions WHERE transaction_time <= '2023-01-31' ORDER BY transaction_time DESC LIMIT 1;