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
5573859	5573859	DIVIDEND	ADD	464288695		0	0	1	0	1.163179		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931084			20240610.ifs	2024-06-10	2024-06-11
5450370	5450370	DIVIDEND	ADD	464288695		0	0	1	0	1.162319		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840652			20231219.ifs	2023-12-19	2023-12-20
5307603	5307603	DIVIDEND	ADD	464288695		0	0	1	0	1.387497		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006737052			20230606.ifs	2023-06-06	2023-06-07
5162436	5162436	DIVIDEND	ADD	464288695		0	0	1	0	1.539965		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629544			20221212.ifs	2022-12-12	2022-12-13
5030155	5030155	DIVIDEND	ADD	464288695		0	0	1	0	2.264281		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536795			20220608.ifs	2022-06-08	2022-06-09
4877105	4877105	DIVIDEND	ADD	464288695		0	0	1	0	2.065693		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417596			20211210.ifs	2021-12-10	2021-12-11
4725932	4725932	DIVIDEND	ADD	464288695		0	0	1	0	1.107301		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320421			20210609.ifs	2021-06-09	2021-06-10
4539154	4539154	DIVIDEND	ADD	464288695		0	0	1	0	.587372		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209255			20201211.ifs	2020-12-11	2020-12-12
4391033	4391033	DIVIDEND	ADD	464288695		0	0	1	0	.398064		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112128			20200612.ifs	2020-06-12	2020-06-13
4128791	4128791	DIVIDEND	ADD	464288695		0	0	1	0	.062737		00	2019-12-30	2019-12-31	2020-01-06	2019-12-27		0	2019-12-27	?	0	0006028466			20191227.ifs	2019-12-27	2019-12-28
4128915	4128915	DIVIDEND	ADD	464288695		0	0	1	0	.062737		00	2019-12-30	2019-12-31	2020-01-06	2019-12-27		0	2019-12-27	?	0	0006028466			20191227.ifs	2019-12-27	2019-12-28
4067977	4067977	DIVIDEND	ADD	464288695		0	0	1	0	.713437		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000066			20191213.ifs	2019-12-13	2019-12-14
4068056	4068056	DIVIDEND	ADD	464288695		0	0	1	0	.713437		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000066			20191213.ifs	2019-12-13	2019-12-14
3780997	3780997	DIVIDEND	ADD	464288695		0	0	1	0	1.68099		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898636			20190614.ifs	2019-06-14	2019-06-15
3781020	3781020	DIVIDEND	ADD	464288695		0	0	1	0	1.68099		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898636			20190614.ifs	2019-06-14	2019-06-15
3452376	3452376	DIVIDEND	ADD	464288695		0	0	1	0	.72966		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785551			20181217.ifs	2018-12-17	2018-12-18
3452535	3452535	DIVIDEND	ADD	464288695		0	0	1	0	.72966		00	2018-12-18	2018-12-19	2018-12-24	2018-12-17		0	2018-12-17	?	0	0005785551			20181217.ifs	2018-12-17	2018-12-18
3144076	3144076	DIVIDEND	ADD	464288695		0	0	1	0	.856596		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676450			20180618.ifs	2018-06-18	2018-06-19
3144077	3144077	DIVIDEND	ADD	464288695		0	0	1	0	.856596		00	2018-06-19	2018-06-20	2018-06-25	2018-06-18		0	2018-06-18	?	0	0005676450			20180618.ifs	2018-06-18	2018-06-19
2852056	2852056	DIVIDEND	ADD	464288695		0	0	1	0	.469925		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571809			20171220.ifs	2017-12-20	2017-12-21
2855943	2855943	DIVIDEND	ADD	464288695		0	0	1	0	.469925		00	2017-12-21	2017-12-22	2017-12-28	2017-12-20		0	2017-12-20	?	0	0005571809			20171220.ifs	2017-12-20	2017-12-21
2595062	2595062	DIVIDEND	ADD	464288695		0	0	1	0	.760292		00	2017-06-20	2017-06-22	2017-06-26	2017-06-19		0	2017-06-19	?	0	0005451182			20170619.ifs	2017-06-19	2017-06-20
2451256	2451256	EQUITY	CHANGE	464288695	ISHARES GLOBAL MATERIALS ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2451257	2451256	EQUITY	CHANGE	464288695	ISHARES GLOBAL MATERIALS ETF	0	A	2006-06-09	?	2	no	no		no		?	2013-07-01	?							20170124.ifs	2017-01-24	2017-01-25
2391658	2391658	DIVIDEND	ADD	464288695		0	0	1	0	.25537		00	2016-12-22	2016-12-27	2016-12-29	2016-12-21		0	2016-12-21	?	0	0005349898			20161221.ifs	2016-12-21	2016-12-22
2225306	2225306	DIVIDEND	ADD	464288695		0	0	1	0	.465407		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235570			20160620.ifs	2016-06-20	2016-06-21
2052971	2052971	DIVIDEND	ADD	464288695		0	0	1	0	.625975		00	2015-12-21	2015-12-23	2015-12-28	2015-12-18		0	2015-12-18	?	0	0005130225			20151218.ifs	2015-12-18	2015-12-19
1893630	1893630	DIVIDEND	ADD	464288695		0	0	1	0	1.012934		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018502			20150623.ifs	2015-06-23	2015-06-24
1727854	1727854	DIVIDEND	ADD	464288695		0	0	1	0	.525785		00	2014-12-19	2014-12-23	2014-12-29	2014-12-18		0	2014-12-18	?	0	0004908442			20141218.ifs	2014-12-18	2014-12-19
1557046	1557046	DIVIDEND	ADD	464288695		0	0	1	0	.773652		00	2014-06-24	2014-06-26	2014-07-01	2014-06-23		0	2014-06-23	?	0	0004800753			20140623.ifs	2014-06-23	2014-06-24
1374574	1374574	DIVIDEND	ADD	464288695		0	0	1	0	.497855		00	2013-12-17	2013-12-19	2013-12-27	2013-12-16		0	2013-12-16	?	0	0004685279			20131216.ifs	2013-12-16	2013-12-17
1226545	1226545	CORPACTION	ADD	464288695	04	#	2013-07-01	464288695	04	?															20130701.ifs	2013-07-01	2013-07-02
1226546	1226546	CORPACTIONAUX	ADD	464288695	04	2013-07-01	MXI	ISHARES TR	S&P GLOBAL MATE	MXI	ISHARES TR	ISHARES GLOBAL	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226547	1226547	EQUITY	CHANGE	464288695	S&P GLBL MATERIALS INDEX FD	0	A	2006-06-09	?	0	no	no		no		?	2008-03-13	?							20130701.ifs	2013-07-01	2013-07-02
1226548	1226547	EQUITY	CHANGE	464288695	ISHARES GLOBAL MATERIALS ETF	0	A	2006-06-09	?	0	no	no		no		?	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1216215	1216215	DIVIDEND	ADD	464288695		0	0	1	9	.833785		03	2013-06-25	2013-06-27	2013-07-02	2013-06-24		0	2013-06-24	?	0	0004588171			20130624.ifs	2013-06-24	2013-06-25
1041716	1041716	DIVIDEND	ADD	464288695		0	0	1	0	.60934		00	2012-12-17	2012-12-19	2012-12-24	2012-12-14		0	2012-12-14	?	0	0004480613			20121214.ifs	2012-12-14	2012-12-15
888514	888514	DIVIDEND	ADD	464288695		0	0	1	0	.69789		00	2012-06-20	2012-06-22	2012-06-27	2012-06-19		0	2012-06-19	?	0	0004388196			20120619.ifs	2012-06-19	2012-06-20
727510	727510	DIVIDEND	ADD	464288695		0	0	1	0	.559144		00	2011-12-19	2011-12-21	2011-12-29	2011-12-16		0	2011-12-16	?	0	0004293079			20111216.ifs	2011-12-16	2011-12-17
651280	651280	DIVIDEND	DELETE	464288695		0	0	1	0	.48224		00	2008-12-24	2008-12-27	2008-01-04	2007-12-21		0	?	2008-03-13	0	0003551876			20110923.ifs	2011-09-23	2011-09-24
651281	651281	DIVIDEND	ADD	464288695		0	0	1	0	.48224	0	00	2007-12-24	2007-12-27	2008-01-04	2007-12-21		0	?	2011-09-23	0	0003551876			20110923.ifs	2011-09-23	2011-09-24
564403	564403	DIVIDEND	ADD	464288695		0	0	1	0	.707602		00	2011-06-21	2011-06-23	2011-06-27	2011-06-20		0	2011-06-20	?	0	0004203086			20110620.ifs	2011-06-20	2011-06-21
383342	383342	DIVIDEND	ADD	464288695		0	0	1	0	.720779		00	2010-12-20	2010-12-22	2010-12-30	2010-12-17		0	2010-12-17	?	0	0004109859			20101217.ifs	2010-12-17	2010-12-18
222828	222828	DIVIDEND	DELETE	464288695		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016347			20100618.ifs	2010-06-18	2010-06-19
222829	222829	DIVIDEND	ADD	464288695		0	0	1	0	.4833		00	2010-06-21	2010-06-23	2010-06-25	2010-06-03		1	2010-06-03	2010-06-18	0	0004016347			20100618.ifs	2010-06-18	2010-06-19
213142	213142	DIVIDEND	ADD	464288695		0	0	1	6	0		08	2010-06-21	2010-06-23	2010-06-25	2010-06-03		0	2010-06-03	?	0	0004016347			20100603.ifs	2010-06-03	2010-06-04
56573	56573	DIVIDEND	ADD	464288695		0	0	1	0	.21733		00	2009-12-21	2009-12-23	2009-12-31	2009-12-18		0	2009-12-18	?	0	0003931845			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 = 152108
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