By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DateSeq | BusinessDate | Units | ActionType | inventory |
---|---|---|---|---|
1020 | 2020-02-10 | 100 | Bought | 100 |
1021 | 2020-02-11 | null | null | 100 |
1022 | 2020-02-12 | null | null | 100 |
1023 | 2020-02-13 | null | null | 100 |
1024 | 2020-02-14 | null | null | 100 |
1025 | 2020-02-17 | 20 | Sold | 80 |
1026 | 2020-02-18 | null | null | 80 |
1027 | 2020-02-19 | null | null | 80 |
1028 | 2020-02-20 | 30 | Sold | 50 |
1029 | 2020-02-21 | null | null | 50 |
1030 | 2020-02-24 | null | null | 50 |
1031 | 2020-02-25 | 100 | Bought | 150 |
1032 | 2020-02-26 | null | null | 150 |
1033 | 2020-02-27 | null | null | 150 |
1034 | 2020-02-28 | null | null | 150 |
1035 | 2020-03-02 | 50 | Sold | 100 |
1036 | 2020-03-03 | null | null | 100 |
1037 | 2020-03-04 | null | null | 100 |
1038 | 2020-03-05 | null | null | 100 |
1039 | 2020-03-06 | null | null | 100 |