Bovespa

Stock exchange located in São Paulo, Brazil

@kaggle.friedliver_bovespa

Table List

1 table(180.2 MB)

Bovespa1998–2019

@kaggle.friedliver_bovespa.bovespa1998_2019

180.2 MB
5822484 rows
26 columns

tipreg TIPREG	datprg DATPRG	codbdi CODBDI	codneg CODNEG	tpmerc TPMERC	nomres NOMRES	especi ESPECI	prazot PRAZOT	modref MODREF	preabe PREABE	premax PREMAX	premin PREMIN	premed PREMED	preult PREULT	preofc PREOFC	preofv PREOFV	totneg TOTNEG	quatot QUATOT	voltot VOLTOT	preexe PREEXE	datven DATVEN	fatcot FATCOT	codisi CODISI	dismes DISMES
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	96	PAL 3	20	PAUL F LUZ	ON *		R$	135.1	139.99	135.1	139.85	139.99	135.1	139.99	2	78187	10934.7		9999-12-31	1000	BRPALFACNOR9	141
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	62	CMI 4	30	CMIG	PN *EJ	30	R$	50.28	51.8	50.27	50.44	51.8			10	4500000	226994.92		9999-12-31	1000	BRCMIGACNPR3	168
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	62	PET 3	30	PETR	ON *	30	R$	211.29	211.3	211.29	211.29	211.3			2	1000000	211294.2		9999-12-31	1000	BRPETRACNOR9	137
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	62	SHA 4	30	SHAP	PN *	30	R$	0.84	0.84	0.83	0.83	0.83			2	500000000	415449		9999-12-31	1000	BRSHAPACNPR7	128
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	62	TEL 4	30	TELB	PN *	30	R$	132.42	132.42	132.41	132.41	132.41			2	2000000	264835.74		9999-12-31	1000	BRTELBACNPR9	127
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	62	TEL 4	30	TELB	PN *	60	R$	137.18	137.18	137.18	137.18	137.18			1	100000	13718		9999-12-31	1000	BRTELBACNPR9	127
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	62	USI 4	30	USIM	PN EJ	30	R$	7.23	7.24	7.23	7.23	7.24			2	5000	36166.5		9999-12-31	1	BRUSIMACNPR0	115
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	62	USI 4	30	USIM	PN EJ	60	R$	7.36	7.37	7.36	7.36	7.37			2	2000	14728		9999-12-31	1	BRUSIMACNPR0	115
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	78	OYN 10	70	INEP	PN *I97		R$	0.08	0.09	0.08	0.08	0.09	0.09	0.1	15	66700000	5544	1.4	1998-02-18	1000	BRINEPACNPR8	126
1	Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	78	OYN 14	70	INEP	PN *I97		R$	0.33	0.37	0.33	0.35	0.37	0.34	0.39	4	13000000	4570	1	1998-02-18	1000	BRINEPACNPR8	126


CREATE TABLE bovespa1998_2019 (
  "tipreg" BIGINT,
  "datprg" TIMESTAMP,
  "codbdi" BIGINT,
  "codneg" VARCHAR,
  "tpmerc" BIGINT,
  "nomres" VARCHAR,
  "especi" VARCHAR,
  "prazot" DOUBLE,
  "modref" VARCHAR,
  "preabe" DOUBLE,
  "premax" DOUBLE,
  "premin" DOUBLE,
  "premed" DOUBLE,
  "preult" DOUBLE,
  "preofc" DOUBLE,
  "preofv" DOUBLE,
  "totneg" BIGINT,
  "quatot" BIGINT,
  "voltot" DOUBLE,
  "preexe" DOUBLE,
  "indopc" BIGINT,
  "datven" VARCHAR,
  "fatcot" BIGINT,
  "ptoexe" BIGINT,
  "codisi" VARCHAR,
  "dismes" BIGINT
);