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
Villeneuve Nadia	Senior VP & CHRO	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	18.81	6469	121682	72113	Mar 03 04:12 PM
Villeneuve Nadia	Senior VP & CHRO	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	45.45	20538	933445	48900	Mar 03 04:12 PM
Nelson Christopher John	President, HVAC	Sun Feb 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	20.95	396014	8296493	493299	Feb 14 04:09 PM
Nelson Christopher John	President, HVAC	Sun Feb 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	45.3	213353	9665446	97285	Feb 14 04:09 PM
Nelson Christopher John	President, HVAC	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		138		97344	Feb 14 04:09 PM
Timperman Jurgen	President, Fire & Security	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		101		18641	Feb 14 04:09 PM
Villeneuve Nadia	Senior VP & CHRO	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		89		65677	Feb 14 04:09 PM
Agrawal Ajay	Senior VP, Strategy & Services	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		56		69037	Feb 14 04:09 PM
O'Connor Kevin J.	Senior VP & CLO	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		310		42467	Feb 14 04:10 PM
Crockett Kyle	Vice President, Controller	Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	45.85	10433	478378		Feb 10 04:16 PM


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