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
FAIRBANK RICHARD D	Chairman and CEO	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		35844		3792873	Feb 17 04:06 PM
Blinde Neal	President, Commercial Banking	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	115.16	8000	921280	121472	Feb 16 04:10 PM
FAIRBANK RICHARD D	Chairman and CEO	Wed Jan 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	116.07	862	100052	3757891	Jan 30 05:12 PM
FAIRBANK RICHARD D	Chairman and CEO	Mon Nov 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	56.32	12537	706084	3769559	Nov 15 04:06 PM
FAIRBANK RICHARD D	Chairman and CEO	Mon Nov 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	114.77	12537	1438871	3757022	Nov 15 04:06 PM
West Kara	Chief Audit Officer	Mon Nov 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	114.63	606	69466	7793	Nov 16 04:06 PM
FAIRBANK RICHARD D	Chairman and CEO	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	56.32	12537	706084	3769559	Nov 15 04:06 PM
FAIRBANK RICHARD D	Chairman and CEO	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	115.67	12537	1450184	3757022	Nov 15 04:06 PM
Alexander Robert M.	Chief Information Officer	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	115	7857	903555	61352	Nov 15 04:09 PM
FAIRBANK RICHARD D	Chairman and CEO	Thu Nov 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	56.32	12537	706084	3769559	Nov 15 04:06 PM


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