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

Lmt

@kaggle.rprkh15_sp500_stock_prices.lmt

565.25 kB
11,480 rows
8 columns

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

Lnc

@kaggle.rprkh15_sp500_stock_prices.lnc

504.16 kB
10,671 rows
8 columns

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

Lnt

@kaggle.rprkh15_sp500_stock_prices.lnt

481.62 kB
12,457 rows
8 columns

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

Low

@kaggle.rprkh15_sp500_stock_prices.low

507.93 kB
10,671 rows
8 columns

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

Lrcx

@kaggle.rprkh15_sp500_stock_prices.lrcx

424.83 kB
9,625 rows
8 columns

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

Lumn

@kaggle.rprkh15_sp500_stock_prices.lumn

476.46 kB
10,671 rows
8 columns

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

Luv

@kaggle.rprkh15_sp500_stock_prices.luv

531.47 kB
10,723 rows
8 columns

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

Lvs

@kaggle.rprkh15_sp500_stock_prices.lvs

233.23 kB
4,423 rows
8 columns

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

Lw

@kaggle.rprkh15_sp500_stock_prices.lw

77.77 kB
1,425 rows
8 columns

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

Lyb

@kaggle.rprkh15_sp500_stock_prices.lyb

163.38 kB
3,073 rows
8 columns

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

Lyv

@kaggle.rprkh15_sp500_stock_prices.lyv

158.85 kB
4,166 rows
8 columns

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

Ma

@kaggle.rprkh15_sp500_stock_prices.ma

214.71 kB
4,060 rows
8 columns

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

Maa

@kaggle.rprkh15_sp500_stock_prices.maa

340.16 kB
7,163 rows
8 columns

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

Mar

@kaggle.rprkh15_sp500_stock_prices.mar

321.44 kB
6,117 rows
8 columns

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

Mas

@kaggle.rprkh15_sp500_stock_prices.mas

514.78 kB
10,671 rows
8 columns

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

Mcd

@kaggle.rprkh15_sp500_stock_prices.mcd

680.69 kB
14,101 rows
8 columns

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

Mchp

@kaggle.rprkh15_sp500_stock_prices.mchp

377.91 kB
7,382 rows
8 columns

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

Mck

@kaggle.rprkh15_sp500_stock_prices.mck

359.06 kB
6,965 rows
8 columns

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

Mco

@kaggle.rprkh15_sp500_stock_prices.mco

331.46 kB
6,973 rows
8 columns

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

Mdlz

@kaggle.rprkh15_sp500_stock_prices.mdlz

279.63 kB
5,303 rows
8 columns

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

Mdt

@kaggle.rprkh15_sp500_stock_prices.mdt

574.31 kB
12,408 rows
8 columns

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

Met

@kaggle.rprkh15_sp500_stock_prices.met

294.52 kB
5,602 rows
8 columns

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

Mgm

@kaggle.rprkh15_sp500_stock_prices.mgm

388.4 kB
8,617 rows
8 columns

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

Mhk

@kaggle.rprkh15_sp500_stock_prices.mhk

277.02 kB
7,626 rows
8 columns

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

S&P500 Stock Prices

About this Dataset