Name: Macroeconomic Index For Retail Sector In Brazil
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Macroeconomic Index For Retail Sector In Brazil

Lojas Renner (LREN3) was chosen to be a representative stock of the retail sector of companies traded on B3 (brazilian stock exchange). The indices Broad National Consumer Price Index (IPCA), Special System for Settlement and Custody (selic), Central Bank Economic Activity Index (IBC-Br), Broad Retail Trade Confidence Index (ICOM), Future Expectations Index, Dollar (exchange), Consumer Stock Index (ICON) and Ibovespa Index (IBOV). Data from during 11 years were used (2011-2021).

Columns
'date' - when the indicator was published
'trend' - trend of stock, uptrend ou downtrend
'ipca' - Broad National Consumer Price Index
'selic' - Special System for Settlement and Custody
'IBC-Br' - Central Bank Economic Activity Index
'icom' - Broad Retail Trade Confidence Index
'expectativa' - Future Expectations Index
'dolar' - Dollar (exchange)
'icon' - Consumer Stock Index
'ibov' - Ibovespa Index
'open' - value of open
'high' - highest value traded
'low' - lower value traded
'close' - value of close
'adjclose' - value of close adjusted
'volume' - volume traded
'ticker' - code of stock traded

Tables

Dataset

@kaggle.clonageinvitro_andre_luis_lopes_da_silva.dataset

24.59 kB
132 rows
17 columns

CREATE TABLE dataset (
  "date" TIMESTAMP,
  "trend" VARCHAR,
  "ipca" DOUBLE,
  "selic" DOUBLE,
  "ibc_br" BIGINT,
  "icom" BIGINT,
  "expectativa" BIGINT,
  "dolar" BIGINT,
  "icon" DOUBLE,
  "ibov" BIGINT,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adjclose" DOUBLE,
  "volume" BIGINT,
  "ticker" VARCHAR
);