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
DEFRANCO JAMES	Director	Tue Mar 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	11.46	150000	1719000	3767658	Mar 08 06:42 PM
DEFRANCO JAMES	Director	Mon Mar 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	11.36	100000	1136000	604642	Mar 08 06:42 PM
DEFRANCO JAMES	Director	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	10.88	500000	5440000	504642	Mar 08 06:42 PM
DEFRANCO JAMES	Director	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	10.96	50000	548000	3617658	Mar 08 06:42 PM
DEFRANCO JAMES	Director	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	10.84	1450000	15718000	3567658	Mar 06 05:54 PM
DEFRANCO JAMES	Director	Tue Sep 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	16.73	110000	1840300	131327	Sep 08 08:42 PM
DEFRANCO JAMES	Director	Mon Aug 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	17.82	144328	2571925	1050000	Aug 24 04:36 PM
DEFRANCO JAMES	Director	Fri Aug 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	18.12	191735	3473809	905672	Aug 23 05:03 PM
DEFRANCO JAMES	Director	Thu Aug 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	18.11	163637	2963466	713937	Aug 22 05:36 PM
DEFRANCO JAMES	Director	Wed Aug 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	18.53	160373	2971712	550300	Aug 19 05:12 PM


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