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
Beckles Kathy Card	EVP, Gen Counsel and Corp Sec	Tue Jan 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	181.95	107	19469	7462	Jan 20 05:50 PM
WRIGHT DAVID B	Director	Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	182.88	4000	731520	9710	Dec 01 04:56 PM
Vaughan Therese M	Director	Fri Sep 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	60.71	2889	175391	13953	Sep 09 04:14 PM
Vaughan Therese M	Director	Fri Sep 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	192.3	932	179224	13021	Sep 09 04:14 PM
Beckles Kathy Card	EVP, Gen Counsel and Corp Sec	Mon Aug 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	200.09	429	85839	6102	Aug 23 04:07 PM
WRIGHT DAVID B	Director	Mon Aug 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	47.61	2071	98600	16980	Aug 15 06:33 PM
WRIGHT DAVID B	Director	Mon Aug 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	204.78	2071	424099	14909	Aug 15 06:33 PM
LISS SAMUEL G	Director	Thu Aug 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	47.61	2486	118358	67939	Aug 11 04:53 PM
LISS SAMUEL G	Director	Thu Aug 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	202.24	587	118715	67352	Aug 11 04:53 PM
Vaughan Therese M	Director	Tue Aug 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	60.71	2023	122816	11693	Aug 10 04:05 PM


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