Dataset: Historical Data For FAANG Stocks

About this Dataset

Historical Data For FAANG Stocks

Context

FAANG is an acronym referring to the stocks of the five most popular and best-performing American technology companies: Facebook, Amazon, Apple, Netflix and Alphabet (formerly known as Google). In addition to being widely known among consumers, the five FAANG stocks are among the largest companies in the world, with a combined market capitalization of over $4.1 trillion as of January 2020. Some have raised concerns that the FAANG stocks may be in the midst of a bubble, whereas others argue that their growth is justified by the stellar financial and operational performance they have shown in recent years.

Regardless of the myriad of accolades, comments, and even controversies surrounding the FAANG stocks, they are nevertheless a data science/mining treasure and the bellwether of the NASDAQ index, if not the entire US technology sector.

This Kaggle dataset contains over 20 years of daily historical data for the five FAANG constituents, as retrieved from this free stock API. It is a public-domain dataset that gives the data science practitioners (a.k.a., you!) the full flexibility to derive second-order insights and investment heuristics from it.

Content

Over 20 years of daily historical data (2000-01-01 to 2020-10-01) for the five FAANG stocks: Facebook, Amazon, Apple, Netflix, and Alphabet/Google. For completeness, both raw and adjusted prices are included, along with historical split events and dividend payouts (check out here for how stock market API providers perform price adjustments).

Acknowledgements

Data source: https://www.alphavantage.co/

Tables

Aapl

@kaggle.brianthecoder_historical_data_for_faang_stocks.aapl

240.93 KB
5221 rows
9 columns


CREATE TABLE aapl (
  "timestamp" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adjusted_close" DOUBLE,
  "volume" BIGINT,
  "dividend_amount" DOUBLE,
  "split_coefficient" DOUBLE
);

Amzn

@kaggle.brianthecoder_historical_data_for_faang_stocks.amzn

232.26 KB
5221 rows
9 columns


CREATE TABLE amzn (
  "timestamp" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adjusted_close" DOUBLE,
  "volume" BIGINT,
  "dividend_amount" DOUBLE,
  "split_coefficient" DOUBLE
);

Fb

@kaggle.brianthecoder_historical_data_for_faang_stocks.fb

98.95 KB
2107 rows
9 columns


CREATE TABLE fb (
  "timestamp" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adjusted_close" DOUBLE,
  "volume" BIGINT,
  "dividend_amount" DOUBLE,
  "split_coefficient" DOUBLE
);

Goog

@kaggle.brianthecoder_historical_data_for_faang_stocks.goog

77.43 KB
1642 rows
9 columns


CREATE TABLE goog (
  "timestamp" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adjusted_close" DOUBLE,
  "volume" BIGINT,
  "dividend_amount" DOUBLE,
  "split_coefficient" DOUBLE
);

Nflx

@kaggle.brianthecoder_historical_data_for_faang_stocks.nflx

206.68 KB
4623 rows
9 columns


CREATE TABLE nflx (
  "timestamp" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adjusted_close" DOUBLE,
  "volume" BIGINT,
  "dividend_amount" DOUBLE,
  "split_coefficient" DOUBLE
);