Baselight

Banks Historical Stock Price

Visualize and analyze the stock prices of 6 major banks!

@kaggle.tomasmantero_banks_historical_stock_price

Loading...
Loading...

About this Dataset

Banks Historical Stock Price

Context

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.

Content

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:

  • Bank of America (BAC)
  • CitiGroup (C)
  • Goldman Sachs (GS)
  • JPMorgan Chase (JPM)
  • Morgan Stanley (MS)
  • Wells Fargo (WFC)

Acknowledgements

Yahoo Finance | Technology Sector
SEC EDGAR | Company Filings
NASDAQ | Historical Quotes

Inspiration

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?

More Datasets

Tables

Afl

@kaggle.tomasmantero_banks_historical_stock_price.afl
  • 172.38 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE afl (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Aig

@kaggle.tomasmantero_banks_historical_stock_price.aig
  • 173.28 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE aig (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Aig Pa

@kaggle.tomasmantero_banks_historical_stock_price.aig_pa
  • 22.29 kB
  • 432 rows
  • 7 columns
Loading...
CREATE TABLE aig_pa (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

All Pg

@kaggle.tomasmantero_banks_historical_stock_price.all_pg
  • 31.64 kB
  • 668 rows
  • 7 columns
Loading...
CREATE TABLE all_pg (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

All Ph

@kaggle.tomasmantero_banks_historical_stock_price.all_ph
  • 18.38 kB
  • 330 rows
  • 7 columns
Loading...
CREATE TABLE all_ph (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Aon

@kaggle.tomasmantero_banks_historical_stock_price.aon
  • 178.95 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE aon (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Axp

@kaggle.tomasmantero_banks_historical_stock_price.axp
  • 181.79 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE axp (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bac

@kaggle.tomasmantero_banks_historical_stock_price.bac
  • 165.28 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE bac (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bac Pb

@kaggle.tomasmantero_banks_historical_stock_price.bac_pb
  • 28.41 kB
  • 641 rows
  • 7 columns
Loading...
CREATE TABLE bac_pb (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bac Pc

@kaggle.tomasmantero_banks_historical_stock_price.bac_pc
  • 43.1 kB
  • 1,219 rows
  • 7 columns
Loading...
CREATE TABLE bac_pc (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bac Pe

@kaggle.tomasmantero_banks_historical_stock_price.bac_pe
  • 103.86 kB
  • 3,172 rows
  • 7 columns
Loading...
CREATE TABLE bac_pe (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bac Pk

@kaggle.tomasmantero_banks_historical_stock_price.bac_pk
  • 27.37 kB
  • 592 rows
  • 7 columns
Loading...
CREATE TABLE bac_pk (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bac Pl

@kaggle.tomasmantero_banks_historical_stock_price.bac_pl
  • 131.76 kB
  • 3,230 rows
  • 7 columns
Loading...
CREATE TABLE bac_pl (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bam

@kaggle.tomasmantero_banks_historical_stock_price.bam
  • 180.89 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE bam (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bcs

@kaggle.tomasmantero_banks_historical_stock_price.bcs
  • 165.34 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE bcs (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bk

@kaggle.tomasmantero_banks_historical_stock_price.bk
  • 169.33 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE bk (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bk Pc

@kaggle.tomasmantero_banks_historical_stock_price.bk_pc
  • 75.83 kB
  • 2,060 rows
  • 7 columns
Loading...
CREATE TABLE bk_pc (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Blk

@kaggle.tomasmantero_banks_historical_stock_price.blk
  • 189.16 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE blk (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bml Pg

@kaggle.tomasmantero_banks_historical_stock_price.bml_pg
  • 83.85 kB
  • 2,122 rows
  • 7 columns
Loading...
CREATE TABLE bml_pg (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bml Ph

@kaggle.tomasmantero_banks_historical_stock_price.bml_ph
  • 80.59 kB
  • 2,122 rows
  • 7 columns
Loading...
CREATE TABLE bml_ph (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bml Pl

@kaggle.tomasmantero_banks_historical_stock_price.bml_pl
  • 81.54 kB
  • 2,122 rows
  • 7 columns
Loading...
CREATE TABLE bml_pl (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bmo

@kaggle.tomasmantero_banks_historical_stock_price.bmo
  • 161.72 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE bmo (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Bns

@kaggle.tomasmantero_banks_historical_stock_price.bns
  • 158.39 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE bns (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Brk A

@kaggle.tomasmantero_banks_historical_stock_price.brk_a
  • 142.99 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE brk_a (
  "date" TIMESTAMP,
  "high" BIGINT,
  "low" BIGINT,
  "open" BIGINT,
  "close" BIGINT,
  "volume" BIGINT,
  "adj_close" BIGINT
);

Brk B

@kaggle.tomasmantero_banks_historical_stock_price.brk_b
  • 174.09 kB
  • 3,749 rows
  • 7 columns
Loading...
CREATE TABLE brk_b (
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE
);

Share link

Anyone who has the link will be able to view this.