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
HRABOWSKI FREEMAN A III	Director	Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	35.8	10000	358000	106568	Mar 02 12:49 PM
MANGAN MICHAEL D	Director	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	35.8	5000	179000	43137	Feb 21 01:48 PM
MANGAN MICHAEL D	Director	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	75	5000	375000	38137	Feb 21 01:48 PM
Tapiero Jacques	Director	Wed Feb 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	74.97	3	254	24452	Feb 06 12:03 PM
Tapiero Jacques	Director	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	83.47	736	61396	24341	Jan 05 01:17 PM
Foley Brendan M	President & COO	Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		20000		89797	Dec 05 02:46 PM
MANGAN MICHAEL D	Director	Thu Nov 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	35.8	5000	179000	43137	Nov 14 10:13 AM
MANGAN MICHAEL D	Director	Thu Nov 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	82	5000	410000	38137	Nov 14 10:13 AM
Kurzius Lawrence Erik	Chairman, President & CEO	Mon Oct 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	74.41	5000	372074		Oct 25 05:34 PM
Foley Brendan M	President & COO	Wed Oct 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	75.47	3200	241491	702	Oct 19 03:45 PM


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