reportDate

ratio

endQuaterAffected

dayFrom

dayTo

Cusip

entryId	groupId	EQUITY	CHANGE	CUSIP	DESCRIPTION	ISSUE STATUS CODE	ISSUE TYPE CODE	ADD DATE	EXPIRATION DATE	PAYMENT FREQUENCY CODE	MARGIN FLAG	OPTION FLAG	CONVERTED CUSIP	NASDAQ MARKET CODE	INDEX ISSUER	CHANGE DATE	MERGENT CHANGE DATE	MATURE DATE	undefined1	undefined2	undefined3	undefined4	temp1	temp2	fileName	fileDate	processDate
5580917	5580917	DIVIDEND	ADD	16950T102		B	0	1	5	1.172246		39	2024-07-03	2024-07-03	?	2024-06-21		0	2024-06-21	?	0	0006935227			20240621.ifs	2024-06-21	2024-06-22
5352380	5352380	DIVIDEND	DELETE	16950T102		B	0	1	5	1.049458		39	2023-07-03	2023-07-05	2023-08-23	2023-06-07		1	2023-06-07	2023-06-20	0	0006737227			20230808.ifs	2023-08-08	2023-08-09
5352381	5352381	DIVIDEND	ADD	16950T102		B	0	1	0	1.036637		02	2023-07-03	2023-07-05	2023-08-23	2023-06-07		2	2023-06-07	2023-08-08	0	0006737227			20230808.ifs	2023-08-08	2023-08-09
5314766	5314766	DIVIDEND	DELETE	16950T102		B	0	1	5	1.049458		39	2023-07-03	2023-07-05	2023-09-14	2023-06-07		0	2023-06-07	?	0	0006737227			20230620.ifs	2023-06-20	2023-06-21
5314767	5314767	DIVIDEND	ADD	16950T102		B	0	1	5	1.049458		39	2023-07-03	2023-07-05	2023-08-23	2023-06-07		1	2023-06-07	2023-06-20	0	0006737227			20230620.ifs	2023-06-20	2023-06-21
5308394	5308394	DIVIDEND	ADD	16950T102		B	0	1	5	1.049458		39	2023-07-03	2023-07-05	2023-09-14	2023-06-07		0	2023-06-07	?	0	0006737227			20230607.ifs	2023-06-07	2023-06-08
5077035	5077035	DIVIDEND	DELETE	16950T102		B	0	1	5	.977668		39	2022-07-06	2022-07-07	2022-08-25	2022-05-31		1	2022-05-31	2022-06-24	0	0006529374			20220810.ifs	2022-08-10	2022-08-11
5077036	5077036	DIVIDEND	ADD	16950T102		B	0	1	0	.972453		02	2022-07-06	2022-07-07	2022-08-25	2022-05-31		2	2022-05-31	2022-08-10	0	0006529374			20220810.ifs	2022-08-10	2022-08-11
5041408	5041408	DIVIDEND	DELETE	16950T102		B	0	1	5	.977668		39	2022-07-06	2022-07-07	2022-09-14	2022-05-31		0	2022-05-31	?	0	0006529374			20220624.ifs	2022-06-24	2022-06-25
5041409	5041409	DIVIDEND	ADD	16950T102		B	0	1	5	.977668		39	2022-07-06	2022-07-07	2022-08-25	2022-05-31		1	2022-05-31	2022-06-24	0	0006529374			20220624.ifs	2022-06-24	2022-06-25
5020942	5020942	DIVIDEND	ADD	16950T102		B	0	1	5	.977668		39	2022-07-06	2022-07-07	2022-09-14	2022-05-31		0	2022-05-31	?	0	0006529374			20220531.ifs	2022-05-31	2022-06-01
4778741	4778741	DIVIDEND	DELETE	16950T102		B	0	1	5	.832283		39	2021-07-01	2021-07-02	2021-08-23	2021-05-26		1	2021-05-26	2021-06-21	0	0006310847			20210806.ifs	2021-08-06	2021-08-07
4778742	4778742	DIVIDEND	ADD	16950T102		B	0	1	0	.820244		02	2021-07-01	2021-07-02	2021-08-23	2021-05-26		2	2021-05-26	2021-08-06	0	0006310847			20210806.ifs	2021-08-06	2021-08-07
4734286	4734286	DIVIDEND	DELETE	16950T102		B	0	1	5	.832283		39	2021-07-01	2021-07-02	2021-09-14	2021-05-26		0	2021-05-26	?	0	0006310847			20210621.ifs	2021-06-21	2021-06-22
4734287	4734287	DIVIDEND	ADD	16950T102		B	0	1	5	.832283		39	2021-07-01	2021-07-02	2021-08-23	2021-05-26		1	2021-05-26	2021-06-21	0	0006310847			20210621.ifs	2021-06-21	2021-06-22
4712157	4712157	DIVIDEND	ADD	16950T102		B	0	1	5	.832283		39	2021-07-01	2021-07-02	2021-09-14	2021-05-26		0	2021-05-26	?	0	0006310847			20210526.ifs	2021-05-26	2021-05-27
4439796	4439796	DIVIDEND	DELETE	16950T102		B	0	1	5	.706747		39	2020-07-01	2020-07-02	2020-08-27	2020-05-22		1	2020-05-22	2020-06-16	0	0006101157			20200813.ifs	2020-08-13	2020-08-14
4439797	4439797	DIVIDEND	ADD	16950T102		B	0	1	0	.712173		02	2020-07-01	2020-07-02	2020-08-27	2020-05-22		2	2020-05-22	2020-08-13	0	0006101157			20200813.ifs	2020-08-13	2020-08-14
4392889	4392889	DIVIDEND	DELETE	16950T102		B	0	1	5	.706747		39	2020-07-01	2020-07-02	?	2020-05-22		0	2020-05-22	?	0	0006101157			20200616.ifs	2020-06-16	2020-06-17
4392890	4392890	DIVIDEND	ADD	16950T102		B	0	1	5	.706747		39	2020-07-01	2020-07-02	2020-08-27	2020-05-22		1	2020-05-22	2020-06-16	0	0006101157			20200616.ifs	2020-06-16	2020-06-17
4347220	4347220	DIVIDEND	ADD	16950T102		B	0	1	5	.706747		39	2020-07-01	2020-07-02	?	2020-05-22		0	2020-05-22	?	0	0006101157			20200522.ifs	2020-05-22	2020-05-23
4347223	4347223	DIVIDEND	ADD	16950T102		B	0	1	5	.706747		39	2020-07-01	2020-07-02	?	2020-05-22		0	2020-05-22	?	0	0006101157			20200522.ifs	2020-05-22	2020-05-23
3880635	3880635	DIVIDEND	DELETE	16950T102		B	0	1	5	.562528		39	2019-07-02	2019-07-03	?	2019-05-22		0	2019-05-22	?	0	0005885703			20190815.ifs	2019-08-15	2019-08-16
3880637	3880637	DIVIDEND	ADD	16950T102		B	0	1	0	.563613		02	2019-07-02	2019-07-03	2019-08-28	2019-05-22		1	2019-05-22	2019-08-15	0	0005885703			20190815.ifs	2019-08-15	2019-08-16
3880659	3880659	DIVIDEND	DELETE	16950T102		B	0	1	5	.562528		39	2019-07-02	2019-07-03	?	2019-05-22		0	2019-05-22	?	0	0005885703			20190815.ifs	2019-08-15	2019-08-16
3880661	3880661	DIVIDEND	ADD	16950T102		B	0	1	0	.563613		02	2019-07-02	2019-07-03	2019-08-28	2019-05-22		1	2019-05-22	2019-08-15	0	0005885703			20190815.ifs	2019-08-15	2019-08-16
3735710	3735710	DIVIDEND	ADD	16950T102		B	0	1	5	.562528		39	2019-07-02	2019-07-03	?	2019-05-22		0	2019-05-22	?	0	0005885703			20190522.ifs	2019-05-22	2019-05-23
3735711	3735711	DIVIDEND	ADD	16950T102		B	0	1	5	.562528		39	2019-07-02	2019-07-03	?	2019-05-22		0	2019-05-22	?	0	0005885703			20190522.ifs	2019-05-22	2019-05-23
3240467	3240467	DIVIDEND	DELETE	16950T102		B	0	1	5	.546788		39	2018-07-02	2018-07-03	?	2018-05-16		0	2018-05-16	?	0	0005661825			20180815.ifs	2018-08-15	2018-08-16
3240469	3240469	DIVIDEND	ADD	16950T102		B	0	1	0	.530995		02	2018-07-02	2018-07-03	2018-08-28	2018-05-16		1	2018-05-16	2018-08-15	0	0005661825			20180815.ifs	2018-08-15	2018-08-16
3240494	3240494	DIVIDEND	DELETE	16950T102		B	0	1	5	.546788		39	2018-07-02	2018-07-03	?	2018-05-16		0	2018-05-16	?	0	0005661825			20180815.ifs	2018-08-15	2018-08-16
3240496	3240496	DIVIDEND	ADD	16950T102		B	0	1	0	.530995		02	2018-07-02	2018-07-03	2018-08-28	2018-05-16		1	2018-05-16	2018-08-15	0	0005661825			20180815.ifs	2018-08-15	2018-08-16
3092773	3092773	DIVIDEND	ADD	16950T102		B	0	1	5	.546788		39	2018-07-02	2018-07-03	?	2018-05-16		0	2018-05-16	?	0	0005661825			20180516.ifs	2018-05-16	2018-05-17
3092790	3092790	DIVIDEND	ADD	16950T102		B	0	1	5	.546788		39	2018-07-02	2018-07-03	?	2018-05-16		0	2018-05-16	?	0	0005661825			20180516.ifs	2018-05-16	2018-05-17
2624687	2624687	DIVIDEND	DELETE	16950T102		B	0	1	5	.432475		39	2017-06-02	2017-06-06	2017-07-31	2017-04-11		0	2017-04-11	?	0	0005420511			20170717.ifs	2017-07-17	2017-07-18
2624688	2624688	DIVIDEND	ADD	16950T102		B	0	1	0	.433564		02	2017-06-02	2017-06-06	2017-07-31	2017-04-11		1	2017-04-11	2017-07-17	0	0005420511			20170717.ifs	2017-07-17	2017-07-18
2541017	2541017	DIVIDEND	ADD	16950T102		B	0	1	5	.432475		39	2017-06-02	2017-06-06	2017-07-31	2017-04-11		0	2017-04-11	?	0	0005420511			20170411.ifs	2017-04-11	2017-04-12
2457749	2457749	EQUITY	CHANGE	16950T102	ADR	0	0	2010-07-09	?	0	no	no		no		2010-07-09	2011-04-19	?							20170126.ifs	2017-01-26	2017-01-27
2457750	2457749	EQUITY	CHANGE	16950T102	ADR	0	0	2010-07-09	?	1	no	no		no		2010-07-09	2011-04-19	?							20170126.ifs	2017-01-26	2017-01-27
2271182	2271182	DIVIDEND	DELETE	16950T102		B	0	1	5	.426051		39	2016-06-30	2016-07-05	?	2016-05-16		1	2016-05-16	2016-05-17	0	0005219337			20160815.ifs	2016-08-15	2016-08-16
2271183	2271183	DIVIDEND	ADD	16950T102		B	0	1	0	.42021		02	2016-06-30	2016-07-05	2016-08-26	2016-05-16		2	2016-05-16	2016-08-15	0	0005219337			20160815.ifs	2016-08-15	2016-08-16
2198192	2198192	DIVIDEND	DELETE	16950T102		B	0	1	5	.426051		39	?	2016-07-05	?	2016-05-16		0	2016-05-16	?	0	0005219337			20160517.ifs	2016-05-17	2016-05-18
2198193	2198193	DIVIDEND	ADD	16950T102		B	0	1	5	.426051		39	2016-06-30	2016-07-05	?	2016-05-16		1	2016-05-16	2016-05-17	0	0005219337			20160517.ifs	2016-05-17	2016-05-18
2197567	2197567	DIVIDEND	ADD	16950T102		B	0	1	5	.426051		39	?	2016-07-05	?	2016-05-16		0	2016-05-16	?	0	0005219337			20160516.ifs	2016-05-16	2016-05-17
1937320	1937320	DIVIDEND	CHANGE	16950T102		B	0	1	0	.44311		02	2015-06-22	2015-06-24	2015-08-17	2015-05-07		3	2015-05-07	2015-08-04	0	0004998954			20150805.ifs	2015-08-05	2015-08-06
1937321	1937320	DIVIDEND	CHANGE	16950T102		B	0	1	0	.44311		02	2015-06-22	2015-06-24	2015-08-17	2015-05-07		4	2015-05-07	2015-08-05	0	0004998954			20150805.ifs	2015-08-05	2015-08-06
1936441	1936441	DIVIDEND	DELETE	16950T102		B	0	1	5	.435796		39	2015-06-22	2015-06-24	?	2015-05-07		2	2015-05-07	2015-05-11	0	0004998954			20150804.ifs	2015-08-04	2015-08-05
1936442	1936442	DIVIDEND	ADD	16950T102		B	0	1	0	.44311		02	2015-06-22	2015-06-24	2015-08-17	2015-05-07		3	2015-05-07	2015-08-04	0	0004998954			20150804.ifs	2015-08-04	2015-08-05
1861353	1861353	DIVIDEND	CHANGE	16950T102		B	0	1	5	.435796		39	2015-06-22	2015-06-24	?	2015-05-07		1	2015-05-07	2015-05-08	0	0004998954			20150511.ifs	2015-05-11	2015-05-12
1861354	1861353	DIVIDEND	CHANGE	16950T102		B	0	1	5	.435796		39	2015-06-22	2015-06-24	?	2015-05-07		2	2015-05-07	2015-05-11	0	0004998954			20150511.ifs	2015-05-11	2015-05-12
1860713	1860713	DIVIDEND	DELETE	16950T102		B	0	1	5	.435796		39	?	2015-06-24	?	2015-05-07		0	2015-05-07	?	0	0004998954			20150508.ifs	2015-05-08	2015-05-09
1860714	1860714	DIVIDEND	ADD	16950T102		B	0	1	5	.435796		39	2015-06-22	2015-06-24	?	2015-05-07		1	2015-05-07	2015-05-08	0	0004998954			20150508.ifs	2015-05-08	2015-05-09
1859735	1859735	DIVIDEND	ADD	16950T102		B	0	1	5	.435796		39	?	2015-06-24	?	2015-05-07		0	2015-05-07	?	0	0004998954			20150507.ifs	2015-05-07	2015-05-08
1600803	1600803	DIVIDEND	CHANGE	16950T102		B	0	1	0	.408432		02	2014-07-01	2014-07-03	2014-08-18	2014-05-07		2	2014-05-07	2014-08-05	0	0004781231			20140806.ifs	2014-08-06	2014-08-07
1600804	1600803	DIVIDEND	CHANGE	16950T102		B	0	1	0	.408432		02	2014-07-01	2014-07-03	2014-08-18	2014-05-07		3	2014-05-07	2014-08-06	0	0004781231			20140806.ifs	2014-08-06	2014-08-07
1600160	1600160	DIVIDEND	DELETE	16950T102		B	0	1	5	.404445		39	2014-07-01	2014-07-03	?	2014-05-07		1	2014-05-07	2014-05-08	0	0004781231			20140805.ifs	2014-08-05	2014-08-06
1600161	1600161	DIVIDEND	ADD	16950T102		B	0	1	0	.408432		02	2014-07-01	2014-07-03	2014-08-18	2014-05-07		2	2014-05-07	2014-08-05	0	0004781231			20140805.ifs	2014-08-05	2014-08-06
1521720	1521720	DIVIDEND	DELETE	16950T102		B	0	1	5	.404445		39	?	2014-07-03	?	2014-05-07		0	2014-05-07	?	0	0004781231			20140508.ifs	2014-05-08	2014-05-09
1521721	1521721	DIVIDEND	ADD	16950T102		B	0	1	5	.404445		39	2014-07-01	2014-07-03	?	2014-05-07		1	2014-05-07	2014-05-08	0	0004781231			20140508.ifs	2014-05-08	2014-05-09
1521001	1521001	DIVIDEND	ADD	16950T102		B	0	1	5	.404445		39	?	2014-07-03	?	2014-05-07		0	2014-05-07	?	0	0004781231			20140507.ifs	2014-05-07	2014-05-08
1294548	1294548	DIVIDEND	CHANGE	16950T102		6	0	1	9	.035		25	2013-09-26	2013-09-30	2013-10-10	2013-09-20		0	2013-09-20	?	0	0004631615			20130923.ifs	2013-09-23	2013-09-24
1294549	1294548	DIVIDEND	CHANGE	16950T102		6	0	1	9	.292541		25	2013-09-26	2013-09-30	2013-10-10	2013-09-20		1	2013-09-20	2013-09-23	0	0004631615			20130923.ifs	2013-09-23	2013-09-24
1293014	1293014	DIVIDEND	ADD	16950T102		6	0	1	9	.035		25	2013-09-26	2013-09-30	2013-10-10	2013-09-20		0	2013-09-20	?	0	0004631615			20130920.ifs	2013-09-20	2013-09-21
1236975	1236975	DIVIDEND	DELETE	16950T102		B	0	1	5	.413226		39	2013-05-31	2013-06-04	?	2013-04-16		1	2013-04-16	2013-04-17	0	0004558196			20130708.ifs	2013-07-08	2013-07-09
1236976	1236976	DIVIDEND	ADD	16950T102		B	0	1	0	.414076		02	2013-05-31	2013-06-04	2013-07-22	2013-04-16		2	2013-04-16	2013-07-08	0	0004558196			20130708.ifs	2013-07-08	2013-07-09
1161708	1161708	DIVIDEND	DELETE	16950T102		B	0	1	5	.413226		39	?	2013-06-04	?	2013-04-16		0	2013-04-16	?	0	0004558196			20130417.ifs	2013-04-17	2013-04-18
1161709	1161709	DIVIDEND	ADD	16950T102		B	0	1	5	.413226		39	2013-05-31	2013-06-04	?	2013-04-16		1	2013-04-16	2013-04-17	0	0004558196			20130417.ifs	2013-04-17	2013-04-18
1161002	1161002	DIVIDEND	ADD	16950T102		B	0	1	5	.413226		39	?	2013-06-04	?	2013-04-16		0	2013-04-16	?	0	0004558196			20130416.ifs	2013-04-16	2013-04-17
910386	910386	DIVIDEND	DELETE	16950T102		B	0	1	5	.271277		39	2012-05-30	2012-06-01	?	2012-05-10		1	2012-05-10	2012-05-11	0	0004373543			20120709.ifs	2012-07-09	2012-07-10
910387	910387	DIVIDEND	ADD	16950T102		B	0	1	0	.271095		02	2012-05-30	2012-06-01	2012-07-23	2012-05-10		2	2012-05-10	2012-07-09	0	0004373543			20120709.ifs	2012-07-09	2012-07-10
860110	860110	DIVIDEND	DELETE	16950T102		B	0	1	5	.271277		39	?	2012-06-01	?	2012-05-10		0	2012-05-10	?	0	0004373543			20120511.ifs	2012-05-11	2012-05-12
860111	860111	DIVIDEND	ADD	16950T102		B	0	1	5	.271277		39	2012-05-30	2012-06-01	?	2012-05-10		1	2012-05-10	2012-05-11	0	0004373543			20120511.ifs	2012-05-11	2012-05-12
859303	859303	DIVIDEND	ADD	16950T102		B	0	1	5	.271277		39	?	2012-06-01	?	2012-05-10		0	2012-05-10	?	0	0004373543			20120510.ifs	2012-05-10	2012-05-11
602476	602476	DIVIDEND	DELETE	16950T102		B	0	1	4	.181522	0	39	2011-04-26	2011-04-28	?	2011-04-15		0	?	2011-04-18	0	0004175645			20110801.ifs	2011-08-01	2011-08-02
602477	602477	DIVIDEND	ADD	16950T102		B	0	1	4	.180651	0	02	2011-04-26	2011-04-28	2011-08-12	2011-04-15		0	?	2011-08-01	0	0004175645			20110801.ifs	2011-08-01	2011-08-02
504260	504260	EQUITY	CHANGE	16950T102	ADR	N	0	2010-07-09	?	0	no	no		no		2010-07-09	?	?							20110419.ifs	2011-04-19	2011-04-20
504261	504260	EQUITY	CHANGE	16950T102	ADR	0	0	2010-07-09	?	0	no	no		no		2010-07-09	2011-04-19	?							20110419.ifs	2011-04-19	2011-04-20
503519	503519	DIVIDEND	DELETE	16950T102		B	0	1	4	.181522		39	?	2011-04-28	?	2011-04-15		0	2011-04-15	?	0	0004175645			20110418.ifs	2011-04-18	2011-04-19
503520	503520	DIVIDEND	ADD	16950T102		B	0	1	4	.181522	0	39	2011-04-26	2011-04-28	?	2011-04-15		0	?	2011-04-18	0	0004175645			20110418.ifs	2011-04-18	2011-04-19
503241	503241	DIVIDEND	ADD	16950T102		B	0	1	4	.181522		39	?	2011-04-28	?	2011-04-15		0	2011-04-15	?	0	0004175645			20110415.ifs	2011-04-15	2011-04-16
245442	245442	EQUITY	ADD	16950T102	ADR	N	0	2010-07-09	?	0	no	no		no		2010-07-09	?	?							20100709.ifs	2010-07-09	2010-07-10
245443	245443	EXCHANGE	ADD	16950T102	66	2010-07-09	?	CIHKY	0	0	2010-07-09	?													20100709.ifs	2010-07-09	2010-07-10

Old Cusip

entryId

groupId

EQUITY

CHANGE

CUSIP

DESCRIPTION

ISSUE STATUS CODE

ISSUE TYPE CODE

ADD DATE

EXPIRATION DATE

PAYMENT FREQUENCY CODE

MARGIN FLAG

OPTION FLAG

CONVERTED CUSIP

NASDAQ MARKET CODE

INDEX ISSUER

CHANGE DATE

MERGENT CHANGE DATE

MATURE DATE

undefined1

undefined2

undefined3

undefined4

temp1

temp2

fileName

fileDate

processDate

BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 159665
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC