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
Pigg Randy L.	Vice President and Controller	Wed Feb 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	66	540	35640	2343	Feb 17 01:42 PM
Hill J Thomas	Chairman, President & CEO	Sun Jan 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	55.41	7000	387870	62912	Jan 25 10:08 AM
Clement David P	Senior Vice President	Mon Dec 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	180	2000	360000	1970	Dec 07 10:42 AM
Clement David P	Senior Vice President	Tue Jun 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	165.23	3377	557985	3970	Jun 08 11:18 AM
Clement David P	Senior Vice President	Fri Jun 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	92.02	2800	257656	9377	Jun 08 11:18 AM
Perkins Jerry F Jr	Senior Vice President	Tue Nov 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	199.04	493	98127	6115	Nov 23 05:54 PM
Clement David P	Senior Vice President	Tue Nov 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	197.71	4000	790840	5266	Nov 23 05:53 PM
Perkins Jerry F Jr	Senior Vice President	Mon Nov 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	198.37	2968	588757	4923	Nov 23 05:54 PM
Clement David P	Senior Vice President	Mon Nov 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	198.16	2743	543560	1698	Nov 23 05:53 PM
Perkins Jerry F Jr	Senior Vice President	Fri Nov 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	55.41	1230	68154	7871	Nov 23 05:54 PM


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