-- Test data from Appendix A of the case study
-- This data is used to validate the balance_history_2024_q1.sql query

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (1, 'ACC001', 150.75, 150.75, '2024-01-15 10:23:45');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (2, 'ACC002', -25.50, -25.50, '2024-02-20 14:15:30');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (3, 'ACC003', 100.00, 100.00, '2024-03-10 09:10:00');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (4, 'ACC001', -50.00, 276.00, '2024-04-18 11:45:25');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (5, 'ACC002', 75.25, -50.25, '2024-05-25 08:30:15');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (6, 'ACC003', -20.75, 79.25, '2024-06-12 16:05:10');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (7, 'ACC001', 200.00, 501.00, '2024-07-04 13:30:50');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (8, 'ACC002', -15.00, 65.25, '2024-08-15 07:50:20');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (9, 'ACC003', 125.00, 204.25, '2024-09-01 17:40:45');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (10, 'ACC001', -75.50, 425.50, '2024-10-10 10:20:10');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (11, 'ACC002', 50.75, -65.25, '2024-11-03 19:15:05');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (12, 'ACC003', -10.00, 344.25, '2024-12-20 11:30:25');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (13, 'ACC001', 175.25, 326.00, '2024-01-22 14:10:45');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (14, 'ACC002', -100.00, -125.50, '2024-03-01 15:35:10');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (15, 'ACC003', 0.00, 100.00, '2024-05-14 09:00:00');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (16, 'ACC001', 25.00, 301.00, '2024-06-30 18:45:30');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (17, 'ACC002', -50.75, -116, '2024-08-22 20:00:20');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (18, 'ACC003', 150.00, 354.25, '2024-09-14 12:15:45');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (19, 'ACC001', -30.25, 395.25, '2024-10-27 10:10:00');

INSERT INTO transactions (id, account_id, amount, new_balance, tx_date)
VALUES (20, 'ACC002', 80.00, 14.75, '2024-12-31 23:59:59');
