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
Braun Jeffrey N	SVP, GC and Secretary	Tue Nov 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	113.57	1354	153771	11634	Nov 23 04:16 PM
Stone John H	President and CEO	Fri Oct 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	104.45	12500	1305612	64535	Oct 31 04:15 PM
Martens Robert C.	SVP Chief Innovation & Design	Mon Jun 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	112.07	2150	240961	5433	Jun 08 04:17 PM
Eckersley Timothy P	Sr. VP-Allegion International	Fri Jun 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	111.32	2046	227751	34284	Jun 06 04:21 PM
Kemp Tracy L	SVP-Chief Info. & Digital Ofr.	Mon May 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	112.55	2544	286327	10379	May 11 04:24 PM
Braun Jeffrey N	SVP and GC	Thu May 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	114.02	2186	249248	12988	May 09 04:20 PM
Eckersley Timothy P	Sr. VP-Allegion International	Thu Nov 18 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	71.83	2500	179587	36573	Nov 22 04:15 PM
Eckersley Timothy P	Sr. VP-Allegion International	Thu Nov 18 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	136.95	2500	342375	34073	Nov 22 04:15 PM
PETRATIS DAVID D	Chairman, President & CEO	Fri Nov 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	135	2841	383535	51141	Nov 16 04:16 PM
Ranck Douglas P	VP, Controller & CAO	Tue Nov 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	131.62	2000	263236	2535	Nov 04 04:16 PM


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