Banks Historical Stock Price
Visualize and analyze the stock prices of 6 major banks!
@kaggle.tomasmantero_banks_historical_stock_price
Visualize and analyze the stock prices of 6 major banks!
@kaggle.tomasmantero_banks_historical_stock_price
The main objective is to provide historical information on stock prices of certain banks. The goal is to make the information easily accessible in case it cannot be downloaded directly from yahoo finance. The idea is that different behaviors in stock prices can be analyzed over time to gain a better understanding of the banking industry. You can also see how different events affect prices, such as the 2007 subprime mortgage crisis, presidential elections, major political reforms, etc.
The dataset contains 99 csv files. Each file has stock information from a specific bank or Financial Service company from Jan 1st, 2006 to Nov 1st, 2020.
For instance, you can find the following banks in this dataset:
Yahoo Finance | Technology Sector
SEC EDGAR | Company Filings
NASDAQ | Historical Quotes
Many have tried, but most have failed, to predict the stock market's ups and downs. Can you do any better? Can you create visualizations that help investors make important decisions?
CREATE TABLE afl (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE aig (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE aig_pa (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE all_pg (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE all_ph (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE aon (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE axp (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bac (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bac_pb (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bac_pc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bac_pe (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bac_pk (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bac_pl (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bam (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bcs (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bk (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bk_pc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE blk (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bml_pg (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bml_ph (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bml_pl (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bmo (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bns (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE brk_a (
"date" TIMESTAMP,
"high" BIGINT,
"low" BIGINT,
"open" BIGINT,
"close" BIGINT,
"volume" BIGINT,
"adj_close" BIGINT
);CREATE TABLE brk_b (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE bx (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE c (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE cb (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE cm (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE cme (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE cof (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE cof_pf (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE cof_pg (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE cof_ph (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE c_pj (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE c_ps (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE gs (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE gs_pa (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE gs_pd (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE gs_pj (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE gs_pk (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE gs_pn (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE hdb (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE hsbc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ibn (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ice (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ing (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE jpm (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE lfc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE lu (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"adj_close" DOUBLE
);Anyone who has the link will be able to view this.