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

Axp

@kaggle.rprkh15_sp500_stock_prices.axp

609.35 kB
12,637 rows
8 columns

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

Azo

@kaggle.rprkh15_sp500_stock_prices.azo

288.97 kB
7,880 rows
8 columns

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

Ba

@kaggle.rprkh15_sp500_stock_prices.ba

749.12 kB
15,236 rows
8 columns

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

Bac

@kaggle.rprkh15_sp500_stock_prices.bac

542.16 kB
12,457 rows
8 columns

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

Ball

@kaggle.rprkh15_sp500_stock_prices.ball

527.83 kB
12,457 rows
8 columns

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

Bax

@kaggle.rprkh15_sp500_stock_prices.bax

510.49 kB
10,263 rows
8 columns

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

Bbwi

@kaggle.rprkh15_sp500_stock_prices.bbwi

499.44 kB
10,155 rows
8 columns

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

Bby

@kaggle.rprkh15_sp500_stock_prices.bby

444.1 kB
9,384 rows
8 columns

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

Bdx

@kaggle.rprkh15_sp500_stock_prices.bdx

549.67 kB
12,457 rows
8 columns

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

Ben

@kaggle.rprkh15_sp500_stock_prices.ben

474.14 kB
9,780 rows
8 columns

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

Bf B

@kaggle.rprkh15_sp500_stock_prices.bf_b

483.53 kB
10,671 rows
8 columns

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

Biib

@kaggle.rprkh15_sp500_stock_prices.biib

289.74 kB
7,763 rows
8 columns

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

Bio

@kaggle.rprkh15_sp500_stock_prices.bio

316.05 kB
10,684 rows
8 columns

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

Bk

@kaggle.rprkh15_sp500_stock_prices.bk

548.17 kB
12,407 rows
8 columns

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

Bkng

@kaggle.rprkh15_sp500_stock_prices.bkng

245.59 kB
5,859 rows
8 columns

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

Bkr

@kaggle.rprkh15_sp500_stock_prices.bkr

447.57 kB
8,888 rows
8 columns

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

Blk

@kaggle.rprkh15_sp500_stock_prices.blk

293.11 kB
5,731 rows
8 columns

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

Bmy

@kaggle.rprkh15_sp500_stock_prices.bmy

628.34 kB
12,637 rows
8 columns

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

Br

@kaggle.rprkh15_sp500_stock_prices.br

199.32 kB
3,854 rows
8 columns

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

Brk B

@kaggle.rprkh15_sp500_stock_prices.brk_b

238.91 kB
6,588 rows
8 columns

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

Bro

@kaggle.rprkh15_sp500_stock_prices.bro

406.77 kB
10,442 rows
8 columns

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

Bsx

@kaggle.rprkh15_sp500_stock_prices.bsx

244.54 kB
7,593 rows
8 columns

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

Bwa

@kaggle.rprkh15_sp500_stock_prices.bwa

365.85 kB
7,280 rows
8 columns

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

Bxp

@kaggle.rprkh15_sp500_stock_prices.bxp

323.69 kB
6,308 rows
8 columns

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

C

@kaggle.rprkh15_sp500_stock_prices.c

543.59 kB
11,480 rows
8 columns

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