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
5573853	5573853	DIVIDEND	ADD	464288752		0	0	1	0	.09373		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931221			20240610.ifs	2024-06-10	2024-06-11
5519557	5519557	DIVIDEND	ADD	464288752		0	0	1	0	.143483		00	2024-03-21	2024-03-22	2024-03-27	2024-03-20		0	2024-03-20	?	0	0006892844			20240320.ifs	2024-03-20	2024-03-21
5450364	5450364	DIVIDEND	ADD	464288752		0	0	1	0	.100629		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840913			20231219.ifs	2023-12-19	2023-12-20
5380085	5380085	DIVIDEND	ADD	464288752		0	0	1	0	.150505		00	2023-09-26	2023-09-27	2023-10-02	2023-09-25		0	2023-09-25	?	0	0006787392			20230925.ifs	2023-09-25	2023-09-26
5307597	5307597	DIVIDEND	ADD	464288752		0	0	1	0	.099455		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006737193			20230606.ifs	2023-06-06	2023-06-07
5253837	5253837	DIVIDEND	ADD	464288752		0	0	1	0	.140118		00	2023-03-23	2023-03-24	2023-03-29	2023-03-22		0	2023-03-23	?	0	0006698991			20230323.ifs	2023-03-23	2023-03-24
5162430	5162430	DIVIDEND	ADD	464288752		0	0	1	0	.123268		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629725			20221212.ifs	2022-12-12	2022-12-13
5103571	5103571	DIVIDEND	ADD	464288752		0	0	1	0	.14885		00	2022-09-26	2022-09-27	2022-09-30	2022-09-22		0	2022-09-23	?	0	0006588059			20220923.ifs	2022-09-23	2022-09-24
5030149	5030149	DIVIDEND	ADD	464288752		0	0	1	0	.101634		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536942			20220608.ifs	2022-06-08	2022-06-09
4976137	4976137	DIVIDEND	ADD	464288752		0	0	1	0	.147888		00	2022-03-24	2022-03-25	2022-03-30	2022-03-23		0	2022-03-23	?	0	0006498254			20220323.ifs	2022-03-23	2022-03-24
4877099	4877099	DIVIDEND	ADD	464288752		0	0	1	0	.068112		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417759			20211210.ifs	2021-12-10	2021-12-11
4808652	4808652	DIVIDEND	ADD	464288752		0	0	1	0	.090736		00	2021-09-24	2021-09-27	2021-09-30	2021-09-23		0	2021-09-23	?	0	0006371821			20210923.ifs	2021-09-23	2021-09-24
4725926	4725926	DIVIDEND	ADD	464288752		0	0	1	0	.071153		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320541			20210609.ifs	2021-06-09	2021-06-10
4661003	4661003	DIVIDEND	ADD	464288752		0	0	1	0	.077654		00	2021-03-25	2021-03-26	2021-03-31	2021-03-24		0	2021-03-24	?	0	0006281514			20210324.ifs	2021-03-24	2021-03-25
4539147	4539147	DIVIDEND	ADD	464288752		0	0	1	0	.077486		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209409			20201211.ifs	2020-12-11	2020-12-12
4467370	4467370	DIVIDEND	ADD	464288752		0	0	1	0	.0511		00	2020-09-23	2020-09-24	2020-09-29	2020-09-22		0	2020-09-22	?	0	0006162016			20200922.ifs	2020-09-22	2020-09-23
4391027	4391027	DIVIDEND	ADD	464288752		0	0	1	0	.053095		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112226			20200612.ifs	2020-06-12	2020-06-13
4252417	4252417	DIVIDEND	ADD	464288752		0	0	1	0	.077167		00	2020-03-25	2020-03-26	2020-03-31	2020-03-24		0	2020-03-24	?	0	0006072885			20200324.ifs	2020-03-24	2020-03-25
4252642	4252642	DIVIDEND	ADD	464288752		0	0	1	0	.077167		00	2020-03-25	2020-03-26	2020-03-31	2020-03-24		0	2020-03-24	?	0	0006072885			20200324.ifs	2020-03-24	2020-03-25
4067965	4067965	DIVIDEND	ADD	464288752		0	0	1	0	.055055		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000223			20191213.ifs	2019-12-13	2019-12-14
4068044	4068044	DIVIDEND	ADD	464288752		0	0	1	0	.055055		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000223			20191213.ifs	2019-12-13	2019-12-14
3933978	3933978	DIVIDEND	ADD	464288752		0	0	1	0	.050366		00	2019-09-24	2019-09-25	2019-09-30	2019-09-23		0	2019-09-23	?	0	0005949151			20190923.ifs	2019-09-23	2019-09-24
3933979	3933979	DIVIDEND	ADD	464288752		0	0	1	0	.050366		00	2019-09-24	2019-09-25	2019-09-30	2019-09-23		0	2019-09-23	?	0	0005949151			20190923.ifs	2019-09-23	2019-09-24
3780985	3780985	DIVIDEND	ADD	464288752		0	0	1	0	.055003		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898858			20190614.ifs	2019-06-14	2019-06-15
3781008	3781008	DIVIDEND	ADD	464288752		0	0	1	0	.055003		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898858			20190614.ifs	2019-06-14	2019-06-15
3638079	3638079	DIVIDEND	ADD	464288752		0	0	1	0	.061719		00	2019-03-20	2019-03-21	2019-03-26	2019-03-19		0	2019-03-19	?	0	0005855016			20190319.ifs	2019-03-19	2019-03-20
3638082	3638082	DIVIDEND	ADD	464288752		0	0	1	0	.061719		00	2019-03-20	2019-03-21	2019-03-26	2019-03-19		0	2019-03-19	?	0	0005855016			20190319.ifs	2019-03-19	2019-03-20
3442953	3442953	DIVIDEND	ADD	464288752		0	0	1	0	.056324		00	2018-12-17	2018-12-18	2018-12-21	2018-12-14		0	2018-12-14	?	0	0005781573			20181214.ifs	2018-12-14	2018-12-15
3443783	3443783	DIVIDEND	ADD	464288752		0	0	1	0	.056324		00	2018-12-17	2018-12-18	2018-12-21	2018-12-14		0	2018-12-14	?	0	0005781573			20181214.ifs	2018-12-14	2018-12-15
3299145	3299145	DIVIDEND	ADD	464288752		0	0	1	0	.040706		00	2018-09-26	2018-09-27	2018-10-02	2018-09-25		0	2018-09-25	?	0	0005728850			20180925.ifs	2018-09-25	2018-09-26
3299252	3299252	DIVIDEND	ADD	464288752		0	0	1	0	.040706		00	2018-09-26	2018-09-27	2018-10-02	2018-09-25		0	2018-09-25	?	0	0005728850			20180925.ifs	2018-09-25	2018-09-26
3000797	3000797	DIVIDEND	ADD	464288752		0	0	1	0	.047848		00	2018-03-22	2018-03-23	2018-03-28	2018-03-21		0	2018-03-21	?	0	0005632779			20180321.ifs	2018-03-21	2018-03-22
3000818	3000818	DIVIDEND	ADD	464288752		0	0	1	0	.047848		00	2018-03-22	2018-03-23	2018-03-28	2018-03-21		0	2018-03-21	?	0	0005632779			20180321.ifs	2018-03-21	2018-03-22
2839568	2839568	DIVIDEND	ADD	464288752		0	0	1	0	.0254		00	2017-12-19	2017-12-20	2017-12-26	2017-12-18		0	2017-12-18	?	0	0005564361			20171218.ifs	2017-12-18	2017-12-19
2686749	2686749	DIVIDEND	ADD	464288752		0	0	1	0	.032388		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005502068			20170925.ifs	2017-09-25	2017-09-26
2686796	2686796	DIVIDEND	ADD	464288752		0	0	1	0	.032388		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005502068			20170925.ifs	2017-09-25	2017-09-26
2642257	2642257	CORPACTION	ADD	464288752	04	X	2017-08-02	464288752	12	2017-08-02															20170802.ifs	2017-08-02	2017-08-03
2601189	2601189	DIVIDEND	ADD	464288752		0	0	1	0	.030916		00	2017-06-27	2017-06-29	2017-06-30	2017-06-26		0	2017-06-26	?	0	0005454912			20170626.ifs	2017-06-26	2017-06-27
2518856	2518856	DIVIDEND	ADD	464288752		0	0	1	0	.03296		00	2017-03-24	2017-03-28	2017-03-30	2017-03-23		0	2017-03-23	?	0	0005406961			20170323.ifs	2017-03-23	2017-03-24
2439858	2439858	EQUITY	CHANGE	464288752	ISHARES U.S. HOME CONSTRUCTION ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-02	?							20170123.ifs	2017-01-23	2017-01-24
2439859	2439858	EQUITY	CHANGE	464288752	ISHARES U.S. HOME CONSTRUCTION ETF	0	A	2006-05-05	?	4	no	no		no		2006-05-08	2013-07-02	?							20170123.ifs	2017-01-23	2017-01-24
2388209	2388209	DIVIDEND	ADD	464288752		0	0	1	0	.031285		00	2016-12-21	2016-12-23	2016-12-28	2016-12-20		0	2016-12-20	?	0	0005346408			20161220.ifs	2016-12-20	2016-12-21
2301178	2301178	DIVIDEND	ADD	464288752		0	0	1	0	.025281		00	2016-09-26	2016-09-28	2016-09-30	2016-09-23		0	2016-09-23	?	0	0005285129			20160923.ifs	2016-09-23	2016-09-24
2225300	2225300	DIVIDEND	ADD	464288752		0	0	1	0	.028455		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235533			20160620.ifs	2016-06-20	2016-06-21
2140469	2140469	DIVIDEND	ADD	464288752		0	0	1	0	.034157		00	2016-03-23	2016-03-28	2016-03-30	2016-03-22		0	2016-03-22	?	0	0005190726			20160322.ifs	2016-03-22	2016-03-23
2063475	2063475	DIVIDEND	ADD	464288752		0	0	1	0	.027548		00	2015-12-24	2015-12-29	2015-12-31	2015-12-23		0	2015-12-23	?	0	0005138830			20151223.ifs	2015-12-23	2015-12-24
1972243	1972243	DIVIDEND	ADD	464288752		0	0	1	0	.019803		00	2015-09-25	2015-09-29	2015-10-01	2015-09-24		0	2015-09-24	?	0	0005067354			20150924.ifs	2015-09-24	2015-09-25
1893624	1893624	DIVIDEND	ADD	464288752		0	0	1	0	.023021		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018465			20150623.ifs	2015-06-23	2015-06-24
1819285	1819285	DIVIDEND	ADD	464288752		0	0	1	0	.022385		00	2015-03-25	2015-03-27	2015-03-31	2015-03-24		0	2015-03-24	?	0	0004972952			20150324.ifs	2015-03-24	2015-03-25
1740539	1740539	DIVIDEND	ADD	464288752		0	0	1	0	.028907		00	2014-12-24	2014-12-29	2014-12-31	2014-12-23		0	2014-12-23	?	0	0004919641			20141223.ifs	2014-12-23	2014-12-24
1636514	1636514	DIVIDEND	ADD	464288752		0	0	1	0	.021367		00	2014-09-24	2014-09-26	2014-09-30	2014-09-23		0	2014-09-23	?	0	0004846746			20140923.ifs	2014-09-23	2014-09-24
1557040	1557040	DIVIDEND	ADD	464288752		0	0	1	0	.019781		00	2014-06-24	2014-06-26	2014-06-30	2014-06-23		0	2014-06-23	?	0	0004800717			20140623.ifs	2014-06-23	2014-06-24
1474535	1474535	DIVIDEND	ADD	464288752		0	0	1	0	.017987		00	2014-03-25	2014-03-27	2014-03-31	2014-03-24		0	2014-03-24	?	0	0004754648			20140324.ifs	2014-03-24	2014-03-25
1389363	1389363	DIVIDEND	ADD	464288752		0	0	1	0	.007412		00	2013-12-23	2013-12-26	2013-12-30	2013-12-20		0	2013-12-20	?	0	0004698563			20131220.ifs	2013-12-20	2013-12-21
1294253	1294253	DIVIDEND	ADD	464288752		0	0	1	0	.015047		00	2013-09-24	2013-09-26	2013-09-30	2013-09-23		0	2013-09-23	?	0	0004632694			20130923.ifs	2013-09-23	2013-09-24
1232214	1232214	EQUITY	CHANGE	464288752	ISHARES U.S. HOME CONSTRUCTION ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-01	?							20130702.ifs	2013-07-02	2013-07-03
1232215	1232214	EQUITY	CHANGE	464288752	ISHARES U.S. HOME CONSTRUCTION ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-02	?							20130702.ifs	2013-07-02	2013-07-03
1226594	1226594	CORPACTION	ADD	464288752	04	#	2013-07-01	464288752	04	?															20130701.ifs	2013-07-01	2013-07-02
1226595	1226595	CORPACTIONAUX	ADD	464288752	04	2013-07-01	ITB	ISHARES TR	ISHARES TRUST D	ITB	ISHARES TR	ISHARES U.S. HO	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226596	1226596	EQUITY	CHANGE	464288752	DJ US HOME CONSTN INDEX FD	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2008-03-13	?							20130701.ifs	2013-07-01	2013-07-02
1226597	1226596	EQUITY	CHANGE	464288752	ISHARES U.S. HOME CONSTRUCTION ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1217523	1217523	DIVIDEND	ADD	464288752		0	0	1	0	.00379		00	2013-06-26	2013-06-28	2013-07-02	2013-06-25		0	2013-06-25	?	0	0004588940			20130625.ifs	2013-06-25	2013-06-26
1140192	1140192	DIVIDEND	ADD	464288752		0	0	1	0	.004378		00	2013-03-25	2013-03-27	2013-04-01	2013-03-22		0	2013-03-22	?	0	0004545072			20130322.ifs	2013-03-22	2013-03-23
1060968	1060968	DIVIDEND	ADD	464288752		0	0	1	9	.020441		03	2012-12-27	2012-12-31	2013-01-03	2012-12-26		0	2012-12-26	?	0	0004496077			20121226.ifs	2012-12-26	2012-12-27
1047870	1047870	DIVIDEND	ADD	464288752		0	0	1	0	.059629		00	2012-12-19	2012-12-21	2012-12-26	2012-12-18		0	2012-12-18	?	0	0004485656			20121218.ifs	2012-12-18	2012-12-19
963415	963415	DIVIDEND	ADD	464288752		0	0	1	0	.012413		00	2012-09-25	2012-09-27	2012-10-01	2012-09-24		0	2012-09-24	?	0	0004433152			20120924.ifs	2012-09-24	2012-09-25
887470	887470	DIVIDEND	ADD	464288752		0	0	1	0	.021496		00	2012-06-19	2012-06-21	2012-06-25	2012-06-18		0	2012-06-18	?	0	0004387631			20120618.ifs	2012-06-18	2012-06-19
809528	809528	DIVIDEND	ADD	464288752		0	0	1	0	.017445		00	2012-03-26	2012-03-28	2012-03-30	2012-03-23		0	2012-03-23	?	0	0004349520			20120323.ifs	2012-03-23	2012-03-24
650814	650814	DIVIDEND	ADD	464288752		0	0	1	0	.031034		00	2011-09-23	2011-09-27	2011-09-29	2011-09-22		0	2011-09-22	?	0	0004245757			20110922.ifs	2011-09-22	2011-09-23
568280	568280	DIVIDEND	ADD	464288752		0	0	1	0	.019962		00	2011-06-24	2011-06-28	2011-06-30	2011-06-23		0	2011-06-23	?	0	0004205158			20110623.ifs	2011-06-23	2011-06-24
479651	479651	DIVIDEND	ADD	464288752		0	0	1	0	.021916		00	2011-03-25	2011-03-29	2011-03-31	2011-03-24		0	2011-03-24	?	0	0004163792			20110324.ifs	2011-03-24	2011-03-25
389316	389316	DIVIDEND	ADD	464288752		0	0	1	0	.019111		00	2010-12-22	2010-12-27	2010-12-29	2010-12-21		0	2010-12-21	?	0	0004114316			20101221.ifs	2010-12-21	2010-12-22
302843	302843	DIVIDEND	ADD	464288752		0	0	1	6	0		08	2010-09-23	2010-09-27	2010-09-29	2010-09-07		0	2010-09-07	?	0	0004058556			20100907.ifs	2010-09-07	2010-09-08
226814	226814	DIVIDEND	DELETE	464288752		0	0	1	6	0		08	2010-06-24	2010-06-28	2010-06-30	2010-06-03		0	2010-06-03	?	0	0004016445			20100623.ifs	2010-06-23	2010-06-24
226815	226815	DIVIDEND	ADD	464288752		0	0	1	0	.02228		00	2010-06-24	2010-06-28	2010-06-30	2010-06-03		1	2010-06-03	2010-06-23	0	0004016445			20100623.ifs	2010-06-23	2010-06-24
213136	213136	DIVIDEND	ADD	464288752		0	0	1	6	0		08	2010-06-24	2010-06-28	2010-06-30	2010-06-03		0	2010-06-03	?	0	0004016445			20100603.ifs	2010-06-03	2010-06-04
139614	139614	DIVIDEND	DELETE	464288752		0	0	1	6	0		08	2010-03-25	2010-03-29	2010-03-31	2010-03-18		0	2010-03-18	?	0	0003978833			20100324.ifs	2010-03-24	2010-04-07
139615	139615	DIVIDEND	ADD	464288752		0	0	1	0	.01958		00	2010-03-25	2010-03-29	2010-03-31	2010-03-18		1	2010-03-18	2010-03-24	0	0003978833			20100324.ifs	2010-03-24	2010-04-07
134913	134913	DIVIDEND	ADD	464288752		0	0	1	6	0		08	2010-03-25	2010-03-29	2010-03-31	2010-03-18		0	2010-03-18	?	0	0003978833			20100318.ifs	2010-03-18	2010-04-07
62782	62782	DIVIDEND	ADD	464288752		0	0	1	0	.02366		00	2009-12-23	2009-12-28	2009-12-30	2009-12-22		0	2009-12-22	?	0	0003936260			20091222.ifs	2009-12-22	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 = 152118
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