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
LAKE CHARLES D II	Chairman & Rep. Director, ALIJ	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	70.36	22291	1568395	53925	Feb 15 04:34 PM
Koide Masatoshi	Pres. and Rep. Director, ALIJ	Mon Feb 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	70.36	19291	1357315	87598	Feb 15 04:20 PM
MOSKOWITZ JOSEPH L	Director	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	71.98	500	35990	19751	Jan 05 08:58 AM
HOWARD JUNE P	Sr. Vice President	Fri Dec 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	31.2	3204	99981	110163	Dec 27 05:28 PM
RIGGIERI ALBERT	SVP, Chief Actuary	Tue Dec 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	70.6	4688	330973	21552	Dec 15 08:49 AM
TILLMAN AUDREY B	Executive Vice President	Fri Nov 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	24.75	13900	344025	174106	Nov 22 09:18 AM
TILLMAN AUDREY B	Executive Vice President	Fri Nov 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	70.8	22400	1585871	151706	Nov 22 09:18 AM
LAKE CHARLES D II	Chairman & Rep. Director, ALIJ	Thu Nov 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	70.01	14130	989241	36375	Nov 21 05:18 PM
KIRSCH ERIC M	Executive Vice President	Wed Nov 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	70.9	28400	2013424	35721	Nov 18 08:58 AM
Fukuzawa Toshihiko	Director	Wed Nov 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	70.64	1400	98896	10258	Nov 18 09:16 AM


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