create table stock_prices
( stock_symbol varchar2(10) not null,
  day          integer      not null,  -- see Note 1
  price        number(4)
);

-- Note 1: for simplicity we'll store trade dates as integers, e.g. day 1, day 2, etc.

insert into stock_prices values ( 'W1', 1, 10 );
insert into stock_prices values ( 'W1', 2, 9  );
insert into stock_prices values ( 'W1', 3, 8  );
insert into stock_prices values ( 'W1', 4, 7  );
insert into stock_prices values ( 'W1', 5, 8  );
insert into stock_prices values ( 'W1', 6, 9  );
insert into stock_prices values ( 'W1', 7, 8  );
insert into stock_prices values ( 'W1', 8, 7  );
insert into stock_prices values ( 'W1', 9, 8  );
insert into stock_prices values ( 'W1',10, 9  );
insert into stock_prices values ( 'W1',11, 10 );

insert into stock_prices values ( 'W2', 1, 9  );
insert into stock_prices values ( 'W2', 2, 9  );
insert into stock_prices values ( 'W2', 3, 9  );
insert into stock_prices values ( 'W2', 4, 7  );
insert into stock_prices values ( 'W2', 5, 8  );
insert into stock_prices values ( 'W2', 6, 8  );
insert into stock_prices values ( 'W2', 7, 8  );
insert into stock_prices values ( 'W2', 8, 5  );
insert into stock_prices values ( 'W2', 9, 9  );
insert into stock_prices values ( 'W2',10, 9  );
insert into stock_prices values ( 'W2',11, 9  );

insert into stock_prices values ( 'V1', 1, 10 );
insert into stock_prices values ( 'V1', 2, 9  );
insert into stock_prices values ( 'V1', 3, 8  );
insert into stock_prices values ( 'V1', 4, 7  );
insert into stock_prices values ( 'V1', 5, 6  );
insert into stock_prices values ( 'V1', 6, 5  );
insert into stock_prices values ( 'V1', 7, 6  );
insert into stock_prices values ( 'V1', 8, 7  );
insert into stock_prices values ( 'V1', 9, 8  );
insert into stock_prices values ( 'V1',10, 9  );
insert into stock_prices values ( 'V1',11, 10 );

insert into stock_prices values ( 'V2', 1, 9  );
insert into stock_prices values ( 'V2', 2, 9  );
insert into stock_prices values ( 'V2', 3, 8  );
insert into stock_prices values ( 'V2', 4, 8  );
insert into stock_prices values ( 'V2', 5, 6  );
insert into stock_prices values ( 'V2', 6, 6  );
insert into stock_prices values ( 'V2', 7, 7  );
insert into stock_prices values ( 'V2', 8, 7  );
insert into stock_prices values ( 'V2', 9, 8  );
insert into stock_prices values ( 'V2',10, 8  );
insert into stock_prices values ( 'V2',11, 9  );

insert into stock_prices values ( 'V3', 1, 5  );
insert into stock_prices values ( 'V3', 2, 5  );
insert into stock_prices values ( 'V3', 3, 5  );
insert into stock_prices values ( 'V3', 4, 7  );
insert into stock_prices values ( 'V3', 5, 7  );
insert into stock_prices values ( 'V3', 6,10  );
insert into stock_prices values ( 'V3', 7,10  );
insert into stock_prices values ( 'V3', 8, 9  );
insert into stock_prices values ( 'V3', 9, 9  );
insert into stock_prices values ( 'V3',10, 8  );
insert into stock_prices values ( 'V3',11, 6  );

insert into stock_prices values ( 'FLAT', 1, 7 );
insert into stock_prices values ( 'FLAT', 2, 7 );
insert into stock_prices values ( 'FLAT', 3, 7 );
insert into stock_prices values ( 'FLAT', 4, 7 );
insert into stock_prices values ( 'FLAT', 5, 7 );
insert into stock_prices values ( 'FLAT', 6, 7 );
insert into stock_prices values ( 'FLAT', 7, 7 );
insert into stock_prices values ( 'FLAT', 8, 7 );
insert into stock_prices values ( 'FLAT', 9, 7 );
insert into stock_prices values ( 'FLAT',10, 7 );
insert into stock_prices values ( 'FLAT',11, 7 );

commit;