Historical Stock Price Dataset

Analyzing Trends and Volatility for Major Ticker Symbols

@kaggle.anitarostami_historical_stock_price_dataset

Table List

1 table(930.25 KB)

Stockpricedataset

@kaggle.anitarostami_historical_stock_price_dataset.stockpricedataset

930.25 KB
25160 rows
8 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume	ticker Ticker
Thu Jan 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.8457145690918	19.89392852783203	19.71500015258789	19.754642486572266	17.273225784301758	234684800	AAPL
Fri Jan 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.7450008392334	19.774999618530277	19.301071166992188	19.320714950561523	16.893808364868164	392467600	AAPL
Mon Jan 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.194643020629883	19.5285701751709	19.05714225769043	19.426071166992188	16.985925674438477	412610800	AAPL
Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.440000534057617	19.498571395874023	19.211429595947266	19.28714370727539	16.864458084106445	317209200	AAPL
Wed Jan 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.243213653564453	19.484285354614254	19.23892974853516	19.40928649902344	16.971254348754883	258529600	AAPL
Thu Jan 09 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.5285701751709	19.53071403503418	19.11964225769043	19.16142845153809	16.75452995300293	279148800	AAPL
Fri Jan 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.27964210510254	19.314285278320312	18.96821403503418	19.033571243286133	16.642730712890625	304976000	AAPL
Mon Jan 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	18.92535781860352	19.375	18.924285888671875	19.133214950561523	16.729862213134766	378492800	AAPL
Tue Jan 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.222143173217773	19.526071548461918	19.2021427154541	19.51392936706543	17.0627498626709	332561600	AAPL
Wed Jan 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.76857185363769	20.007143020629883	19.7021427154541	19.90571403503418	17.405324935913086	391638800	AAPL


CREATE TABLE stockpricedataset (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "ticker" VARCHAR
);