drop table if exists highlowtemp;

create table highlowtemp(
  day varchar(255),
  h double,
  l double,
  o double,
  c double,
  color varchar(255),
  v double
);

insert into highlowtemp
values
('MON',	1,	5,	2,	3, '', 400),
('TUE',	4,	10,	3,	5, '', 600),
('WED',	3,	9,	5,	4, '', 200),
('THU',	7,	12,	4,	9, '', 300),
('FRI',	14,	7,	9,	10, '', 700);


PLOT HIGHLOW
    ALL XLABELS, DARK SKYBLUE HIGH, LOW, OPEN, CLOSE, LIGHT RED BAR:Y2        
  WITH
    TITLE Y "Price"
    TITLE Y2 "Volume"
    SCALE Y2 0 2400 800
    COLLAR
    HORIZONTAL GRIDLINES
    VERSION "1.4.4"

SELECT substring(day, 1,1),h,l,o,c,v
  FROM highlowtemp 
union all
SELECT substring(day, 1,1),h,l,o,c,v
from highlowtemp
union all
SELECT substring(day, 1,1),h,l,o,c,v
from highlowtemp
union all
SELECT substring(day, 1,1),h,l,o,c,v
from highlowtemp
;