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
KONDO CHRIS	Principal Accounting Officer	Tue Nov 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	148.72	20200	3004144	31505	Nov 23 06:30 PM
Maestri Luca	Senior Vice President, CFO	Fri Oct 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	155.95	176299	27493275	110673	Nov 01 06:30 PM
O'BRIEN DEIRDRE	Senior Vice President	Mon Oct 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	142.45	8053	1147150	136290	Oct 18 06:33 PM
Adams Katherine L.	SVP, GC and Secretary	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	141.41	181139	25615117	427334	Oct 04 10:02 PM
O'BRIEN DEIRDRE	Senior Vice President	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	142.16	176299	25062882	136290	Oct 04 10:05 PM
Maestri Luca	Senior Vice President, CFO	Wed Aug 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	174.95	96735	16924259	110673	Aug 19 06:30 PM
Adams Katherine L.	SVP, GC and Secretary	Wed Aug 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	164.77	25000	4119155	427334	Aug 05 06:30 PM
Adams Katherine L.	SVP, GC and Secretary	Wed May 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	161.72	25000	4042888	452334	May 06 06:30 PM
O'BRIEN DEIRDRE	Senior Vice President	Mon Apr 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	164.91	8000	1319305	136290	Apr 19 06:31 PM
WILLIAMS JEFFREY E	COO	Mon Apr 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	177.75	105901	18824389	489662	Apr 05 06:33 PM


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