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
DEMCHAK WILLIAM S	President/CEO	Thu Jan 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	153.38	6550	1004639	482924	Jan 24 11:31 AM
Deborah Guild	Executive Vice President	Thu Nov 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	159.66	2833	452307	20527	Nov 21 12:28 PM
Lyons Michael P.	Executive Vice President	Tue Aug 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	166.96	3500	584355	174651	Aug 25 12:37 PM
NIBLOCK ROBERT A	Director	Fri May 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	167.07	2000	334145	6063	May 10 01:55 PM
Deborah Guild	Executive Vice President	Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	170.56	1257	214398	23360	May 05 01:48 PM
Lyons Michael P.	Executive Vice President	Mon Mar 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	182.59	5500	1004228	178151	Mar 16 03:07 PM
HANNON MICHAEL J	Executive Vice President	Wed Feb 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	208.36	3000	625083	44991	Feb 17 04:20 PM
Pfinsgraff Martin	Director	Wed Dec 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	199.31	7	1395	1550	Dec 17 03:55 PM
Lyons Michael P.	Executive Vice President	Tue Dec 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	198.6	5000	993025	158820	Dec 15 02:17 PM
Fallon Kieran John	Executive Vice President	Wed Dec 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	202.02	125	25252	7178	Dec 02 03:02 PM


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