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
Staehler Cord Friedrich	SVP, Chief Technology Officer	Mon Mar 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	39.33	4000	157320	97693	Mar 08 04:11 PM
LUCIER GREGORY T	Director	Tue Nov 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	31.45	6000	188700	15000	Nov 15 04:15 PM
Deese Willie A	Director	Mon May 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	38.02	6900	262338	29926	May 25 05:59 PM
BRANDT ERIC	Director	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	38.02	6900	262338	42055	May 04 07:44 PM
BRANDT ERIC	Director	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	39.71	6900	273999	35155	May 04 07:44 PM
Casey Donald M Jr.	President & CEO	Wed Dec 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	49.78	20000	995600	52500	Dec 02 04:08 PM
Yankie Lisa	Sr VP & Chief HR Officer	Fri Nov 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	52.63	1903	100155	21825	Nov 23 01:50 PM
Petersohn Walter	Chief Commercial Officer	Wed Nov 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	46.25	41616	1924726	43488	Nov 19 04:28 PM
Petersohn Walter	Chief Commercial Officer	Wed Nov 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	54.18	86431	4682610	25740	Nov 19 04:28 PM


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