Name: Brazilian Stock Market Analysis
Creator: Kaggle
License: https://opensource.org/licenses/MIT

About this Dataset

Brazilian Stock Market Analysis

This dataset provides a comprehensive overview of the Brazilian stock market, covering various sectors and industries from 2018 to 2023. Each row in the dataset represents a specific asset, identified by its ticker on B3 (the Brazilian stock exchange). The dataset includes detailed information such as sector, industry, trading dates, opening price, closing price, trading volume, dividends, dividend yield, and P/E (price/earnings) ratio. Additionally, it contains daily historical price data for the assets over time.

Key Columns:

•	Ticker: The asset’s code on the stock exchange.
•	Sector: The sector in which the asset operates.
•	Industry: The specific industry within the sector.
•	Date: The reference date for the data.
•	Open: The asset’s opening price on the specified date.
•	Price: The asset’s closing price on the specified date.
•	Volume: The trading volume of the asset.
•	Dividend: The amount of dividends paid.
•	Dividend Yield: The dividend yield as a percentage of the price.
•	P/E Ratio: The price-to-earnings ratio.

Applications:

This dataset is ideal for stock performance analysis, sector and industry studies, investment strategy development, and machine learning models focused on market predictions. It can be used by investors, market analysts, researchers, and finance professionals interested in examining the behavior of the Brazilian stock market over five years.

Tables

Brazilian Stock Market Analysis Dataset 2018–2023

@kaggle.kaioguilherme_brazilian_stock_market_analysis.brazilian_stock_market_analysis_dataset_2018_2023

4.67 MB
406 rows
1,259 columns

CREATE TABLE brazilian_stock_market_analysis_dataset_2018_2023 (
  "ticker" VARCHAR,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "date" BIGINT,
  "open" DOUBLE,
  "price" DOUBLE,
  "volume" BIGINT,
  "dividend" DOUBLE,
  "dividend_yield" DOUBLE,
  "p_l" DOUBLE,
  "p_vp" DOUBLE,
  "lpa" DOUBLE,
  "vpa" DOUBLE,
  "graham" DOUBLE,
  "enterprise_value" DOUBLE,
  "market_cap" DOUBLE,
  "valuation_12m" DOUBLE,
  "valuation" DOUBLE,
  "price_min" DOUBLE,
  "price_med" DOUBLE,
  "price_max" DOUBLE,
  "n_2023_11_03" DOUBLE  -- 2023-11-03,
  "n_2023_11_01" DOUBLE  -- 2023-11-01,
  "n_2023_10_31" DOUBLE  -- 2023-10-31,
  "n_2023_10_30" DOUBLE  -- 2023-10-30,
  "n_2023_10_27" DOUBLE  -- 2023-10-27,
  "n_2023_10_26" DOUBLE  -- 2023-10-26,
  "n_2023_10_25" DOUBLE  -- 2023-10-25,
  "n_2023_10_24" DOUBLE  -- 2023-10-24,
  "n_2023_10_23" DOUBLE  -- 2023-10-23,
  "n_2023_10_20" DOUBLE  -- 2023-10-20,
  "n_2023_10_19" DOUBLE  -- 2023-10-19,
  "n_2023_10_18" DOUBLE  -- 2023-10-18,
  "n_2023_10_17" DOUBLE  -- 2023-10-17,
  "n_2023_10_16" DOUBLE  -- 2023-10-16,
  "n_2023_10_13" DOUBLE  -- 2023-10-13,
  "n_2023_10_11" DOUBLE  -- 2023-10-11,
  "n_2023_10_10" DOUBLE  -- 2023-10-10,
  "n_2023_10_09" DOUBLE  -- 2023-10-09,
  "n_2023_10_06" DOUBLE  -- 2023-10-06,
  "n_2023_10_05" DOUBLE  -- 2023-10-05,
  "n_2023_10_04" DOUBLE  -- 2023-10-04,
  "n_2023_10_03" DOUBLE  -- 2023-10-03,
  "n_2023_10_02" DOUBLE  -- 2023-10-02,
  "n_2023_09_29" DOUBLE  -- 2023-09-29,
  "n_2023_09_28" DOUBLE  -- 2023-09-28,
  "n_2023_09_27" DOUBLE  -- 2023-09-27,
  "n_2023_09_26" DOUBLE  -- 2023-09-26,
  "n_2023_09_25" DOUBLE  -- 2023-09-25,
  "n_2023_09_22" DOUBLE  -- 2023-09-22,
  "n_2023_09_21" DOUBLE  -- 2023-09-21,
  "n_2023_09_20" DOUBLE  -- 2023-09-20,
  "n_2023_09_19" DOUBLE  -- 2023-09-19,
  "n_2023_09_18" DOUBLE  -- 2023-09-18,
  "n_2023_09_15" DOUBLE  -- 2023-09-15,
  "n_2023_09_14" DOUBLE  -- 2023-09-14,
  "n_2023_09_13" DOUBLE  -- 2023-09-13,
  "n_2023_09_12" DOUBLE  -- 2023-09-12,
  "n_2023_09_11" DOUBLE  -- 2023-09-11,
  "n_2023_09_08" DOUBLE  -- 2023-09-08,
  "n_2023_09_06" DOUBLE  -- 2023-09-06,
  "n_2023_09_05" DOUBLE  -- 2023-09-05,
  "n_2023_09_04" DOUBLE  -- 2023-09-04,
  "n_2023_09_01" DOUBLE  -- 2023-09-01,
  "n_2023_08_31" DOUBLE  -- 2023-08-31,
  "n_2023_08_30" DOUBLE  -- 2023-08-30,
  "n_2023_08_29" DOUBLE  -- 2023-08-29,
  "n_2023_08_28" DOUBLE  -- 2023-08-28,
  "n_2023_08_25" DOUBLE  -- 2023-08-25,
  "n_2023_08_24" DOUBLE  -- 2023-08-24,
  "n_2023_08_23" DOUBLE  -- 2023-08-23,
  "n_2023_08_22" DOUBLE  -- 2023-08-22,
  "n_2023_08_21" DOUBLE  -- 2023-08-21,
  "n_2023_08_18" DOUBLE  -- 2023-08-18,
  "n_2023_08_17" DOUBLE  -- 2023-08-17,
  "n_2023_08_16" DOUBLE  -- 2023-08-16,
  "n_2023_08_15" DOUBLE  -- 2023-08-15,
  "n_2023_08_14" DOUBLE  -- 2023-08-14,
  "n_2023_08_11" DOUBLE  -- 2023-08-11,
  "n_2023_08_10" DOUBLE  -- 2023-08-10,
  "n_2023_08_09" DOUBLE  -- 2023-08-09,
  "n_2023_08_08" DOUBLE  -- 2023-08-08,
  "n_2023_08_07" DOUBLE  -- 2023-08-07,
  "n_2023_08_04" DOUBLE  -- 2023-08-04,
  "n_2023_08_03" DOUBLE  -- 2023-08-03,
  "n_2023_08_02" DOUBLE  -- 2023-08-02,
  "n_2023_08_01" DOUBLE  -- 2023-08-01,
  "n_2023_07_31" DOUBLE  -- 2023-07-31,
  "n_2023_07_28" DOUBLE  -- 2023-07-28,
  "n_2023_07_27" DOUBLE  -- 2023-07-27,
  "n_2023_07_26" DOUBLE  -- 2023-07-26,
  "n_2023_07_25" DOUBLE  -- 2023-07-25,
  "n_2023_07_24" DOUBLE  -- 2023-07-24,
  "n_2023_07_21" DOUBLE  -- 2023-07-21,
  "n_2023_07_20" DOUBLE  -- 2023-07-20,
  "n_2023_07_19" DOUBLE  -- 2023-07-19,
  "n_2023_07_18" DOUBLE  -- 2023-07-18,
  "n_2023_07_17" DOUBLE  -- 2023-07-17,
  "n_2023_07_14" DOUBLE  -- 2023-07-14,
  "n_2023_07_13" DOUBLE  -- 2023-07-13
);