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
Parsey Merdad	Chief Medical Officer	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	79.96	12984	1038225	70130	Mar 02 07:01 PM
Parsey Merdad	Chief Medical Officer	Fri Dec 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	85.33	553	47187	45556	Jan 03 08:05 PM
Dickinson Andrew D	Chief Financial Officer	Sat Dec 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		1027		69695	Dec 13 03:11 PM
Wilfong Diane E.	SVP, Controller & CAO	Wed Nov 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	63.91	6416	410047	34749	Nov 10 04:20 PM
Wilfong Diane E.	SVP, Controller & CAO	Wed Nov 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	83.5	6416	535736	28333	Nov 10 04:20 PM
Wilfong Diane E.	SVP, Controller & CAO	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	72.7	16255	1181738	44588	Nov 02 04:57 PM
Wilfong Diane E.	SVP, Controller & CAO	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	79.25	16255	1288209	28333	Nov 02 04:57 PM
Lofton Kevin E	Director	Thu Apr 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	25.62	16322	418251	90525	Apr 29 06:43 PM
Pletcher Brett A	EVP,Corp Affairs & Gen Counsel	Fri Mar 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	58.24	3634	211644	32576	Mar 14 09:46 PM
Wilfong Diane E.	SVP, Controller & CAO	Thu Mar 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		3297		27516	Mar 14 09:30 PM


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