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

Rop

@kaggle.rprkh15_sp500_stock_prices.rop

372.84 kB
7,659 rows
8 columns

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

Rost

@kaggle.rprkh15_sp500_stock_prices.rost

431.18 kB
9,306 rows
8 columns

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

Rsg

@kaggle.rprkh15_sp500_stock_prices.rsg

308.3 kB
6,047 rows
8 columns

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

Rtx

@kaggle.rprkh15_sp500_stock_prices.rtx

721.49 kB
15,173 rows
8 columns

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

Sbac

@kaggle.rprkh15_sp500_stock_prices.sbac

295.87 kB
5,806 rows
8 columns

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

Sbny

@kaggle.rprkh15_sp500_stock_prices.sbny

233.21 kB
4,608 rows
8 columns

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

Sbux

@kaggle.rprkh15_sp500_stock_prices.sbux

380.8 kB
7,566 rows
8 columns

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

Schw

@kaggle.rprkh15_sp500_stock_prices.schw

437.71 kB
8,771 rows
8 columns

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

Sedg

@kaggle.rprkh15_sp500_stock_prices.sedg

79.98 kB
1,837 rows
8 columns

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

See

@kaggle.rprkh15_sp500_stock_prices.see

466.49 kB
10,671 rows
8 columns

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

Shw

@kaggle.rprkh15_sp500_stock_prices.shw

493.78 kB
10,671 rows
8 columns

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

Sivb

@kaggle.rprkh15_sp500_stock_prices.sivb

300.04 kB
8,747 rows
8 columns

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

Sjm

@kaggle.rprkh15_sp500_stock_prices.sjm

323.17 kB
6,973 rows
8 columns

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

Slb

@kaggle.rprkh15_sp500_stock_prices.slb

524.16 kB
10,218 rows
8 columns

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

Sna

@kaggle.rprkh15_sp500_stock_prices.sna

519.02 kB
12,457 rows
8 columns

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

Snps

@kaggle.rprkh15_sp500_stock_prices.snps

261.49 kB
7,651 rows
8 columns

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

So

@kaggle.rprkh15_sp500_stock_prices.so

480.86 kB
10,218 rows
8 columns

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

Spg

@kaggle.rprkh15_sp500_stock_prices.spg

361.44 kB
7,195 rows
8 columns

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

Spgi

@kaggle.rprkh15_sp500_stock_prices.spgi

547.84 kB
12,457 rows
8 columns

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

Sre

@kaggle.rprkh15_sp500_stock_prices.sre

312.73 kB
6,049 rows
8 columns

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

Ste

@kaggle.rprkh15_sp500_stock_prices.ste

356.39 kB
7,585 rows
8 columns

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

Stt

@kaggle.rprkh15_sp500_stock_prices.stt

498.48 kB
10,671 rows
8 columns

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

Stx

@kaggle.rprkh15_sp500_stock_prices.stx

261.38 kB
4,929 rows
8 columns

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

Stz

@kaggle.rprkh15_sp500_stock_prices.stz

358.36 kB
7,637 rows
8 columns

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

Swk

@kaggle.rprkh15_sp500_stock_prices.swk

489.11 kB
10,671 rows
8 columns

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