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
HAYES GREGORY	Director	Wed Feb 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	97.75	10250	1001938	14299	Feb 02 06:00 PM
Pruitt Joseph Scott	Vice President and Controller	Tue Nov 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	78.47	600	47085	15902	Nov 15 07:33 PM
Pruitt Joseph Scott	Vice President and Controller	Tue Nov 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	110.68	600	66406	15302	Nov 15 07:33 PM
Pruitt Joseph Scott	Vice President and Controller	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	74.7	3000	224100	18302	Nov 15 07:33 PM
Pruitt Joseph Scott	Vice President and Controller	Fri Nov 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	111.86	3000	335565	15302	Nov 15 07:33 PM
Garland Greg C.	Chairman and CEO	Thu Jun 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	74.14	146700	10875604	803263	Jun 13 05:13 PM
Garland Greg C.	Chairman and CEO	Thu Jun 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	109.7	146700	16093635	656563	Jun 13 05:13 PM
Roberts Timothy D.	Executive Vice President	Wed Jun 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	82.08	59100	4850821	78901	Jun 09 05:09 PM
Roberts Timothy D.	Executive Vice President	Wed Jun 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	110.21	59100	6513452	48201	Jun 09 05:09 PM
Johnson Paula Ann	Retired Executive VP and GC	Tue Jun 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	73.31	44700	3276986	147189	Jun 08 05:18 PM


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