S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri May 12 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	21.223464577598676	21.27340137932392	20.24468878603558	21.07365226745605	10933700
Mon May 15 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20.98376689645806	22.272155196762466	20.98376689645806	21.99250602722168	3487300
Tue May 16 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	22.162292633903714	22.382017241586208	22.022466151772136	22.072404861450195	1289300
Wed May 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	22.12234166616127	22.48189275597534	21.642941483053832	22.072404861450195	1583700
Thu May 18 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	22.16229425914628	23.60049491393713	21.952555473051486	22.471906661987305	4075200
Fri May 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	22.531829350246703	23.46066838694669	22.292129260931706	22.69162940979004	1248600
Mon May 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	22.7715280967238	23.06116687817044	22.49187896149737	22.86141586303711	383100
Tue May 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	22.96129255030428	23.58051920505861	22.621716950111097	23.42071914672852	704000
Wed May 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	23.51060601929849	23.56353933416805	22.981267155702227	23.32084274291992	408800
Thu May 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	23.390755148148763	23.790255280766825	22.282140613287595	22.48189163208008	1080700


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