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
Kennedy John Christopher	EVP, President LFD	Thu Dec 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	30.79	1500	46185	20336	Dec 16 08:26 AM
Connelly Deirdre P	Director	Fri Nov 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	37.41	3000	112230	4000	Nov 18 04:17 PM
GLASS DENNIS R	Director	Tue May 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	58.13	50000	2906500	558622	Jun 01 04:21 PM
Kennedy John Christopher	EVP, President LFD	Thu Nov 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	54.33	10922	593376	23646	Nov 12 04:16 PM
Kennedy John Christopher	EVP, President LFD	Thu Nov 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	73.52	10922	802985	12724	Nov 12 04:16 PM
Freitag Randal J	EVP & CFO	Mon Nov 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	29.54	61430	1814642	266912	Nov 09 04:17 PM
Freitag Randal J	EVP & CFO	Mon Nov 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	73.05	61430	4487462	205482	Nov 09 04:17 PM
GLASS DENNIS R	President & CEO	Wed Oct 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	75.08	150000	11262000	640883	Oct 22 04:22 PM
GLASS DENNIS R	President & CEO	Mon Sep 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	72.05	150000	10807500	790883	Sep 28 04:15 PM
Solon Kenneth S.	EVP & Chief Information Ofc.	Fri Aug 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Option Exercise	51.01	14000	714138	69819	Aug 10 04:26 PM


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