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
O'Grady Michael	Chairman and CEO	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	52.69	28469	1500032	59744	Feb 09 09:06 PM
Tyler Jason J.	EVP & Chief Financial Officer	Sun Feb 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	52.69	2491	131251	32234	Feb 07 06:05 PM
Tyler Jason J.	EVP & Chief Financial Officer	Sun Feb 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	96.98	1764	171073	30470	Feb 07 06:05 PM
Allnutt Lauren E	EVP & Controller	Thu Mar 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	105.61	393	41505	4534	Mar 14 05:28 PM
Tyler Jason J.	EVP & Chief Financial Officer	Mon Jan 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	43.65	3437	150025	25222	Feb 02 05:19 PM
Tyler Jason J.	EVP & Chief Financial Officer	Mon Jan 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	115.6	1936	223802	23286	Feb 02 05:19 PM
O'Grady Michael	Chairman, President and CEO	Thu Dec 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	43.65	48110	2100002	103802	Dec 10 06:14 PM
South Thomas A	Executive Vice President	Thu Dec 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	118.22	2000	236440	20621	Dec 10 06:14 PM
O'Grady Michael	Chairman, President and CEO	Thu Dec 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	119.03	48110	5726533	55692	Dec 10 06:14 PM
St Clair Joyce	Executive Vice President	Wed Nov 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	125	9395	1174375	31652	Nov 05 05:48 PM


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