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
Stone Randy Lee	President, Mobility & Material	Fri Jan 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	80.07	4565	365520	72005	Jan 18 04:18 PM
Stone Randy Lee	President, Mobility & Material	Fri Jan 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	85	4565	388025	67440	Jan 18 04:18 PM
Weaver Leland	President, Water & Protection	Thu Jan 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	80.07	2183	174793	17279	Jan 14 04:21 PM
Weaver Leland	President, Water & Protection	Thu Jan 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	84	2183	183372	15096	Jan 14 04:21 PM
Goss Michael G.	Controller	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	80.07	1157	92641	6893	Jan 05 01:03 PM
Goss Michael G.	Controller	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	81.5	1145	93318	5748	Jan 05 01:03 PM
Lee Rose	President, Water & Protection	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	59.87	26448	1583388	56607	Aug 26 04:09 PM
Lee Rose	President, Water & Protection	Tue Aug 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	74.37	26448	1967059	43356	Aug 26 04:09 PM
KISSAM LUTHER C IV	Director	Thu Aug 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	75.94	5000	379687	14023	Aug 06 04:18 PM


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