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
Rocker Tchernavia	Chief Administrative Officer	Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	9.32	69823	650689	260291	Feb 14 04:03 PM
Gibbs David W	Director	Tue May 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	9.6	25000	240085	50000	Jun 01 04:32 PM
Gibbs David W	Director	Fri May 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Buy	9.39	25000	234732	25000	Jun 01 04:32 PM
Maheshwari Aditya	Chief Accounting Officer	Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	15.64	2899	45340	58506	Mar 01 05:07 PM
Bergman David	Chief Financial Officer	Fri Nov 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	21.29	3500	74524	313578	Nov 15 04:14 PM
Browne Colin	Chief Operating Officer	Tue Nov 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	21.04	47550	1000276	369224	Nov 10 05:49 PM
Plank Kevin A	Exec. Chairman and Brand Chief	Tue Nov 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	21.07	123338	2599200	3252750	Nov 10 04:21 PM
Plank Kevin A	Exec. Chairman and Brand Chief	Mon Nov 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	21.17	263340	5575145	3277146	Nov 10 04:21 PM
Plank Kevin A	Exec. Chairman and Brand Chief	Fri Nov 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	21.49	526423	11313761	3329235	Nov 08 06:42 PM
Plank Kevin A	Exec. Chairman and Brand Chief	Thu Nov 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	22.31	336899	7516153	3433361	Nov 08 06:42 PM


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