By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Delta | NetBalance | Timestamp | MostRecentPriceTimestamp | MostRecentPrice | rn |
---|---|---|---|---|---|
2 | 2 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 1.0000 | 1 |
4 | 6 | 2020-01-02 00:00:00 | 2020-01-01 23:59:00 | 1.0200 | 1 |
-1 | 5 | 2020-01-03 00:00:00 | 2020-01-02 18:00:00 | 2.0200 | 1 |