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

Alltrades

@kaggle.gustavomartino_bovespa_03_07_2023.alltrades

40.55 MB
1486277 rows
18 columns

session_date Session Date	ticker Ticker	trade_number Trade Number	trade_price Trade Price	trade_qty Trade Qty	trade_time Trade Time	anul_indicator Anul Indicator	buyoffer_date Buyoffer Date	buyoffer_sequence Buyoffer Sequence	buyoffer_generationid Buyoffer Generationid	buyoffer_condition Buyoffer Condition	selloffer_date Selloffer Date	selloffer_sequence Selloffer Sequence	selloffer_generationid Selloffer Generationid	selloffer_condition Selloffer Condition	buy_broker Buy Broker	sell_broker Sell Broker
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	160	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917763406	15783313	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917762979	15783314	2	115	308
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	70	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917755715	15783295	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917761100	15783296	2	3	262
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	10	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917763946	15783282	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917761100	15783283	2	238	262
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	100	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917757778	15783301	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917760160	15783302	2	386	174
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	90	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917757757	15783299	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917760160	15783300	2	386	174
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	110	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917757778	15783303	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917761318	15783304	2	386	174
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	50	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917755060	15783291	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917761100	15783292	2	114	262
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	140	14.54	100	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917763829	15783309	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917763860	15783310	2	93	174
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	130	14.54	200	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917765149	15783307	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917763860	15783308	2	174	174
Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	AALR3	30	14.54	300	10:02:00.014	1	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917756537	15783287	2	Wed Jul 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	86917761100	15783288	2	23	262


CREATE TABLE alltrades (
  "session_date" TIMESTAMP,
  "ticker" VARCHAR,
  "trade_number" BIGINT,
  "trade_price" DOUBLE,
  "trade_qty" BIGINT,
  "trade_time" VARCHAR,
  "anul_indicator" BIGINT,
  "buyoffer_date" TIMESTAMP,
  "buyoffer_sequence" DOUBLE,
  "buyoffer_generationid" BIGINT,
  "buyoffer_condition" BIGINT,
  "selloffer_date" TIMESTAMP,
  "selloffer_sequence" BIGINT,
  "selloffer_generationid" BIGINT,
  "selloffer_condition" BIGINT,
  "direct_indicator" BIGINT,
  "buy_broker" BIGINT,
  "sell_broker" BIGINT
);