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
5583489	5583489	DIVIDEND	ADD	921910840		0	0	1	0	.7344		00	2024-06-27	2024-06-27	2024-07-01	2024-06-25		0	2024-06-26	?	0	0006937788			20240626.ifs	2024-06-26	2024-06-27
5519376	5519376	DIVIDEND	ADD	921910840		0	0	1	0	.6984		00	2024-03-21	2024-03-22	2024-03-26	2024-03-19		0	2024-03-20	?	0	0006891962			20240320.ifs	2024-03-20	2024-03-21
5448878	5448878	DIVIDEND	ADD	921910840		0	0	1	0	.769		00	2023-12-21	2023-12-22	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840850			20231219.ifs	2023-12-19	2023-12-20
5376825	5376825	DIVIDEND	ADD	921910840		0	0	1	0	.6848		00	2023-09-21	2023-09-22	2023-09-26	2023-09-19		0	2023-09-20	?	0	0006785107			20230920.ifs	2023-09-20	2023-09-21
5316334	5316334	DIVIDEND	ADD	921910840		0	0	1	0	.6606		00	2023-06-23	2023-06-26	2023-06-28	2023-06-21		0	2023-06-22	?	0	0006742043			20230622.ifs	2023-06-22	2023-06-23
5251880	5251880	DIVIDEND	ADD	921910840		0	0	1	0	.5926		00	2023-03-23	2023-03-24	2023-03-28	2023-03-21		0	2023-03-21	?	0	0006698243			20230321.ifs	2023-03-21	2023-03-22
5178873	5178873	DIVIDEND	ADD	921910840		0	0	1	0	.702		00	2022-12-22	2022-12-23	2022-12-28	2022-12-20		0	2022-12-20	?	0	0006645422			20221220.ifs	2022-12-20	2022-12-21
5104451	5104451	DIVIDEND	ADD	921910840		0	0	1	0	.6774		00	2022-09-28	2022-09-29	2022-10-03	2022-09-26		0	2022-09-26	?	0	0006588351			20220926.ifs	2022-09-26	2022-09-27
5036969	5036969	DIVIDEND	ADD	921910840		0	0	1	0	.5968		00	2022-06-23	2022-06-24	2022-06-28	2022-06-21		0	2022-06-21	?	0	0006541598			20220621.ifs	2022-06-21	2022-06-22
4975977	4975977	DIVIDEND	ADD	921910840		0	0	1	0	.5468		00	2022-03-24	2022-03-25	2022-03-29	2022-03-22		0	2022-03-23	?	0	0006497768			20220323.ifs	2022-03-23	2022-03-24
4907154	4907154	DIVIDEND	ADD	921910840		0	0	1	0	.6572		00	2021-12-27	2021-12-28	2021-12-30	2021-12-22		0	2021-12-22	?	0	0006446434			20211222.ifs	2021-12-22	2021-12-23
4810877	4810877	DIVIDEND	ADD	921910840		0	0	1	0	.6217		00	2021-09-29	2021-09-30	2021-10-04	2021-09-27		0	2021-09-28	?	0	0006372557			20210928.ifs	2021-09-28	2021-09-29
4735014	4735014	DIVIDEND	ADD	921910840		0	0	1	0	.5465		00	2021-06-24	2021-06-25	2021-06-29	2021-06-22		0	2021-06-22	?	0	0006325597			20210622.ifs	2021-06-22	2021-06-23
4660780	4660780	DIVIDEND	ADD	921910840		0	0	1	0	.4939		00	2021-03-26	2021-03-29	2021-03-31	2021-03-24		0	2021-03-24	?	0	0006281470			20210324.ifs	2021-03-24	2021-03-25
4566635	4566635	DIVIDEND	ADD	921910840		0	0	1	0	.6513		00	2020-12-24	2020-12-28	2020-12-30	2020-12-22		0	2020-12-22	?	0	0006230712			20201222.ifs	2020-12-22	2020-12-23
4458858	4458858	DIVIDEND	ADD	921910840		0	0	1	0	.4566		00	2020-09-11	2020-09-14	2020-09-16	2020-09-09		0	2020-09-09	?	0	0006157080			20200909.ifs	2020-09-09	2020-09-10
4399050	4399050	DIVIDEND	ADD	921910840		0	0	1	0	.5262		00	2020-06-25	2020-06-26	2020-06-30	2020-06-23		0	2020-06-24	?	0	0006117008			20200624.ifs	2020-06-24	2020-06-25
4254921	4254921	DIVIDEND	ADD	921910840		0	0	1	0	.5072		00	2020-03-26	2020-03-27	2020-03-31	2020-03-24		0	2020-03-25	?	0	0006072957			20200325.ifs	2020-03-25	2020-03-26
4254922	4254922	DIVIDEND	ADD	921910840		0	0	1	0	.5072		00	2020-03-26	2020-03-27	2020-03-31	2020-03-24		0	2020-03-25	?	0	0006072957			20200325.ifs	2020-03-25	2020-03-26
4102731	4102731	DIVIDEND	ADD	921910840		0	0	1	0	.5989		00	2019-12-24	2019-12-26	2019-12-30	2019-12-20		0	2019-12-20	?	0	0006019222			20191220.ifs	2019-12-20	2019-12-21
4103597	4103597	DIVIDEND	ADD	921910840		0	0	1	0	.5989		00	2019-12-24	2019-12-26	2019-12-30	2019-12-20		0	2019-12-20	?	0	0006019222			20191220.ifs	2019-12-20	2019-12-21
3943427	3943427	DIVIDEND	ADD	921910840		0	0	1	0	.5749		00	2019-10-01	2019-10-02	2019-10-04	2019-09-27		0	2019-09-27	?	0	0005952767			20190927.ifs	2019-09-27	2019-09-28
3943430	3943430	DIVIDEND	ADD	921910840		0	0	1	0	.5749		00	2019-10-01	2019-10-02	2019-10-04	2019-09-27		0	2019-09-27	?	0	0005952767			20190927.ifs	2019-09-27	2019-09-28
3798985	3798985	DIVIDEND	ADD	921910840		0	0	1	0	.5726		00	2019-06-27	2019-06-28	2019-07-02	2019-06-25		0	2019-06-25	?	0	0005904149			20190625.ifs	2019-06-25	2019-06-26
3799006	3799006	DIVIDEND	ADD	921910840		0	0	1	0	.5726		00	2019-06-27	2019-06-28	2019-07-02	2019-06-25		0	2019-06-25	?	0	0005904149			20190625.ifs	2019-06-25	2019-06-26
3641866	3641866	DIVIDEND	ADD	921910840		0	0	1	0	.5963		00	2019-03-25	2019-03-26	2019-03-28	2019-03-21		0	2019-03-21	?	0	0005856391			20190321.ifs	2019-03-21	2019-03-22
3641867	3641867	DIVIDEND	ADD	921910840		0	0	1	0	.5963		00	2019-03-25	2019-03-26	2019-03-28	2019-03-21		0	2019-03-21	?	0	0005856391			20190321.ifs	2019-03-21	2019-03-22
3474265	3474265	DIVIDEND	ADD	921910840		0	0	1	0	.5136		00	2018-12-24	2018-12-26	2018-12-28	2018-12-20		0	2018-12-20	?	0	0005799618			20181220.ifs	2018-12-20	2018-12-21
3474291	3474291	DIVIDEND	ADD	921910840		0	0	1	0	.5136		00	2018-12-24	2018-12-26	2018-12-28	2018-12-20		0	2018-12-20	?	0	0005799618			20181220.ifs	2018-12-20	2018-12-21
3154541	3154541	DIVIDEND	ADD	921910840		0	0	1	0	.4605		00	2018-06-28	2018-06-29	2018-07-03	2018-06-26		0	2018-06-26	?	0	0005681046			20180626.ifs	2018-06-26	2018-06-27
3154544	3154544	DIVIDEND	ADD	921910840		0	0	1	0	.4605		00	2018-06-28	2018-06-29	2018-07-03	2018-06-26		0	2018-06-26	?	0	0005681046			20180626.ifs	2018-06-26	2018-06-27
2997944	2997944	DIVIDEND	ADD	921910840		0	0	1	0	.4154		00	2018-03-22	2018-03-23	2018-03-27	2018-03-20		0	2018-03-20	?	0	0005631994			20180320.ifs	2018-03-20	2018-03-21
2998091	2998091	DIVIDEND	ADD	921910840		0	0	1	0	.4154		00	2018-03-22	2018-03-23	2018-03-27	2018-03-20		0	2018-03-20	?	0	0005631994			20180320.ifs	2018-03-20	2018-03-21
2857515	2857515	DIVIDEND	ADD	921910840		0	0	1	0	.4726		00	2017-12-26	2017-12-27	2017-12-29	2017-12-21		0	2017-12-21	?	0	0005576530			20171221.ifs	2017-12-21	2017-12-22
2686320	2686320	DIVIDEND	ADD	921910840		0	0	1	0	.512		00	2017-09-27	2017-09-28	2017-10-02	2017-09-25		0	2017-09-25	?	0	0005501879			20170925.ifs	2017-09-25	2017-09-26
2686369	2686369	DIVIDEND	ADD	921910840		0	0	1	0	.512		00	2017-09-27	2017-09-28	2017-10-02	2017-09-25		0	2017-09-25	?	0	0005501879			20170925.ifs	2017-09-25	2017-09-26
2597251	2597251	DIVIDEND	ADD	921910840		0	0	1	0	.413		00	2017-06-23	2017-06-27	2017-06-29	2017-06-21		0	2017-06-21	?	0	0005452967			20170621.ifs	2017-06-21	2017-06-22
2521599	2521599	DIVIDEND	ADD	921910840		0	0	1	0	.394		00	2017-03-29	2017-03-31	2017-04-04	2017-03-27		0	2017-03-28	?	0	0005407843			20170328.ifs	2017-03-28	2017-03-29
2379038	2379038	DIVIDEND	ADD	921910840		0	0	1	0	.492		00	2016-12-20	2016-12-22	2016-12-27	2016-12-16		0	2016-12-16	?	0	0005340891			20161216.ifs	2016-12-16	2016-12-17
2296892	2296892	DIVIDEND	ADD	921910840		0	0	1	0	.431		00	2016-09-20	2016-09-22	2016-09-26	2016-09-16		0	2016-09-19	?	0	0005282348			20160919.ifs	2016-09-19	2016-09-20
2225093	2225093	DIVIDEND	ADD	921910840		0	0	1	0	.386		00	2016-06-21	2016-06-23	2016-06-27	2016-06-17		0	2016-06-20	?	0	0005235155			20160620.ifs	2016-06-20	2016-06-21
2138326	2138326	DIVIDEND	ADD	921910840		0	0	1	0	.386		00	2016-03-21	2016-03-23	2016-03-28	2016-03-17		0	2016-03-18	?	0	0005188776			20160318.ifs	2016-03-18	2016-03-19
2039198	2039198	DIVIDEND	ADD	921910840		0	0	1	0	.431		00	2015-12-17	2015-12-21	2015-12-31	2015-12-15		0	2015-12-15	?	0	0005118965			20151215.ifs	2015-12-15	2015-12-16
1967583	1967583	DIVIDEND	ADD	921910840		0	0	1	0	.388		00	2015-09-21	2015-09-23	2015-09-25	2015-09-17		0	2015-09-17	?	0	0005063849			20150917.ifs	2015-09-17	2015-09-18
1888939	1888939	DIVIDEND	ADD	921910840		0	0	1	0	.36		00	2015-06-22	2015-06-24	2015-06-26	2015-06-18		0	2015-06-18	?	0	0005016024			20150618.ifs	2015-06-18	2015-06-19
1815573	1815573	DIVIDEND	ADD	921910840		0	0	1	0	.348		00	2015-03-23	2015-03-25	2015-03-27	2015-03-19		0	2015-03-19	?	0	0004970805			20150319.ifs	2015-03-19	2015-03-20
1721914	1721914	DIVIDEND	ADD	921910840		0	0	1	0	.4		00	2014-12-18	2014-12-22	2014-12-24	2014-12-16		0	2014-12-17	?	0	0004902351			20141217.ifs	2014-12-17	2014-12-18
1632602	1632602	DIVIDEND	ADD	921910840		0	0	1	0	.353		00	2014-09-22	2014-09-24	2014-09-26	2014-09-18		0	2014-09-18	?	0	0004844652			20140918.ifs	2014-09-18	2014-09-19
1553323	1553323	DIVIDEND	ADD	921910840		0	0	1	0	.316		00	2014-06-23	2014-06-25	2014-06-27	2014-06-19		0	2014-06-19	?	0	0004798804			20140619.ifs	2014-06-19	2014-06-20
1471540	1471540	DIVIDEND	ADD	921910840		0	0	1	0	.302		00	2014-03-24	2014-03-26	2014-03-28	2014-03-20		0	2014-03-20	?	0	0004753307			20140320.ifs	2014-03-20	2014-03-21
1392105	1392105	DIVIDEND	CHANGE	921910840		0	0	1	0	.371		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		0	2013-12-18	?	0	0004692380			20131223.ifs	2013-12-23	2013-12-24
1392106	1392105	DIVIDEND	CHANGE	921910840		0	0	1	0	.371		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		1	2013-12-18	2013-12-23	0	0004692380			20131223.ifs	2013-12-23	2013-12-24
1379161	1379161	DIVIDEND	ADD	921910840		0	0	1	0	.371		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		0	2013-12-18	?	0	0004692380			20131218.ifs	2013-12-18	2013-12-19
1295521	1295521	DIVIDEND	CHANGE	921910840		0	0	1	0	.31		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		0	2013-09-19	?	0	0004631237			20130924.ifs	2013-09-24	2013-09-25
1295522	1295521	DIVIDEND	CHANGE	921910840		0	0	1	0	.31		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		1	2013-09-19	2013-09-24	0	0004631237			20130924.ifs	2013-09-24	2013-09-25
1290853	1290853	DIVIDEND	ADD	921910840		0	0	1	0	.31		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		0	2013-09-19	?	0	0004631237			20130919.ifs	2013-09-19	2013-09-20
1217072	1217072	DIVIDEND	CHANGE	921910840		0	0	1	0	.304		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586723			20130625.ifs	2013-06-25	2013-06-26
1217073	1217072	DIVIDEND	CHANGE	921910840		0	0	1	0	.304		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		1	2013-06-20	2013-06-25	0	0004586723			20130625.ifs	2013-06-25	2013-06-26
1212982	1212982	DIVIDEND	ADD	921910840		0	0	1	0	.304		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586723			20130620.ifs	2013-06-20	2013-06-21
1161299	1161299	CORPACTION	ADD	921910840	04	#	2013-04-17	921910840	04	?															20130417.ifs	2013-04-17	2013-04-18
1161300	1161300	CORPACTIONAUX	ADD	921910840	04	2013-04-17	MGV	VANGUARD WORLD FD	VANGUARD WORLD	MGV	VANGUARD WORLD FD	MEGA CAP VALUE	2013-04-17	?											20130417.ifs	2013-04-17	2013-04-18
1161301	1161301	EQUITY	CHANGE	921910840	MEGA CAP 300 VALUE INDEX ETF	0	A	2007-12-21	?	0	no	no		no		?	2008-03-19	?							20130417.ifs	2013-04-17	2013-04-18
1161302	1161301	EQUITY	CHANGE	921910840	MEGA CAP VALUE ETF	0	A	2007-12-21	?	0	no	no		no		?	2013-04-17	?							20130417.ifs	2013-04-17	2013-04-18
1141271	1141271	DIVIDEND	CHANGE	921910840		0	0	1	0	.275		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		0	2013-03-20	?	0	0004543634			20130325.ifs	2013-03-25	2013-03-26
1141272	1141271	DIVIDEND	CHANGE	921910840		0	0	1	0	.275		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		1	2013-03-20	2013-03-25	0	0004543634			20130325.ifs	2013-03-25	2013-03-26
1137472	1137472	DIVIDEND	ADD	921910840		0	0	1	0	.275		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		0	2013-03-20	?	0	0004543634			20130320.ifs	2013-03-20	2013-03-21
1046597	1046597	DIVIDEND	ADD	921910840		0	0	1	0	.347		00	2012-12-20	2012-12-24	2012-12-27	2012-12-18		0	2012-12-18	?	0	0004485831			20121218.ifs	2012-12-18	2012-12-19
965501	965501	DIVIDEND	CHANGE	921910840		0	0	1	0	.305		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		0	2012-09-20	?	0	0004431816			20120926.ifs	2012-09-26	2012-09-27
965502	965501	DIVIDEND	CHANGE	921910840		0	0	1	0	.305		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		1	2012-09-20	2012-09-26	0	0004431816			20120926.ifs	2012-09-26	2012-09-27
960123	960123	DIVIDEND	ADD	921910840		0	0	1	0	.305		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		0	2012-09-20	?	0	0004431816			20120920.ifs	2012-09-20	2012-09-21
893833	893833	DIVIDEND	CHANGE	921910840		0	0	1	0	.286		00	2012-06-25	2012-06-27	2012-06-29	2012-06-21		0	2012-06-21	?	0	0004390032			20120626.ifs	2012-06-26	2012-06-27
893834	893833	DIVIDEND	CHANGE	921910840		0	0	1	0	.286		00	2012-06-25	2012-06-27	2012-06-29	2012-06-21		1	2012-06-21	2012-06-26	0	0004390032			20120626.ifs	2012-06-26	2012-06-27
890734	890734	DIVIDEND	ADD	921910840		0	0	1	0	.286		00	2012-06-25	2012-06-27	2012-06-29	2012-06-21		0	2012-06-21	?	0	0004390032			20120621.ifs	2012-06-21	2012-06-22
813795	813795	DIVIDEND	CHANGE	921910840		0	0	1	0	.258		00	2012-03-26	2012-03-28	2012-03-30	2012-03-22		0	2012-03-22	?	0	0004348886			20120329.ifs	2012-03-29	2012-03-30
813796	813795	DIVIDEND	CHANGE	921910840		0	0	1	0	.258		00	2012-03-26	2012-03-28	2012-03-30	2012-03-22		1	2012-03-22	2012-03-29	0	0004348886			20120329.ifs	2012-03-29	2012-03-30
807988	807988	DIVIDEND	ADD	921910840		0	0	1	0	.258		00	2012-03-26	2012-03-28	2012-03-30	2012-03-22		0	2012-03-22	?	0	0004348886			20120322.ifs	2012-03-22	2012-03-23
730123	730123	DIVIDEND	ADD	921910840		0	0	1	0	.323		00	2011-12-21	2011-12-23	2011-12-28	2011-12-19		0	2011-12-19	?	0	0004295326			20111219.ifs	2011-12-19	2011-12-20
653265	653265	DIVIDEND	CHANGE	921910840		0	0	1	0	.276		00	2011-09-23	2011-09-27	2011-09-29	2011-09-21		0	2011-09-21	?	0	0004245151			20110926.ifs	2011-09-26	2011-09-27
653266	653265	DIVIDEND	CHANGE	921910840		0	0	1	0	.276		00	2011-09-23	2011-09-27	2011-09-29	2011-09-21		1	2011-09-21	2011-09-26	0	0004245151			20110926.ifs	2011-09-26	2011-09-27
649298	649298	DIVIDEND	ADD	921910840		0	0	1	0	.276		00	2011-09-23	2011-09-27	2011-09-29	2011-09-21		0	2011-09-21	?	0	0004245151			20110921.ifs	2011-09-21	2011-09-22
570666	570666	DIVIDEND	CHANGE	921910840		0	0	1	0	.24		00	2011-06-24	2011-06-28	2011-06-30	2011-06-22		0	2011-06-22	?	0	0004204484			20110627.ifs	2011-06-27	2011-06-28
570667	570666	DIVIDEND	CHANGE	921910840		0	0	1	0	.24		00	2011-06-24	2011-06-28	2011-06-30	2011-06-22		1	2011-06-22	2011-06-27	0	0004204484			20110627.ifs	2011-06-27	2011-06-28
566934	566934	DIVIDEND	ADD	921910840		0	0	1	0	.24		00	2011-06-24	2011-06-28	2011-06-30	2011-06-22		0	2011-06-22	?	0	0004204484			20110622.ifs	2011-06-22	2011-06-23
478369	478369	DIVIDEND	ADD	921910840		0	0	1	0	.21		00	2011-03-25	2011-03-29	2011-03-31	2011-03-23		0	2011-03-23	?	0	0004163100			20110323.ifs	2011-03-23	2011-03-24
385596	385596	DIVIDEND	ADD	921910840		0	0	1	0	.262		00	2010-12-22	2010-12-27	2010-12-29	2010-12-20		0	2010-12-20	?	0	0004112241			20101220.ifs	2010-12-20	2010-12-21
225080	225080	DIVIDEND	ADD	921910840		0	0	1	0	.208		00	2010-06-24	2010-06-28	2010-06-30	2010-06-22		0	2010-06-22	?	0	0004021830			20100622.ifs	2010-06-22	2010-06-23
137931	137931	DIVIDEND	ADD	921910840		0	0	1	0	.2		00	2010-03-25	2010-03-29	2010-03-31	2010-03-23		0	2010-03-23	?	0	0003981574			20100323.ifs	2010-03-23	2010-04-07
55693	55693	DIVIDEND	ADD	921910840		0	0	1	0	.323		00	2009-12-22	2009-12-24	2009-12-29	2009-12-18		0	2009-12-18	?	0	0003931434			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 = 152196
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