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
QUAN NANCY	SVP & Chief Technical Officer	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	37.2	74000	2753170	293790	Mar 03 01:27 PM
QUAN NANCY	SVP & Chief Technical Officer	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	58.71	74000	4344599	219790	Mar 03 01:27 PM
Quincey James	Chairman and CEO	Sun Feb 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	37.61	34875	1311649	386612	Feb 15 01:13 PM
Quincey James	Chairman and CEO	Sun Feb 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	60.32	34875	2103754	351737	Feb 15 01:13 PM
SMITH BRIAN JOHN	Senior Executive	Mon Jan 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	37.61	126972	4775417	243140	Jan 19 03:01 PM
SMITH BRIAN JOHN	Senior Executive	Mon Jan 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	62.07	126972	7881317	116168	Jan 19 03:01 PM
SMITH BRIAN JOHN	Senior Executive	Fri Dec 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	37.61	94200	3542862	210368	Dec 20 01:00 PM
SMITH BRIAN JOHN	Senior Executive	Fri Dec 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	63.02	94200	5936409	116168	Dec 20 01:00 PM
QUAN NANCY	SVP & Chief Technical Officer	Fri Nov 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	61.12	13746	840198	184710	Nov 22 08:59 AM
RANDAZZA MARK	Principal Accounting Officer	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	37.2	42068	1565140	82214	Nov 15 02:31 PM


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