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
4817104	4817104	CORPACTION	ADD	561641101	66	D	2021-10-01			?															20211001.ifs	2021-10-01	2021-10-02
4817105	4817105	EQUITY	CHANGE	561641101	ADR	N	0	2008-10-16	?	1	no	no		no		2008-10-16	?	?							20211001.ifs	2021-10-01	2021-10-02
4817106	4817105	EQUITY	CHANGE	561641101	ADR	D	0	2008-10-16	2021-10-01	1	no	no		no		2008-10-16	2021-10-01	?							20211001.ifs	2021-10-01	2021-10-02
4751753	4751753	DIVIDEND	DELETE	561641101		B	0	1	5	.00868		39	2021-06-30	2021-07-01	2021-07-19	2021-06-10		0	2021-06-10	?	0	0006320649			20210702.ifs	2021-07-02	2021-07-03
4751754	4751754	DIVIDEND	ADD	561641101		B	0	1	0	.00842		02	2021-06-30	2021-07-01	2021-07-19	2021-06-10		1	2021-06-10	2021-07-02	0	0006320649			20210702.ifs	2021-07-02	2021-07-03
4727068	4727068	DIVIDEND	ADD	561641101		B	0	1	5	.00868		39	2021-06-30	2021-07-01	2021-07-19	2021-06-10		0	2021-06-10	?	0	0006320649			20210610.ifs	2021-06-10	2021-06-11
4528784	4528784	DIVIDEND	DELETE	561641101		B	0	1	5	.008426		39	2020-12-03	2020-12-04	2020-12-22	2020-11-13		0	2020-11-13	?	0	0006188159			20201207.ifs	2020-12-07	2020-12-08
4528785	4528785	DIVIDEND	ADD	561641101		B	0	1	0	.00863		02	2020-12-03	2020-12-04	2020-12-22	2020-11-13		1	2020-11-13	2020-12-07	0	0006188159			20201207.ifs	2020-12-07	2020-12-08
4506935	4506935	DIVIDEND	ADD	561641101		B	0	1	5	.008426		39	2020-12-03	2020-12-04	2020-12-22	2020-11-13		0	2020-11-13	?	0	0006188159			20201113.ifs	2020-11-13	2020-11-14
3765482	3765482	DIVIDEND	DELETE	561641101		B	0	1	5	.372836		39	2019-05-23	2019-05-24	2019-06-11	2019-04-08		0	2019-04-08	?	0	0005869315			20190604.ifs	2019-06-04	2019-06-05
3765484	3765484	DIVIDEND	ADD	561641101		B	0	1	0	.368142		02	2019-05-23	2019-05-24	2019-06-11	2019-04-08		1	2019-04-08	2019-06-04	0	0005869315			20190604.ifs	2019-06-04	2019-06-05
3765487	3765487	DIVIDEND	DELETE	561641101		B	0	1	5	.372836		39	2019-05-23	2019-05-24	2019-06-11	2019-04-08		0	2019-04-08	?	0	0005869315			20190604.ifs	2019-06-04	2019-06-05
3765489	3765489	DIVIDEND	ADD	561641101		B	0	1	0	.368142		02	2019-05-23	2019-05-24	2019-06-11	2019-04-08		1	2019-04-08	2019-06-04	0	0005869315			20190604.ifs	2019-06-04	2019-06-05
3678781	3678781	DIVIDEND	ADD	561641101		B	0	1	5	.372836		39	2019-05-23	2019-05-24	2019-06-11	2019-04-08		0	2019-04-08	?	0	0005869315			20190408.ifs	2019-04-08	2019-04-09
3678795	3678795	DIVIDEND	ADD	561641101		B	0	1	5	.372836		39	2019-05-23	2019-05-24	2019-06-11	2019-04-08		0	2019-04-08	?	0	0005869315			20190408.ifs	2019-04-08	2019-04-09
3298998	3298998	DIVIDEND	ADD	561641101		0	1	1	9	.154422		31	2016-06-13	2016-06-15	2018-10-02	2018-09-25		0	2018-09-25	?	1	0005728579			20180925.ifs	2018-09-25	2018-09-26
3299000	3299000	DIVIDEND	ADD	561641101		0	1	1	9	.154422		31	2015-05-04	2015-05-06	2018-10-01	2018-09-25		0	2018-09-25	?	0	0005728578			20180925.ifs	2018-09-25	2018-09-26
3299002	3299002	DIVIDEND	ADD	561641101		0	1	1	9	.154422		31	2018-05-15	2018-05-16	2018-10-04	2018-09-25		0	2018-09-25	?	2	0005728545			20180925.ifs	2018-09-25	2018-09-26
3299107	3299107	DIVIDEND	ADD	561641101		0	1	1	9	.154422		31	2016-06-13	2016-06-15	2018-10-02	2018-09-25		0	2018-09-25	?	1	0005728579			20180925.ifs	2018-09-25	2018-09-26
3299109	3299109	DIVIDEND	ADD	561641101		0	1	1	9	.154422		31	2015-05-04	2015-05-06	2018-10-01	2018-09-25		0	2018-09-25	?	0	0005728578			20180925.ifs	2018-09-25	2018-09-26
3299111	3299111	DIVIDEND	ADD	561641101		0	1	1	9	.154422		31	2018-05-15	2018-05-16	2018-10-04	2018-09-25		0	2018-09-25	?	2	0005728545			20180925.ifs	2018-09-25	2018-09-26
3099675	3099675	DIVIDEND	DELETE	561641101		B	0	1	5	.24535		39	2018-05-15	2018-05-16	2018-06-01	2018-04-17		0	2018-04-17	?	0	0005647386			20180523.ifs	2018-05-23	2018-05-24
3099676	3099676	DIVIDEND	DELETE	561641101		B	0	1	5	.24535		39	2018-05-15	2018-05-16	2018-06-01	2018-04-17		0	2018-04-17	?	0	0005647386			20180523.ifs	2018-05-23	2018-05-24
3099677	3099677	DIVIDEND	ADD	561641101		B	0	1	0	.23443		02	2018-05-15	2018-05-16	2018-06-01	2018-04-17		1	2018-04-17	2018-05-23	0	0005647386			20180523.ifs	2018-05-23	2018-05-24
3099678	3099678	DIVIDEND	ADD	561641101		B	0	1	0	.23443		02	2018-05-15	2018-05-16	2018-06-01	2018-04-17		1	2018-04-17	2018-05-23	0	0005647386			20180523.ifs	2018-05-23	2018-05-24
3040969	3040969	DIVIDEND	ADD	561641101		B	0	1	5	.24535		39	2018-05-15	2018-05-16	2018-06-01	2018-04-17		0	2018-04-17	?	0	0005647386			20180417.ifs	2018-04-17	2018-04-18
3040996	3040996	DIVIDEND	ADD	561641101		B	0	1	5	.24535		39	2018-05-15	2018-05-16	2018-06-01	2018-04-17		0	2018-04-17	?	0	0005647386			20180417.ifs	2018-04-17	2018-04-18
2581955	2581955	DIVIDEND	CHANGE	561641101		B	0	1	0	.222157		02	2017-05-24	2017-05-26	2017-06-12	2017-04-10		2	2017-04-10	2017-05-31	0	0005420384			20170601.ifs	2017-06-01	2017-06-02
2581956	2581955	DIVIDEND	CHANGE	561641101		B	0	1	0	.222157		02	2017-05-24	2017-05-26	2017-06-12	2017-04-10		3	2017-04-10	2017-06-01	0	0005420384			20170601.ifs	2017-06-01	2017-06-02
2577922	2577922	DIVIDEND	DELETE	561641101		B	0	1	5	.210919		39	2017-05-24	2017-05-26	2017-06-13	2017-04-10		1	2017-04-10	2017-04-18	0	0005420384			20170531.ifs	2017-05-31	2017-06-01
2577923	2577923	DIVIDEND	ADD	561641101		B	0	1	0	.222157		02	2017-05-24	2017-05-26	2017-06-12	2017-04-10		2	2017-04-10	2017-05-31	0	0005420384			20170531.ifs	2017-05-31	2017-06-01
2543413	2543413	DIVIDEND	CHANGE	561641101		B	0	1	5	.210919		39	2017-05-24	2017-05-26	2017-06-13	2017-04-10		0	2017-04-10	?	0	0005420384			20170418.ifs	2017-04-18	2017-04-19
2543414	2543413	DIVIDEND	CHANGE	561641101		B	0	1	5	.210919		39	2017-05-24	2017-05-26	2017-06-13	2017-04-10		1	2017-04-10	2017-04-18	0	0005420384			20170418.ifs	2017-04-18	2017-04-19
2540302	2540302	DIVIDEND	ADD	561641101		B	0	1	5	.210919		39	2017-05-24	2017-05-26	2017-06-13	2017-04-10		0	2017-04-10	?	0	0005420384			20170410.ifs	2017-04-10	2017-04-11
2464245	2464245	EQUITY	CHANGE	561641101	ADR	N	0	2008-10-16	?	0	no	no		no		2008-10-16	?	?							20170126.ifs	2017-01-26	2017-01-27
2464246	2464245	EQUITY	CHANGE	561641101	ADR	N	0	2008-10-16	?	1	no	no		no		2008-10-16	?	?							20170126.ifs	2017-01-26	2017-01-27
2224010	2224010	DIVIDEND	DELETE	561641101		B	0	1	5	.222675		39	2016-06-13	2016-06-15	2016-07-01	2016-05-19		2	2016-05-19	2016-06-14	0	0005220483			20160617.ifs	2016-06-17	2016-06-18
2224011	2224011	DIVIDEND	ADD	561641101		B	0	1	0	.2216		02	2016-06-13	2016-06-15	2016-07-01	2016-05-19		3	2016-05-19	2016-06-17	0	0005220483			20160617.ifs	2016-06-17	2016-06-18
2220104	2220104	DIVIDEND	CHANGE	561641101		B	0	1	5	.222675		39	2016-06-13	2016-06-15	2016-07-01	2016-05-19		1	2016-05-19	2016-05-20	0	0005220483			20160614.ifs	2016-06-14	2016-06-15
2220105	2220104	DIVIDEND	CHANGE	561641101		B	0	1	5	.222675		39	2016-06-13	2016-06-15	2016-07-01	2016-05-19		2	2016-05-19	2016-06-14	0	0005220483			20160614.ifs	2016-06-14	2016-06-15
2200639	2200639	DIVIDEND	DELETE	561641101		B	0	1	5	.222675		39	?	2016-06-15	2016-07-01	2016-05-19		0	2016-05-19	?	0	0005220483			20160520.ifs	2016-05-20	2016-05-21
2200640	2200640	DIVIDEND	ADD	561641101		B	0	1	5	.222675		39	2016-06-13	2016-06-15	2016-07-01	2016-05-19		1	2016-05-19	2016-05-20	0	0005220483			20160520.ifs	2016-05-20	2016-05-21
2199544	2199544	DIVIDEND	ADD	561641101		B	0	1	5	.222675		39	?	2016-06-15	2016-07-01	2016-05-19		0	2016-05-19	?	0	0005220483			20160519.ifs	2016-05-19	2016-05-20
2172608	2172608	DIVIDEND	DELETE	561641101		B	0	1	5	.219233	0	39	2016-04-20	2016-04-22	2016-05-10	2016-02-24		0	?	2016-02-25	0	0005175112			20160425.ifs	2016-04-25	2016-04-26
2172609	2172609	DIVIDEND	ADD	561641101		0	0	E	0	0	0	58	?	?	2016-05-10	2016-02-24		0	?	2016-04-25	0	0005175112			20160425.ifs	2016-04-25	2016-04-26
2118685	2118685	DIVIDEND	DELETE	561641101		B	0	1	5	.219233		39	?	2016-04-22	2016-05-10	2016-02-24		0	2016-02-24	?	0	0005175112			20160225.ifs	2016-02-25	2016-02-26
2118686	2118686	DIVIDEND	ADD	561641101		B	0	1	5	.219233	0	39	2016-04-20	2016-04-22	2016-05-10	2016-02-24		0	?	2016-02-25	0	0005175112			20160225.ifs	2016-02-25	2016-02-26
2119084	2119084	DIVIDEND	CHANGE	561641101		B	0	1	5	.219233	0	39	2016-04-20	2016-04-22	2016-05-10	2016-02-24		0	?	2016-02-25	0	0005175112			20160225.ifs	2016-02-25	2016-02-26
2119085	2119084	DIVIDEND	CHANGE	561641101		B	0	1	5	.219233	0	39	2016-04-20	2016-04-22	2016-05-10	2016-02-24		0	?	2016-02-25	0	0005175112			20160225.ifs	2016-02-25	2016-02-26
2118321	2118321	DIVIDEND	ADD	561641101		B	0	1	5	.219233		39	?	2016-04-22	2016-05-10	2016-02-24		0	2016-02-24	?	0	0005175112			20160224.ifs	2016-02-24	2016-02-25
1860346	1860346	DIVIDEND	DELETE	561641101		B	0	1	5	.211258	0	39	2015-05-04	2015-05-06	2015-05-22	2015-03-18		0	?	2015-05-01	0	0004969825			20150508.ifs	2015-05-08	2015-05-09
1860347	1860347	DIVIDEND	ADD	561641101		B	0	1	0	.223968	0	02	2015-05-04	2015-05-06	2015-05-22	2015-03-18		0	?	2015-05-08	0	0004969825			20150508.ifs	2015-05-08	2015-05-09
1856082	1856082	DIVIDEND	CHANGE	561641101		B	0	1	5	.211258	0	39	2015-05-04	2015-05-06	2015-05-22	2015-03-18		0	?	2015-03-19	0	0004969825			20150501.ifs	2015-05-01	2015-05-02
1856083	1856082	DIVIDEND	CHANGE	561641101		B	0	1	5	.211258	0	39	2015-05-04	2015-05-06	2015-05-22	2015-03-18		0	?	2015-05-01	0	0004969825			20150501.ifs	2015-05-01	2015-05-02
1815405	1815405	DIVIDEND	DELETE	561641101		B	0	1	5	.211258		39	?	2015-05-06	2015-05-22	2015-03-18		0	2015-03-18	?	0	0004969825			20150319.ifs	2015-03-19	2015-03-20
1815406	1815406	DIVIDEND	ADD	561641101		B	0	1	5	.211258	0	39	2015-05-04	2015-05-06	2015-05-22	2015-03-18		0	?	2015-03-19	0	0004969825			20150319.ifs	2015-03-19	2015-03-20
1815884	1815884	DIVIDEND	CHANGE	561641101		B	0	1	5	.211258	0	39	2015-05-04	2015-05-06	2015-05-22	2015-03-18		0	?	2015-03-19	0	0004969825			20150319.ifs	2015-03-19	2015-03-20
1815885	1815884	DIVIDEND	CHANGE	561641101		B	0	1	5	.211258	0	39	2015-05-04	2015-05-06	2015-05-22	2015-03-18		0	?	2015-03-19	0	0004969825			20150319.ifs	2015-03-19	2015-03-20
1815036	1815036	DIVIDEND	ADD	561641101		B	0	1	5	.211258		39	?	2015-05-06	2015-05-22	2015-03-18		0	2015-03-18	?	0	0004969825			20150318.ifs	2015-03-18	2015-03-19
1528496	1528496	DIVIDEND	DELETE	561641101		B	0	1	5	.28201		39	2014-05-13	2014-05-15	2014-06-02	2014-04-08		1	2014-04-08	2014-04-09	0	0004767251			20140522.ifs	2014-05-22	2014-05-23
1528497	1528497	DIVIDEND	ADD	561641101		B	0	1	0	.278538		02	2014-05-13	2014-05-15	2014-06-02	2014-04-08		2	2014-04-08	2014-05-22	0	0004767251			20140522.ifs	2014-05-22	2014-05-23
1493866	1493866	DIVIDEND	DELETE	561641101		B	0	1	5	.28201		39	?	2014-05-15	2014-06-02	2014-04-08		0	2014-04-08	?	0	0004767251			20140409.ifs	2014-04-09	2014-04-10
1493867	1493867	DIVIDEND	ADD	561641101		B	0	1	5	.28201		39	2014-05-13	2014-05-15	2014-06-02	2014-04-08		1	2014-04-08	2014-04-09	0	0004767251			20140409.ifs	2014-04-09	2014-04-10
1493320	1493320	DIVIDEND	ADD	561641101		B	0	1	5	.28201		39	?	2014-05-15	2014-06-02	2014-04-08		0	2014-04-08	?	0	0004767251			20140408.ifs	2014-04-08	2014-04-09
1206315	1206315	DIVIDEND	DELETE	561641101		B	0	1	5	.085219		39	2013-06-04	2013-06-06	2013-06-24	2013-05-24		0	2013-05-24	?	0	0004573457			20130607.ifs	2013-06-07	2013-06-08
1206316	1206316	DIVIDEND	ADD	561641101		B	0	1	0	.087236		02	2013-06-04	2013-06-06	2013-06-24	2013-05-24		1	2013-05-24	2013-06-07	0	0004573457			20130607.ifs	2013-06-07	2013-06-08
1192747	1192747	DIVIDEND	ADD	561641101		B	0	1	5	.085219		39	2013-06-04	2013-06-06	2013-06-24	2013-05-24		0	2013-05-24	?	0	0004573457			20130524.ifs	2013-05-24	2013-05-25
841906	841906	DIVIDEND	DELETE	561641101		B	0	1	5	.201544		39	2012-04-18	2012-04-20	2012-05-08	2012-04-09		0	2012-04-09	?	0	0004360398			20120424.ifs	2012-04-24	2012-04-25
841907	841907	DIVIDEND	ADD	561641101		B	0	1	0	.202695		02	2012-04-18	2012-04-20	2012-05-08	2012-04-09		1	2012-04-09	2012-04-24	0	0004360398			20120424.ifs	2012-04-24	2012-04-25
832387	832387	DIVIDEND	ADD	561641101		B	0	1	5	.201544		39	2012-04-18	2012-04-20	2012-05-08	2012-04-09		0	2012-04-09	?	0	0004360398			20120409.ifs	2012-04-09	2012-04-10
575012	575012	DIVIDEND	DELETE	561641101		B	0	1	5	.196074		39	2011-06-23	2011-06-27	2011-07-13	2011-06-15		2	2011-06-15	2011-06-23	0	0004200803			20110630.ifs	2011-06-30	2011-07-01
575013	575013	DIVIDEND	ADD	561641101		B	0	1	0	.192481		02	2011-06-23	2011-06-27	2011-07-13	2011-06-15		3	2011-06-15	2011-06-30	0	0004200803			20110630.ifs	2011-06-30	2011-07-01
568205	568205	DIVIDEND	CHANGE	561641101		B	0	1	5	.196074		39	2011-06-23	2011-06-27	2011-07-13	2011-06-15		1	2011-06-15	2011-06-16	0	0004200803			20110623.ifs	2011-06-23	2011-06-24
568206	568205	DIVIDEND	CHANGE	561641101		B	0	1	5	.196074		39	2011-06-23	2011-06-27	2011-07-13	2011-06-15		2	2011-06-15	2011-06-23	0	0004200803			20110623.ifs	2011-06-23	2011-06-24
561935	561935	DIVIDEND	DELETE	561641101		B	0	1	5	.196074		39	?	2011-06-27	2011-07-13	2011-06-15		0	2011-06-15	?	0	0004200803			20110616.ifs	2011-06-16	2011-06-17
561936	561936	DIVIDEND	ADD	561641101		B	0	1	5	.196074		39	2011-06-23	2011-06-27	2011-07-13	2011-06-15		1	2011-06-15	2011-06-16	0	0004200803			20110616.ifs	2011-06-16	2011-06-17
560221	560221	DIVIDEND	ADD	561641101		B	0	1	5	.196074		39	?	2011-06-27	2011-07-13	2011-06-15		0	2011-06-15	?	0	0004200803			20110615.ifs	2011-06-15	2011-06-16
558800	558800	DIVIDEND	DELETE	561641101		B	0	1	5	.389384		39	?	2011-06-27	?	2011-06-10		0	2011-06-10	?	0	0004200089			20110614.ifs	2011-06-14	2011-06-15
557756	557756	DIVIDEND	ADD	561641101		B	0	1	5	.389384		39	?	2011-06-27	?	2011-06-10		0	2011-06-10	?	0	0004200089			20110610.ifs	2011-06-10	2011-06-11
155599	155599	DIVIDEND	DELETE	561641101		B	0	1	4	.02093		39	2010-03-31	2010-04-05	2010-04-21	2010-03-23		0	2010-03-23	?	0	0003981040			20100407.ifs	2010-04-07	2010-04-08
155600	155600	DIVIDEND	ADD	561641101		B	0	1	4	.02054		02	2010-03-31	2010-04-05	2010-04-21	2010-03-23		1	2010-03-23	2010-04-07	0	0003981040			20100407.ifs	2010-04-07	2010-04-08
138483	138483	DIVIDEND	ADD	561641101		B	0	1	4	.02093		39	2010-03-31	2010-04-05	2010-04-21	2010-03-23		0	2010-03-23	?	0	0003981040			20100323.ifs	2010-03-23	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 = 157003
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