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
5573849	5573849	DIVIDEND	ADD	464288794		0	0	1	0	.363949		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931029			20240610.ifs	2024-06-10	2024-06-11
5519553	5519553	DIVIDEND	ADD	464288794		0	0	1	0	.353113		00	2024-03-21	2024-03-22	2024-03-27	2024-03-20		0	2024-03-20	?	0	0006892625			20240320.ifs	2024-03-20	2024-03-21
5450360	5450360	DIVIDEND	ADD	464288794		0	0	1	0	.437493		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840544			20231219.ifs	2023-12-19	2023-12-20
5380081	5380081	DIVIDEND	ADD	464288794		0	0	1	0	.578523		00	2023-09-26	2023-09-27	2023-10-02	2023-09-25		0	2023-09-25	?	0	0006787303			20230925.ifs	2023-09-25	2023-09-26
5307593	5307593	DIVIDEND	ADD	464288794		0	0	1	0	.506067		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006736996			20230606.ifs	2023-06-06	2023-06-07
5252898	5252898	DIVIDEND	ADD	464288794		0	0	1	0	.428995		00	2023-03-23	2023-03-24	2023-03-29	2023-03-22		0	2023-03-22	?	0	0006698855			20230322.ifs	2023-03-22	2023-03-23
5162426	5162426	DIVIDEND	ADD	464288794		0	0	1	0	.450663		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629493			20221212.ifs	2022-12-12	2022-12-13
5103567	5103567	DIVIDEND	ADD	464288794		0	0	1	0	.483118		00	2022-09-26	2022-09-27	2022-09-30	2022-09-23		0	2022-09-23	?	0	0006587978			20220923.ifs	2022-09-23	2022-09-24
5030145	5030145	DIVIDEND	ADD	464288794		0	0	1	0	.396428		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536785			20220608.ifs	2022-06-08	2022-06-09
4976133	4976133	DIVIDEND	ADD	464288794		0	0	1	0	.727636		00	2022-03-24	2022-03-25	2022-03-30	2022-03-23		0	2022-03-23	?	0	0006498166			20220323.ifs	2022-03-23	2022-03-24
4877095	4877095	DIVIDEND	ADD	464288794		0	0	1	0	.516568		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417586			20211210.ifs	2021-12-10	2021-12-11
4808648	4808648	DIVIDEND	ADD	464288794		0	0	1	0	.435256		00	2021-09-24	2021-09-27	2021-09-30	2021-09-23		0	2021-09-23	?	0	0006371652			20210923.ifs	2021-09-23	2021-09-24
4725922	4725922	DIVIDEND	ADD	464288794		0	0	1	0	.260823		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320411			20210609.ifs	2021-06-09	2021-06-10
4660999	4660999	DIVIDEND	ADD	464288794		0	0	1	0	.23427		00	2021-03-25	2021-03-26	2021-03-31	2021-03-24		0	2021-03-24	?	0	0006281423			20210324.ifs	2021-03-24	2021-03-25
4539143	4539143	DIVIDEND	ADD	464288794		0	0	1	0	.222022		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209245			20201211.ifs	2020-12-11	2020-12-12
4467366	4467366	DIVIDEND	ADD	464288794		0	0	1	0	.32678		00	2020-09-23	2020-09-24	2020-09-29	2020-09-22		0	2020-09-22	?	0	0006161951			20200922.ifs	2020-09-22	2020-09-23
4391023	4391023	DIVIDEND	ADD	464288794		0	0	1	0	.286958		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112118			20200612.ifs	2020-06-12	2020-06-13
4252410	4252410	DIVIDEND	ADD	464288794		0	0	1	0	.394555		00	2020-03-25	2020-03-26	2020-03-31	2020-03-24		0	2020-03-24	?	0	0006072815			20200324.ifs	2020-03-24	2020-03-25
4252634	4252634	DIVIDEND	ADD	464288794		0	0	1	0	.394555		00	2020-03-25	2020-03-26	2020-03-31	2020-03-24		0	2020-03-24	?	0	0006072815			20200324.ifs	2020-03-24	2020-03-25
4067957	4067957	DIVIDEND	ADD	464288794		0	0	1	0	.237154		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000074			20191213.ifs	2019-12-13	2019-12-14
4068036	4068036	DIVIDEND	ADD	464288794		0	0	1	0	.237154		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000074			20191213.ifs	2019-12-13	2019-12-14
3933970	3933970	DIVIDEND	ADD	464288794		0	0	1	0	.233487		00	2019-09-24	2019-09-25	2019-09-30	2019-09-23		0	2019-09-23	?	0	0005949060			20190923.ifs	2019-09-23	2019-09-24
3933971	3933971	DIVIDEND	ADD	464288794		0	0	1	0	.233487		00	2019-09-24	2019-09-25	2019-09-30	2019-09-23		0	2019-09-23	?	0	0005949060			20190923.ifs	2019-09-23	2019-09-24
3780977	3780977	DIVIDEND	ADD	464288794		0	0	1	0	.222988		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898626			20190614.ifs	2019-06-14	2019-06-15
3781000	3781000	DIVIDEND	ADD	464288794		0	0	1	0	.222988		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898626			20190614.ifs	2019-06-14	2019-06-15
3638071	3638071	DIVIDEND	ADD	464288794		0	0	1	0	.34647		00	2019-03-20	2019-03-21	2019-03-26	2019-03-19		0	2019-03-19	?	0	0005854888			20190319.ifs	2019-03-19	2019-03-20
3638074	3638074	DIVIDEND	ADD	464288794		0	0	1	0	.34647		00	2019-03-20	2019-03-21	2019-03-26	2019-03-19		0	2019-03-19	?	0	0005854888			20190319.ifs	2019-03-19	2019-03-20
3442945	3442945	DIVIDEND	ADD	464288794		0	0	1	0	.243169		00	2018-12-17	2018-12-18	2018-12-21	2018-12-14		0	2018-12-14	?	0	0005781478			20181214.ifs	2018-12-14	2018-12-15
3443775	3443775	DIVIDEND	ADD	464288794		0	0	1	0	.243169		00	2018-12-17	2018-12-18	2018-12-21	2018-12-14		0	2018-12-14	?	0	0005781478			20181214.ifs	2018-12-14	2018-12-15
3299137	3299137	DIVIDEND	ADD	464288794		0	0	1	0	.267768		00	2018-09-26	2018-09-27	2018-10-02	2018-09-25		0	2018-09-25	?	0	0005728796			20180925.ifs	2018-09-25	2018-09-26
3299244	3299244	DIVIDEND	ADD	464288794		0	0	1	0	.267768		00	2018-09-26	2018-09-27	2018-10-02	2018-09-25		0	2018-09-25	?	0	0005728796			20180925.ifs	2018-09-25	2018-09-26
3000789	3000789	DIVIDEND	ADD	464288794		0	0	1	0	.185478		00	2018-03-22	2018-03-23	2018-03-28	2018-03-21		0	2018-03-21	?	0	0005632736			20180321.ifs	2018-03-21	2018-03-22
3000810	3000810	DIVIDEND	ADD	464288794		0	0	1	0	.185478		00	2018-03-22	2018-03-23	2018-03-28	2018-03-21		0	2018-03-21	?	0	0005632736			20180321.ifs	2018-03-21	2018-03-22
2839564	2839564	DIVIDEND	ADD	464288794		0	0	1	0	.235121		00	2017-12-19	2017-12-20	2017-12-26	2017-12-18		0	2017-12-18	?	0	0005564343			20171218.ifs	2017-12-18	2017-12-19
2686741	2686741	DIVIDEND	ADD	464288794		0	0	1	0	.165695		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005501995			20170925.ifs	2017-09-25	2017-09-26
2686788	2686788	DIVIDEND	ADD	464288794		0	0	1	0	.165695		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005501995			20170925.ifs	2017-09-25	2017-09-26
2601185	2601185	DIVIDEND	ADD	464288794		0	0	1	0	.20819		00	2017-06-27	2017-06-29	2017-06-30	2017-06-26		0	2017-06-26	?	0	0005454904			20170626.ifs	2017-06-26	2017-06-27
2518852	2518852	DIVIDEND	ADD	464288794		0	0	1	0	.253516		00	2017-03-24	2017-03-28	2017-03-30	2017-03-23		0	2017-03-23	?	0	0005406953			20170323.ifs	2017-03-23	2017-03-24
2439866	2439866	EQUITY	CHANGE	464288794	US BROKER-DEALERS & SECURITIES EXCHANGES ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2015-12-01	?							20170123.ifs	2017-01-23	2017-01-24
2439867	2439866	EQUITY	CHANGE	464288794	US BROKER-DEALERS & SECURITIES EXCHANGES ETF	0	A	2006-05-05	?	4	no	no		no		2006-05-08	2015-12-01	?							20170123.ifs	2017-01-23	2017-01-24
2388205	2388205	DIVIDEND	ADD	464288794		0	0	1	0	.186474		00	2016-12-21	2016-12-23	2016-12-28	2016-12-20		0	2016-12-20	?	0	0005346376			20161220.ifs	2016-12-20	2016-12-21
2301174	2301174	DIVIDEND	ADD	464288794		0	0	1	0	.134803		00	2016-09-26	2016-09-28	2016-09-30	2016-09-23		0	2016-09-23	?	0	0005285121			20160923.ifs	2016-09-23	2016-09-24
2225294	2225294	DIVIDEND	ADD	464288794		0	0	1	0	.154155		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235504			20160620.ifs	2016-06-20	2016-06-21
2140465	2140465	DIVIDEND	ADD	464288794		0	0	1	0	.259498		00	2016-03-23	2016-03-28	2016-03-30	2016-03-22		0	2016-03-22	?	0	0005190702			20160322.ifs	2016-03-22	2016-03-23
2063471	2063471	DIVIDEND	ADD	464288794		0	0	1	0	.242822		00	2015-12-24	2015-12-29	2015-12-31	2015-12-23		0	2015-12-23	?	0	0005138779			20151223.ifs	2015-12-23	2015-12-24
2017694	2017694	CORPACTION	ADD	464288794	04	#	2015-12-01	464288794	04	?															20151201.ifs	2015-12-01	2015-12-02
2017695	2017695	CORPACTIONAUX	ADD	464288794	04	2015-12-01	IAI	ISHARES TR	ISHARES TRUST -	IAI	ISHARES TR	US BROKER-DEALE	2015-12-01	?											20151201.ifs	2015-12-01	2015-12-02
2017696	2017696	EQUITY	CHANGE	464288794	US BROKER-DEALERS ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-01	?							20151201.ifs	2015-12-01	2015-12-02
2017697	2017696	EQUITY	CHANGE	464288794	US BROKER-DEALERS & SECURITIES EXCHANGES ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2015-12-01	?							20151201.ifs	2015-12-01	2015-12-02
1972239	1972239	DIVIDEND	ADD	464288794		0	0	1	0	.119936		00	2015-09-25	2015-09-29	2015-10-01	2015-09-24		0	2015-09-24	?	0	0005067346			20150924.ifs	2015-09-24	2015-09-25
1893620	1893620	DIVIDEND	ADD	464288794		0	0	1	0	.091486		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018434			20150623.ifs	2015-06-23	2015-06-24
1819281	1819281	DIVIDEND	ADD	464288794		0	0	1	0	.089382		00	2015-03-25	2015-03-27	2015-03-31	2015-03-24		0	2015-03-24	?	0	0004972928			20150324.ifs	2015-03-24	2015-03-25
1740535	1740535	DIVIDEND	ADD	464288794		0	0	1	0	.179339		00	2014-12-24	2014-12-29	2014-12-31	2014-12-23		0	2014-12-23	?	0	0004919677			20141223.ifs	2014-12-23	2014-12-24
1636510	1636510	DIVIDEND	ADD	464288794		0	0	1	0	.089899		00	2014-09-24	2014-09-26	2014-09-30	2014-09-23		0	2014-09-23	?	0	0004846723			20140923.ifs	2014-09-23	2014-09-24
1557036	1557036	DIVIDEND	ADD	464288794		0	0	1	0	.106514		00	2014-06-24	2014-06-26	2014-06-30	2014-06-23		0	2014-06-23	?	0	0004800692			20140623.ifs	2014-06-23	2014-06-24
1474531	1474531	DIVIDEND	ADD	464288794		0	0	1	0	.106284		00	2014-03-25	2014-03-27	2014-03-31	2014-03-24		0	2014-03-24	?	0	0004754624			20140324.ifs	2014-03-24	2014-03-25
1389359	1389359	DIVIDEND	ADD	464288794		0	0	1	0	.190951		00	2013-12-23	2013-12-26	2013-12-30	2013-12-20		0	2013-12-20	?	0	0004698555			20131220.ifs	2013-12-20	2013-12-21
1294249	1294249	DIVIDEND	ADD	464288794		0	0	1	0	.093301		00	2013-09-24	2013-09-26	2013-09-30	2013-09-23		0	2013-09-23	?	0	0004632686			20130923.ifs	2013-09-23	2013-09-24
1226965	1226965	CORPACTION	ADD	464288794	04	#	2013-07-01	464288794	04	?															20130701.ifs	2013-07-01	2013-07-02
1226966	1226966	CORPACTIONAUX	ADD	464288794	04	2013-07-01	IAI	ISHARES TR	DOW JONES US BR	IAI	ISHARES TR	US BROKER-DEALE	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226967	1226967	EQUITY	CHANGE	464288794	DJ US BROKER-DEALERS INDX FD	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2008-03-25	?							20130701.ifs	2013-07-01	2013-07-02
1226968	1226967	EQUITY	CHANGE	464288794	US BROKER-DEALERS ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1217519	1217519	DIVIDEND	ADD	464288794		0	0	1	0	.073864		00	2013-06-26	2013-06-28	2013-07-02	2013-06-25		0	2013-06-25	?	0	0004588932			20130625.ifs	2013-06-25	2013-06-26
1140188	1140188	DIVIDEND	ADD	464288794		0	0	1	0	.076559		00	2013-03-25	2013-03-27	2013-04-01	2013-03-22		0	2013-03-22	?	0	0004545064			20130322.ifs	2013-03-22	2013-03-23
1060966	1060966	DIVIDEND	ADD	464288794		0	0	1	9	.025617		03	2012-12-27	2012-12-31	2013-01-03	2012-12-26		0	2012-12-26	?	0	0004496063			20121226.ifs	2012-12-26	2012-12-27
1047866	1047866	DIVIDEND	ADD	464288794		0	0	1	0	.354619		00	2012-12-19	2012-12-21	2012-12-26	2012-12-18		0	2012-12-18	?	0	0004485647			20121218.ifs	2012-12-18	2012-12-19
963411	963411	DIVIDEND	ADD	464288794		0	0	1	0	.088761		00	2012-09-25	2012-09-27	2012-10-01	2012-09-24		0	2012-09-24	?	0	0004433144			20120924.ifs	2012-09-24	2012-09-25
887466	887466	DIVIDEND	ADD	464288794		0	0	1	0	.137862		00	2012-06-19	2012-06-21	2012-06-25	2012-06-18		0	2012-06-18	?	0	0004387623			20120618.ifs	2012-06-18	2012-06-19
809524	809524	DIVIDEND	ADD	464288794		0	0	1	0	.094397		00	2012-03-26	2012-03-28	2012-03-30	2012-03-23		0	2012-03-23	?	0	0004349516			20120323.ifs	2012-03-23	2012-03-24
650810	650810	DIVIDEND	ADD	464288794		0	0	1	0	.065543		00	2011-09-23	2011-09-27	2011-09-29	2011-09-22		0	2011-09-22	?	0	0004245749			20110922.ifs	2011-09-22	2011-09-23
568276	568276	DIVIDEND	ADD	464288794		0	0	1	0	.072994		00	2011-06-24	2011-06-28	2011-06-30	2011-06-23		0	2011-06-23	?	0	0004205150			20110623.ifs	2011-06-23	2011-06-24
479647	479647	DIVIDEND	ADD	464288794		0	0	1	0	.045194		00	2011-03-25	2011-03-29	2011-03-31	2011-03-24		0	2011-03-24	?	0	0004163784			20110324.ifs	2011-03-24	2011-03-25
389312	389312	DIVIDEND	ADD	464288794		0	0	1	0	.344556		00	2010-12-22	2010-12-27	2010-12-29	2010-12-21		0	2010-12-21	?	0	0004114309			20101221.ifs	2010-12-21	2010-12-22
302839	302839	DIVIDEND	ADD	464288794		0	0	1	6	0		08	2010-09-23	2010-09-27	2010-09-29	2010-09-07		0	2010-09-07	?	0	0004058563			20100907.ifs	2010-09-07	2010-09-08
226806	226806	DIVIDEND	DELETE	464288794		0	0	1	6	0		08	2010-06-24	2010-06-28	2010-06-30	2010-06-03		0	2010-06-03	?	0	0004016450			20100623.ifs	2010-06-23	2010-06-24
226807	226807	DIVIDEND	ADD	464288794		0	0	1	0	.04115		00	2010-06-24	2010-06-28	2010-06-30	2010-06-03		1	2010-06-03	2010-06-23	0	0004016450			20100623.ifs	2010-06-23	2010-06-24
213132	213132	DIVIDEND	ADD	464288794		0	0	1	6	0		08	2010-06-24	2010-06-28	2010-06-30	2010-06-03		0	2010-06-03	?	0	0004016450			20100603.ifs	2010-06-03	2010-06-04
139606	139606	DIVIDEND	DELETE	464288794		0	0	1	6	0		08	2010-03-25	2010-03-29	2010-03-31	2010-03-18		0	2010-03-18	?	0	0003978826			20100324.ifs	2010-03-24	2010-04-07
139607	139607	DIVIDEND	ADD	464288794		0	0	1	0	.04415		00	2010-03-25	2010-03-29	2010-03-31	2010-03-18		1	2010-03-18	2010-03-24	0	0003978826			20100324.ifs	2010-03-24	2010-04-07
134909	134909	DIVIDEND	ADD	464288794		0	0	1	6	0		08	2010-03-25	2010-03-29	2010-03-31	2010-03-18		0	2010-03-18	?	0	0003978826			20100318.ifs	2010-03-18	2010-04-07
62778	62778	DIVIDEND	ADD	464288794		0	0	1	0	.03148		00	2009-12-23	2009-12-28	2009-12-30	2009-12-22		0	2009-12-22	?	0	0003936251			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 = 151968
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