Dark Mode
Historical B3 Stock and Coin Values
Stock & Market Data
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Financial market data detailing stock prices and company information from the Brazil Stock Market (B3) spanning 1994 through 2020. This curated collection is structured as an analytical environment suitable for decision support systems, reflecting the movements of shares, daily values, and associated currency exchange rates. The Brazilian market is highly active, exchanging values estimated around BRL ~25.9 billion per day during the first half of 2020, highlighting the value of these underlying data for financial analysis. The structure allows users to compare different financial assets based on the economic sectors in which the respective companies operate.
Columns
The data is structured into five files, adhering to a Data Warehouse design:
dimCompany (Company Information):
keyCompany: Primary key identifier for the company.stockCodeCompany: The specific code used to identify the stock.nameCompany: The full name of the company.sectorCodeCompany: Code identifying the sector of the company.sectorCompany: Full description of the economic sector.segmentCompany: Description of the specific company segment.
dimCoin (Coin/Currency Information):
keyCoin: Primary key identifier for the coin.abbrevCoin: Abbreviation of the coin/currency.nameCoin: Name of the coin/currency.symbolCoin: Symbol used for the coin/currency.
dimTime (Date and Time Dimension):
keyTime: Primary key for the date/time record.datetime: Full date and time stamp.dayTime: Day number.dayWeekTime: Day of the week number.dayWeekAbbrevTime: Abbreviated day of the week.dayWeekCompleteTime: Full day of the week name.monthTime: Month number.monthAbbrevTime: Abbreviated month name.monthCompleteTime: Full month name.bimonthTime,quarterTime,semesterTime: Temporal groupings for aggregation.yearTime: Year number.
factCoins (Coin Value Facts):
keyTime: Foreign key linking to the time dimension.keyCoin: Foreign key linking to the coin dimension.valueCoin: The measured value of the coin over time.
factStocks (Stock Price Facts):
keyTime: Foreign key linking to the time dimension.keyCompany: Foreign key linking to the company dimension.openValueStock: The opening price of the stock.closeValueStock: The closing price of the stock.highValueStock: The highest price reached.lowValueStock: The lowest price reached.quantityStock: The volume or quantity of stock traded.
Distribution
The information is delivered in a tabular format, specifically modeled as a Data Warehouse, structured into five separate CSV files corresponding to three dimension tables and two fact tables. An accompanying SQL command file (
data-warehouse.sql, 1.91 kB) is provided for setting up the star schema structure, which is ideal for OLAP and analytics. Specific row counts or dataset size in GB are not available in the description. The data is suitable for Time Series Analysis.Usage
This product is highly valuable for analysis and visualization of financial business metrics. Specific applications include developing decision support systems, performing regression tasks for price prediction, and using association rules to identify the best groups of stocks. Users can utilise the structure to answer key strategic questions, such as identifying the most profitable economic sectors for investment over a specific period. It facilitates comparing asset performance across different sectors listed on B3.
Coverage
The data covers the entirety of the Brazil Stock Market (B3) transactions. The time scope spans historical daily values from 1994 up to 2020.
License
Attribution 4.0 International (CC BY 4.0)
Who Can Use It
- Financial Analysts: Seeking to compare asset returns and identify standing-out sectors or profitable companies.
- Data Scientists: For developing machine learning models related to stock price prediction (regression tasks) or market segmentation (association rules).
- Academics and Researchers: Studying historical performance and dynamics of the Latin American stock market.
- Business Intelligence Professionals: Constructing dashboards and visualisations for decision support systems.
Dataset Name Suggestions
- B3 Brazilian Stock Market Daily Data (1994–2020)
- Brazil Financial Data Warehouse Schema
- Historical B3 Stock and Coin Values
- Brazilian Stock Exchange Market Indicators
Attributes
Original Data Source: Historical B3 Stock and Coin Values
QUALITYLoading...