S&P 500 Stock Prices

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue Jan 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	18.125	18.1875	16.25	16.875	16.875	812300
Wed Jan 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	17.125	17.1875	13.4375	13.5	13.5	1212700
Thu Feb 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	13.125	14.375	13	14.1875	14.1875	669100
Fri Feb 02 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14	14.5625	13.75	14.125	14.125	775000
Mon Feb 05 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.4375	14.5	13.875	14.125	14.125	489400
Tue Feb 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.015625	14.0625	13.875	14	14	737900
Wed Feb 07 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14	14.0625	13	13.0625	13.0625	1361000
Thu Feb 08 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	13.125	13.1875	13	13.0625	13.0625	712000
Fri Feb 09 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	13.046875	13.0625	11.875	12	12	1100800
Mon Feb 12 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	12.046875	12.125	10.9375	11.0625	11.0625	552000


CREATE TABLE algn (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);