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

Nee

@kaggle.rprkh15_sp500_stock_prices.nee

533 kB
12,457 rows
8 columns

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

Nem

@kaggle.rprkh15_sp500_stock_prices.nem

520.54 kB
10,671 rows
8 columns

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

Nflx

@kaggle.rprkh15_sp500_stock_prices.nflx

227.09 kB
5,069 rows
8 columns

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

Ni

@kaggle.rprkh15_sp500_stock_prices.ni

494.32 kB
12,457 rows
8 columns

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

Nke

@kaggle.rprkh15_sp500_stock_prices.nke

508.13 kB
10,491 rows
8 columns

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

Nlok

@kaggle.rprkh15_sp500_stock_prices.nlok

391 kB
8,327 rows
8 columns

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

Nlsn

@kaggle.rprkh15_sp500_stock_prices.nlsn

151.65 kB
2,883 rows
8 columns

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

Noc

@kaggle.rprkh15_sp500_stock_prices.noc

508.78 kB
10,218 rows
8 columns

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

Now

@kaggle.rprkh15_sp500_stock_prices.now

114.05 kB
2,524 rows
8 columns

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

Nrg

@kaggle.rprkh15_sp500_stock_prices.nrg

243.74 kB
4,684 rows
8 columns

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

Nsc

@kaggle.rprkh15_sp500_stock_prices.nsc

506.76 kB
10,113 rows
8 columns

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

Ntap

@kaggle.rprkh15_sp500_stock_prices.ntap

342.87 kB
6,705 rows
8 columns

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

Ntrs

@kaggle.rprkh15_sp500_stock_prices.ntrs

465.26 kB
10,671 rows
8 columns

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

Nue

@kaggle.rprkh15_sp500_stock_prices.nue

519.66 kB
10,671 rows
8 columns

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

Nvda

@kaggle.rprkh15_sp500_stock_prices.nvda

310.45 kB
5,907 rows
8 columns

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

Nvr

@kaggle.rprkh15_sp500_stock_prices.nvr

300.49 kB
9,319 rows
8 columns

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

Nwl

@kaggle.rprkh15_sp500_stock_prices.nwl

485.38 kB
10,671 rows
8 columns

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

Nws

@kaggle.rprkh15_sp500_stock_prices.nws

115.39 kB
2,282 rows
8 columns

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

Nwsa

@kaggle.rprkh15_sp500_stock_prices.nwsa

118.98 kB
2,282 rows
8 columns

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

Nxpi

@kaggle.rprkh15_sp500_stock_prices.nxpi

158.51 kB
3,003 rows
8 columns

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

O

@kaggle.rprkh15_sp500_stock_prices.o

348.46 kB
6,982 rows
8 columns

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

Odfl

@kaggle.rprkh15_sp500_stock_prices.odfl

330.43 kB
7,736 rows
8 columns

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

Ogn

@kaggle.rprkh15_sp500_stock_prices.ogn

20.32 kB
292 rows
8 columns

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

Oke

@kaggle.rprkh15_sp500_stock_prices.oke

469.4 kB
10,533 rows
8 columns

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

Omc

@kaggle.rprkh15_sp500_stock_prices.omc

468.07 kB
10,671 rows
8 columns

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