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
Bancel Stephane	Chief Executive Officer	Thu Jul 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	0.99	40000	39600	5451946	Jul 29 04:46 PM
Bancel Stephane	Chief Executive Officer	Thu Jul 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	157	10000	1570000	6784880	Jul 29 04:46 PM
Bancel Stephane	Chief Executive Officer	Thu Jul 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	156.73	40000	6269397	5411946	Jul 29 04:46 PM
Bancel Stephane	Chief Executive Officer	Wed Jul 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	0.99	40000	39600	5451946	Jul 29 04:46 PM
Andres Juan	See remarks	Wed Jul 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	20.93	2000	41860	12367	Jul 29 04:47 PM
AFEYAN NOUBAR	Director	Wed Jul 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	161	10000	1610000	2477209	Jul 29 07:30 PM
Andres Juan	See remarks	Wed Jul 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	161	2000	322000	10367	Jul 29 04:47 PM
Bancel Stephane	Chief Executive Officer	Wed Jul 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	156.32	40000	6252642	5411946	Jul 29 04:46 PM
Hoge Stephen	President	Mon Jul 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	10.9	10000	109000	1634231	Jul 26 05:32 PM
Hoge Stephen	President	Mon Jul 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	162.75	10000	1627500	1624231	Jul 26 05:32 PM


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