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
SANTI ERNEST SCOTT	Chairman & CEO	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	92.85	235656	21880835	449194	Feb 07 04:55 PM
O'HERLIHY CHRISTOPHER A	Vice Chairman	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	94.29	60137	5670054	100209	Feb 07 04:53 PM
SANTI ERNEST SCOTT	Chairman & CEO	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	246.29	235656	58040211	213538	Feb 07 04:55 PM
O'HERLIHY CHRISTOPHER A	Vice Chairman	Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	246.26	60137	14809603	40072	Feb 07 04:53 PM
SMITH DAVID BYRON JR	Director	Fri Dec 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	221.81	1390	308316	118994	Dec 12 04:59 PM
Larsen Michael M	SVP & CFO	Mon Nov 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	128	51248	6559744	87850	Nov 16 04:07 PM
Larsen Michael M	SVP & CFO	Mon Nov 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	228.01	51248	11685056	36602	Nov 16 04:07 PM
Schlitz Lei Zhang	Executive Vice President	Wed May 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	205.34	1000	205340	7803	May 13 04:54 PM
SANTI ERNEST SCOTT	Chairman & CEO	Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	98.26	148789	14620007	351821	Feb 08 05:30 PM
SANTI ERNEST SCOTT	Chairman & CEO	Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	231.44	148789	34435379	203032	Feb 08 05:30 PM


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