Name: Brazil Stock Exchange Historical Quote 1995-2019
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Brazil Stock Exchange Historical Quote 1995-2019

Content

Merging the contents of all files from 1995 onwards. COTAHIST_AAAATXT from B3 site

Data source

http://www.b3.com.br/en_us/market-data-and-indices/data-services/market-data/historical-data/equities/historical-quotes/

Basic Concepts

The COTAHIST.AAAA.TXT file contains the historical quotation data relative to the negotiation of all financial market papers during a one-year period, classified by the fields: Type of Register, Date of Exchange, BDI (Daily Information Bulletin) Code, Company Name and Negotiation Code. This subdivision can be modified according to the user’s preferences / requirements, according to the equipment and software available.
The name of the file identifies the corresponding year. Ex.: COTAHIST.1990.TXT, COTAHIST.1991.TXT, Etc.

Attached Tables

CODBDI Table

02 - Round Lot
05 - Bmfbovespa Regulations Sanction
06 - Stocks Of Cos. Under Reorganization
07 - Extrajudicial Recovery
08 - Judicial Recovery
09 - Temporary Especial Management
10 - Rights And Receipts
11 - Intervention
12 - Real Estate Funds
14 - Investment Certificates / Debentures / Public Debt Securities
18 - Bonds
22 - Bonuses (Private)
26 - Policies / Bonuses / Public Securities
32 - Exercise Of Index Call Options
33 - Exercise Of Index Put Options
38 - Exercise Of Call Options
42 - Exercise Of Put Options
46 - Auction Of Non-Quoted Securities
48 - Privatization Auction
49 - Auction Of Economical Recovery Fund Of Espirito Santo State
50 - Auction
51 - Finor Auction
52 - Finam Auction
53 - Fiset Auction
54 - Auction Of Shares In Arrears
56 - Sales By Court Order
58 - Others
60 - Share Swap
61 - Goal
62 - Term
66 - Debentures With Maturity Dates Of Up To 3 Years
68 - Debentures With Maturity Dates Greater Than 3 Years
70 - Forward With Continuous Movement
71 - Forward With Gain Retention
74 - Index Call Options
75 - Index Put Options
78 - Call Options
82 - Put Options
83 - Debentures And Promissory Notes Bovespafix
84 - Debentures And Promissory Notes Somafix
90 - Registered Term View
96 - Factionary
99 - Grand Tota

Tables

Bovespa

@kaggle.ronaldoaf_brazil_stock_exchange_historical_quote_19952019.bovespa

178.63 MB
6,394,425 rows
20 columns

CREATE TABLE bovespa (
  "codbdi" BIGINT,
  "codneg" VARCHAR,
  "date" BIGINT,
  "datven" BIGINT,
  "fatcot" BIGINT,
  "nomres" VARCHAR,
  "prazot" DOUBLE,
  "preabe" DOUBLE,
  "preexe" DOUBLE,
  "premax" DOUBLE,
  "premed" DOUBLE,
  "premin" DOUBLE,
  "preofc" DOUBLE,
  "preofv" DOUBLE,
  "preult" DOUBLE,
  "ptoexe" DOUBLE,
  "quatot" BIGINT,
  "totneg" BIGINT,
  "tpmerc" BIGINT,
  "voltot" DOUBLE
);