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
Johnson Amal M	Director	Fri Dec 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	218.44	500	109220	500	Dec 05 08:39 PM
Johnson Amal M	Director	Fri Dec 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	218.44	500	109220	2000	Dec 05 08:39 PM
SCHALL MICHAEL J	President and CEO	Tue Mar 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	248.7	12132	3017228	60390	Mar 30 06:48 PM
Kleiman Angela L.	Sr. EVP & COO	Tue Mar 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	248.7	6309	1569048	14419	Mar 30 06:51 PM
SCHALL MICHAEL J	President and CEO	Tue Mar 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	349.19	12132	4236373	48258	Mar 30 06:48 PM
Kleiman Angela L.	Sr. EVP & COO	Tue Mar 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	354.21	6309	2234710	8110	Mar 30 06:51 PM
Johnson Amal M	Director	Tue Mar 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	229.9	7329	1684937	8829	Mar 16 04:19 PM
Johnson Amal M	Director	Tue Mar 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	334.95	7329	2454877	1500	Mar 16 04:19 PM
MARCUS GEORGE M	Director	Tue Dec 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	227.76	41814	9523595	173959	Dec 22 07:42 PM
Berry Adam W	Executive Vice President & CIO	Mon Dec 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	248.7	3235	804544	6098	Dec 14 04:32 PM


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