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
Kennedy Melanie M	EVP, CHRO	Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	152.1	693	105405	11361	Jun 02 09:50 PM
Kennedy Melanie M	EVP, CHRO	Fri May 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	145.52	1029	149740	12054	May 23 04:15 PM
Wikle Melissa K.	Vice President and Controller	Mon Nov 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	81.72	2362	193023	7774	Nov 22 06:40 PM
Wikle Melissa K.	Vice President and Controller	Mon Nov 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	172.03	2362	406335	5412	Nov 22 06:40 PM
Norton Cheryl	EVP and COO	Mon Nov 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	172.11	3538	608916	8467	Nov 22 06:36 PM
Duffy Maureen	SVP, Comms & External Affairs	Fri Nov 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	52.75	4136	218174	23256	Nov 22 06:21 PM
Lynch Walter	President and CEO	Fri Nov 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	65.15	24617	1603798	157119	Nov 22 06:29 PM
Norton Cheryl	EVP and COO	Fri Nov 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	62.63	2906	181998	14911	Nov 22 06:36 PM
Norton Cheryl	EVP and COO	Fri Nov 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	173.47	2906	504104	12005	Nov 22 06:36 PM
Lynch Walter	President and CEO	Fri Nov 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	173.42	24617	4269080	132502	Nov 22 06:29 PM


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