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
5583487	5583487	DIVIDEND	ADD	921910873		0	0	1	0	.6177		00	2024-06-27	2024-06-27	2024-07-01	2024-06-25		0	2024-06-26	?	0	0006937786			20240626.ifs	2024-06-26	2024-06-27
5519374	5519374	DIVIDEND	ADD	921910873		0	0	1	0	.58		00	2024-03-21	2024-03-22	2024-03-26	2024-03-19		0	2024-03-20	?	0	0006891967			20240320.ifs	2024-03-20	2024-03-21
5448877	5448877	DIVIDEND	ADD	921910873		0	0	1	0	.6737		00	2023-12-21	2023-12-22	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840848			20231219.ifs	2023-12-19	2023-12-20
5376823	5376823	DIVIDEND	ADD	921910873		0	0	1	0	.5723		00	2023-09-21	2023-09-22	2023-09-26	2023-09-19		0	2023-09-20	?	0	0006785105			20230920.ifs	2023-09-20	2023-09-21
5316332	5316332	DIVIDEND	ADD	921910873		0	0	1	0	.5424		00	2023-06-23	2023-06-26	2023-06-28	2023-06-21		0	2023-06-22	?	0	0006742048			20230622.ifs	2023-06-22	2023-06-23
5251879	5251879	DIVIDEND	ADD	921910873		0	0	1	0	.501		00	2023-03-23	2023-03-24	2023-03-28	2023-03-21		0	2023-03-21	?	0	0006698241			20230321.ifs	2023-03-21	2023-03-22
5178872	5178872	DIVIDEND	ADD	921910873		0	0	1	0	.6042		00	2022-12-22	2022-12-23	2022-12-28	2022-12-20		0	2022-12-20	?	0	0006645420			20221220.ifs	2022-12-20	2022-12-21
5104450	5104450	DIVIDEND	ADD	921910873		0	0	1	0	.5891		00	2022-09-28	2022-09-29	2022-10-03	2022-09-26		0	2022-09-26	?	0	0006588349			20220926.ifs	2022-09-26	2022-09-27
5036968	5036968	DIVIDEND	ADD	921910873		0	0	1	0	.5123		00	2022-06-23	2022-06-24	2022-06-28	2022-06-21		0	2022-06-21	?	0	0006541596			20220621.ifs	2022-06-21	2022-06-22
4975975	4975975	DIVIDEND	ADD	921910873		0	0	1	0	.475		00	2022-03-24	2022-03-25	2022-03-29	2022-03-22		0	2022-03-23	?	0	0006497734			20220323.ifs	2022-03-23	2022-03-24
4907153	4907153	DIVIDEND	ADD	921910873		0	0	1	0	.5536		00	2021-12-27	2021-12-28	2021-12-30	2021-12-22		0	2021-12-22	?	0	0006446432			20211222.ifs	2021-12-22	2021-12-23
4810875	4810875	DIVIDEND	ADD	921910873		0	0	1	0	.5115		00	2021-09-29	2021-09-30	2021-10-04	2021-09-27		0	2021-09-28	?	0	0006372555			20210928.ifs	2021-09-28	2021-09-29
4735013	4735013	DIVIDEND	ADD	921910873		0	0	1	0	.4653		00	2021-06-24	2021-06-25	2021-06-29	2021-06-22		0	2021-06-22	?	0	0006325595			20210622.ifs	2021-06-22	2021-06-23
4660779	4660779	DIVIDEND	ADD	921910873		0	0	1	0	.4339		00	2021-03-26	2021-03-29	2021-03-31	2021-03-24		0	2021-03-24	?	0	0006281468			20210324.ifs	2021-03-24	2021-03-25
4566634	4566634	DIVIDEND	ADD	921910873		0	0	1	0	.608		00	2020-12-24	2020-12-28	2020-12-30	2020-12-22		0	2020-12-22	?	0	0006230647			20201222.ifs	2020-12-22	2020-12-23
4458857	4458857	DIVIDEND	ADD	921910873		0	0	1	0	.4012		00	2020-09-11	2020-09-14	2020-09-16	2020-09-09		0	2020-09-09	?	0	0006157078			20200909.ifs	2020-09-09	2020-09-10
4399048	4399048	DIVIDEND	ADD	921910873		0	0	1	0	.4634		00	2020-06-25	2020-06-26	2020-06-30	2020-06-23		0	2020-06-24	?	0	0006117006			20200624.ifs	2020-06-24	2020-06-25
4254917	4254917	DIVIDEND	ADD	921910873		0	0	1	0	.4619		00	2020-03-26	2020-03-27	2020-03-31	2020-03-24		0	2020-03-25	?	0	0006072955			20200325.ifs	2020-03-25	2020-03-26
4254918	4254918	DIVIDEND	ADD	921910873		0	0	1	0	.4619		00	2020-03-26	2020-03-27	2020-03-31	2020-03-24		0	2020-03-25	?	0	0006072955			20200325.ifs	2020-03-25	2020-03-26
4102729	4102729	DIVIDEND	ADD	921910873		0	0	1	0	.5168		00	2019-12-24	2019-12-26	2019-12-30	2019-12-20		0	2019-12-20	?	0	0006019220			20191220.ifs	2019-12-20	2019-12-21
4103595	4103595	DIVIDEND	ADD	921910873		0	0	1	0	.5168		00	2019-12-24	2019-12-26	2019-12-30	2019-12-20		0	2019-12-20	?	0	0006019220			20191220.ifs	2019-12-20	2019-12-21
3943426	3943426	DIVIDEND	ADD	921910873		0	0	1	0	.5046		00	2019-10-01	2019-10-02	2019-10-04	2019-09-27		0	2019-09-27	?	0	0005952764			20190927.ifs	2019-09-27	2019-09-28
3943428	3943428	DIVIDEND	ADD	921910873		0	0	1	0	.5046		00	2019-10-01	2019-10-02	2019-10-04	2019-09-27		0	2019-09-27	?	0	0005952764			20190927.ifs	2019-09-27	2019-09-28
3798983	3798983	DIVIDEND	ADD	921910873		0	0	1	0	.5204		00	2019-06-27	2019-06-28	2019-07-02	2019-06-25		0	2019-06-25	?	0	0005904147			20190625.ifs	2019-06-25	2019-06-26
3799003	3799003	DIVIDEND	ADD	921910873		0	0	1	0	.5204		00	2019-06-27	2019-06-28	2019-07-02	2019-06-25		0	2019-06-25	?	0	0005904147			20190625.ifs	2019-06-25	2019-06-26
3641864	3641864	DIVIDEND	ADD	921910873		0	0	1	0	.481		00	2019-03-25	2019-03-26	2019-03-28	2019-03-21		0	2019-03-21	?	0	0005856389			20190321.ifs	2019-03-21	2019-03-22
3641865	3641865	DIVIDEND	ADD	921910873		0	0	1	0	.481		00	2019-03-25	2019-03-26	2019-03-28	2019-03-21		0	2019-03-21	?	0	0005856389			20190321.ifs	2019-03-21	2019-03-22
3474263	3474263	DIVIDEND	ADD	921910873		0	0	1	0	.5143		00	2018-12-24	2018-12-26	2018-12-28	2018-12-20		0	2018-12-20	?	0	0005799616			20181220.ifs	2018-12-20	2018-12-21
3474289	3474289	DIVIDEND	ADD	921910873		0	0	1	0	.5143		00	2018-12-24	2018-12-26	2018-12-28	2018-12-20		0	2018-12-20	?	0	0005799616			20181220.ifs	2018-12-20	2018-12-21
3154539	3154539	DIVIDEND	ADD	921910873		0	0	1	0	.4575		00	2018-06-28	2018-06-29	2018-07-03	2018-06-26		0	2018-06-26	?	0	0005681044			20180626.ifs	2018-06-26	2018-06-27
3154542	3154542	DIVIDEND	ADD	921910873		0	0	1	0	.4575		00	2018-06-28	2018-06-29	2018-07-03	2018-06-26		0	2018-06-26	?	0	0005681044			20180626.ifs	2018-06-26	2018-06-27
2997942	2997942	DIVIDEND	ADD	921910873		0	0	1	0	.3721		00	2018-03-22	2018-03-23	2018-03-27	2018-03-20		0	2018-03-20	?	0	0005631992			20180320.ifs	2018-03-20	2018-03-21
2998089	2998089	DIVIDEND	ADD	921910873		0	0	1	0	.3721		00	2018-03-22	2018-03-23	2018-03-27	2018-03-20		0	2018-03-20	?	0	0005631992			20180320.ifs	2018-03-20	2018-03-21
2857514	2857514	DIVIDEND	ADD	921910873		0	0	1	0	.4612		00	2017-12-26	2017-12-27	2017-12-29	2017-12-21		0	2017-12-21	?	0	0005576521			20171221.ifs	2017-12-21	2017-12-22
2686318	2686318	DIVIDEND	ADD	921910873		0	0	1	0	.473		00	2017-09-27	2017-09-28	2017-10-02	2017-09-25		0	2017-09-25	?	0	0005501877			20170925.ifs	2017-09-25	2017-09-26
2686367	2686367	DIVIDEND	ADD	921910873		0	0	1	0	.473		00	2017-09-27	2017-09-28	2017-10-02	2017-09-25		0	2017-09-25	?	0	0005501877			20170925.ifs	2017-09-25	2017-09-26
2597250	2597250	DIVIDEND	ADD	921910873		0	0	1	0	.403		00	2017-06-23	2017-06-27	2017-06-29	2017-06-21		0	2017-06-21	?	0	0005452965			20170621.ifs	2017-06-21	2017-06-22
2521597	2521597	DIVIDEND	ADD	921910873		0	0	1	0	.338		00	2017-03-29	2017-03-31	2017-04-04	2017-03-27		0	2017-03-28	?	0	0005407841			20170328.ifs	2017-03-28	2017-03-29
2379037	2379037	DIVIDEND	ADD	921910873		0	0	1	0	.471		00	2016-12-20	2016-12-22	2016-12-27	2016-12-16		0	2016-12-16	?	0	0005340889			20161216.ifs	2016-12-16	2016-12-17
2295506	2295506	DIVIDEND	ADD	921910873		0	0	1	0	.422		00	2016-09-20	2016-09-22	2016-09-26	2016-09-16		0	2016-09-16	?	0	0005282209			20160916.ifs	2016-09-16	2016-09-17
2225091	2225091	DIVIDEND	ADD	921910873		0	0	1	0	.368		00	2016-06-21	2016-06-23	2016-06-27	2016-06-17		0	2016-06-20	?	0	0005235153			20160620.ifs	2016-06-20	2016-06-21
2138325	2138325	DIVIDEND	ADD	921910873		0	0	1	0	.369		00	2016-03-21	2016-03-23	2016-03-28	2016-03-17		0	2016-03-18	?	0	0005188774			20160318.ifs	2016-03-18	2016-03-19
2039196	2039196	DIVIDEND	ADD	921910873		0	0	1	0	.427		00	2015-12-17	2015-12-21	2015-12-23	2015-12-15		0	2015-12-15	?	0	0005118934			20151215.ifs	2015-12-15	2015-12-16
1967581	1967581	DIVIDEND	ADD	921910873		0	0	1	0	.371		00	2015-09-21	2015-09-23	2015-09-25	2015-09-17		0	2015-09-17	?	0	0005063835			20150917.ifs	2015-09-17	2015-09-18
1888937	1888937	DIVIDEND	ADD	921910873		0	0	1	0	.357		00	2015-06-22	2015-06-24	2015-06-26	2015-06-18		0	2015-06-18	?	0	0005016013			20150618.ifs	2015-06-18	2015-06-19
1815571	1815571	DIVIDEND	ADD	921910873		0	0	1	0	.314		00	2015-03-23	2015-03-25	2015-03-27	2015-03-19		0	2015-03-19	?	0	0004970803			20150319.ifs	2015-03-19	2015-03-20
1721912	1721912	DIVIDEND	ADD	921910873		0	0	1	0	.376		00	2014-12-18	2014-12-22	2014-12-24	2014-12-16		0	2014-12-17	?	0	0004902349			20141217.ifs	2014-12-17	2014-12-18
1632600	1632600	DIVIDEND	ADD	921910873		0	0	1	0	.315		00	2014-09-22	2014-09-24	2014-09-26	2014-09-18		0	2014-09-18	?	0	0004844649			20140918.ifs	2014-09-18	2014-09-19
1553321	1553321	DIVIDEND	ADD	921910873		0	0	1	0	.306		00	2014-06-23	2014-06-25	2014-06-27	2014-06-19		0	2014-06-19	?	0	0004798802			20140619.ifs	2014-06-19	2014-06-20
1471538	1471538	DIVIDEND	ADD	921910873		0	0	1	0	.276		00	2014-03-24	2014-03-26	2014-03-28	2014-03-20		0	2014-03-20	?	0	0004753305			20140320.ifs	2014-03-20	2014-03-21
1392103	1392103	DIVIDEND	CHANGE	921910873		0	0	1	0	.359		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		0	2013-12-18	?	0	0004692378			20131223.ifs	2013-12-23	2013-12-24
1392104	1392103	DIVIDEND	CHANGE	921910873		0	0	1	0	.359		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		1	2013-12-18	2013-12-23	0	0004692378			20131223.ifs	2013-12-23	2013-12-24
1379159	1379159	DIVIDEND	ADD	921910873		0	0	1	0	.359		00	2013-12-20	2013-12-24	2013-12-27	2013-12-18		0	2013-12-18	?	0	0004692378			20131218.ifs	2013-12-18	2013-12-19
1295519	1295519	DIVIDEND	CHANGE	921910873		0	0	1	0	.296		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		0	2013-09-19	?	0	0004631235			20130924.ifs	2013-09-24	2013-09-25
1295520	1295519	DIVIDEND	CHANGE	921910873		0	0	1	0	.296		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		1	2013-09-19	2013-09-24	0	0004631235			20130924.ifs	2013-09-24	2013-09-25
1290851	1290851	DIVIDEND	ADD	921910873		0	0	1	0	.296		00	2013-09-23	2013-09-25	2013-09-27	2013-09-19		0	2013-09-19	?	0	0004631235			20130919.ifs	2013-09-19	2013-09-20
1217068	1217068	DIVIDEND	CHANGE	921910873		0	0	1	0	.285		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586718			20130625.ifs	2013-06-25	2013-06-26
1217069	1217068	DIVIDEND	CHANGE	921910873		0	0	1	0	.285		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		1	2013-06-20	2013-06-25	0	0004586718			20130625.ifs	2013-06-25	2013-06-26
1212980	1212980	DIVIDEND	ADD	921910873		0	0	1	0	.285		00	2013-06-24	2013-06-26	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586718			20130620.ifs	2013-06-20	2013-06-21
1141269	1141269	DIVIDEND	CHANGE	921910873		0	0	1	0	.236		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		0	2013-03-20	?	0	0004543631			20130325.ifs	2013-03-25	2013-03-26
1141270	1141269	DIVIDEND	CHANGE	921910873		0	0	1	0	.236		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		1	2013-03-20	2013-03-25	0	0004543631			20130325.ifs	2013-03-25	2013-03-26
1137470	1137470	DIVIDEND	ADD	921910873		0	0	1	0	.236		00	2013-03-22	2013-03-26	2013-03-28	2013-03-20		0	2013-03-20	?	0	0004543631			20130320.ifs	2013-03-20	2013-03-21
1099433	1099433	CORPACTION	ADD	921910873	04	#	2013-01-31	921910873	04	?															20130131.ifs	2013-01-31	2013-02-01
1099434	1099434	CORPACTIONAUX	ADD	921910873	04	2013-01-31	MGC	VANGUARD WORLD FD	VANGUARD WORLD	MGC	VANGUARD WORLD FD	VANGUARD MEGA C	2013-01-31	?											20130131.ifs	2013-01-31	2013-02-01
1099435	1099435	EQUITY	CHANGE	921910873	MEGA CAP 300 INDEX-ETF	0	A	2007-12-21	?	0	no	no		no		?	2008-03-19	?							20130131.ifs	2013-01-31	2013-02-01
1099436	1099435	EQUITY	CHANGE	921910873	VANGUARD MEGA CAP ETF	0	A	2007-12-21	?	0	no	no		no		?	2013-01-31	?							20130131.ifs	2013-01-31	2013-02-01
1046595	1046595	DIVIDEND	ADD	921910873		0	0	1	0	.377		00	2012-12-20	2012-12-24	2012-12-27	2012-12-18		0	2012-12-18	?	0	0004485820			20121218.ifs	2012-12-18	2012-12-19
965499	965499	DIVIDEND	CHANGE	921910873		0	0	1	0	.292		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		0	2012-09-20	?	0	0004431813			20120926.ifs	2012-09-26	2012-09-27
965500	965499	DIVIDEND	CHANGE	921910873		0	0	1	0	.292		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		1	2012-09-20	2012-09-26	0	0004431813			20120926.ifs	2012-09-26	2012-09-27
960121	960121	DIVIDEND	ADD	921910873		0	0	1	0	.292		00	2012-09-24	2012-09-26	2012-09-28	2012-09-20		0	2012-09-20	?	0	0004431813			20120920.ifs	2012-09-20	2012-09-21
893831	893831	DIVIDEND	CHANGE	921910873		0	0	1	0	.223		00	2012-06-25	2012-06-27	2012-06-29	2012-06-21		0	2012-06-21	?	0	0004390030			20120626.ifs	2012-06-26	2012-06-27
893832	893831	DIVIDEND	CHANGE	921910873		0	0	1	0	.223		00	2012-06-25	2012-06-27	2012-06-29	2012-06-21		1	2012-06-21	2012-06-26	0	0004390030			20120626.ifs	2012-06-26	2012-06-27
890732	890732	DIVIDEND	ADD	921910873		0	0	1	0	.223		00	2012-06-25	2012-06-27	2012-06-29	2012-06-21		0	2012-06-21	?	0	0004390030			20120621.ifs	2012-06-21	2012-06-22
813791	813791	DIVIDEND	CHANGE	921910873		0	0	1	0	.213		00	2012-03-26	2012-03-28	2012-03-30	2012-03-22		0	2012-03-22	?	0	0004348877			20120329.ifs	2012-03-29	2012-03-30
813792	813791	DIVIDEND	CHANGE	921910873		0	0	1	0	.213		00	2012-03-26	2012-03-28	2012-03-30	2012-03-22		1	2012-03-22	2012-03-29	0	0004348877			20120329.ifs	2012-03-29	2012-03-30
807986	807986	DIVIDEND	ADD	921910873		0	0	1	0	.213		00	2012-03-26	2012-03-28	2012-03-30	2012-03-22		0	2012-03-22	?	0	0004348877			20120322.ifs	2012-03-22	2012-03-23
730121	730121	DIVIDEND	ADD	921910873		0	0	1	0	.277		00	2011-12-21	2011-12-23	2011-12-28	2011-12-19		0	2011-12-19	?	0	0004295323			20111219.ifs	2011-12-19	2011-12-20
653263	653263	DIVIDEND	CHANGE	921910873		0	0	1	0	.215		00	2011-09-23	2011-09-27	2011-09-29	2011-09-21		0	2011-09-21	?	0	0004245149			20110926.ifs	2011-09-26	2011-09-27
653264	653263	DIVIDEND	CHANGE	921910873		0	0	1	0	.215		00	2011-09-23	2011-09-27	2011-09-29	2011-09-21		1	2011-09-21	2011-09-26	0	0004245149			20110926.ifs	2011-09-26	2011-09-27
649296	649296	DIVIDEND	ADD	921910873		0	0	1	0	.215		00	2011-09-23	2011-09-27	2011-09-29	2011-09-21		0	2011-09-21	?	0	0004245149			20110921.ifs	2011-09-21	2011-09-22
570664	570664	DIVIDEND	CHANGE	921910873		0	0	1	0	.216		00	2011-06-24	2011-06-28	2011-06-30	2011-06-22		0	2011-06-22	?	0	0004204482			20110627.ifs	2011-06-27	2011-06-28
570665	570664	DIVIDEND	CHANGE	921910873		0	0	1	0	.216		00	2011-06-24	2011-06-28	2011-06-30	2011-06-22		1	2011-06-22	2011-06-27	0	0004204482			20110627.ifs	2011-06-27	2011-06-28
566932	566932	DIVIDEND	ADD	921910873		0	0	1	0	.216		00	2011-06-24	2011-06-28	2011-06-30	2011-06-22		0	2011-06-22	?	0	0004204482			20110622.ifs	2011-06-22	2011-06-23
478367	478367	DIVIDEND	ADD	921910873		0	0	1	0	.182		00	2011-03-25	2011-03-29	2011-03-31	2011-03-23		0	2011-03-23	?	0	0004163098			20110323.ifs	2011-03-23	2011-03-24
385594	385594	DIVIDEND	ADD	921910873		0	0	1	0	.228		00	2010-12-22	2010-12-27	2010-12-29	2010-12-20		0	2010-12-20	?	0	0004112239			20101220.ifs	2010-12-20	2010-12-21
225078	225078	DIVIDEND	ADD	921910873		0	0	1	0	.191		00	2010-06-24	2010-06-28	2010-06-30	2010-06-22		0	2010-06-22	?	0	0004021828			20100622.ifs	2010-06-22	2010-06-23
137929	137929	DIVIDEND	ADD	921910873		0	0	1	0	.16		00	2010-03-25	2010-03-29	2010-03-31	2010-03-23		0	2010-03-23	?	0	0003981571			20100323.ifs	2010-03-23	2010-04-07
55691	55691	DIVIDEND	ADD	921910873		0	0	1	0	.285		00	2009-12-22	2009-12-24	2009-12-29	2009-12-18		0	2009-12-18	?	0	0003931429			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 = 152194
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