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
Nash William D	President & CEO	Fri Dec 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	60.98	8220	501256	165128	Jan 03 04:41 PM
Cafritz Diane L	EVP, General Counsel & CHRO	Thu Jul 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	58.38	15555	908101	20543	Jul 22 04:16 PM
Cafritz Diane L	EVP, General Counsel & CHRO	Thu Jul 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	94.75	15555	1473836	4988	Jul 22 04:16 PM
Shamim Mohammad	EVP and CITO	Mon Jul 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	93.91	3456	324553	8769	Jul 19 04:20 PM
Cafritz Diane L	EVP, General Counsel & CHRO	Thu Jul 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	58.38	15000	875700	23080	Jul 05 04:17 PM
Cafritz Diane L	EVP, General Counsel & CHRO	Thu Jul 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	91.06	18092	1647430	4988	Jul 05 04:17 PM
Wilson Charles Joseph	SVP	Thu Dec 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	63.17	16059	1014506	27827	Jan 03 04:46 PM
Wilson Charles Joseph	SVP	Thu Dec 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	127.48	16059	2047201	11768	Jan 03 04:46 PM
Lyski James	EVP & Chief Marketing Officer	Tue Aug 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	51.63	63129	3259350	79084	Aug 05 04:28 PM
Lyski James	EVP & Chief Marketing Officer	Tue Aug 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	139.54	63129	8809021	15955	Aug 05 04:28 PM


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