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
Gavelle Jean-Luc	President, ISS Division	Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	42.03	129800	5454888	75000	Feb 10 02:01 PM
Gavelle Jean-Luc	President, ISS Division	Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	81.64	129800	10596236		Feb 10 02:01 PM
NORWITT RICHARD ADAM	President & CEO	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.99	650000	18843500	1617424	Feb 07 08:46 AM
D'AMICO LANCE E	Sr. VP, Secretary & GenCounsel	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	36.45	25000	911250	50700	Feb 07 08:49 AM
NORWITT RICHARD ADAM	President & CEO	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	81.72	650000	53115790	967424	Feb 07 08:46 AM
D'AMICO LANCE E	Sr. VP, Secretary & GenCounsel	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	82.19	25000	2054728	25700	Feb 07 08:49 AM
Silverman David M	Senior VP, Human Resources	Tue Nov 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.98	75000	2173500	82000	Nov 23 08:23 AM
Silverman David M	Senior VP, Human Resources	Tue Nov 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	80.02	75000	6001522	7000	Nov 23 08:23 AM
Doherty William J	President, CS Division	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	39.42	127000	5006150	77000	Nov 14 08:09 AM
WALTER LUC	President, HES Division	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.99	82400	2388776	286812	Nov 14 08:07 AM


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