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

Vz

@kaggle.rprkh15_sp500_stock_prices.vz

500.43 kB
9,739 rows
8 columns

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

Wab

@kaggle.rprkh15_sp500_stock_prices.wab

337.28 kB
6,815 rows
8 columns

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

Wat

@kaggle.rprkh15_sp500_stock_prices.wat

260.29 kB
6,707 rows
8 columns

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

Wba

@kaggle.rprkh15_sp500_stock_prices.wba

510.77 kB
10,671 rows
8 columns

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

Wbd

@kaggle.rprkh15_sp500_stock_prices.wbd

167.73 kB
4,282 rows
8 columns

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

Wdc

@kaggle.rprkh15_sp500_stock_prices.wdc

431.28 kB
11,018 rows
8 columns

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

Wec

@kaggle.rprkh15_sp500_stock_prices.wec

474.8 kB
10,671 rows
8 columns

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

Well

@kaggle.rprkh15_sp500_stock_prices.well

431.56 kB
10,669 rows
8 columns

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

Wfc

@kaggle.rprkh15_sp500_stock_prices.wfc

578.52 kB
12,637 rows
8 columns

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

Whr

@kaggle.rprkh15_sp500_stock_prices.whr

547.86 kB
12,457 rows
8 columns

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

Wm

@kaggle.rprkh15_sp500_stock_prices.wm

385.76 kB
8,581 rows
8 columns

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

Wmb

@kaggle.rprkh15_sp500_stock_prices.wmb

508.59 kB
10,218 rows
8 columns

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

Wmt

@kaggle.rprkh15_sp500_stock_prices.wmt

609.5 kB
12,577 rows
8 columns

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

Wrb

@kaggle.rprkh15_sp500_stock_prices.wrb

498.75 kB
12,287 rows
8 columns

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

Wrk

@kaggle.rprkh15_sp500_stock_prices.wrk

95.45 kB
1,775 rows
8 columns

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

Wst

@kaggle.rprkh15_sp500_stock_prices.wst

438.12 kB
10,671 rows
8 columns

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

Wtw

@kaggle.rprkh15_sp500_stock_prices.wtw

276.13 kB
5,304 rows
8 columns

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

Wy

@kaggle.rprkh15_sp500_stock_prices.wy

599.48 kB
12,407 rows
8 columns

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

Wynn

@kaggle.rprkh15_sp500_stock_prices.wynn

260.66 kB
4,961 rows
8 columns

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

Xel

@kaggle.rprkh15_sp500_stock_prices.xel

515.75 kB
12,457 rows
8 columns

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

Xom

@kaggle.rprkh15_sp500_stock_prices.xom

726.65 kB
15,236 rows
8 columns

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

Xray

@kaggle.rprkh15_sp500_stock_prices.xray

403.32 kB
8,799 rows
8 columns

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

Xyl

@kaggle.rprkh15_sp500_stock_prices.xyl

142.75 kB
2,703 rows
8 columns

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

Yum

@kaggle.rprkh15_sp500_stock_prices.yum

323.88 kB
6,245 rows
8 columns

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

Zbh

@kaggle.rprkh15_sp500_stock_prices.zbh

273.89 kB
5,274 rows
8 columns

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