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
rahim rami	Chief Executive Officer	Tue Mar 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	31.28	6250	195509	937089	Mar 08 05:47 PM
rahim rami	Chief Executive Officer	Mon Mar 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	31.33	6250	195798	943339	Mar 08 05:47 PM
rahim rami	Chief Executive Officer	Sun Mar 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	31.31	6250	195660	949589	Mar 08 05:47 PM
DelSanto Anne	Director	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	30.75	900	27675	26636	Mar 01 04:56 PM
Mobassaly Robert	SVP General Counsel	Tue Feb 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	31.5	2678	84357	21899	Feb 22 05:20 PM
Leelanivas Manoj	EVP Chief Operating Officer	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		17325		175905	Feb 21 06:43 PM
rahim rami	Chief Executive Officer	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		57981		222052	Feb 21 06:42 PM
Miller Kenneth Bradley	EVP CFO	Mon Feb 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		18645		245076	Feb 21 06:42 PM
Miller Kenneth Bradley	EVP CFO	Sat Feb 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		18843		235774	Feb 21 06:42 PM
rahim rami	Chief Executive Officer	Sat Feb 19 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise		62271		196234	Feb 21 06:42 PM


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