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
Choi Caroline	SENIOR VICE PRESIDENT	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	48.48	15392	746204	31827	Jan 05 02:25 PM
Powell Steven D	PRESIDENT AND CEO, SCE	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	48.48	4077	197653	9592	Jan 05 02:33 PM
CHANG VANESSA C L	Director	Mon May 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	69.3	111	7692	6178	Jun 16 05:35 PM
CHANG VANESSA C L	Director	Thu Mar 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	67.18	155	10413	6011	Jun 16 05:35 PM
CHANG VANESSA C L	Director	Wed Mar 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	66.17	200	13234	5856	Jun 16 05:35 PM
Choi Caroline	SENIOR VICE PRESIDENT	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	43.1	32927	1419154	38841	Jan 05 02:19 PM
Taylor Peter J.	Director	Wed Nov 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	63.56	3100	197041	19076	Nov 19 05:59 PM
Taylor Peter J.	Director	Thu Nov 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	62.44	220	13737	22176	Nov 08 05:15 PM
Taylor Peter J.	Director	Mon Aug 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	54.69	230	12579	22396	Aug 04 12:48 PM


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