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

On

@kaggle.rprkh15_sp500_stock_prices.on

179.15 kB
5,584 rows
8 columns

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

Orcl

@kaggle.rprkh15_sp500_stock_prices.orcl

455.23 kB
9,158 rows
8 columns

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

Orly

@kaggle.rprkh15_sp500_stock_prices.orly

270.3 kB
7,358 rows
8 columns

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

Otis

@kaggle.rprkh15_sp500_stock_prices.otis

35.07 kB
583 rows
8 columns

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

Oxy

@kaggle.rprkh15_sp500_stock_prices.oxy

497.58 kB
10,218 rows
8 columns

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

Para

@kaggle.rprkh15_sp500_stock_prices.para

222.5 kB
4,178 rows
8 columns

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

Payc

@kaggle.rprkh15_sp500_stock_prices.payc

94.1 kB
2,075 rows
8 columns

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

Payx

@kaggle.rprkh15_sp500_stock_prices.payx

453.47 kB
9,799 rows
8 columns

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

Pcar

@kaggle.rprkh15_sp500_stock_prices.pcar

486.05 kB
10,671 rows
8 columns

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

Peak

@kaggle.rprkh15_sp500_stock_prices.peak

436.42 kB
9,359 rows
8 columns

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

Peg

@kaggle.rprkh15_sp500_stock_prices.peg

505.39 kB
10,723 rows
8 columns

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

Penn

@kaggle.rprkh15_sp500_stock_prices.penn

260.04 kB
7,082 rows
8 columns

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

Pep

@kaggle.rprkh15_sp500_stock_prices.pep

609.06 kB
12,637 rows
8 columns

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

Pfe

@kaggle.rprkh15_sp500_stock_prices.pfe

611.14 kB
12,637 rows
8 columns

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

Pfg

@kaggle.rprkh15_sp500_stock_prices.pfg

272.6 kB
5,215 rows
8 columns

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

Pg

@kaggle.rprkh15_sp500_stock_prices.pg

726.83 kB
15,236 rows
8 columns

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

Pgr

@kaggle.rprkh15_sp500_stock_prices.pgr

491.2 kB
10,671 rows
8 columns

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

Ph

@kaggle.rprkh15_sp500_stock_prices.ph

498.64 kB
10,671 rows
8 columns

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

Phm

@kaggle.rprkh15_sp500_stock_prices.phm

487.91 kB
10,671 rows
8 columns

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

Pkg

@kaggle.rprkh15_sp500_stock_prices.pkg

288.15 kB
5,649 rows
8 columns

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

Pki

@kaggle.rprkh15_sp500_stock_prices.pki

535.31 kB
12,457 rows
8 columns

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

Pld

@kaggle.rprkh15_sp500_stock_prices.pld

315.77 kB
6,198 rows
8 columns

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

Pm

@kaggle.rprkh15_sp500_stock_prices.pm

190.41 kB
3,606 rows
8 columns

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

Pnc

@kaggle.rprkh15_sp500_stock_prices.pnc

506.22 kB
11,764 rows
8 columns

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

Pnr

@kaggle.rprkh15_sp500_stock_prices.pnr

486.28 kB
12,407 rows
8 columns

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