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
Ritter William D.	SEVP	Thu Jan 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	23.42	13000	304456	24344	Jan 30 05:47 PM
Lusco C. Matthew	SEVP & CRO	Tue Jan 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	22.83	100000	2282760	77843	Jan 27 06:09 PM
Golodryga Zhanna	Director	Wed Apr 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		6350		29270	Apr 22 01:27 PM
DEFOSSET DON	Director	Wed Apr 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		18698		152679	Apr 22 01:27 PM
JOHNSON JOIA M	Director	Wed Apr 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		5276		5276	Apr 22 01:27 PM
Peters Scott M.	SEVP	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		29998		71397	Apr 05 06:13 PM
Smith Ronald G.	SEVP	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		38569		271697	Apr 05 06:13 PM
Ritter William D.	SEVP	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		25713		48749	Apr 05 06:13 PM
Turner David J Jr	CFO	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		59996		220887	Apr 05 06:13 PM
Turner John M JR	President & CEO	Fri Apr 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		187485		578035	Apr 05 06:13 PM


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