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
Sorgi Vincent	President and CEO	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	85201	2454641	191454	Feb 22 04:43 PM
Bergstein Joseph P Jr	EVP and CFO	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	25167	725061	61600	Feb 22 04:37 PM
Henninger Tadd J	SVP-Finance and Treasurer	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	5429	156409	19798	Feb 22 04:41 PM
Crockett John R III	President of a PPL Subsidiary	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	4947	142523	16307	Feb 22 04:39 PM
Beers Marlene C	Vice President and Controller	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	4720	135983	23626	Feb 22 04:36 PM
Raymond Stephanie R	President of a PPL Subsidiary	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	4608	132756	28446	Feb 22 04:42 PM
Bonenberger David J	President of a PPL Subsidiary	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	4489	129328	39095	Feb 22 04:38 PM
Gosman Angela K	EVP and CHRO	Thu Feb 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.81	2632	75828	3947	Feb 22 04:39 PM
Gosman Angela K	EVP and CHRO	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	28.54	403	11502	1453	Feb 15 04:22 PM
Bonenberger David J	President of a PPL Subsidiary	Mon Jan 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	26.13	719	18787	34606	Jan 25 04:16 PM


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