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
Carter-Miller Jocelyn	Director	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	35.5	6425	228088	31789	Mar 02 04:10 PM
KRAKOWSKY PHILIPPE	CEO	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	35.61	71020	2529022	584012	Mar 02 04:25 PM
Bonzani Andrew	EVP & General Counsel	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	35.61	38885	1384695	111769	Mar 02 04:40 PM
Johnson Ellen Tobi	CFO	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	35.56	30437	1082340	133533	Mar 02 05:10 PM
CARROLL CHRISTOPHER F	SVP, Controller & CAO	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	35.54	16507	586659	55406	Mar 02 04:57 PM
Carter-Miller Jocelyn	Director	Fri Aug 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	30	6500	195000	38214	Aug 19 04:09 PM
HUDSON DAWN E	Director	Mon May 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	32.45	18376	596301	32880	May 09 05:06 PM
GUILFOILE MARY	Director	Fri May 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	32.41	6301	204215	102803	May 06 05:17 PM
Carter-Miller Jocelyn	Director	Fri Apr 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	33.26	6764	224971	44714	May 03 05:13 PM
Johnson Ellen Tobi	CFO	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	36.32	2778	100897	124625	Mar 02 07:26 PM


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