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
5559986	5559986	DIVIDEND	ADD	526107107		0	0	1	0	1.15		00	2024-06-28	2024-06-28	2024-07-15	2024-05-20		0	2024-05-20	?	0	0006920921			20240520.ifs	2024-05-20	2024-05-21
5517329	5517329	DIVIDEND	ADD	526107107		0	0	1	0	1.1		00	2024-03-27	2024-03-29	2024-04-15	2024-03-15		0	2024-03-15	?	0	0006890369			20240315.ifs	2024-03-15	2024-03-16
5433299	5433299	DIVIDEND	ADD	526107107		0	0	1	0	1.1		00	2023-12-28	2023-12-29	2024-01-17	2023-12-08		0	2023-12-08	?	0	0006824754			20231208.ifs	2023-12-08	2023-12-09
5335402	5335402	DIVIDEND	ADD	526107107		0	0	1	0	1.1		00	2023-08-30	2023-08-31	2023-09-15	2023-07-14		0	2023-07-14	?	0	0006756254			20230714.ifs	2023-07-14	2023-07-15
5291446	5291446	DIVIDEND	ADD	526107107		0	0	1	0	1.1		00	2023-06-29	2023-06-30	2023-07-14	2023-05-15		0	2023-05-15	?	0	0006725817			20230515.ifs	2023-05-15	2023-05-16
5250434	5250434	DIVIDEND	ADD	526107107		0	0	1	0	1.06		00	2023-03-30	2023-03-31	2023-04-14	2023-03-17		0	2023-03-17	?	0	0006696826			20230317.ifs	2023-03-17	2023-03-18
5160235	5160235	DIVIDEND	ADD	526107107		0	0	1	0	1.06		00	2022-12-29	2022-12-30	2023-01-13	2022-12-09		0	2022-12-09	?	0	0006626772			20221209.ifs	2022-12-09	2022-12-10
5056348	5056348	DIVIDEND	ADD	526107107		0	0	1	0	1.06		00	2022-08-30	2022-08-31	2022-09-15	2022-07-08		0	2022-07-08	?	0	0006554765			20220708.ifs	2022-07-08	2022-07-09
5014580	5014580	DIVIDEND	ADD	526107107		0	0	1	0	1.06		00	2022-06-29	2022-06-30	2022-07-15	2022-05-19		0	2022-05-19	?	0	0006525327			20220519.ifs	2022-05-19	2022-05-20
4970032	4970032	DIVIDEND	ADD	526107107		0	0	1	0	.92		00	2022-03-30	2022-03-31	2022-04-15	2022-03-11		0	2022-03-11	?	0	0006493965			20220311.ifs	2022-03-11	2022-03-12
4876912	4876912	DIVIDEND	ADD	526107107		0	0	1	0	.92		00	2021-12-30	2021-12-31	2022-01-14	2021-12-10		0	2021-12-10	?	0	0006415464			20211210.ifs	2021-12-10	2021-12-11
4803581	4803581	DIVIDEND	ADD	526107107		0	0	1	0	.92		00	2021-09-29	2021-09-30	2021-10-15	2021-09-16		0	2021-09-16	?	0	0006368538			20210916.ifs	2021-09-16	2021-09-17
4708288	4708288	DIVIDEND	ADD	526107107		0	0	1	0	.92		00	2021-06-29	2021-06-30	2021-07-15	2021-05-19		0	2021-05-19	?	0	0006309392			20210519.ifs	2021-05-19	2021-05-20
4652440	4652440	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2021-03-30	2021-03-31	2021-04-15	2021-03-12		0	2021-03-12	?	0	0006276903			20210312.ifs	2021-03-12	2021-03-13
4538622	4538622	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2020-12-30	2020-12-31	2021-01-15	2020-12-11		0	2020-12-11	?	0	0006207071			20201211.ifs	2020-12-11	2020-12-12
4465346	4465346	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2020-09-30	2020-10-01	2020-10-15	2020-09-18		0	2020-09-18	?	0	0006160242			20200918.ifs	2020-09-18	2020-09-19
4343156	4343156	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2020-06-29	2020-06-30	2020-07-15	2020-05-20		0	2020-05-20	?	0	0006100485			20200520.ifs	2020-05-20	2020-05-21
4343388	4343388	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2020-06-29	2020-06-30	2020-07-15	2020-05-20		0	2020-05-20	?	0	0006100485			20200520.ifs	2020-05-20	2020-05-21
4246191	4246191	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2020-03-31	2020-04-01	2020-04-15	2020-03-20		0	2020-03-20	?	0	0006070897			20200320.ifs	2020-03-20	2020-03-21
4246208	4246208	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2020-03-31	2020-04-01	2020-04-15	2020-03-20		0	2020-03-20	?	0	0006070897			20200320.ifs	2020-03-20	2020-03-21
4067215	4067215	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2019-12-30	2019-12-31	2020-01-15	2019-12-13		0	2019-12-13	?	0	0005998068			20191213.ifs	2019-12-13	2019-12-14
4067321	4067321	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2019-12-30	2019-12-31	2020-01-15	2019-12-13		0	2019-12-13	?	0	0005998068			20191213.ifs	2019-12-13	2019-12-14
3928292	3928292	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2019-09-30	2019-10-01	2019-10-15	2019-09-19		0	2019-09-19	?	0	0005947034			20190919.ifs	2019-09-19	2019-09-20
3928293	3928293	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2019-09-30	2019-10-01	2019-10-15	2019-09-19		0	2019-09-19	?	0	0005947034			20190919.ifs	2019-09-19	2019-09-20
3735251	3735251	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2019-06-27	2019-06-28	2019-07-15	2019-05-22		0	2019-05-22	?	0	0005885907			20190522.ifs	2019-05-22	2019-05-23
3735254	3735254	DIVIDEND	ADD	526107107		0	0	1	0	.77		00	2019-06-27	2019-06-28	2019-07-15	2019-05-22		0	2019-05-22	?	0	0005885907			20190522.ifs	2019-05-22	2019-05-23
3633241	3633241	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2019-03-29	2019-04-01	2019-04-15	2019-03-15		0	2019-03-15	?	0	0005852753			20190315.ifs	2019-03-15	2019-03-16
3633252	3633252	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2019-03-29	2019-04-01	2019-04-15	2019-03-15		0	2019-03-15	?	0	0005852753			20190315.ifs	2019-03-15	2019-03-16
3412354	3412354	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2018-12-28	2018-12-31	2019-01-15	2018-12-07		0	2018-12-07	?	0	0005768501			20181207.ifs	2018-12-07	2018-12-08
3412684	3412684	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2018-12-28	2018-12-31	2019-01-15	2018-12-07		0	2018-12-07	?	0	0005768501			20181207.ifs	2018-12-07	2018-12-08
3281223	3281223	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2018-09-27	2018-09-28	2018-10-15	2018-09-13		0	2018-09-13	?	0	0005723458			20180913.ifs	2018-09-13	2018-09-14
3281296	3281296	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2018-09-27	2018-09-28	2018-10-15	2018-09-13		0	2018-09-13	?	0	0005723458			20180913.ifs	2018-09-13	2018-09-14
3091263	3091263	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2018-06-28	2018-06-29	2018-07-13	2018-05-15		0	2018-05-15	?	0	0005661665			20180515.ifs	2018-05-15	2018-05-16
3091264	3091264	DIVIDEND	ADD	526107107		0	0	1	0	.64		00	2018-06-28	2018-06-29	2018-07-13	2018-05-15		0	2018-05-15	?	0	0005661665			20180515.ifs	2018-05-15	2018-05-16
2995293	2995293	DIVIDEND	ADD	526107107		0	0	1	0	.51		00	2018-03-29	2018-04-02	2018-04-13	2018-03-16		0	2018-03-16	?	0	0005630221			20180316.ifs	2018-03-16	2018-03-17
2995294	2995294	DIVIDEND	ADD	526107107		0	0	1	0	.51		00	2018-03-29	2018-04-02	2018-04-13	2018-03-16		0	2018-03-16	?	0	0005630221			20180316.ifs	2018-03-16	2018-03-17
2816177	2816177	DIVIDEND	ADD	526107107		0	0	1	0	.51		00	2017-12-28	2017-12-29	2018-01-16	2017-12-07		0	2017-12-08	?	0	0005545580			20171208.ifs	2017-12-08	2017-12-09
2816212	2816212	DIVIDEND	ADD	526107107		0	0	1	0	.51		00	2017-12-28	2017-12-29	2018-01-16	2017-12-07		0	2017-12-08	?	0	0005545580			20171208.ifs	2017-12-08	2017-12-09
2670912	2670912	DIVIDEND	ADD	526107107		0	0	1	0	.51		00	2017-09-28	2017-09-29	2017-10-16	2017-09-14		0	2017-09-14	?	0	0005497265			20170914.ifs	2017-09-14	2017-09-15
2671303	2671303	DIVIDEND	ADD	526107107		0	0	1	0	.51		00	2017-09-28	2017-09-29	2017-10-16	2017-09-14		0	2017-09-14	?	0	0005497265			20170914.ifs	2017-09-14	2017-09-15
2569141	2569141	DIVIDEND	ADD	526107107		0	0	1	0	.51		00	2017-06-28	2017-06-30	2017-07-17	2017-05-17		0	2017-05-17	?	0	0005435907			20170517.ifs	2017-05-17	2017-05-18
2515471	2515471	DIVIDEND	ADD	526107107		0	0	1	0	.43		00	2017-03-29	2017-03-31	2017-04-17	2017-03-17		0	2017-03-17	?	0	0005403942			20170317.ifs	2017-03-17	2017-03-18
2367734	2367734	DIVIDEND	ADD	526107107		0	0	1	0	.43		00	2016-12-28	2016-12-30	2017-01-17	2016-12-09		0	2016-12-09	?	0	0005327837			20161209.ifs	2016-12-09	2016-12-10
2294495	2294495	DIVIDEND	ADD	526107107		0	0	1	0	.43		00	2016-09-28	2016-09-30	2016-10-14	2016-09-15		0	2016-09-15	?	0	0005281148			20160915.ifs	2016-09-15	2016-09-16
2194625	2194625	DIVIDEND	ADD	526107107		0	0	1	0	.43		00	2016-06-28	2016-06-30	2016-07-15	2016-05-11		0	2016-05-11	?	0	0005218212			20160511.ifs	2016-05-11	2016-05-12
2133978	2133978	DIVIDEND	ADD	526107107		0	0	1	0	.36		00	2016-03-29	2016-03-31	2016-04-15	2016-03-11		0	2016-03-11	?	0	0005186181			20160311.ifs	2016-03-11	2016-03-12
2034686	2034686	DIVIDEND	ADD	526107107		0	0	1	0	.36		00	2015-12-29	2015-12-31	2016-01-15	2015-12-11		0	2015-12-11	?	0	0005111971			20151211.ifs	2015-12-11	2015-12-12
1968172	1968172	DIVIDEND	ADD	526107107		0	0	1	0	.36		00	2015-09-29	2015-10-01	2015-10-15	2015-09-17		0	2015-09-17	?	0	0005063127			20150917.ifs	2015-09-17	2015-09-18
1862785	1862785	DIVIDEND	ADD	526107107		0	0	1	0	.36		00	2015-06-26	2015-06-30	2015-07-15	2015-05-13		0	2015-05-13	?	0	0005000003			20150513.ifs	2015-05-13	2015-05-14
1811731	1811731	DIVIDEND	ADD	526107107		0	0	1	0	.3		00	2015-03-27	2015-03-31	2015-04-15	2015-03-13		0	2015-03-13	?	0	0004968010			20150313.ifs	2015-03-13	2015-03-14
1711658	1711658	DIVIDEND	ADD	526107107		0	0	1	0	.3		00	2014-12-29	2014-12-31	2015-01-15	2014-12-12		0	2014-12-12	?	0	0004893309			20141212.ifs	2014-12-12	2014-12-13
1633271	1633271	DIVIDEND	ADD	526107107		0	0	1	0	.3		00	2014-09-29	2014-10-01	2014-10-15	2014-09-18		0	2014-09-18	?	0	0004844170			20140918.ifs	2014-09-18	2014-09-19
1466997	1466997	DIVIDEND	ADD	526107107		0	0	1	0	.24		00	2014-03-27	2014-03-31	2014-04-15	2014-03-14		0	2014-03-14	?	0	0004750306			20140314.ifs	2014-03-14	2014-03-15
1369550	1369550	DIVIDEND	ADD	526107107		0	0	1	0	.24		00	2013-12-27	2013-12-31	2014-01-15	2013-12-13		0	2013-12-13	?	0	0004680841			20131213.ifs	2013-12-13	2013-12-14
1291444	1291444	DIVIDEND	ADD	526107107		0	0	1	0	.24		00	2013-10-01	2013-10-03	2013-10-15	2013-09-19		0	2013-09-19	?	0	0004631398			20130919.ifs	2013-09-19	2013-09-20
1186096	1186096	DIVIDEND	ADD	526107107		0	0	1	0	.24		00	2013-06-26	2013-06-28	2013-07-15	2013-05-15		0	2013-05-15	?	0	0004571380			20130515.ifs	2013-05-15	2013-05-16
1135507	1135507	DIVIDEND	DELETE	526107107		0	0	1	0	.2		00	2013-03-26	2013-03-29	2013-04-15	2013-03-15		0	2013-03-15	?	0	0004541605			20130318.ifs	2013-03-18	2013-03-19
1135508	1135508	DIVIDEND	ADD	526107107		0	0	1	0	.2		00	2013-03-26	2013-03-28	2013-04-15	2013-03-15		1	2013-03-15	2013-03-18	0	0004541605			20130318.ifs	2013-03-18	2013-03-19
1134145	1134145	DIVIDEND	ADD	526107107		0	0	1	0	.2		00	2013-03-26	2013-03-29	2013-04-15	2013-03-15		0	2013-03-15	?	0	0004541605			20130315.ifs	2013-03-15	2013-03-16
1031821	1031821	DIVIDEND	ADD	526107107		0	0	1	0	.2		00	2012-12-13	2012-12-17	2012-12-28	2012-12-07		0	2012-12-07	?	0	0004471785			20121207.ifs	2012-12-07	2012-12-08
960725	960725	DIVIDEND	ADD	526107107		0	0	1	0	.2		00	2012-10-02	2012-10-04	2012-10-15	2012-09-20		0	2012-09-20	?	0	0004431603			20120920.ifs	2012-09-20	2012-09-21
858534	858534	DIVIDEND	ADD	526107107		0	0	1	0	.18		00	2012-06-13	2012-06-15	2012-07-16	2012-05-09		0	2012-05-09	?	0	0004373292			20120509.ifs	2012-05-09	2012-05-10
799929	799929	DIVIDEND	ADD	526107107		0	0	1	0	.18		00	2012-03-28	2012-03-30	2012-04-16	2012-03-09		0	2012-03-09	?	0	0004344743			20120309.ifs	2012-03-09	2012-03-10
716811	716811	DIVIDEND	ADD	526107107		0	0	1	0	.18		00	2011-12-28	2011-12-30	2012-01-13	2011-12-09		0	2011-12-09	?	0	0004284510			20111209.ifs	2011-12-09	2011-12-10
645620	645620	DIVIDEND	ADD	526107107		0	0	1	0	.18		00	2011-09-28	2011-09-30	2011-10-14	2011-09-16		0	2011-09-16	?	0	0004243519			20110916.ifs	2011-09-16	2011-09-17
524362	524362	DIVIDEND	ADD	526107107		0	0	1	0	.18		00	2011-06-24	2011-06-28	2011-07-15	2011-05-11		0	2011-05-11	?	0	0004187618			20110511.ifs	2011-05-11	2011-05-12
470341	470341	DIVIDEND	ADD	526107107		0	0	1	0	.18		00	2011-03-23	2011-03-25	2011-04-15	2011-03-11		0	2011-03-11	?	0	0004158964			20110311.ifs	2011-03-11	2011-03-12
309903	309903	DIVIDEND	ADD	526107107		0	0	1	0	.15		00	2010-09-29	2010-10-01	2010-10-15	2010-09-17		0	2010-09-17	?	0	0004061300			20100917.ifs	2010-09-17	2010-09-18
190601	190601	DIVIDEND	ADD	526107107		0	0	1	0	.15		00	2010-06-24	2010-06-28	2010-07-15	2010-05-12		0	2010-05-12	?	0	0004005559			20100512.ifs	2010-05-12	2010-05-13
132037	132037	DIVIDEND	ADD	526107107		0	0	1	0	.15		00	2010-03-24	2010-03-26	2010-04-15	2010-03-12		0	2010-03-12	?	0	0003977629			20100312.ifs	2010-03-12	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 = 134178
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