Stock Level After Each Movement

For each movement show the SKU's stock right after it, in date order within the SKU. Order by SKU then id.

Table schema

StockMoves(id INT PRIMARY KEY, sku VARCHAR(5), qty INT, move_type VARCHAR(3), move_date DATE)

Sample data

id | sku | qty | move_type | move_date
1 | A1 | 100 | IN | 2026-08-01
2 | A1 | 30 | OUT | 2026-08-05
3 | B2 | 50 | IN | 2026-08-02
4 | B2 | 45 | OUT | 2026-08-10
5 | A1 | 20 | OUT | 2026-08-20
6 | C3 | 10 | IN | 2026-06-01