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
SUSMAN SALLY	Executive Vice President	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	22.89	72984	1670604	209179	Feb 28 05:52 PM
JOHNSON RADY A	Executive Vice President	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	22.89	33654	770340	116473	Feb 28 05:52 PM
Hwang Angela	President, Global Biopharma	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	22.89	20273	464049	44541	Feb 28 05:52 PM
McDermott Michael	Executive Vice President	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	22.89	14178	324534	93099	Feb 28 05:52 PM
DAMICO JENNIFER B.	SVP & Controller	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	22.89	11150	255224	27893	Feb 28 05:52 PM
SUSMAN SALLY	Executive Vice President	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	30.17	76043	2294217	195493	Feb 24 09:17 PM
Hwang Angela	President, Global Biopharmaceu	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	30.17	57032	1720655	67027	Feb 24 09:34 PM
JOHNSON RADY A	Executive Vice President	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	30.17	31558	952105	106556	Feb 24 08:27 PM
SAHNI PAYAL	Executive Vice President	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	30.17	15209	458856	32671	Feb 24 09:03 PM
McDermott Michael	Executive Vice President	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	30.17	13307	401472	88957	Feb 24 08:52 PM


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