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
PENDARVIS DAVID	Chief Administrative Officer	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	216.69	1500	325035	94172	Mar 07 12:32 PM
Ghoshal Kaushik	President, SaaS Business	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	220	1000	220000	15704	Mar 07 12:28 PM
Sandercock Brett	Chief Financial Officer	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	215.22	10000	2152196	106880	Feb 22 04:21 PM
Farrell Michael J.	Chief Executive Officer	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	57.76	5675	327788	442575	Feb 16 03:23 PM
Farrell Michael J.	Chief Executive Officer	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	214.83	5675	1219144	436900	Feb 16 03:23 PM
Douglas Robert Andrew	President and COO	Tue Feb 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	213.5	1500	320250	261445	Feb 16 07:12 PM
Sandercock Brett	Chief Financial Officer	Sun Feb 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	215	4000	860000	116880	Feb 14 01:53 PM
PENDARVIS DAVID	Chief Administrative Officer	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	224.5	1500	336750	95672	Feb 06 01:55 PM
Drexler Karen	Director	Wed Feb 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	226.58	594	134589	7987	Feb 03 07:30 PM
Farrell Michael J.	Chief Executive Officer	Mon Jan 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	57.76	5675	327788	442575	Jan 18 04:28 PM


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