By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | date | value | next_date | next_value |
|---|---|---|---|---|
| 1 | 20190101 | 50 | 20190104 | 25 |
| 1 | 20190104 | 25 | None | None |
| 2 | 20190101 | 63 | 20190115 | 43 |
| 2 | 20190115 | 43 | None | None |
| id | date | value | next_date | next_value |
|---|---|---|---|---|
| 1 | 20190101 | 50 | 20190104 | 25 |
| 1 | 20190104 | 25 | None | None |
| 2 | 20190101 | 63 | 20190115 | 43 |
| 2 | 20190115 | 43 | None | None |