Historical Data For FAANG Stocks
20 years of EOD data for FAANG stocks
@kaggle.brianthecoder_historical_data_for_faang_stocks
20 years of EOD data for FAANG stocks
@kaggle.brianthecoder_historical_data_for_faang_stocks
CREATE TABLE aapl (
"timestamp" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adjusted_close" DOUBLE,
"volume" BIGINT,
"dividend_amount" DOUBLE,
"split_coefficient" DOUBLE
);
CREATE TABLE amzn (
"timestamp" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adjusted_close" DOUBLE,
"volume" BIGINT,
"dividend_amount" DOUBLE,
"split_coefficient" DOUBLE
);
CREATE TABLE fb (
"timestamp" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adjusted_close" DOUBLE,
"volume" BIGINT,
"dividend_amount" DOUBLE,
"split_coefficient" DOUBLE
);
CREATE TABLE goog (
"timestamp" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adjusted_close" DOUBLE,
"volume" BIGINT,
"dividend_amount" DOUBLE,
"split_coefficient" DOUBLE
);
CREATE TABLE nflx (
"timestamp" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adjusted_close" DOUBLE,
"volume" BIGINT,
"dividend_amount" DOUBLE,
"split_coefficient" DOUBLE
);
Anyone who has the link will be able to view this.