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 ma (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE mco (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE met (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE met_pa (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE met_pe (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE mfc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE mmc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ms (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE msci (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ms_pa (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ms_pe (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ms_pf (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ms_pi (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ms_pk (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE pgr (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE pnc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE puk (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE pypl (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"adj_close" DOUBLE
);CREATE TABLE rkt (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"adj_close" DOUBLE
);CREATE TABLE ry (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ry_pt (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE schw (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE schw_pc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE schw_pd (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE smfg (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE spgi (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE td (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE tfc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE trow (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE trv (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE ubs (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE usb (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE usb_ph (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE usb_pm (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE usb_po (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE usb_pp (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wbk (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pl (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pn (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_po (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pp (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pq (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pr (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pt (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pv (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_pw (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_px (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);CREATE TABLE wfc_py (
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"adj_close" DOUBLE
);Anyone who has the link will be able to view this.