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
Gallagher Marie T.	SVP and Controller	Wed Oct 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	180.01	5558	1000486	41195	Oct 28 04:35 PM
Santilli Paula	CEO, Latin America	Wed Oct 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	179.63	2787	500629	59997	Oct 28 04:38 PM
Johnston Hugh F	Vice Chairman, EVP & CFO	Mon Oct 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	175.74	23394	4111295	128332	Oct 26 05:34 PM
Laguarta Ramon	Chairman and CEO	Fri Oct 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	173.09	5900	1021236	310757	Oct 25 04:34 PM
Krishnan Ramkumar	CEO Intl Beverages & CCO	Thu Jul 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	174.83	3433	600193	50577	Aug 01 04:28 PM
Williams Steven C	CEO, PFNA	Fri Jul 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	171.18	1753	300076	70892	Jul 19 04:35 PM
Tanner Kirk	CEO, PBNA	Tue May 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	174.15	13679	2382260	90291	May 19 04:30 PM
Willemsen Eugene	CEO, AMESA	Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	175.61	4560	800779	8277	May 18 05:03 PM
Flavell David	EVP, Gen Counsel & Corp Sec	Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	175.11	5150	901826	28275	May 18 04:52 PM
Krishnan Ramkumar	CEO Intl Beverages & CCO	Tue May 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	89.25	6723	600028	59886	May 12 04:23 PM


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