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
MCGARRY MICHAEL H	Executive Chairman	Mon Jan 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	95	61867	5877365	245512	Feb 01 11:42 AM
MCGARRY MICHAEL H	Executive Chairman	Mon Jan 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	129.96	61867	8040427	183645	Feb 01 11:42 AM
Foulkes Anne M.	Sr. VP and General Counsel	Mon Jan 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	107.46	21757	2338073	32334	Jan 25 01:53 PM
Foulkes Anne M.	Sr. VP and General Counsel	Mon Jan 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	128.33	21757	2791985	10577	Jan 25 01:53 PM
Liebert Rebecca B.	Executive Vice President	Wed Apr 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	107.39	30086	3230928	54779	Apr 28 11:45 AM
Liebert Rebecca B.	Executive Vice President	Wed Apr 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	129.9	30086	3908273	24693	Apr 28 11:45 AM
Healey Melanie	Director	Wed Apr 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		947		5112	Apr 22 01:43 PM
Smith Cathy R	Director	Wed Apr 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		947		3886	Apr 22 01:42 PM
RICHENHAGEN MARTIN	Director	Wed Apr 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		947		28076	Apr 22 01:40 PM


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