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 |