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
WALLMAN RICHARD F	Director	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	424.95	1000	424950	1000	Feb 15 04:26 PM
HUNN LAURENCE NEIL	President and CEO	Mon Jan 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	115.22	5000	576100	117048	Jan 12 04:14 PM
HUNN LAURENCE NEIL	President and CEO	Mon Jan 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	443.57	5000	2217826	112048	Jan 12 04:14 PM
WRIGHT CHRISTOPHER	Director	Wed Dec 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	438.24	416	182308	38708	Dec 16 05:56 PM
JOHNSON ROBERT D	Director	Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	442.12	250	110530	6403	Dec 02 04:06 PM
Crisci Robert	Executive VP and CFO	Mon Nov 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	435.45	6000	2612726	30887	Nov 23 04:14 PM
Crisci Robert	Executive VP and CFO	Wed Nov 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	192.81	32000	6169820	68887	Nov 18 04:20 PM
Crisci Robert	Executive VP and CFO	Wed Nov 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	431.7	32000	13814551	36887	Nov 18 04:20 PM
WALLMAN RICHARD F	Director	Fri Nov 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	390	1000	390000	46409	Nov 07 04:05 PM
JOHNSON ROBERT D	Director	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	398.39	250	99598	6653	Sep 02 04:11 PM


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