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

Swks

@kaggle.rprkh15_sp500_stock_prices.swks

392.49 kB
9,538 rows
8 columns

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

Syf

@kaggle.rprkh15_sp500_stock_prices.syf

106.35 kB
2,001 rows
8 columns

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

Syk

@kaggle.rprkh15_sp500_stock_prices.syk

467.62 kB
10,671 rows
8 columns

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

Syy

@kaggle.rprkh15_sp500_stock_prices.syy

512.69 kB
12,404 rows
8 columns

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

T

@kaggle.rprkh15_sp500_stock_prices.t

497.05 kB
9,739 rows
8 columns

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

Tap

@kaggle.rprkh15_sp500_stock_prices.tap

491.15 kB
11,874 rows
8 columns

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

Tdg

@kaggle.rprkh15_sp500_stock_prices.tdg

209.86 kB
4,110 rows
8 columns

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

Tdy

@kaggle.rprkh15_sp500_stock_prices.tdy

216.44 kB
5,694 rows
8 columns

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

Tech

@kaggle.rprkh15_sp500_stock_prices.tech

357.32 kB
8,420 rows
8 columns

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

Tel

@kaggle.rprkh15_sp500_stock_prices.tel

199.14 kB
3,796 rows
8 columns

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

Ter

@kaggle.rprkh15_sp500_stock_prices.ter

492.48 kB
12,457 rows
8 columns

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

Tfc

@kaggle.rprkh15_sp500_stock_prices.tfc

444.56 kB
10,670 rows
8 columns

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

Tfx

@kaggle.rprkh15_sp500_stock_prices.tfx

468.12 kB
10,671 rows
8 columns

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

Tgt

@kaggle.rprkh15_sp500_stock_prices.tgt

577.09 kB
12,457 rows
8 columns

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

Tjx

@kaggle.rprkh15_sp500_stock_prices.tjx

442.82 kB
8,831 rows
8 columns

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

Tmo

@kaggle.rprkh15_sp500_stock_prices.tmo

472.31 kB
10,671 rows
8 columns

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

Tmus

@kaggle.rprkh15_sp500_stock_prices.tmus

187.81 kB
3,835 rows
8 columns

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

Tpr

@kaggle.rprkh15_sp500_stock_prices.tpr

287.45 kB
5,474 rows
8 columns

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

Trmb

@kaggle.rprkh15_sp500_stock_prices.trmb

272.21 kB
8,056 rows
8 columns

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

Trow

@kaggle.rprkh15_sp500_stock_prices.trow

437.54 kB
9,144 rows
8 columns

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

Trv

@kaggle.rprkh15_sp500_stock_prices.trv

512.92 kB
11,764 rows
8 columns

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

Tsco

@kaggle.rprkh15_sp500_stock_prices.tsco

331.65 kB
7,149 rows
8 columns

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

Tsla

@kaggle.rprkh15_sp500_stock_prices.tsla

137.7 kB
3,030 rows
8 columns

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

Tsn

@kaggle.rprkh15_sp500_stock_prices.tsn

474.3 kB
10,671 rows
8 columns

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

Tt

@kaggle.rprkh15_sp500_stock_prices.tt

519.71 kB
10,671 rows
8 columns

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