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
5573856	5573856	DIVIDEND	ADD	464288729		0	0	1	0	1.146375		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931083			20240610.ifs	2024-06-10	2024-06-11
5450367	5450367	DIVIDEND	ADD	464288729		0	0	1	0	.855052		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840651			20231219.ifs	2023-12-19	2023-12-20
5307600	5307600	DIVIDEND	ADD	464288729		0	0	1	0	1.487503		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006737051			20230606.ifs	2023-06-06	2023-06-07
5162433	5162433	DIVIDEND	ADD	464288729		0	0	1	0	.586348		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629543			20221212.ifs	2022-12-12	2022-12-13
5030152	5030152	DIVIDEND	ADD	464288729		0	0	1	0	1.148684		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536794			20220608.ifs	2022-06-08	2022-06-09
4919504	4919504	DIVIDEND	ADD	464288729		0	0	1	0	.176453		00	2021-12-30	2021-12-31	2022-01-05	2021-12-29		0	2021-12-29	?	0	0006454876			20211229.ifs	2021-12-29	2021-12-30
4877102	4877102	DIVIDEND	ADD	464288729		0	0	1	0	.632115		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417595			20211210.ifs	2021-12-10	2021-12-11
4725929	4725929	DIVIDEND	ADD	464288729		0	0	1	0	.942531		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320420			20210609.ifs	2021-06-09	2021-06-10
4539150	4539150	DIVIDEND	ADD	464288729		0	0	1	9	.142035		03	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	1	0006209302			20201211.ifs	2020-12-11	2020-12-12
4539151	4539151	DIVIDEND	ADD	464288729		0	0	1	0	.451945		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209254			20201211.ifs	2020-12-11	2020-12-12
4391030	4391030	DIVIDEND	ADD	464288729		0	0	1	0	.751353		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112127			20200612.ifs	2020-06-12	2020-06-13
4067971	4067971	DIVIDEND	ADD	464288729		0	0	1	0	.571998		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000069			20191213.ifs	2019-12-13	2019-12-14
4068050	4068050	DIVIDEND	ADD	464288729		0	0	1	0	.571998		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000069			20191213.ifs	2019-12-13	2019-12-14
3780991	3780991	DIVIDEND	ADD	464288729		0	0	1	0	1.101499		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898635			20190614.ifs	2019-06-14	2019-06-15
3781014	3781014	DIVIDEND	ADD	464288729		0	0	1	0	1.101499		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898635			20190614.ifs	2019-06-14	2019-06-15
3452372	3452372	DIVIDEND	ADD	464288729		0	0	1	0	.611209		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785550			20181217.ifs	2018-12-17	2018-12-18
3452531	3452531	DIVIDEND	ADD	464288729		0	0	1	0	.611209		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785550			20181217.ifs	2018-12-17	2018-12-18
3144072	3144072	DIVIDEND	ADD	464288729		0	0	1	0	1.11151		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676448			20180618.ifs	2018-06-18	2018-06-19
3144073	3144073	DIVIDEND	ADD	464288729		0	0	1	0	1.11151		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676448			20180618.ifs	2018-06-18	2018-06-19
2852052	2852052	DIVIDEND	ADD	464288729		0	0	1	0	.547701		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571808			20171220.ifs	2017-12-20	2017-12-21
2855941	2855941	DIVIDEND	ADD	464288729		0	0	1	0	.547701		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571808			20171220.ifs	2017-12-20	2017-12-21
2595060	2595060	DIVIDEND	ADD	464288729		0	0	1	0	.82275		00	2017-06-20	2017-06-22	2017-06-26	2017-06-19		0	2017-06-19	?	0	0005451181			20170619.ifs	2017-06-19	2017-06-20
2451260	2451260	EQUITY	CHANGE	464288729	ISHARES GLOBAL INDUSTRIALS ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2451261	2451260	EQUITY	CHANGE	464288729	ISHARES GLOBAL INDUSTRIALS ETF	0	A	2006-06-09	?	2	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2391656	2391656	DIVIDEND	ADD	464288729		0	0	1	0	.573458		00	2016-12-22	2016-12-27	2016-12-29	2016-12-21		0	2016-12-21	?	0	0005349820			20161221.ifs	2016-12-21	2016-12-22
2225303	2225303	DIVIDEND	ADD	464288729		0	0	1	0	.742352		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235500			20160620.ifs	2016-06-20	2016-06-21
2052969	2052969	DIVIDEND	ADD	464288729		0	0	1	0	.553725		00	2015-12-21	2015-12-23	2015-12-28	2015-12-18		0	2015-12-18	?	0	0005130223			20151218.ifs	2015-12-18	2015-12-19
1893627	1893627	DIVIDEND	ADD	464288729		0	0	1	0	.766927		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018430			20150623.ifs	2015-06-23	2015-06-24
1727852	1727852	DIVIDEND	ADD	464288729		0	0	1	0	.47922		00	2014-12-19	2014-12-23	2014-12-29	2014-12-18		0	2014-12-18	?	0	0004908440			20141218.ifs	2014-12-18	2014-12-19
1557043	1557043	DIVIDEND	ADD	464288729		0	0	1	0	.878897		00	2014-06-24	2014-06-26	2014-07-01	2014-06-23		0	2014-06-23	?	0	0004800687			20140623.ifs	2014-06-23	2014-06-24
1374572	1374572	DIVIDEND	ADD	464288729		0	0	1	0	.430433		00	2013-12-17	2013-12-19	2013-12-27	2013-12-16		0	2013-12-16	?	0	0004685277			20131216.ifs	2013-12-16	2013-12-17
1226668	1226668	CORPACTION	ADD	464288729	04	#	2013-07-01	464288729	04	?															20130701.ifs	2013-07-01	2013-07-02
1226669	1226669	CORPACTIONAUX	ADD	464288729	04	2013-07-01	EXI	ISHARES TR	S&P GLOBAL INDU	EXI	ISHARES TR	ISHARES GLOBAL	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226670	1226670	EQUITY	CHANGE	464288729	S&P GLBL INDUSTRIALS INDEX FD	0	A	2006-06-09	?	0	no	no		no		?	2008-03-13	?							20130701.ifs	2013-07-01	2013-07-02
1226671	1226670	EQUITY	CHANGE	464288729	ISHARES GLOBAL INDUSTRIALS ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1216213	1216213	DIVIDEND	ADD	464288729		0	0	1	0	.648253		00	2013-06-25	2013-06-27	2013-07-02	2013-06-24		0	2013-06-24	?	0	0004588156			20130624.ifs	2013-06-24	2013-06-25
1041714	1041714	DIVIDEND	ADD	464288729		0	0	1	0	.556107		00	2012-12-17	2012-12-19	2012-12-24	2012-12-14		0	2012-12-14	?	0	0004480547			20121214.ifs	2012-12-14	2012-12-15
888512	888512	DIVIDEND	ADD	464288729		0	0	1	0	.703394		00	2012-06-20	2012-06-22	2012-06-27	2012-06-19		0	2012-06-19	?	0	0004388194			20120619.ifs	2012-06-19	2012-06-20
727508	727508	DIVIDEND	ADD	464288729		0	0	1	0	.482101		00	2011-12-19	2011-12-21	2011-12-29	2011-12-16		0	2011-12-16	?	0	0004293075			20111216.ifs	2011-12-16	2011-12-17
564401	564401	DIVIDEND	ADD	464288729		0	0	1	0	.662862		00	2011-06-21	2011-06-23	2011-06-27	2011-06-20		0	2011-06-20	?	0	0004203084			20110620.ifs	2011-06-20	2011-06-21
383340	383340	DIVIDEND	ADD	464288729		0	0	1	0	.381424		00	2010-12-20	2010-12-22	2010-12-30	2010-12-17		0	2010-12-17	?	0	0004109857			20101217.ifs	2010-12-17	2010-12-18
222824	222824	DIVIDEND	DELETE	464288729		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016343			20100618.ifs	2010-06-18	2010-06-19
222825	222825	DIVIDEND	ADD	464288729		0	0	1	0	.4164		00	2010-06-21	2010-06-23	2010-06-25	2010-06-03		1	2010-06-03	2010-06-18	0	0004016343			20100618.ifs	2010-06-18	2010-06-19
213139	213139	DIVIDEND	ADD	464288729		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016343			20100603.ifs	2010-06-03	2010-06-04
56571	56571	DIVIDEND	ADD	464288729		0	0	1	0	.24972		00	2009-12-21	2009-12-23	2009-12-31	2009-12-18		0	2009-12-18	?	0	0003931823			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 = 152110
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