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
Kempczinski Christopher J	President and CEO	Wed Feb 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	267.69	3850	1030606	34637	Feb 24 03:32 PM
Gross Marion K.	EVP-Chief Supply Chain Officer	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		1962		2180	Feb 22 04:11 PM
Steijaert Manuel JM	EVP - Chief Customer Officer	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		5098		4400	Feb 22 04:09 PM
Sempels Jo	President, IDL	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		1571		1571	Feb 22 04:06 PM
OZAN KEVIN M	SEVP - Strategic Initiatives	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		12863		34831	Feb 22 04:04 PM
Kempczinski Christopher J	President and CEO	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		33940		52967	Feb 22 04:03 PM
Hoovel Catherine A.	SVP - Corporate Controller	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		769		1953	Feb 22 04:00 PM
Flatley Edith Morgan	EVP - Global CMO	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		3583		4543	Feb 22 03:59 PM
Erlinger Joseph M.	President, McDonald's USA	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		8039		16226	Feb 22 03:57 PM
Borden Ian Frederick	EVP & CFO	Fri Feb 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		6790		13925	Feb 22 03:55 PM


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