S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Jun 25 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	14.504950762920105	14.643094205081171	12.985384756004644	13.65882968902588	44833800
Mon Jun 28 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	13.520683433277446	13.745163713476144	12.450079883887334	13.693360328674316	9166200
Tue Jun 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	13.520686589278183	18.614686229891014	13.23576790636236	15.955446243286133	14730000
Wed Jun 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	16.818832898084544	21.981901346050048	16.438939311173677	20.58320999145508	16852800
Thu Jul 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	21.80922474092848	22.379061966938487	19.61621586446888	20.16878318786621	9501000
Fri Jul 02 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	20.358735165571748	20.85086744056649	18.64922305243213	19.71982765197754	3912600
Tue Jul 06 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	19.89249936995968	21.308457472559407	18.92550181886632	19.27085876464844	3632400
Wed Jul 07 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	19.149988209305214	19.75435900533116	17.682223334777955	18.657855987548828	4234800
Thu Jul 08 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	18.994574944781984	19.06364506862432	17.682220458984375	17.682220458984375	2370000
Fri Jul 09 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	18.23479500463453	18.372938444976047	16.853370086704302	18.338401794433597	2935200


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