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
Hoyt Aimee L	SVP, Chief People Officer	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	199.06	3917	779737	2881	Mar 03 11:22 AM
Aravanis Alexander	SVP, Chief Technology Officer	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	201.74	5398	1088982	2922	Feb 23 06:08 PM
Reeves Kathryne Gambrell	SVP, Chief Marketing Officer	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		2789		6973	Feb 23 05:51 PM
Pegels Kevin Carl	Chief of Global Operations	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		1097		7539	Feb 23 05:46 PM
Hoyt Aimee L	SVP, Chief People Officer	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		5282		8163	Feb 23 05:42 PM
Febbo Phillip G.	SVP Chief Medical Officer	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		3522		8475	Feb 23 05:34 PM
GOSWAMI JOYDEEP	SVP Chief Financial Officer	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		4696		12292	Feb 23 05:38 PM
Dadswell Charles	SVP & General Counsel	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		5282		11948	Feb 23 05:29 PM
Aravanis Alexander	SVP, Chief Technology Officer	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		9292		12214	Feb 23 06:08 PM
deSouza Francis A	President and CEO	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		23473		100419	Feb 23 05:59 PM


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