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
Hahn Ava	Chief Legal Officer & SVP	Thu Mar 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	488.92	3206	1567478	3433	Mar 03 05:12 PM
Hahn Ava	Chief Legal Officer & SVP	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	479	487	233273	6639	Mar 03 05:12 PM
ARCHER TIMOTHY	President and CEO	Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		17480		101684	Feb 10 11:15 AM
Varadarajan Seshasayee	Senior Vice President	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		3956		26167	Feb 09 06:46 PM
Gottscho Richard A	Executive Vice President & CTO	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		4599		31271	Feb 09 06:44 PM
Hahn Ava	Chief Legal Officer & SVP	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		5059		8959	Feb 09 06:41 PM
Meikle Scott Gerald	Senior Vice President	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		2759		23184	Feb 09 06:38 PM
Bettinger Douglas R	Chief Financial Officer & EVP	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		5059		100608	Feb 09 06:36 PM
Vahedi Vahid	Senior Vice President	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		3956		27380	Feb 09 06:30 PM
LORD PATRICK J	Executive Vice President	Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		4599		15270	Feb 09 06:27 PM


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