Bovespa - 03.07.2019

All orders and trades occurred at Bovespa in 03/07/2019 (DDMMAAAA)

@kaggle.gustavomartino_bovespa_03_07_2023

Table List

4 tables(397.16 MB)

Alltrades

Brokers

Buyorders

Sellorders

Buyorders

@kaggle.gustavomartino_bovespa_03_07_2023.buyorders

175.56 MB
9866827 rows
16 columns

session_date Session Date	ticker Ticker	nature Nature	sequence Sequence	generationid Generationid	event_code Event Code	time Time	priority Priority	price Price	order_qty Order Qty	date Date	entry_date Entry Date	status Status	broker Broker
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86811309262	26437379	1	09:45:13.124000	2147483647	11	5000	Fri Apr 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 26 2019 09:45:13 GMT+0000 (Coordinated Universal Time)	0	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86816015301	3968518	2	13:08:34.713000	2147483647	12.8	200	Mon May 13 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 13 2019 13:08:34 GMT+0000 (Coordinated Universal Time)	5	308
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86816015301	7692193	1	11:29:48.492000	2147483647	13	200	Tue Apr 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 2019 11:29:48 GMT+0000 (Coordinated Universal Time)	0	308
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86816015301	29386512	2	16:38:06.608000	2147483647	12	200	Thu Jun 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 06 2019 16:38:06 GMT+0000 (Coordinated Universal Time)	5	308
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86869662112	161692	1	09:45:18.048000	2147483647	13	400	Mon Jun 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 03 2019 09:45:18 GMT+0000 (Coordinated Universal Time)	0	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86872705746	9255392	1	10:59:38.546000	2147483647	11.15	200	Tue Jun 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 04 2019 10:59:38 GMT+0000 (Coordinated Universal Time)	0	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86875775761	18787149	1	12:42:15.545000	2147483647	13	200	Wed Jun 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 05 2019 12:42:15 GMT+0000 (Coordinated Universal Time)	0	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86878200795	26201894	1	13:17:19.999000	2147483647	12.99	100	Thu Jun 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 06 2019 13:17:19 GMT+0000 (Coordinated Universal Time)	0	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86881887541	161780	1	09:45:33.747000	2147483647	11	300	Mon Jun 10 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 10 2019 09:45:33 GMT+0000 (Coordinated Universal Time)	0	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	1	86881887541	918519	2	10:44:22.401000	2147483647	13	300	Mon Jun 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 17 2019 10:44:22 GMT+0000 (Coordinated Universal Time)	5	3


CREATE TABLE buyorders (
  "session_date" TIMESTAMP,
  "ticker" VARCHAR,
  "nature" BIGINT,
  "sequence" DOUBLE,
  "generationid" BIGINT,
  "event_code" BIGINT,
  "time" VARCHAR,
  "priority" BIGINT,
  "price" DOUBLE,
  "order_qty" BIGINT,
  "dealt_qty" BIGINT,
  "date" TIMESTAMP,
  "entry_date" TIMESTAMP,
  "status" VARCHAR,
  "condition" BIGINT,
  "broker" BIGINT
);