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
Daniel Karen L	Director	Tue Mar 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	245.38	2046	502057	8028	Mar 08 06:28 PM
Lemerand June C	VP & Chief Information Officer	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	147.2	2120	312068	4035	Mar 03 04:48 PM
Lemerand June C	VP & Chief Information Officer	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	249.07	2120	528036	1915	Mar 03 04:48 PM
LEHMAN WILLIAM DUDLEY	Director	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	248.24	363	90111	10980	Feb 10 04:58 PM
Pagliari Aldo John	Sr VP - Finance & CFO	Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	109.43	10000	1094300	87541	Feb 13 06:18 PM
Pagliari Aldo John	Sr VP - Finance & CFO	Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	251.9	7030	1770878	80511	Feb 13 06:18 PM
Boyd Iain	VP - Operations Development	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	155.92	2736	426597	8985	Feb 03 05:54 PM
Chambers Timothy L	Sr VP & Pres - Tools	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	109.43	231	25278	14136	Feb 03 05:44 PM
Boyd Iain	VP - Operations Development	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	259.01	2736	708663	6249	Feb 03 05:54 PM
Chambers Timothy L	Sr VP & Pres - Tools	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	259	231	59829	13905	Feb 03 05:44 PM


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