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
Klasko Stephen K. M.D.	Director	Thu Jan 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	78.5	3014	236599	4849	Jan 27 06:12 PM
Kelly Liam	Chairman, President & CEO	Tue Jan 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	79.97	9619	769273	21850	Jan 13 07:16 PM
Kelly Liam	Chairman, President & CEO	Fri Dec 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	78.62	16343	1284887	32153	Jan 04 06:54 PM
Kelly Liam	Chairman, President & CEO	Fri Dec 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	250.03	16343	4086243	15810	Jan 04 06:54 PM
RANDLE STUART A	Director	Tue Jun 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	78.5	3014	236599	7334	Jun 09 05:33 PM
RANDLE STUART A	Director	Tue Jun 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	283.31	3014	853896	4320	Jun 09 05:33 PM
Kelly Liam	Chairman, President & CEO	Mon Dec 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	59.91	8987	538383	34762	Dec 29 04:37 PM
Kelly Liam	Chairman, President & CEO	Mon Dec 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	330	8987	2965710	25775	Dec 29 04:37 PM
Krakauer Andrew A	Director	Tue Nov 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	307.23	1000	307232	3534	Dec 02 04:57 PM
Hicks Cameron P	Corp. VP & Chief HR Officer	Wed Nov 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	121	3600	435600	12204	Nov 12 04:36 PM


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