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
Roupie Christophe Pierre Danie	Head of EMEA and APAC	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	366.58	604	221414	5882	Mar 07 04:15 PM
Begleiter Steven L	Director	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	348.73	1000	348730	8538	Feb 08 04:29 PM
McVey Richard M	Chairman & CEO	Thu Dec 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	156.85	24515	3845178	729746	Dec 12 04:15 PM
Roupie Christophe Pierre Danie	Head of EMEA and APAC	Tue Jun 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	285.03	1740	495952	5318	Jun 09 04:15 PM
Prager Richard Leon	Director	Fri Apr 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	271.25	1000	271245	2149	Apr 25 04:38 PM
Themelis Nicholas	Chief Information Officer	Mon Mar 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	364.89	2000	729777	8544	Mar 09 04:15 PM
Themelis Nicholas	Chief Information Officer	Tue Dec 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	370.08	2000	740165	9587	Dec 09 04:30 PM
McPherson Kevin M	Global Head of Sales	Tue Nov 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	103.3	936	96689	72024	Nov 18 04:14 PM
McPherson Kevin M	Global Head of Sales	Tue Nov 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	391.72	936	366650	71088	Nov 18 04:14 PM
Themelis Nicholas	Chief Information Officer	Tue Sep 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	461.54	2000	923075	11587	Sep 09 04:15 PM


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