add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
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