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
Asher Andrew Lynn	EVP, CFO	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	71.97	3800	273486	314755	Feb 10 03:00 PM
Asher Andrew Lynn	EVP, CFO	Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	71.89	3000	215670	310955	Feb 10 03:00 PM
Samuels Theodore R. II	Director	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	71.88	7000	503160	11912	Feb 09 05:07 PM
MURRAY JAMES E	EVP, Chief Operating Officer	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	73.3	6750	494775	136220	Feb 09 05:07 PM
BAGLEY SHANNON	EVP, Chief Admin. Officer	Fri Jul 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	92.21	9000	829890	118194	Aug 01 05:27 PM
Robinson Lori Jean	Director	Thu Jul 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	92.77	1200	111324	9908	Aug 01 05:27 PM
GEPHARDT Richard A	Director	Fri Jul 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	88	4480	394240	22560	Jul 12 07:51 PM
GEPHARDT Richard A	Director	Thu Jun 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	84.03	10220	858787	27040	Jun 23 07:09 PM
GEPHARDT Richard A	Director	Tue Jun 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	80.01	3300	264033	37260	Jun 23 07:09 PM
Dallas H James	Director	Fri Apr 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	81.75	3065	250564	32582	May 03 07:11 PM


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