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
5573855	5573855	DIVIDEND	ADD	464288737		0	0	1	0	.659257		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931082			20240610.ifs	2024-06-10	2024-06-11
5450366	5450366	DIVIDEND	ADD	464288737		0	0	1	0	1.156824		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840650			20231219.ifs	2023-12-19	2023-12-20
5307599	5307599	DIVIDEND	ADD	464288737		0	0	1	0	.613575		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006737050			20230606.ifs	2023-06-06	2023-06-07
5162432	5162432	DIVIDEND	ADD	464288737		0	0	1	0	.588259		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629542			20221212.ifs	2022-12-12	2022-12-13
5030151	5030151	DIVIDEND	ADD	464288737		0	0	1	0	.595175		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536793			20220608.ifs	2022-06-08	2022-06-09
4919503	4919503	DIVIDEND	ADD	464288737		0	0	1	0	.047858		00	2021-12-30	2021-12-31	2022-01-05	2021-12-29		0	2021-12-29	?	0	0006454875			20211229.ifs	2021-12-29	2021-12-30
4877101	4877101	DIVIDEND	ADD	464288737		0	0	1	0	.729108		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417594			20211210.ifs	2021-12-10	2021-12-11
4725928	4725928	DIVIDEND	ADD	464288737		0	0	1	0	.687067		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320419			20210609.ifs	2021-06-09	2021-06-10
4539149	4539149	DIVIDEND	ADD	464288737		0	0	1	0	.782228		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209253			20201211.ifs	2020-12-11	2020-12-12
4391029	4391029	DIVIDEND	ADD	464288737		0	0	1	0	.581764		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112126			20200612.ifs	2020-06-12	2020-06-13
4067969	4067969	DIVIDEND	ADD	464288737		0	0	1	0	.604167		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000070			20191213.ifs	2019-12-13	2019-12-14
4068048	4068048	DIVIDEND	ADD	464288737		0	0	1	0	.604167		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000070			20191213.ifs	2019-12-13	2019-12-14
3780989	3780989	DIVIDEND	ADD	464288737		0	0	1	0	.597915		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898634			20190614.ifs	2019-06-14	2019-06-15
3781012	3781012	DIVIDEND	ADD	464288737		0	0	1	0	.597915		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898634			20190614.ifs	2019-06-14	2019-06-15
3452370	3452370	DIVIDEND	ADD	464288737		0	0	1	0	.715546		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785549			20181217.ifs	2018-12-17	2018-12-18
3452529	3452529	DIVIDEND	ADD	464288737		0	0	1	0	.715546		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785549			20181217.ifs	2018-12-17	2018-12-18
3144070	3144070	DIVIDEND	ADD	464288737		0	0	1	0	.652026		35	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676444			20180618.ifs	2018-06-18	2018-06-19
3144071	3144071	DIVIDEND	ADD	464288737		0	0	1	0	.652026		35	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676444			20180618.ifs	2018-06-18	2018-06-19
3019453	3019453	DIVIDEND	ADD	464288737		0	0	6	0	1		11	2018-05-02	2018-04-27	2018-05-01	2018-03-29		0	2018-04-02	?	0	0005641918			20180402.ifs	2018-04-02	2018-04-03
3019454	3019454	SPLIT	ADD	464288737	.5	2018-05-02	11	2018-04-02	?																20180402.ifs	2018-04-02	2018-04-03
3023923	3023923	DIVIDEND	ADD	464288737		0	0	6	0	1		11	2018-05-02	2018-04-27	2018-05-01	2018-03-29		0	2018-04-02	?	0	0005641918			20180402.ifs	2018-04-02	2018-04-03
3023924	3023924	SPLIT	ADD	464288737	.5	2018-05-02	11	2018-04-02	?																20180402.ifs	2018-04-02	2018-04-03
2852050	2852050	DIVIDEND	ADD	464288737		0	0	1	0	1.157949		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571804			20171220.ifs	2017-12-20	2017-12-21
2855940	2855940	DIVIDEND	ADD	464288737		0	0	1	0	1.157949		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571804			20171220.ifs	2017-12-20	2017-12-21
2595059	2595059	DIVIDEND	ADD	464288737		0	0	1	0	1.1431		00	2017-06-20	2017-06-22	2017-06-26	2017-06-19		0	2017-06-19	?	0	0005451177			20170619.ifs	2017-06-19	2017-06-20
2451262	2451262	EQUITY	CHANGE	464288737	ISHARES GLOBAL CONSUMER STAPLES ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-02	?							20170124.ifs	2017-01-24	2017-01-25
2451263	2451262	EQUITY	CHANGE	464288737	ISHARES GLOBAL CONSUMER STAPLES ETF	0	A	2006-06-09	?	2	no	no		no		?	2013-07-02	?							20170124.ifs	2017-01-24	2017-01-25
2391655	2391655	DIVIDEND	ADD	464288737		0	0	1	0	1.047743		00	2016-12-22	2016-12-27	2016-12-29	2016-12-21		0	2016-12-21	?	0	0005349892			20161221.ifs	2016-12-21	2016-12-22
2225302	2225302	DIVIDEND	ADD	464288737		0	0	1	0	1.109291		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235567			20160620.ifs	2016-06-20	2016-06-21
2052968	2052968	DIVIDEND	ADD	464288737		0	0	1	0	.898588		00	2015-12-21	2015-12-23	2015-12-28	2015-12-18		0	2015-12-18	?	0	0005130219			20151218.ifs	2015-12-18	2015-12-19
1893626	1893626	DIVIDEND	ADD	464288737		0	0	1	0	1.150649		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018500			20150623.ifs	2015-06-23	2015-06-24
1727851	1727851	DIVIDEND	ADD	464288737		0	0	1	0	.931829		00	2014-12-19	2014-12-23	2014-12-29	2014-12-18		0	2014-12-18	?	0	0004908452			20141218.ifs	2014-12-18	2014-12-19
1557042	1557042	DIVIDEND	ADD	464288737		0	0	1	0	1.17212		00	2014-06-24	2014-06-26	2014-07-01	2014-06-23		0	2014-06-23	?	0	0004800752			20140623.ifs	2014-06-23	2014-06-24
1374571	1374571	DIVIDEND	ADD	464288737		0	0	1	0	.814808		00	2013-12-17	2013-12-19	2013-12-27	2013-12-16		0	2013-12-16	?	0	0004685273			20131216.ifs	2013-12-16	2013-12-17
1232236	1232236	EQUITY	CHANGE	464288737	ISHARES GLOBAL CONSUMER STAPLES ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20130702.ifs	2013-07-02	2013-07-03
1232237	1232236	EQUITY	CHANGE	464288737	ISHARES GLOBAL CONSUMER STAPLES ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-02	?							20130702.ifs	2013-07-02	2013-07-03
1227272	1227272	CORPACTION	ADD	464288737	04	#	2013-07-01	464288737	04	?															20130701.ifs	2013-07-01	2013-07-02
1227273	1227273	CORPACTIONAUX	ADD	464288737	04	2013-07-01	KXI	ISHARES TR	S&P GLOBAL CONS	KXI	ISHARES TR	ISHARES GLOBAL	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1227274	1227274	EQUITY	CHANGE	464288737	S&P GLBL CNSUMR STPLS IDX FD	0	A	2006-06-09	?	0	no	no		no		?	2008-03-13	?							20130701.ifs	2013-07-01	2013-07-02
1227275	1227274	EQUITY	CHANGE	464288737	ISHARES GLOBAL CONSUMER STAPLES ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1216212	1216212	DIVIDEND	ADD	464288737		0	0	1	0	.933304		00	2013-06-25	2013-06-27	2013-07-02	2013-06-24		0	2013-06-24	?	0	0004588170			20130624.ifs	2013-06-24	2013-06-25
1041713	1041713	DIVIDEND	ADD	464288737		0	0	1	0	1.04394		00	2012-12-17	2012-12-19	2012-12-24	2012-12-14		0	2012-12-14	?	0	0004480608			20121214.ifs	2012-12-14	2012-12-15
888511	888511	DIVIDEND	ADD	464288737		0	0	1	0	.968031		00	2012-06-20	2012-06-22	2012-06-27	2012-06-19		0	2012-06-19	?	0	0004388190			20120619.ifs	2012-06-19	2012-06-20
727507	727507	DIVIDEND	ADD	464288737		0	0	1	0	.684503		00	2011-12-19	2011-12-21	2011-12-29	2011-12-16		0	2011-12-16	?	0	0004293069			20111216.ifs	2011-12-16	2011-12-17
564400	564400	DIVIDEND	ADD	464288737		0	0	1	0	.871134		00	2011-06-21	2011-06-23	2011-06-27	2011-06-20		0	2011-06-20	?	0	0004203079			20110620.ifs	2011-06-20	2011-06-21
383339	383339	DIVIDEND	ADD	464288737		0	0	1	0	.640581		00	2010-12-20	2010-12-22	2010-12-30	2010-12-17		0	2010-12-17	?	0	0004109853			20101217.ifs	2010-12-17	2010-12-18
222822	222822	DIVIDEND	DELETE	464288737		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016352			20100618.ifs	2010-06-18	2010-06-19
222823	222823	DIVIDEND	ADD	464288737		0	0	1	0	.80951		00	2010-06-21	2010-06-23	2010-06-25	2010-06-03		1	2010-06-03	2010-06-18	0	0004016352			20100618.ifs	2010-06-18	2010-06-19
213138	213138	DIVIDEND	ADD	464288737		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016352			20100603.ifs	2010-06-03	2010-06-04
56570	56570	DIVIDEND	ADD	464288737		0	0	1	0	.56545		00	2009-12-21	2009-12-23	2009-12-31	2009-12-18		0	2009-12-18	?	0	0003931821			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 = 152111
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