By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
STOCK | CDATE | VALUE_MATCH | PATTERN | SERIAL_NO | PRICE | MOV_AVG | CNT5 | ONLY_5_MOV_AVG |
---|---|---|---|---|---|---|---|---|
ABC | 01-JAN-21 | 1 | OTHER | 10 | 14 | 14 | 1 | null |
ABC | 02-JAN-21 | 1 | DOWN | 11 | 12 | 13 | 2 | null |
ABC | 03-JAN-21 | 2 | DOWN | 12 | 11 | 12.33 | 3 | null |
ABC | 04-JAN-21 | 3 | DOWN | 13 | 8 | 11.25 | 4 | null |
ABC | 05-JAN-21 | 1 | UP | 14 | 9 | 10.8 | 5 | 10.8 |
ABC | 06-JAN-21 | 1 | DOWN | 15 | 7 | 10.17 | 6 | null |
ABC | 07-JAN-21 | 2 | DOWN | 16 | 5 | 8.67 | 6 | null |
ABC | 08-JAN-21 | 1 | UP | 17 | 10 | 8.33 | 6 | null |
XYZ | 01-JAN-21 | 1 | OTHER | 1 | 315 | 315 | 1 | null |
XYZ | 02-JAN-21 | 1 | DOWN | 2 | 311.1 | 313.05 | 2 | null |
XYZ | 03-JAN-21 | 2 | DOWN | 3 | 308.1 | 311.4 | 3 | null |
XYZ | 04-JAN-21 | 1 | UP | 4 | 310 | 311.05 | 4 | null |
XYZ | 05-JAN-21 | 1 | DOWN | 5 | 308.7 | 310.58 | 5 | 310.58 |
XYZ | 06-JAN-21 | 1 | UP | 6 | 311.2 | 310.68 | 6 | null |
XYZ | 07-JAN-21 | 2 | UP | 7 | 313.75 | 310.48 | 6 | null |
XYZ | 08-JAN-21 | 3 | UP | 8 | 314.7 | 311.08 | 6 | null |
XYZ | 09-JAN-21 | 1 | DOWN | 9 | 308.05 | 311.07 | 6 | null |