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
Calleja Fernandez Bernardo	President, Otis EMEA	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	54.14	7746	419407	27744	Mar 07 08:17 PM
Calleja Fernandez Bernardo	President, Otis EMEA	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	86.85	703	61058	22215	Mar 07 08:17 PM
Calleja Fernandez Bernardo	President, Otis EMEA	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	59.53	11479	683345	29105	Feb 16 05:26 PM
Calleja Fernandez Bernardo	President, Otis EMEA	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	84.67	837	70869	19998	Feb 16 05:26 PM
Ryan Michael Patrick	VP, CAO & Controller	Sun Feb 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	60.62	1787	108334	3359	Feb 07 06:24 PM
Ryan Michael Patrick	VP, CAO & Controller	Sun Feb 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	84.46	3018	254903		Feb 07 06:24 PM
Cramer James F.	President, Otis Americas	Sun Feb 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	83.97	700	58779	5037	Feb 07 06:24 PM
LaFreniere Nora E.	EVP, General Counsel	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	59.53	19049	1133987	31425	Feb 07 06:25 PM
de Montlivault Stephane	President, Otis Asia Pac	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	56	14299	800754	40897	Feb 07 06:25 PM
Zheng Peiming	President, Otis China	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	59.53	6206	369443	18434	Feb 07 06:24 PM


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