By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| DateIn | Val |
|---|---|
| 2021-12-28 | 123.45 |
| 2021-12-29 | 123.45 |
| 2021-12-30 | 98.75 |
| 2021-12-31 | 43.12 |
| 2022-01-11 | 43.12 |
| 2022-01-12 | 123.45 |
| DateIn | Val | val_changed | adjacent_group_no |
|---|---|---|---|
| 2021-12-28 | 123.45 | 1 | 1 |
| 2021-12-29 | 123.45 | 0 | 1 |
| 2021-12-30 | 98.75 | 1 | 2 |
| 2021-12-31 | 43.12 | 1 | 3 |
| 2022-01-11 | 43.12 | 0 | 3 |
| 2022-01-12 | 123.45 | 1 | 4 |