FAANG Historical Stock Data
This also includes Tesla historical stock data
@kaggle.nward7_faang_historical_stock_data
This also includes Tesla historical stock data
@kaggle.nward7_faang_historical_stock_data
Historical Data on FAANG stocks as well as Tesla stocks.
Date : Date of observation
Open : Opening price on the given day
High : Highest price on the given day
Low : Lowest price on the given day
Close : Closing price on the given day
The adjusted closing price amends a stock's closing price to reflect that stock's value after accounting for any corporate actions. It is often used when examining historical returns or doing a detailed analysis of past performance.
Volume: Volume of transactions on the given day
CREATE TABLE aapl (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE amzn (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE fb (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE goog (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE nflx (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE tsla (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);Anyone who has the link will be able to view this.