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
5573854	5573854	DIVIDEND	ADD	464288745		0	0	1	0	1.365507		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931081			20240610.ifs	2024-06-10	2024-06-11
5450365	5450365	DIVIDEND	ADD	464288745		0	0	1	0	.632631		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840649			20231219.ifs	2023-12-19	2023-12-20
5307598	5307598	DIVIDEND	ADD	464288745		0	0	1	0	.95499		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006737049			20230606.ifs	2023-06-06	2023-06-07
5162431	5162431	DIVIDEND	ADD	464288745		0	0	1	0	.631283		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629541			20221212.ifs	2022-12-12	2022-12-13
5030150	5030150	DIVIDEND	ADD	464288745		0	0	1	0	.62791		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536792			20220608.ifs	2022-06-08	2022-06-09
4919502	4919502	DIVIDEND	ADD	464288745		0	0	1	0	.418887		00	2021-12-30	2021-12-31	2022-01-05	2021-12-29		0	2021-12-29	?	0	0006454874			20211229.ifs	2021-12-29	2021-12-30
4877100	4877100	DIVIDEND	ADD	464288745		0	0	1	0	.499958		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417593			20211210.ifs	2021-12-10	2021-12-11
4725927	4725927	DIVIDEND	ADD	464288745		0	0	1	0	.670322		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320418			20210609.ifs	2021-06-09	2021-06-10
4539148	4539148	DIVIDEND	ADD	464288745		0	0	1	0	.487746		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209252			20201211.ifs	2020-12-11	2020-12-12
4391028	4391028	DIVIDEND	ADD	464288745		0	0	1	0	.523503		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112125			20200612.ifs	2020-06-12	2020-06-13
4067967	4067967	DIVIDEND	ADD	464288745		0	0	1	0	.738265		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000071			20191213.ifs	2019-12-13	2019-12-14
4068046	4068046	DIVIDEND	ADD	464288745		0	0	1	0	.738265		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000071			20191213.ifs	2019-12-13	2019-12-14
3780987	3780987	DIVIDEND	ADD	464288745		0	0	1	0	1.127865		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898633			20190614.ifs	2019-06-14	2019-06-15
3781010	3781010	DIVIDEND	ADD	464288745		0	0	1	0	1.127865		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898633			20190614.ifs	2019-06-14	2019-06-15
3452368	3452368	DIVIDEND	ADD	464288745		0	0	1	0	.745848		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785548			20181217.ifs	2018-12-17	2018-12-18
3452527	3452527	DIVIDEND	ADD	464288745		0	0	1	0	.745848		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785548			20181217.ifs	2018-12-17	2018-12-18
3144068	3144068	DIVIDEND	ADD	464288745		0	0	1	0	1.003446		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676443			20180618.ifs	2018-06-18	2018-06-19
3144069	3144069	DIVIDEND	ADD	464288745		0	0	1	0	1.003446		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676443			20180618.ifs	2018-06-18	2018-06-19
2852048	2852048	DIVIDEND	ADD	464288745		0	0	1	0	.658321		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571803			20171220.ifs	2017-12-20	2017-12-21
2855939	2855939	DIVIDEND	ADD	464288745		0	0	1	0	.658321		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571803			20171220.ifs	2017-12-20	2017-12-21
2595058	2595058	DIVIDEND	ADD	464288745		0	0	1	0	.716515		00	2017-06-20	2017-06-22	2017-06-26	2017-06-19		0	2017-06-19	?	0	0005451176			20170619.ifs	2017-06-19	2017-06-20
2451264	2451264	EQUITY	CHANGE	464288745	ISHARES GLOBAL CONSUMER DISCRETIONARY ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2451265	2451264	EQUITY	CHANGE	464288745	ISHARES GLOBAL CONSUMER DISCRETIONARY ETF	0	A	2006-06-09	?	2	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2391654	2391654	DIVIDEND	ADD	464288745		0	0	1	0	.66797		00	2016-12-22	2016-12-27	2016-12-29	2016-12-21		0	2016-12-21	?	0	0005349905			20161221.ifs	2016-12-21	2016-12-22
2225301	2225301	DIVIDEND	ADD	464288745		0	0	1	0	.926502		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235576			20160620.ifs	2016-06-20	2016-06-21
2052967	2052967	DIVIDEND	ADD	464288745		0	0	1	0	.429639		00	2015-12-21	2015-12-23	2015-12-28	2015-12-18		0	2015-12-18	?	0	0005130218			20151218.ifs	2015-12-18	2015-12-19
1893625	1893625	DIVIDEND	ADD	464288745		0	0	1	0	.609574		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018509			20150623.ifs	2015-06-23	2015-06-24
1727850	1727850	DIVIDEND	ADD	464288745		0	0	1	0	.632603		00	2014-12-19	2014-12-23	2014-12-29	2014-12-18		0	2014-12-18	?	0	0004908448			20141218.ifs	2014-12-18	2014-12-19
1557041	1557041	DIVIDEND	ADD	464288745		0	0	1	0	.826576		00	2014-06-24	2014-06-26	2014-07-01	2014-06-23		0	2014-06-23	?	0	0004800758			20140623.ifs	2014-06-23	2014-06-24
1374570	1374570	DIVIDEND	ADD	464288745		0	0	1	0	.422344		00	2013-12-17	2013-12-19	2013-12-27	2013-12-16		0	2013-12-16	?	0	0004685272			20131216.ifs	2013-12-16	2013-12-17
1226561	1226561	CORPACTION	ADD	464288745	04	#	2013-07-01	464288745	04	?															20130701.ifs	2013-07-01	2013-07-02
1226562	1226562	CORPACTIONAUX	ADD	464288745	04	2013-07-01	RXI	ISHARES TR	S&P GLOBAL CONS	RXI	ISHARES TR	ISHARES GLOBAL	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226563	1226563	EQUITY	CHANGE	464288745	S&P GLBL CONSUMR DSCRY IDX FD	0	A	2006-06-09	?	0	no	no		no		?	2008-03-13	?							20130701.ifs	2013-07-01	2013-07-02
1226564	1226563	EQUITY	CHANGE	464288745	ISHARES GLOBAL CONSUMER DISCRETIONARY ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1216211	1216211	DIVIDEND	ADD	464288745		0	0	1	0	.599243		00	2013-06-25	2013-06-27	2013-07-02	2013-06-24		0	2013-06-24	?	0	0004588172			20130624.ifs	2013-06-24	2013-06-25
1041712	1041712	DIVIDEND	ADD	464288745		0	0	1	0	.439754		00	2012-12-17	2012-12-19	2012-12-24	2012-12-14		0	2012-12-14	?	0	0004480615			20121214.ifs	2012-12-14	2012-12-15
888510	888510	DIVIDEND	ADD	464288745		0	0	1	0	.428589		00	2012-06-20	2012-06-22	2012-06-27	2012-06-19		0	2012-06-19	?	0	0004388189			20120619.ifs	2012-06-19	2012-06-20
727506	727506	DIVIDEND	ADD	464288745		0	0	1	0	.388276		00	2011-12-19	2011-12-21	2011-12-29	2011-12-16		0	2011-12-16	?	0	0004293067			20111216.ifs	2011-12-16	2011-12-17
564399	564399	DIVIDEND	ADD	464288745		0	0	1	0	.491915		00	2011-06-21	2011-06-23	2011-06-27	2011-06-20		0	2011-06-20	?	0	0004203078			20110620.ifs	2011-06-20	2011-06-21
383338	383338	DIVIDEND	ADD	464288745		0	0	1	0	.291843		00	2010-12-20	2010-12-22	2010-12-30	2010-12-17		0	2010-12-17	?	0	0004109852			20101217.ifs	2010-12-17	2010-12-18
222820	222820	DIVIDEND	DELETE	464288745		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016349			20100618.ifs	2010-06-18	2010-06-19
222821	222821	DIVIDEND	ADD	464288745		0	0	1	0	.27755		00	2010-06-21	2010-06-23	2010-06-25	2010-06-03		1	2010-06-03	2010-06-18	0	0004016349			20100618.ifs	2010-06-18	2010-06-19
213137	213137	DIVIDEND	ADD	464288745		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016349			20100603.ifs	2010-06-03	2010-06-04
56569	56569	DIVIDEND	ADD	464288745		0	0	1	0	.24551		00	2009-12-21	2009-12-23	2009-12-31	2009-12-18		0	2009-12-18	?	0	0003931818			20091218.ifs	2009-12-18	2010-04-07

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 = 152107
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