Name: S&P500 Stock Prices
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

S&P500 Stock Prices

Context

The Standard and Poor's 500 is a stock market index tracking the performance of 500 large companies listed on stock exchanges in the United States. It is one of the most commonly followed equity indices. As of December 31, 2020, more than $5.4 trillion was invested in assets tied to the performance of the index.

Inspiration

This dataset can be used to create some interesting visualizations and identify how stock prices of a particular company vary over time. Working with stock data is one of the best ways to get acquainted with timeseries forecasting. Can you create a model to stay one step ahead of the market and make statistically informed trading decisions?

Content

The naming convention of the files are in the form ticker.csv. The individual files contain the historical stock price data of that company. All the files have the following columns:

Date: The date is in the format yy-mm-dd
Open: Price of the stock when the market opens
High: Highest price reached in the day
Low: Lowest price reached in the day
Close: Price of the stock when the market closes
Volume: Number of shares traded in a day
Dividends: The dividends of the stock
Stock Splits: The stock splits of the company. In a stock split, a company divides its existing stock into multiple shares to boost liquidity.

Acknowledgement

Credits to Yahoo Finance that simplified the process of scraping stock data.

Tables

Gl

@kaggle.rprkh15_sp500_stock_prices.gl

481.95 kB
10,533 rows
8 columns

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

Glw

@kaggle.rprkh15_sp500_stock_prices.glw

515.79 kB
10,218 rows
8 columns

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

Gm

@kaggle.rprkh15_sp500_stock_prices.gm

153.96 kB
2,930 rows
8 columns

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

Gnrc

@kaggle.rprkh15_sp500_stock_prices.gnrc

141.59 kB
3,125 rows
8 columns

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

Goog

@kaggle.rprkh15_sp500_stock_prices.goog

207.87 kB
4,505 rows
8 columns

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

Googl

@kaggle.rprkh15_sp500_stock_prices.googl

207.54 kB
4,505 rows
8 columns

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

Gpc

@kaggle.rprkh15_sp500_stock_prices.gpc

501.63 kB
10,671 rows
8 columns

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

Gpn

@kaggle.rprkh15_sp500_stock_prices.gpn

281.47 kB
5,406 rows
8 columns

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

Grmn

@kaggle.rprkh15_sp500_stock_prices.grmn

282.95 kB
5,430 rows
8 columns

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

Gs

@kaggle.rprkh15_sp500_stock_prices.gs

308.78 kB
5,836 rows
8 columns

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

Gww

@kaggle.rprkh15_sp500_stock_prices.gww

534.15 kB
12,457 rows
8 columns

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

Hal

@kaggle.rprkh15_sp500_stock_prices.hal

636.53 kB
12,637 rows
8 columns

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

Has

@kaggle.rprkh15_sp500_stock_prices.has

498.22 kB
10,671 rows
8 columns

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

Hban

@kaggle.rprkh15_sp500_stock_prices.hban

465.27 kB
10,671 rows
8 columns

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

Hca

@kaggle.rprkh15_sp500_stock_prices.hca

151.08 kB
2,854 rows
8 columns

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

Hd

@kaggle.rprkh15_sp500_stock_prices.hd

503.93 kB
10,288 rows
8 columns

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

Hes

@kaggle.rprkh15_sp500_stock_prices.hes

520.74 kB
10,671 rows
8 columns

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

Hig

@kaggle.rprkh15_sp500_stock_prices.hig

349.14 kB
6,688 rows
8 columns

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

Hii

@kaggle.rprkh15_sp500_stock_prices.hii

148.31 kB
2,846 rows
8 columns

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

Hlt

@kaggle.rprkh15_sp500_stock_prices.hlt

115.69 kB
2,159 rows
8 columns

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

Holx

@kaggle.rprkh15_sp500_stock_prices.holx

262.54 kB
8,154 rows
8 columns

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

Hon

@kaggle.rprkh15_sp500_stock_prices.hon

713.53 kB
15,236 rows
8 columns

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

Hpe

@kaggle.rprkh15_sp500_stock_prices.hpe

91.26 kB
1,694 rows
8 columns

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

Hpq

@kaggle.rprkh15_sp500_stock_prices.hpq

751.95 kB
15,236 rows
8 columns

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

Hrl

@kaggle.rprkh15_sp500_stock_prices.hrl

457.83 kB
10,671 rows
8 columns

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