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
Hudson Scott R	Vice President	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	43.71	18700	817377	60931	Mar 08 08:32 PM
Jain Vishal	VICE PRESIDENT	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	43.71	11300	493923	35964	Mar 08 08:28 PM
Hudson Scott R	Vice President	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	190.66	18700	3565342	42231	Mar 08 08:32 PM
GALLAGHER THOMAS JOSEPH	VICE PRESIDENT	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	43.71	25400	1110234	314756	Mar 07 06:23 PM
Cavaness Joel D	Vice President	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		4961		126048	Mar 07 06:31 PM
McCurdy Kay W	Director	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	196.59	182	35779	31091	Feb 10 06:06 PM
GALLAGHER J PATRICK JR	President & CEO	Sun Feb 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	43.71	62900	2749359	82809	Feb 09 01:51 PM
McCurdy Kay W	Director	Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	199	750	149250	31273	Dec 05 07:00 PM
HOWELL DOUGLAS K	VP & Chief Financial Officer	Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	52.1	4700	244887	92823	Dec 02 05:05 PM
HOWELL DOUGLAS K	VP & Chief Financial Officer	Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	196.32	4700	922704	88123	Dec 02 05:05 PM


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