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
Lagano Roxanne	Executive Vice President	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	79.85	13010	1038843	39367	Feb 16 04:18 PM
Lagano Roxanne	Executive Vice President	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	175	13010	2276750	26357	Feb 16 04:18 PM
Lagano Roxanne	Executive Vice President	Fri Jul 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	79.85	2167	173038	25854	Jul 26 04:36 PM
Lagano Roxanne	Executive Vice President	Fri Jul 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	180.26	2167	390623	23687	Jul 26 04:36 PM
PECK KRISTIN C	Chief Executive Officer	Thu Jul 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	36.49	9689	353599	49432	Jul 25 04:08 PM
PECK KRISTIN C	Chief Executive Officer	Thu Jul 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	180	9689	1744020	39743	Jul 25 04:08 PM
PECK KRISTIN C	Chief Executive Officer	Thu Jul 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	30.89	311	9607	40054	Jul 11 04:08 PM
PECK KRISTIN C	Chief Executive Officer	Thu Jul 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	180	311	55980	39743	Jul 11 04:08 PM
Lagano Roxanne	Executive Vice President	Mon Jun 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	79.85	4334	346076	28021	Jun 28 05:29 PM
Lagano Roxanne	Executive Vice President	Mon Jun 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	175	4334	758450	23687	Jun 28 05:29 PM


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