By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
16 rows affected
STOCK | CDATE | PTTRN | OPEN | HIGH | LOW | CLOSE | VOLUME |
---|---|---|---|---|---|---|---|
DDD | 01-JAN-21 | INITIAL_VALUE | 135.35 | 136.8 | 135.1 | 136.6 | 16454 |
DDD | 02-JAN-21 | UP | 136.5 | 138.5 | 136.5 | 138 | 281461 |
DDD | 03-JAN-21 | UP | 137.5 | 139.5 | 137.3 | 139.4 | 77334 |
DDD | 04-JAN-21 | UP | 139 | 140.5 | 138.5 | 140 | 321684 |
DDD | 05-JAN-21 | BEARISH | 139.7 | 139.8 | 139.3 | 139.4 | 873009 |
DDD | 06-JAN-21 | DOWN | 139.2 | 139.2 | 137.2 | 137.8 | 62522 |
DDD | 07-JAN-21 | DOWN | 138 | 138.5 | 136.5 | 137 | 114826 |
DDD | 08-JAN-21 | DOWN | 136.6 | 136.8 | 135.1 | 135.35 | 27317 |
XYZ | 01-JAN-21 | INITIAL_VALUE | 40 | 40.5 | 38.5 | 38.8 | 83057 |
XYZ | 02-JAN-21 | DOWN | 39.2 | 39.2 | 37.2 | 37.8 | 181814 |
XYZ | 03-JAN-21 | DOWN | 38 | 38.5 | 36.5 | 37 | 117378 |
XYZ | 04-JAN-21 | DOWN | 36 | 36.1 | 35.6 | 35.7 | 93737 |
XYZ | 05-JAN-21 | BULLISH | 35.35 | 36.8 | 35.1 | 36.6 | 169106 |
XYZ | 06-JAN-21 | UP | 36.5 | 38.5 | 36.5 | 38 | 123179 |
XYZ | 07-JAN-21 | UP | 37.5 | 39.5 | 37.3 | 39.4 | 282986 |
XYZ | 08-JAN-21 | UP | 39 | 40.5 | 38.5 | 40 | 117437 |
STOCK | CDATE | OPEN | HIGH | LOW | CLOSE | VOLUME | PTTRN |
---|---|---|---|---|---|---|---|
DDD | 01-JAN-21 | 135.35 | 136.8 | 135.1 | 136.6 | 16454 | INITIAL_VALUE |
DDD | 02-JAN-21 | 136.5 | 138.5 | 136.5 | 138 | 281461 | UP |
DDD | 03-JAN-21 | 137.5 | 139.5 | 137.3 | 139.4 | 77334 | UP |
DDD | 04-JAN-21 | 139 | 140.5 | 138.5 | 140 | 321684 | UP |
DDD | 05-JAN-21 | 139.7 | 139.8 | 139.3 | 139.4 | 873009 | BEARISH |
DDD | 06-JAN-21 | 139.2 | 139.2 | 137.2 | 137.8 | 62522 | DOWN |
DDD | 07-JAN-21 | 138 | 138.5 | 136.5 | 137 | 114826 | DOWN |
DDD | 08-JAN-21 | 136.6 | 136.8 | 135.1 | 135.35 | 27317 | DOWN |
XYZ | 01-JAN-21 | 40 | 40.5 | 38.5 | 38.8 | 83057 | INITIAL_VALUE |
XYZ | 02-JAN-21 | 39.2 | 39.2 | 37.2 | 37.8 | 181814 | DOWN |
XYZ | 03-JAN-21 | 38 | 38.5 | 36.5 | 37 | 117378 | DOWN |
XYZ | 04-JAN-21 | 36 | 36.1 | 35.6 | 35.7 | 93737 | DOWN |
XYZ | 05-JAN-21 | 35.35 | 36.8 | 35.1 | 36.6 | 169106 | BULLISH |
XYZ | 06-JAN-21 | 36.5 | 38.5 | 36.5 | 38 | 123179 | UP |
XYZ | 07-JAN-21 | 37.5 | 39.5 | 37.3 | 39.4 | 282986 | UP |
XYZ | 08-JAN-21 | 39 | 40.5 | 38.5 | 40 | 117437 | UP |