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

Mkc

@kaggle.rprkh15_sp500_stock_prices.mkc

487.39 kB
12,457 rows
8 columns

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

Mktx

@kaggle.rprkh15_sp500_stock_prices.mktx

223.63 kB
4,450 rows
8 columns

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

Mlm

@kaggle.rprkh15_sp500_stock_prices.mlm

354.09 kB
7,149 rows
8 columns

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

Mmc

@kaggle.rprkh15_sp500_stock_prices.mmc

548.86 kB
12,457 rows
8 columns

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

Mmm

@kaggle.rprkh15_sp500_stock_prices.mmm

726.69 kB
15,236 rows
8 columns

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

Mnst

@kaggle.rprkh15_sp500_stock_prices.mnst

292.1 kB
9,222 rows
8 columns

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

Mo

@kaggle.rprkh15_sp500_stock_prices.mo

747.07 kB
15,236 rows
8 columns

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

Moh

@kaggle.rprkh15_sp500_stock_prices.moh

192.62 kB
4,790 rows
8 columns

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

Mos

@kaggle.rprkh15_sp500_stock_prices.mos

437.59 kB
8,684 rows
8 columns

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

Mpc

@kaggle.rprkh15_sp500_stock_prices.mpc

148.79 kB
2,780 rows
8 columns

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

Mpwr

@kaggle.rprkh15_sp500_stock_prices.mpwr

223.82 kB
4,440 rows
8 columns

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

Mrk

@kaggle.rprkh15_sp500_stock_prices.mrk

739.41 kB
15,236 rows
8 columns

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

Mrna

@kaggle.rprkh15_sp500_stock_prices.mrna

44.65 kB
904 rows
8 columns

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

Mro

@kaggle.rprkh15_sp500_stock_prices.mro

702.32 kB
15,236 rows
8 columns

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

Ms

@kaggle.rprkh15_sp500_stock_prices.ms

385.84 kB
7,400 rows
8 columns

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

Msci

@kaggle.rprkh15_sp500_stock_prices.msci

188.64 kB
3,688 rows
8 columns

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

Msft

@kaggle.rprkh15_sp500_stock_prices.msft

475.29 kB
9,157 rows
8 columns

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

Msi

@kaggle.rprkh15_sp500_stock_prices.msi

721.58 kB
15,236 rows
8 columns

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

Mtb

@kaggle.rprkh15_sp500_stock_prices.mtb

454.29 kB
10,671 rows
8 columns

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

Mtch

@kaggle.rprkh15_sp500_stock_prices.mtch

360.85 kB
7,424 rows
8 columns

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

Mtd

@kaggle.rprkh15_sp500_stock_prices.mtd

239.95 kB
6,203 rows
8 columns

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

Mu

@kaggle.rprkh15_sp500_stock_prices.mu

447.88 kB
9,606 rows
8 columns

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

Nclh

@kaggle.rprkh15_sp500_stock_prices.nclh

97.74 kB
2,386 rows
8 columns

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

Ndaq

@kaggle.rprkh15_sp500_stock_prices.ndaq

251.95 kB
5,043 rows
8 columns

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

Ndsn

@kaggle.rprkh15_sp500_stock_prices.ndsn

434.49 kB
10,670 rows
8 columns

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