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
5559977	5559977	DIVIDEND	ADD	679580100		0	0	1	0	.26		35	2024-06-05	2024-06-05	2024-06-19	2024-05-20		0	2024-05-20	?	0	0006920806			20240520.ifs	2024-05-20	2024-05-21
5500968	5500968	DIVIDEND	CHANGE	679580100		0	0	6	0	1		11	2024-03-28	2024-03-13	2024-03-27	2024-02-16		0	2024-02-20	?	0	0006878015			20240221.ifs	2024-02-21	2024-02-22
5500969	5500968	DIVIDEND	CHANGE	679580100		0	0	6	0	2	0	11	2024-03-28	2024-03-13	2024-03-27	2024-02-16		0	2024-02-20	?	0	0006878015			20240221.ifs	2024-02-21	2024-02-22
5500637	5500637	DIVIDEND	ADD	679580100		0	0	6	0	1		11	2024-03-28	2024-03-13	2024-03-27	2024-02-16		0	2024-02-20	?	0	0006878015			20240220.ifs	2024-02-20	2024-02-21
5500638	5500638	SPLIT	ADD	679580100	.5	2024-03-28	11	2024-02-20	?																20240220.ifs	2024-02-20	2024-02-21
5487972	5487972	DIVIDEND	ADD	679580100		0	0	1	0	.52		00	2024-03-05	2024-03-06	2024-03-20	2024-01-31		0	2024-01-31	?	0	0006868620			20240131.ifs	2024-01-31	2024-02-01
5397410	5397410	DIVIDEND	ADD	679580100		0	0	1	0	.4		00	2023-12-05	2023-12-06	2023-12-20	2023-10-19		0	2023-10-19	?	0	0006799621			20231019.ifs	2023-10-19	2023-10-20
5337469	5337469	DIVIDEND	ADD	679580100		0	0	1	0	.4		00	2023-09-05	2023-09-06	2023-09-20	2023-07-20		0	2023-07-20	?	0	0006757479			20230720.ifs	2023-07-20	2023-07-21
5293590	5293590	DIVIDEND	ADD	679580100		0	0	1	0	.4		00	2023-06-06	2023-06-07	2023-06-21	2023-05-18		0	2023-05-18	?	0	0006726593			20230518.ifs	2023-05-18	2023-05-19
5222963	5222963	DIVIDEND	ADD	679580100		0	0	1	0	.4		00	2023-02-28	2023-03-01	2023-03-15	2023-02-01		0	2023-02-01	?	0	0006676238			20230201.ifs	2023-02-01	2023-02-02
5123154	5123154	DIVIDEND	ADD	679580100		0	0	1	0	.3		00	2022-12-06	2022-12-07	2022-12-21	2022-10-20		0	2022-10-20	?	0	0006600711			20221020.ifs	2022-10-20	2022-10-21
5061736	5061736	DIVIDEND	ADD	679580100		0	0	1	0	.3		00	2022-09-06	2022-09-07	2022-09-21	2022-07-21		0	2022-07-21	?	0	0006557510			20220721.ifs	2022-07-21	2022-07-22
5014557	5014557	DIVIDEND	ADD	679580100		0	0	1	0	.3		00	2022-05-31	2022-06-01	2022-06-15	2022-05-19		0	2022-05-19	?	0	0006525290			20220519.ifs	2022-05-19	2022-05-20
4947600	4947600	DIVIDEND	ADD	679580100		0	0	1	0	.3		00	2022-03-01	2022-03-02	2022-03-16	2022-02-02		0	2022-02-02	?	0	0006477107			20220202.ifs	2022-02-02	2022-02-03
4829963	4829963	DIVIDEND	ADD	679580100		0	0	1	0	.2		00	2021-11-30	2021-12-01	2021-12-15	2021-10-21		0	2021-10-21	?	0	0006384957			20211021.ifs	2021-10-21	2021-10-22
4763268	4763268	DIVIDEND	ADD	679580100		0	0	1	0	.2		00	2021-08-31	2021-09-01	2021-09-15	2021-07-22		0	2021-07-22	?	0	0006341609			20210722.ifs	2021-07-22	2021-07-23
4708890	4708890	DIVIDEND	ADD	679580100		0	0	1	0	.2		00	2021-06-01	2021-06-02	2021-06-16	2021-05-20		0	2021-05-20	?	0	0006309515			20210520.ifs	2021-05-20	2021-05-21
4624361	4624361	DIVIDEND	ADD	679580100		0	0	1	0	.2		00	2021-03-02	2021-03-03	2021-03-17	2021-02-04		0	2021-02-04	?	0	0006262049			20210204.ifs	2021-02-04	2021-02-05
4506348	4506348	EQUITY	CHANGE	679580100	COM	0	0	1991-10-24	?	9	yes	no		yes		1996-12-17	?	?							20201113.ifs	2020-11-13	2020-11-14
4506349	4506348	EQUITY	CHANGE	679580100	COM	0	0	1991-10-24	?	4	yes	no		yes		1996-12-17	2020-11-13	?							20201113.ifs	2020-11-13	2020-11-14
4490240	4490240	DIVIDEND	ADD	679580100		0	0	1	0	.15		00	2020-12-01	2020-12-02	2020-12-16	2020-10-23		0	2020-10-23	?	0	0006177043			20201023.ifs	2020-10-23	2020-10-24
4423278	4423278	DIVIDEND	ADD	679580100		0	0	1	0	.15		00	2020-09-01	2020-09-02	2020-09-16	2020-07-23		0	2020-07-23	?	0	0006132434			20200723.ifs	2020-07-23	2020-07-24
4344959	4344959	DIVIDEND	ADD	679580100		0	0	1	1	.15		06	2020-06-02	2020-06-03	2020-06-17	2020-05-21		0	2020-05-21	?	0	0006100684			20200521.ifs	2020-05-21	2020-05-22
4344960	4344960	DIVIDEND	ADD	679580100		0	0	1	1	.15		06	2020-06-02	2020-06-03	2020-06-17	2020-05-21		0	2020-05-21	?	0	0006100684			20200521.ifs	2020-05-21	2020-05-22
4212436	4212436	DIVIDEND	ADD	679580100		0	0	6	0	.5		11	2020-03-25	2020-03-10	2020-03-24	2020-02-21		0	2020-02-21	?	0	0006057094			20200221.ifs	2020-02-21	2020-02-22
4212438	4212438	SPLIT	ADD	679580100	.6666666667	2020-03-25	11	2020-02-21	?																20200221.ifs	2020-02-21	2020-02-22
4212514	4212514	DIVIDEND	ADD	679580100		0	0	6	0	.5		11	2020-03-25	2020-03-10	2020-03-24	2020-02-21		0	2020-02-21	?	0	0006057094			20200221.ifs	2020-02-21	2020-02-22
4212516	4212516	SPLIT	ADD	679580100	.6666666667	2020-03-25	11	2020-02-21	?																20200221.ifs	2020-02-21	2020-02-22
4200062	4200062	DIVIDEND	ADD	679580100		0	0	1	0	.23		00	2020-03-03	2020-03-04	2020-03-18	2020-02-06		0	2020-02-06	?	0	0006053534			20200206.ifs	2020-02-06	2020-02-07
4200109	4200109	DIVIDEND	ADD	679580100		0	0	1	0	.23		00	2020-03-03	2020-03-04	2020-03-18	2020-02-06		0	2020-02-06	?	0	0006053534			20200206.ifs	2020-02-06	2020-02-07
3976077	3976077	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-12-03	2019-12-04	2019-12-18	2019-10-17		0	2019-10-17	?	0	0005963164			20191017.ifs	2019-10-17	2019-10-18
3976080	3976080	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-12-03	2019-12-04	2019-12-18	2019-10-17		0	2019-10-17	?	0	0005963164			20191017.ifs	2019-10-17	2019-10-18
3839306	3839306	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-09-03	2019-09-04	2019-09-18	2019-07-18		0	2019-07-18	?	0	0005917549			20190718.ifs	2019-07-18	2019-07-19
3839314	3839314	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-09-03	2019-09-04	2019-09-18	2019-07-18		0	2019-07-18	?	0	0005917549			20190718.ifs	2019-07-18	2019-07-19
3730226	3730226	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-06-04	2019-06-05	2019-06-19	2019-05-16		0	2019-05-16	?	0	0005884631			20190516.ifs	2019-05-16	2019-05-17
3730239	3730239	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-06-04	2019-06-05	2019-06-19	2019-05-16		0	2019-05-16	?	0	0005884631			20190516.ifs	2019-05-16	2019-05-17
3577347	3577347	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-03-05	2019-03-06	2019-03-20	2019-02-07		0	2019-02-07	?	0	0005836838			20190207.ifs	2019-02-07	2019-02-08
3577348	3577348	DIVIDEND	ADD	679580100		0	0	1	0	.17		00	2019-03-05	2019-03-06	2019-03-20	2019-02-07		0	2019-02-07	?	0	0005836838			20190207.ifs	2019-02-07	2019-02-08
3396767	3396767	DIVIDEND	DELETE	679580100		0	0	1	0	.13		00	2018-12-05	2018-12-06	2018-12-20	2018-11-01		0	2018-11-01	?	0	0005750139			20181203.ifs	2018-12-03	2018-12-04
3396768	3396768	DIVIDEND	DELETE	679580100		0	0	1	0	.13		00	2018-12-05	2018-12-06	2018-12-20	2018-11-01		0	2018-11-01	?	0	0005750139			20181203.ifs	2018-12-03	2018-12-04
3396769	3396769	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-12-06	2018-12-06	2018-12-20	2018-11-01		1	2018-11-01	2018-12-03	0	0005750139			20181203.ifs	2018-12-03	2018-12-04
3396770	3396770	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-12-06	2018-12-06	2018-12-20	2018-11-01		1	2018-11-01	2018-12-03	0	0005750139			20181203.ifs	2018-12-03	2018-12-04
3354126	3354126	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-12-05	2018-12-06	2018-12-20	2018-11-01		0	2018-11-01	?	0	0005750139			20181101.ifs	2018-11-01	2018-11-02
3354223	3354223	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-12-05	2018-12-06	2018-12-20	2018-11-01		0	2018-11-01	?	0	0005750139			20181101.ifs	2018-11-01	2018-11-02
3210120	3210120	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-09-05	2018-09-06	2018-09-20	2018-07-18		0	2018-07-30	?	0	0005698092			20180730.ifs	2018-07-30	2018-07-31
3210121	3210121	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-09-05	2018-09-06	2018-09-20	2018-07-18		0	2018-07-30	?	0	0005698092			20180730.ifs	2018-07-30	2018-07-31
3093783	3093783	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-06-05	2018-06-06	2018-06-20	2018-05-17		0	2018-05-17	?	0	0005662434			20180517.ifs	2018-05-17	2018-05-18
3093792	3093792	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-06-05	2018-06-06	2018-06-20	2018-05-17		0	2018-05-17	?	0	0005662434			20180517.ifs	2018-05-17	2018-05-18
2948806	2948806	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-03-05	2018-03-06	2018-03-20	2018-02-08		0	2018-02-08	?	0	0005613776			20180208.ifs	2018-02-08	2018-02-09
2948809	2948809	DIVIDEND	ADD	679580100		0	0	1	0	.13		00	2018-03-05	2018-03-06	2018-03-20	2018-02-08		0	2018-02-08	?	0	0005613776			20180208.ifs	2018-02-08	2018-02-09
2740190	2740190	DIVIDEND	ADD	679580100		0	0	1	0	.1		00	2017-12-05	2017-12-06	2017-12-20	2017-10-30		0	2017-10-30	?	0	0005519668			20171030.ifs	2017-10-30	2017-10-31
2740268	2740268	DIVIDEND	ADD	679580100		0	0	1	0	.1		00	2017-12-05	2017-12-06	2017-12-20	2017-10-30		0	2017-10-30	?	0	0005519668			20171030.ifs	2017-10-30	2017-10-31
2635207	2635207	DIVIDEND	ADD	679580100		0	0	1	0	.1		00	2017-09-01	2017-09-06	2017-09-20	2017-07-31		0	2017-07-31	?	0	0005473651			20170731.ifs	2017-07-31	2017-08-01
2569115	2569115	DIVIDEND	ADD	679580100		0	0	1	0	.1		00	2017-06-02	2017-06-06	2017-06-20	2017-05-17		0	2017-05-17	?	0	0005435957			20170517.ifs	2017-05-17	2017-05-18
2569116	2569116	DIVIDEND	DELETE	679580100		0	0	1	0	.1		35	2017-03-02	2017-03-06	2017-03-20	2017-02-02		0	2017-02-02	?	0	0005385459			20170517.ifs	2017-05-17	2017-05-18
2569117	2569117	DIVIDEND	ADD	679580100		0	0	1	0	.1		00	2017-03-02	2017-03-06	2017-03-20	2017-02-02		1	2017-02-02	2017-05-17	0	0005385459			20170517.ifs	2017-05-17	2017-05-18
2484155	2484155	DIVIDEND	ADD	679580100		0	0	1	0	.1		35	2017-03-02	2017-03-06	2017-03-20	2017-02-02		0	2017-02-02	?	0	0005385459			20170202.ifs	2017-02-02	2017-02-03
932210	932210	DIVIDEND	ADD	679580100		0	0	6	0	.5		22	2012-09-10	2012-08-24	2012-09-07	2012-08-13		0	2012-08-13	?	0	0004415498			20120813.ifs	2012-08-13	2012-08-14
932211	932211	SPLIT	ADD	679580100	.6666666667	2012-09-10	22	2012-08-13	?																20120813.ifs	2012-08-13	2012-08-14
270957	270957	DIVIDEND	DELETE	679580100		0	0	6	0	.5		11	?	2010-08-09	?	2010-08-02		0	2010-08-02	?	0	0004041394			20100803.ifs	2010-08-03	2010-08-04
270958	270958	DIVIDEND	ADD	679580100		0	0	6	0	.5		22	2010-08-24	2010-08-09	2010-08-23	2010-08-02		1	2010-08-02	2010-08-03	0	0004041394			20100803.ifs	2010-08-03	2010-08-04
270959	270959	SPLIT	ADD	679580100	.6666666667	2010-08-24	22	2010-08-03	?																20100803.ifs	2010-08-03	2010-08-04
267941	267941	DIVIDEND	ADD	679580100		0	0	6	0	.5		11	?	2010-08-09	?	2010-08-02		0	2010-08-02	?	0	0004041394			20100802.ifs	2010-08-02	2010-08-03

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