S&P500–11year History

Stocks from 2010 through 2020

@kaggle.shawnseamons_sp500_11year_history

Table List

1 table(43.08 MB)

Sp500–11year

@kaggle.shawnseamons_sp500_11year_history.sp500_11year

43.08 MB
1319334 rows
12 columns

date Date	ticker Ticker	p1 P1	close Close	spread Spread	d1 D1	nd1 ND1	nd2 ND2	nd3 ND3	nd10 ND10	nd15 ND15	nd20 ND20
Mon Feb 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	0.9993788616761068	80.44000244140625	4.680000305175781	80.48999786376953	80.43000030517578	81.5	79.20999908447266	80.47000122070312	79.70999908447266	81.12999725341797
Tue Feb 02 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	0.9998756571863886	80.43000030517578	4.69000244140625	80.44000244140625	81.5	79.20999908447266	78.54000091552734	80.13999938964844	80.06999969482422	81
Wed Feb 03 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	1.013303489876468	81.5	4.69000244140625	80.43000030517578	79.20999908447266	78.54000091552734	77.52999877929688	81.11000061035156	79.73999786376953	81.0199966430664
Thu Feb 04 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	0.9719018292573331	79.20999908447266	5.910003662109375	81.5	78.54000091552734	77.52999877929688	78.72000122070312	81.5199966430664	80.1500015258789	82.44000244140625
Fri Feb 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	0.9915414950550524	78.54000091552734	6.580001831054688	79.20999908447266	77.52999877929688	78.72000122070312	78.62000274658203	80.68000030517578	80.58000183105469	81.30999755859375
Mon Feb 08 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	0.9871402836203584	77.52999877929688	7.590003967285156	78.54000091552734	78.72000122070312	78.62000274658203	80.2699966430664	79.70999908447266	81.12999725341797	81.98999786376953
Tue Feb 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	1.0153489289325774	78.72000122070312	7.590003967285156	77.52999877929688	78.62000274658203	80.2699966430664	79.18000030517578	80.06999969482422	81	81.55999755859375
Wed Feb 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	0.9987296942000708	78.62000274658203	7.590003967285156	78.72000122070312	80.2699966430664	79.18000030517578	80.47000122070312	79.73999786376953	81.0199966430664	81.26000213623047
Thu Feb 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	1.0209869478356908	80.2699966430664	7.590003967285156	78.62000274658203	79.18000030517578	80.47000122070312	80.13999938964844	80.1500015258789	82.44000244140625	81.37999725341797
Fri Feb 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	MMM	0.9864208747542688	79.18000030517578	7.590003967285156	80.2699966430664	80.47000122070312	80.13999938964844	81.11000061035156	80.58000183105469	81.30999755859375	81.26000213623047


CREATE TABLE sp500_11year (
  "date" TIMESTAMP,
  "ticker" VARCHAR,
  "p1" DOUBLE,
  "close" DOUBLE,
  "spread" DOUBLE,
  "d1" DOUBLE,
  "nd1" DOUBLE,
  "nd2" DOUBLE,
  "nd3" DOUBLE,
  "nd10" DOUBLE,
  "nd15" DOUBLE,
  "nd20" DOUBLE
);