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
5573857	5573857	DIVIDEND	ADD	464288711		0	0	1	0	.989386		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931085			20240610.ifs	2024-06-10	2024-06-11
5450368	5450368	DIVIDEND	ADD	464288711		0	0	1	0	1.135837		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840653			20231219.ifs	2023-12-19	2023-12-20
5307601	5307601	DIVIDEND	ADD	464288711		0	0	1	0	.955724		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006737053			20230606.ifs	2023-06-06	2023-06-07
5162434	5162434	DIVIDEND	ADD	464288711		0	0	1	0	1.037204		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629545			20221212.ifs	2022-12-12	2022-12-13
5030153	5030153	DIVIDEND	ADD	464288711		0	0	1	0	.849083		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536796			20220608.ifs	2022-06-08	2022-06-09
4877103	4877103	DIVIDEND	ADD	464288711		0	0	1	0	.978714		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417597			20211210.ifs	2021-12-10	2021-12-11
4725930	4725930	DIVIDEND	ADD	464288711		0	0	1	0	.823188		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320422			20210609.ifs	2021-06-09	2021-06-10
4539152	4539152	DIVIDEND	ADD	464288711		0	0	1	0	1.009411		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209256			20201211.ifs	2020-12-11	2020-12-12
4391031	4391031	DIVIDEND	ADD	464288711		0	0	1	0	.58514		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112129			20200612.ifs	2020-06-12	2020-06-13
4067973	4067973	DIVIDEND	ADD	464288711		0	0	1	0	.960662		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000068			20191213.ifs	2019-12-13	2019-12-14
4068052	4068052	DIVIDEND	ADD	464288711		0	0	1	0	.960662		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000068			20191213.ifs	2019-12-13	2019-12-14
3780993	3780993	DIVIDEND	ADD	464288711		0	0	1	0	1.053959		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898637			20190614.ifs	2019-06-14	2019-06-15
3781016	3781016	DIVIDEND	ADD	464288711		0	0	1	0	1.053959		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898637			20190614.ifs	2019-06-14	2019-06-15
3452374	3452374	DIVIDEND	ADD	464288711		0	0	1	0	.719645		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785552			20181217.ifs	2018-12-17	2018-12-18
3452533	3452533	DIVIDEND	ADD	464288711		0	0	1	0	.719645		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785552			20181217.ifs	2018-12-17	2018-12-18
3144074	3144074	DIVIDEND	ADD	464288711		0	0	1	0	.829913		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676454			20180618.ifs	2018-06-18	2018-06-19
3144075	3144075	DIVIDEND	ADD	464288711		0	0	1	0	.829913		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676454			20180618.ifs	2018-06-18	2018-06-19
2852054	2852054	DIVIDEND	ADD	464288711		0	0	1	0	.849753		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571813			20171220.ifs	2017-12-20	2017-12-21
2855942	2855942	DIVIDEND	ADD	464288711		0	0	1	0	.849753		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571813			20171220.ifs	2017-12-20	2017-12-21
2595061	2595061	DIVIDEND	ADD	464288711		0	0	1	0	.942587		00	2017-06-20	2017-06-22	2017-06-26	2017-06-19		0	2017-06-19	?	0	0005451186			20170619.ifs	2017-06-19	2017-06-20
2451258	2451258	EQUITY	CHANGE	464288711	ISHARES GLOBAL UTILITIES ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2451259	2451258	EQUITY	CHANGE	464288711	ISHARES GLOBAL UTILITIES ETF	0	A	2006-06-09	?	2	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2391657	2391657	DIVIDEND	ADD	464288711		0	0	1	0	1.045679		00	2016-12-22	2016-12-27	2016-12-29	2016-12-21		0	2016-12-21	?	0	0005349891			20161221.ifs	2016-12-21	2016-12-22
2225304	2225304	DIVIDEND	ADD	464288711		0	0	1	0	1.086439		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235565			20160620.ifs	2016-06-20	2016-06-21
2052970	2052970	DIVIDEND	ADD	464288711		0	0	1	0	.663848		00	2015-12-21	2015-12-23	2015-12-28	2015-12-18		0	2015-12-18	?	0	0005130230			20151218.ifs	2015-12-18	2015-12-19
1893628	1893628	DIVIDEND	ADD	464288711		0	0	1	0	.998492		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018498			20150623.ifs	2015-06-23	2015-06-24
1727853	1727853	DIVIDEND	ADD	464288711		0	0	1	0	.730913		00	2014-12-19	2014-12-23	2014-12-29	2014-12-18		0	2014-12-18	?	0	0004908451			20141218.ifs	2014-12-18	2014-12-19
1557044	1557044	DIVIDEND	ADD	464288711		0	0	1	0	1.015161		00	2014-06-24	2014-06-26	2014-07-01	2014-06-23		0	2014-06-23	?	0	0004800750			20140623.ifs	2014-06-23	2014-06-24
1374573	1374573	DIVIDEND	ADD	464288711		0	0	1	0	.855486		00	2013-12-17	2013-12-19	2013-12-27	2013-12-16		0	2013-12-16	?	0	0004685282			20131216.ifs	2013-12-16	2013-12-17
1226388	1226388	CORPACTION	ADD	464288711	04	#	2013-07-01	464288711	04	?															20130701.ifs	2013-07-01	2013-07-02
1226389	1226389	CORPACTIONAUX	ADD	464288711	04	2013-07-01	JXI	ISHARES TR	S&P GLOBAL UTIL	JXI	ISHARES TR	ISHARES GLOBAL	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226390	1226390	EQUITY	CHANGE	464288711	S&P GLBL UTILITIES INDEX FD	0	A	2006-06-09	?	0	no	no		no		?	2008-03-13	?							20130701.ifs	2013-07-01	2013-07-02
1226391	1226390	EQUITY	CHANGE	464288711	ISHARES GLOBAL UTILITIES ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1216214	1216214	DIVIDEND	ADD	464288711		0	0	1	0	1.046385		00	2013-06-25	2013-06-27	2013-07-02	2013-06-24		0	2013-06-24	?	0	0004588169			20130624.ifs	2013-06-24	2013-06-25
1041715	1041715	DIVIDEND	ADD	464288711		0	0	1	0	.733808		00	2012-12-17	2012-12-19	2012-12-24	2012-12-14		0	2012-12-14	?	0	0004480603			20121214.ifs	2012-12-14	2012-12-15
888513	888513	DIVIDEND	ADD	464288711		0	0	1	0	.995408		00	2012-06-20	2012-06-22	2012-06-27	2012-06-19		0	2012-06-19	?	0	0004388199			20120619.ifs	2012-06-19	2012-06-20
727509	727509	DIVIDEND	ADD	464288711		0	0	1	0	.821133		00	2011-12-19	2011-12-21	2011-12-29	2011-12-16		0	2011-12-16	?	0	0004293084			20111216.ifs	2011-12-16	2011-12-17
564402	564402	DIVIDEND	ADD	464288711		0	0	1	0	1.136846		00	2011-06-21	2011-06-23	2011-06-27	2011-06-20		0	2011-06-20	?	0	0004203091			20110620.ifs	2011-06-20	2011-06-21
383341	383341	DIVIDEND	ADD	464288711		0	0	1	0	.693398		00	2010-12-20	2010-12-22	2010-12-30	2010-12-17		0	2010-12-17	?	0	0004109862			20101217.ifs	2010-12-17	2010-12-18
222826	222826	DIVIDEND	DELETE	464288711		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016339			20100618.ifs	2010-06-18	2010-06-19
222827	222827	DIVIDEND	ADD	464288711		0	0	1	0	1.21658		00	2010-06-21	2010-06-23	2010-06-25	2010-06-03		1	2010-06-03	2010-06-18	0	0004016339			20100618.ifs	2010-06-18	2010-06-19
213140	213140	DIVIDEND	ADD	464288711		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016339			20100603.ifs	2010-06-03	2010-06-04
56572	56572	DIVIDEND	ADD	464288711		0	0	1	0	.56347		00	2009-12-21	2009-12-23	2009-12-31	2009-12-18		0	2009-12-18	?	0	0003931831			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 = 152109
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