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

A

@kaggle.rprkh15_sp500_stock_prices.a

296.94 kB
5,697 rows
8 columns

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

Aal

@kaggle.rprkh15_sp500_stock_prices.aal

218.36 kB
4,226 rows
8 columns

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

Aap

@kaggle.rprkh15_sp500_stock_prices.aap

271.21 kB
5,189 rows
8 columns

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

Aapl

@kaggle.rprkh15_sp500_stock_prices.aapl

525.76 kB
10,483 rows
8 columns

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

Abbv

@kaggle.rprkh15_sp500_stock_prices.abbv

129.3 kB
2,398 rows
8 columns

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

Abc

@kaggle.rprkh15_sp500_stock_prices.abc

347.69 kB
6,866 rows
8 columns

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

Abmd

@kaggle.rprkh15_sp500_stock_prices.abmd

256.99 kB
8,809 rows
8 columns

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

Abt

@kaggle.rprkh15_sp500_stock_prices.abt

532.08 kB
10,671 rows
8 columns

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

Acn

@kaggle.rprkh15_sp500_stock_prices.acn

275.38 kB
5,278 rows
8 columns

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

Adbe

@kaggle.rprkh15_sp500_stock_prices.adbe

411.88 kB
9,051 rows
8 columns

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

Adi

@kaggle.rprkh15_sp500_stock_prices.adi

476.65 kB
10,671 rows
8 columns

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

Adm

@kaggle.rprkh15_sp500_stock_prices.adm

515.31 kB
10,671 rows
8 columns

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

Adp

@kaggle.rprkh15_sp500_stock_prices.adp

521.77 kB
10,671 rows
8 columns

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

Adsk

@kaggle.rprkh15_sp500_stock_prices.adsk

418.52 kB
9,334 rows
8 columns

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

Aee

@kaggle.rprkh15_sp500_stock_prices.aee

318.57 kB
6,171 rows
8 columns

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

Aep

@kaggle.rprkh15_sp500_stock_prices.aep

646.59 kB
15,236 rows
8 columns

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

Aes

@kaggle.rprkh15_sp500_stock_prices.aes

377.26 kB
7,820 rows
8 columns

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

Afl

@kaggle.rprkh15_sp500_stock_prices.afl

501.5 kB
10,671 rows
8 columns

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

Aig

@kaggle.rprkh15_sp500_stock_prices.aig

567.46 kB
12,491 rows
8 columns

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

Aiz

@kaggle.rprkh15_sp500_stock_prices.aiz

241.65 kB
4,640 rows
8 columns

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

Ajg

@kaggle.rprkh15_sp500_stock_prices.ajg

428.34 kB
9,593 rows
8 columns

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

Akam

@kaggle.rprkh15_sp500_stock_prices.akam

227.49 kB
5,711 rows
8 columns

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

Alb

@kaggle.rprkh15_sp500_stock_prices.alb

353.29 kB
7,147 rows
8 columns

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

Algn

@kaggle.rprkh15_sp500_stock_prices.algn

209.5 kB
5,396 rows
8 columns

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

Alk

@kaggle.rprkh15_sp500_stock_prices.alk

461.79 kB
10,671 rows
8 columns

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