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
Queenan Daniel G	CEO, Real Estate Investments	Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	80.08	5000	400400	178841	Dec 02 06:02 PM
Queenan Daniel G	CEO, Real Estate Investments	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	78.26	5000	391300	183841	Sep 02 04:46 PM
Giamartino Emma E.	See Remarks	Tue Aug 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	79.77	517	41241	21737	Sep 01 05:03 PM
Queenan Daniel G	CEO, Real Estate Investments	Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	83.16	5000	415800	188841	Jun 03 05:21 PM
KIRK J. CHRISTOPHER	Global Chief Operating Officer	Tue May 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	78.35	15160	1187760	150888	May 12 04:36 PM
SULENTIC ROBERT E	President and CEO	Fri Mar 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	90.09	30000	2702750	1006250	Mar 07 07:02 PM
Giamartino Emma E.	See Remarks	Wed Mar 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	97	146	14162	23309	Mar 02 08:28 PM
Queenan Daniel G	Global CEO, Advisory Services	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	96.86	5000	484300	197930	Mar 02 08:26 PM
LAFITTE MICHAEL J	See Remarks	Fri Feb 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	98	7406	725788	250963	Mar 01 07:23 PM
Midler Laurence H	EVP, GC & Chief Risk Officer	Wed Feb 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sale	99.73	2558	255102	123435	Feb 23 07:11 PM


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