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
Griggs James M	SVP & Corp Controller	Mon Nov 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	200	300	60000	4820	Nov 15 04:11 PM
Nelson Lisa M	EVP, President International	Thu Nov 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	159.58	100	15958	7406	Nov 07 04:06 PM
GAMBLE JOHN W JR	EVP, CFO & COO	Wed Oct 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	165.52	15000	2482852	46073	Oct 28 04:12 PM
Begor Mark W	CEO	Wed Oct 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	165.51	11000	1820641	92918	Oct 28 04:12 PM
KELLEY JOHN J III	EVP, Chief Legal Officer	Wed Oct 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	165.56	9000	1490023	9042	Oct 28 04:12 PM
Houston Julia A	EVP, Strategy & Mktg Officer	Wed Oct 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	165.52	5000	827624	7932	Oct 28 04:12 PM
Nelson Lisa M	EVP, President International	Wed Oct 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	165.58	684	113257	7590	Oct 28 04:12 PM
Smith Melissa D	Director	Fri Oct 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	148.69	672	99923	3474	Oct 25 04:06 PM
Begor Mark W	CEO	Wed Apr 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	204.74	15000	3071052	43692	Apr 28 04:13 PM
Singh Sid	President - USIS	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	129.88	19222	2496595	40422	Mar 01 04:15 PM


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