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

Sellorders

@kaggle.gustavomartino_bovespa_03_07_2023.sellorders

181.03 MB
10222964 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	dealt_qty Dealt Qty	date Date	entry_date Entry Date	status Status	condition Condition	broker Broker
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86817823461	4598929	2	14:13:11.261000	2147483647	21.58	100		Mon Jul 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 01 2019 14:13:11 GMT+0000 (Coordinated Universal Time)	5		3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86822904349	25615257	2	09:45:10.931000	2147483647	23.09	100		Fri Jun 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 28 2019 09:45:10 GMT+0000 (Coordinated Universal Time)	5		3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86854182210	15542333	4	17:12:17.744000	2147483647	14.65	5000	200	Tue Jul 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 02 2019 17:12:17 GMT+0000 (Coordinated Universal Time)	1	2	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86854182210	15542335	4	17:12:17.744000	2147483647	14.65	5000	300	Tue Jul 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 02 2019 17:12:17 GMT+0000 (Coordinated Universal Time)	1	2	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86854182210	17066228	4	11:01:17.061000	2147483647	14.65	5000	4900	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 03 2019 11:01:17 GMT+0000 (Coordinated Universal Time)	1	2	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86854182210	17066231	4	11:01:17.061000	2147483647	14.65	5000	5000	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 03 2019 11:01:17 GMT+0000 (Coordinated Universal Time)	2	2	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86875073066	17249310	4	11:10:36.895000	2147483647	14.75	200	100	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 03 2019 11:10:36 GMT+0000 (Coordinated Universal Time)	1	2	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86875073066	17258997	4	11:11:11.695000	2147483647	14.75	200	200	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 03 2019 11:11:11 GMT+0000 (Coordinated Universal Time)	2	2	3
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86882770204	12645217	2	09:46:34.442000	2147483647	14.39	300		Wed Jun 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2019 09:46:34 GMT+0000 (Coordinated Universal Time)	5		114
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	2	86882770204	21142654	2	12:20:48.701000	2147483647	15.49	300		Thu Jun 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 27 2019 12:20:48 GMT+0000 (Coordinated Universal Time)	5		114


CREATE TABLE sellorders (
  "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
);