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
Bjornholt James Eric	Senior VP and CFO	Wed Feb 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	81.58	2777	226548	30582	Feb 23 04:35 PM
Johnson Karlton D	Director	Wed Feb 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	81	396	32076	973	Feb 24 04:21 PM
CHAPMAN MATTHEW W	Director	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	81.13	1000	81130	35682	Feb 23 04:35 PM
SANGHI STEVE	Executive Chair	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	85.91	45306	3892238	10078615	Feb 17 04:19 PM
MOORTHY GANESH	President & CEO	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	85.91	21646	1859608	762027	Feb 17 04:19 PM
DREHOBL STEPHEN V	Senior VP, MCU8/MCU16 BU	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	85.91	10106	868206	76498	Feb 17 04:17 PM
SIMONCIC RICHARD J	Senior VP, Analog/Intrfce BU	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	85.91	6832	586937	120936	Feb 17 04:20 PM
Bjornholt James Eric	Senior VP and CFO	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	85.91	6676	573535	41993	Feb 17 04:15 PM
Bjornholt James Eric	Senior VP and CFO	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	85	6813	579105	33359	Feb 17 04:15 PM
Bjornholt James Eric	Senior VP and CFO	Tue Nov 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	72.88	2630	191674	36358	Nov 23 04:10 PM


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