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
5517027	5517027	DIVIDEND	ADD	Y002A1105		6	0	3	0	1.1907		28	?	2024-05-30	2024-06-14	2024-03-15		0	2024-03-15	?	0	0006890360			20240315.ifs	2024-03-15	2024-03-16
5357628	5357628	DIVIDEND	ADD	Y002A1105		6	0	3	0	.4229		28	?	2023-09-11	2023-09-26	2023-08-24		0	2023-08-24	?	0	0006771349			20230824.ifs	2023-08-24	2023-08-25
5247101	5247101	DIVIDEND	ADD	Y002A1105		6	0	3	0	1.134		28	?	2023-05-24	2023-06-09	2023-03-10		0	2023-03-10	?	0	0006694787			20230310.ifs	2023-03-10	2023-03-11
5082459	5082459	DIVIDEND	ADD	Y002A1105		6	0	3	0	.4028		28	?	2022-09-13	2022-09-29	2022-08-25		0	2022-08-25	?	0	0006572752			20220825.ifs	2022-08-25	2022-08-26
4971158	4971158	DIVIDEND	ADD	Y002A1105		6	0	3	0	1.08		28	?	2022-05-25	2022-06-10	2022-03-15		0	2022-03-15	?	0	0006494652			20220315.ifs	2022-03-15	2022-03-16
4782621	4782621	DIVIDEND	ADD	Y002A1105		6	0	3	0	.38		28	?	2021-09-03	2021-09-21	2021-08-17		0	2021-08-17	?	0	0006354051			20210817.ifs	2021-08-17	2021-08-18
4652333	4652333	DIVIDEND	ADD	Y002A1105		6	0	3	0	1.003		28	?	2021-05-26	2021-06-10	2021-03-12		0	2021-03-12	?	0	0006276925			20210312.ifs	2021-03-12	2021-03-13
4443077	4443077	DIVIDEND	ADD	Y002A1105		6	0	3	0	.35		28	?	2020-09-08	2020-09-24	2020-08-20		0	2020-08-20	?	0	0006145574			20200820.ifs	2020-08-20	2020-08-21
4385436	4385436	DIVIDEND	ADD	Y002A1105		6	0	3	0	.933		28	?	2020-06-04	2020-06-19	2020-06-03		0	2020-06-03	?	0	0006109615			20200603.ifs	2020-06-03	2020-06-04
4385933	4385933	DIVIDEND	ADD	Y002A1105		6	0	3	0	.933		28	?	2020-06-04	2020-06-19	2020-06-03		0	2020-06-03	?	0	0006109615			20200603.ifs	2020-06-03	2020-06-04
3943324	3943324	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.333		28	?	2019-09-10	2019-09-26	2019-08-26		0	2019-08-26	?	0	0005933103			20190927.ifs	2019-09-27	2019-09-28
3943326	3943325	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.333		28	?	2019-09-10	2019-09-26	2019-08-26		1	2019-08-26	2019-09-27	0	0005933103			20190927.ifs	2019-09-27	2019-09-28
3943329	3943329	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.333		28	?	2019-09-10	2019-09-26	2019-08-26		0	2019-08-26	?	0	0005933103			20190927.ifs	2019-09-27	2019-09-28
3943331	3943330	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.333		28	?	2019-09-10	2019-09-26	2019-08-26		1	2019-08-26	2019-09-27	0	0005933103			20190927.ifs	2019-09-27	2019-09-28
3890344	3890344	DIVIDEND	ADD	Y002A1105		6	0	3	0	.333		28	?	2019-09-10	2019-09-26	2019-08-26		0	2019-08-26	?	0	0005933103			20190826.ifs	2019-08-26	2019-08-27
3890345	3890345	DIVIDEND	ADD	Y002A1105		6	0	3	0	.333		28	?	2019-09-10	2019-09-26	2019-08-26		0	2019-08-26	?	0	0005933103			20190826.ifs	2019-08-26	2019-08-27
3774930	3774930	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		1	2019-03-19	2019-06-11	1	0005854253			20190612.ifs	2019-06-12	2019-06-13
3774931	3774931	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		1	2019-03-19	2019-06-11	1	0005854253			20190612.ifs	2019-06-12	2019-06-13
3774932	3774931	DIVIDEND	CHANGE	Y002A1105		6	0	3	9	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		1	2019-03-19	2019-06-12	1	0005854253			20190612.ifs	2019-06-12	2019-06-13
3774933	3774932	DIVIDEND	CHANGE	Y002A1105		6	0	3	9	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		1	2019-03-19	2019-06-12	1	0005854253			20190612.ifs	2019-06-12	2019-06-13
3773916	3773916	DIVIDEND	CHANGE	Y002A1105		6	0	3	9	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	2019-03-20	1	0005854253			20190611.ifs	2019-06-11	2019-06-12
3773917	3773917	DIVIDEND	CHANGE	Y002A1105		6	0	3	9	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	2019-03-20	1	0005854253			20190611.ifs	2019-06-11	2019-06-12
3773918	3773917	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		1	2019-03-19	2019-06-11	1	0005854253			20190611.ifs	2019-06-11	2019-06-12
3773919	3773918	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		1	2019-03-19	2019-06-11	1	0005854253			20190611.ifs	2019-06-11	2019-06-12
3773920	3773920	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.848		28	?	2019-05-22	2019-06-06	2019-03-18		0	2019-03-19	?	0	0005854252			20190611.ifs	2019-06-11	2019-06-12
3773921	3773921	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.848		28	?	2019-05-22	2019-06-06	2019-03-18		0	2019-03-19	?	0	0005854252			20190611.ifs	2019-06-11	2019-06-12
3773922	3773921	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.848		28	?	2019-05-22	2019-06-06	2019-03-18		1	2019-03-19	2019-06-11	0	0005854252			20190611.ifs	2019-06-11	2019-06-12
3773923	3773922	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.848		28	?	2019-05-22	2019-06-06	2019-03-18		1	2019-03-19	2019-06-11	0	0005854252			20190611.ifs	2019-06-11	2019-06-12
3639262	3639262	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.095		28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	?	1	0005854253			20190320.ifs	2019-03-20	2019-03-21
3639263	3639262	DIVIDEND	CHANGE	Y002A1105		6	0	3	9	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	2019-03-20	1	0005854253			20190320.ifs	2019-03-20	2019-03-21
3639275	3639275	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.095		28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	?	1	0005854253			20190320.ifs	2019-03-20	2019-03-21
3639277	3639276	DIVIDEND	CHANGE	Y002A1105		6	0	3	9	.095	0	28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	2019-03-20	1	0005854253			20190320.ifs	2019-03-20	2019-03-21
3636950	3636950	DIVIDEND	ADD	Y002A1105		6	0	3	0	.095		28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	?	1	0005854253			20190319.ifs	2019-03-19	2019-03-20
3636953	3636953	DIVIDEND	ADD	Y002A1105		6	0	3	0	.848		28	?	2019-05-22	2019-06-06	2019-03-18		0	2019-03-19	?	0	0005854252			20190319.ifs	2019-03-19	2019-03-20
3636954	3636954	DIVIDEND	ADD	Y002A1105		6	0	3	0	.095		28	?	2019-05-22	2019-06-06	2019-03-19		0	2019-03-19	?	1	0005854253			20190319.ifs	2019-03-19	2019-03-20
3636956	3636956	DIVIDEND	ADD	Y002A1105		6	0	3	0	.848		28	?	2019-05-22	2019-06-06	2019-03-18		0	2019-03-19	?	0	0005854252			20190319.ifs	2019-03-19	2019-03-20
3255427	3255427	DIVIDEND	ADD	Y002A1105		6	0	3	0	.292		28	?	2018-09-11	2018-09-28	2018-08-31		0	2018-08-31	?	0	0005713686			20180831.ifs	2018-08-31	2018-09-01
3255502	3255502	DIVIDEND	ADD	Y002A1105		6	0	3	0	.292		28	?	2018-09-11	2018-09-28	2018-08-31		0	2018-08-31	?	0	0005713686			20180831.ifs	2018-08-31	2018-09-01
3134401	3134401	DIVIDEND	ADD	Y002A1105		6	0	3	0	.7438		28	?	2018-05-24	2018-06-08	2018-05-11		0	?	2018-06-12	0	0005660542			20180612.ifs	2018-06-12	2018-06-13
3134474	3134474	DIVIDEND	ADD	Y002A1105		6	0	3	0	.7438		28	?	2018-05-24	2018-06-08	2018-05-11		0	?	2018-06-12	0	0005660542			20180612.ifs	2018-06-12	2018-06-13
2661337	2661337	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2562		28	?	2017-08-15	2017-08-31	2017-08-01		0	2017-08-01	?	0	0005477214			20170901.ifs	2017-09-01	2017-09-02
2661338	2661337	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2562		28	?	2017-08-15	2017-08-31	2017-08-01		1	2017-08-01	2017-09-01	0	0005477214			20170901.ifs	2017-09-01	2017-09-02
2637866	2637866	DIVIDEND	ADD	Y002A1105		6	0	3	0	.2562		28	?	2017-08-15	2017-08-31	2017-08-01		0	2017-08-01	?	0	0005477214			20170801.ifs	2017-08-01	2017-08-02
2580322	2580322	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.6375		28	?	2017-05-17	2017-05-31	2017-02-27		0	2017-02-27	?	0	0005391733			20170601.ifs	2017-06-01	2017-06-02
2580323	2580322	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.6375		28	?	2017-05-17	2017-05-31	2017-02-27		1	2017-02-27	2017-06-01	0	0005391733			20170601.ifs	2017-06-01	2017-06-02
2496276	2496276	DIVIDEND	ADD	Y002A1105		6	0	3	0	.6375		28	?	2017-05-17	2017-05-31	2017-02-27		0	2017-02-27	?	0	0005391733			20170227.ifs	2017-02-27	2017-02-28
2288722	2288722	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.219		28	?	2016-08-15	2016-08-31	2016-08-02		0	2016-08-02	?	0	0005262298			20160906.ifs	2016-09-06	2016-09-07
2288723	2288722	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.219		28	?	2016-08-15	2016-08-31	2016-08-02		1	2016-08-02	2016-09-06	0	0005262298			20160906.ifs	2016-09-06	2016-09-07
2263831	2263831	DIVIDEND	ADD	Y002A1105		6	0	3	0	.219		28	?	2016-08-15	2016-08-31	2016-08-02		0	2016-08-02	?	0	0005262298			20160802.ifs	2016-08-02	2016-08-03
2125091	2125091	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.51		28	?	2016-05-10	2016-05-27	2016-02-29		0	2016-02-29	?	0	0005177713			20160301.ifs	2016-03-01	2016-03-02
2125092	2125091	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.51		28	?	2016-05-10	2016-05-27	2016-02-29		1	2016-02-29	2016-03-01	0	0005177713			20160301.ifs	2016-03-01	2016-03-02
2121287	2121287	DIVIDEND	ADD	Y002A1105		6	0	3	0	.51		28	?	2016-05-10	2016-05-27	2016-02-29		0	2016-02-29	?	0	0005177713			20160229.ifs	2016-02-29	2016-03-01
1954062	1954062	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.1872		28	?	2015-08-12	2015-08-28	2015-07-29		1	2015-07-29	2015-07-30	0	0005036729			20150901.ifs	2015-09-01	2015-09-02
1954063	1954062	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.1872		28	?	2015-08-12	2015-08-28	2015-07-29		2	2015-07-29	2015-09-01	0	0005036729			20150901.ifs	2015-09-01	2015-09-02
1925751	1925751	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.1872		28	?	2015-08-12	2015-08-28	2015-07-29		0	2015-07-29	?	0	0005036729			20150730.ifs	2015-07-30	2015-07-31
1925752	1925751	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.1872		28	?	2015-08-12	2015-08-28	2015-07-29		1	2015-07-29	2015-07-30	0	0005036729			20150730.ifs	2015-07-30	2015-07-31
1924827	1924827	DIVIDEND	ADD	Y002A1105		6	0	3	0	.1872		28	?	2015-08-12	2015-08-28	2015-07-29		0	2015-07-29	?	0	0005036729			20150729.ifs	2015-07-29	2015-07-30
1619395	1619395	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.16		28	?	2014-08-13	2014-08-29	2014-07-30		1	2014-07-30	2014-07-31	0	0004818657			20140902.ifs	2014-09-02	2014-09-03
1619396	1619395	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.16		28	?	2014-08-13	2014-08-29	2014-07-30		2	2014-07-30	2014-09-02	0	0004818657			20140902.ifs	2014-09-02	2014-09-03
1590662	1590662	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.16		28	?	2014-08-13	2014-08-29	2014-07-30		0	2014-07-30	?	0	0004818657			20140731.ifs	2014-07-31	2014-08-01
1590663	1590662	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.16		28	?	2014-08-13	2014-08-29	2014-07-30		1	2014-07-30	2014-07-31	0	0004818657			20140731.ifs	2014-07-31	2014-08-01
1589336	1589336	DIVIDEND	ADD	Y002A1105		6	0	3	0	.16		28	?	2014-08-13	2014-08-29	2014-07-30		0	2014-07-30	?	0	0004818657			20140730.ifs	2014-07-30	2014-07-31
1533536	1533536	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2862		28	?	2014-05-13	2014-05-29	2014-05-01		0	2014-05-01	?	0	0004778358			20140530.ifs	2014-05-30	2014-05-31
1533537	1533536	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2862		28	?	2014-05-13	2014-05-29	2014-05-01		1	2014-05-01	2014-05-30	0	0004778358			20140530.ifs	2014-05-30	2014-05-31
1511233	1511233	DIVIDEND	ADD	Y002A1105		6	0	3	0	.2862		28	?	2014-05-13	2014-05-29	2014-05-01		0	2014-05-01	?	0	0004778358			20140501.ifs	2014-05-01	2014-05-02
1247669	1247669	DIVIDEND	ADD	Y002A1105		6	0	3	0	.1393		28	?	2013-08-09	2013-08-30	2013-07-26		0	2013-07-26	?	0	0004604780			20130726.ifs	2013-07-26	2013-07-27
1200002	1200002	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2467		28	?	2013-05-15	2013-05-30	2013-04-29		1	2013-04-29	2013-04-30	0	0004561854			20130603.ifs	2013-06-03	2013-06-04
1200003	1200002	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2467		28	?	2013-05-15	2013-05-30	2013-04-29		2	2013-04-29	2013-06-03	0	0004561854			20130603.ifs	2013-06-03	2013-06-04
1170438	1170438	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2467		28	?	2013-05-15	2013-05-30	2013-04-29		0	2013-04-29	?	0	0004561854			20130430.ifs	2013-04-30	2013-05-01
1170439	1170438	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.2467		28	?	2013-05-15	2013-05-30	2013-04-29		1	2013-04-29	2013-04-30	0	0004561854			20130430.ifs	2013-04-30	2013-05-01
1169157	1169157	DIVIDEND	ADD	Y002A1105		6	0	3	0	.2467		28	?	2013-05-15	2013-05-30	2013-04-29		0	2013-04-29	?	0	0004561854			20130429.ifs	2013-04-29	2013-04-30
923597	923597	DIVIDEND	ADD	Y002A1105		6	0	3	0	.1233		28	?	2012-08-10	2012-08-31	2012-08-01		0	?	2012-08-02	0	0004410321			20120802.ifs	2012-08-02	2012-08-03
924412	924412	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.1233		28	?	2012-08-10	2012-08-31	2012-08-01		0	?	2012-08-02	0	0004410321			20120802.ifs	2012-08-02	2012-08-03
924413	924412	DIVIDEND	CHANGE	Y002A1105		6	0	3	0	.1233		28	?	2012-08-10	2012-08-31	2012-08-01		0	?	2012-08-02	0	0004410321			20120802.ifs	2012-08-02	2012-08-03
810719	810719	DIVIDEND	ADD	Y002A1105		6	0	3	0	.22		28	?	2012-05-11	2012-05-25	2012-03-28		0	2012-03-28	?	0	0004350611			20120328.ifs	2012-03-28	2012-03-29
596180	596180	DIVIDEND	ADD	Y002A1105		6	0	3	4	.11		28	?	2011-08-12	2011-09-02	2011-07-29		0	2011-07-29	?	0	0004221440			20110729.ifs	2011-07-29	2011-07-30
376421	376421	EQUITY	ADD	Y002A1105	NEW ISSUE	0	0	2010-12-14	?	0	no	no		no		?	?	?							20101214.ifs	2010-12-14	2010-12-15
376422	376422	EQUITY	CHANGE	Y002A1105	NEW ISSUE	0	0	2010-12-14	?	0	no	no		no		?	?	?							20101214.ifs	2010-12-14	2010-12-15
376423	376422	EQUITY	CHANGE	Y002A1105	ORD	N	0	2010-12-14	?	0	no	no		no		?	2010-12-14	?							20101214.ifs	2010-12-14	2010-12-15
376424	376424	EXCHANGE	ADD	Y002A1105	66	2010-12-14	2010-12-14	AAIGF	0	0	?	2010-12-14													20101214.ifs	2010-12-14	2010-12-15
376461	376461	EQUITY	CHANGE	Y002A1105	ORD	N	0	2010-12-14	?	0	no	no		no		?	2010-12-14	?							20101214.ifs	2010-12-14	2010-12-15
376462	376461	EQUITY	CHANGE	Y002A1105	ORD	0	0	2010-12-14	?	0	no	no		no		?	2010-12-14	?							20101214.ifs	2010-12-14	2010-12-15

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 = 159575
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