S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Nov 18 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	27.896015594576287	30.65496506623837	24.523970418177804	26.976367950439453	62546380
Fri Nov 19 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	26.32495034986816	26.36327036607168	24.4090165670242	24.75388526916504	15234146
Mon Nov 22 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	25.328662924203982	26.97636795043945	24.562288797548025	26.976367950439453	6577870
Tue Nov 23 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	26.05672393525993	26.74646144251069	24.523975372314453	24.523975372314453	5975611
Wed Nov 24 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	24.60061894844241	25.711862216945104	24.523980523310136	25.17539978027344	4843231
Fri Nov 26 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	25.06043964835052	25.44362681893464	24.983802868159035	25.252033233642575	1729466
Mon Nov 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	25.137071282004708	26.01840055569966	24.868839354070055	25.826807022094727	4074751
Tue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	25.75016508316673	26.32494560486103	25.098747812504936	25.865121841430664	4310034
Wed Dec 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	25.865134807334524	26.63150922043521	25.673541204059354	26.32495880126953	2957329
Thu Dec 02 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	26.82310086769868	27.58947685972669	26.47823207998942	27.05301284790039	3069868


CREATE TABLE a (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);