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
FARLEY JR JAMES D	President and CEO	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	12.75	79921	1018993	1718588	Mar 03 06:03 PM
Lawler John T.	Vice President, CFO	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	12.75	29821	380218	473504	Mar 03 06:05 PM
Galhotra Ashwani Kumar	President, Ford Blue	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	12.75	24850	316838	536455	Mar 03 06:03 PM
Cannis Theodore J.	CEO of Ford Pro	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	12.75	18518	236104	62252	Mar 03 06:02 PM
FARLEY JR JAMES D	President and CEO	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	12.86	79921	1027840	1638667	Mar 03 06:03 PM
Lawler John T.	Vice President, CFO	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	13.07	29821	389623	443683	Mar 03 06:05 PM
Galhotra Ashwani Kumar	President, Ford Blue	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	13.01	24850	323321	511605	Mar 03 06:03 PM
Cannis Theodore J.	CEO of Ford Pro	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	13.02	18518	241012	43734	Mar 03 06:02 PM
Rowley Stuart J.	Chief Transform. & Quality Off	Wed Nov 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	12.75	29821	380218	254799	Nov 17 04:42 PM
Rowley Stuart J.	Chief Transform. & Quality Off	Wed Nov 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	13.97	29821	416617	224978	Nov 17 04:42 PM


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