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
MEYROWITZ CAROL	Executive Chairman	Tue Nov 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	79.79	16223	1294470	209390	Nov 22 05:00 PM
Greenlees Louise	SEVP - Group President	Tue Nov 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	79.99	6708	536577	51627	Nov 22 08:43 PM
LANE AMY B	Director	Mon Nov 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	78.86	3200	252351	26531	Nov 22 05:00 PM
Canestrari Kenneth	SEVP - Group President	Fri Nov 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	78.51	4100	321893	126822	Nov 21 05:00 PM
MEYROWITZ CAROL	Executive Chairman	Thu Nov 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	78.02	39354	3070486	225613	Nov 18 05:00 PM
Herrman Ernie	CEO & President	Thu Sep 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	65.9	50282	3313800	696439	Sep 09 05:00 PM
MEYROWITZ CAROL	Executive Chairman	Thu Aug 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	67.62	70720	4782065	264967	Aug 22 05:00 PM
Canestrari Kenneth	SEVP - Group President	Thu Aug 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	68	29977	2038436	130922	Aug 22 05:00 PM
Goldenberg Scott	SEVP, CFO	Thu Aug 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	68	16551	1125468	102576	Aug 22 05:00 PM
Greenlees Louise	SEVP - Group President	Thu Aug 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	68	8822	599896	58335	Aug 22 05:00 PM


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