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

Jci

@kaggle.rprkh15_sp500_stock_prices.jci

449.17 kB
8,767 rows
8 columns

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

Jkhy

@kaggle.rprkh15_sp500_stock_prices.jkhy

403.29 kB
9,234 rows
8 columns

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

Jnj

@kaggle.rprkh15_sp500_stock_prices.jnj

729.28 kB
15,236 rows
8 columns

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

Jnpr

@kaggle.rprkh15_sp500_stock_prices.jnpr

297.81 kB
5,799 rows
8 columns

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

Jpm

@kaggle.rprkh15_sp500_stock_prices.jpm

531.39 kB
10,671 rows
8 columns

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

K

@kaggle.rprkh15_sp500_stock_prices.k

542.11 kB
12,457 rows
8 columns

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

Kdp

@kaggle.rprkh15_sp500_stock_prices.kdp

187.17 kB
3,570 rows
8 columns

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

Key

@kaggle.rprkh15_sp500_stock_prices.key

434.54 kB
8,739 rows
8 columns

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

Keys

@kaggle.rprkh15_sp500_stock_prices.keys

85.58 kB
1,945 rows
8 columns

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

Khc

@kaggle.rprkh15_sp500_stock_prices.khc

95.29 kB
1,768 rows
8 columns

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

Kim

@kaggle.rprkh15_sp500_stock_prices.kim

376.01 kB
7,715 rows
8 columns

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

Klac

@kaggle.rprkh15_sp500_stock_prices.klac

452.92 kB
10,528 rows
8 columns

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

Kmb

@kaggle.rprkh15_sp500_stock_prices.kmb

521.5 kB
10,671 rows
8 columns

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

Kmi

@kaggle.rprkh15_sp500_stock_prices.kmi

152.66 kB
2,872 rows
8 columns

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

Kmx

@kaggle.rprkh15_sp500_stock_prices.kmx

241.36 kB
6,401 rows
8 columns

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

Ko

@kaggle.rprkh15_sp500_stock_prices.ko

747.15 kB
15,236 rows
8 columns

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

Kr

@kaggle.rprkh15_sp500_stock_prices.kr

636.18 kB
15,236 rows
8 columns

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

L

@kaggle.rprkh15_sp500_stock_prices.l

509.47 kB
10,671 rows
8 columns

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

Ldos

@kaggle.rprkh15_sp500_stock_prices.ldos

201.72 kB
3,960 rows
8 columns

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

Len

@kaggle.rprkh15_sp500_stock_prices.len

477.73 kB
10,671 rows
8 columns

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

Lh

@kaggle.rprkh15_sp500_stock_prices.lh

367.86 kB
8,134 rows
8 columns

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

Lhx

@kaggle.rprkh15_sp500_stock_prices.lhx

502.78 kB
10,218 rows
8 columns

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

Lin

@kaggle.rprkh15_sp500_stock_prices.lin

380.83 kB
7,573 rows
8 columns

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

Lkq

@kaggle.rprkh15_sp500_stock_prices.lkq

238.74 kB
4,724 rows
8 columns

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

Lly

@kaggle.rprkh15_sp500_stock_prices.lly

628 kB
12,637 rows
8 columns

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