Insider Trading S&P500 - Inside Info

insider_trading Insider Trading	relationship Relationship	date Date	transaction Transaction	cost Cost	shares Shares	value Value ($)	shares_total Shares Total	sec_form_4 SEC Form 4
VanHimbergen Robert M	VP Corporate Controller	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	33.39	5683	189755	45301	Feb 28 10:42 AM
VanHimbergen Robert M	VP Corporate Controller	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	64.44	5683	366213	39618	Feb 28 10:42 AM
VanHimbergen Robert M	VP Corporate Controller	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	41.75	8573	357923	48191	Feb 04 10:43 AM
VanHimbergen Robert M	VP Corporate Controller	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	69.63	8573	596938	39618	Feb 04 10:43 AM
Leng Visal	VP & Pres, APAC BTS	Wed Jan 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	33.39	600	20034	110019	Jan 13 04:07 PM
Leng Visal	VP & Pres, APAC BTS	Wed Jan 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	81	600	48600	109419	Jan 13 04:07 PM
Leng Visal	VP & Pres, APAC BTS	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	33.39	33723	1126011	143142	Jan 10 03:24 PM
Leng Visal	VP & Pres, APAC BTS	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	80.13	33723	2702224	109419	Jan 10 03:24 PM
MANNING NATHAN D	VP & Pres, North America	Tue Dec 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	78.47	5144	403650	89257	Dec 14 06:01 PM
Donofrio John	Exec VP & General Counsel	Mon Dec 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	78.9	31784	2507670	35306	Dec 13 05:54 PM


CREATE TABLE jci (
  "insider_trading" VARCHAR,
  "relationship" VARCHAR,
  "date" TIMESTAMP,
  "transaction" VARCHAR,
  "cost" DOUBLE,
  "shares" BIGINT,
  "value" BIGINT,
  "shares_total" BIGINT,
  "sec_form_4" VARCHAR
);