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
5573845	5573845	DIVIDEND	ADD	464288836		0	0	1	0	.294016		00	2024-06-11	2024-06-11	2024-06-17	2024-06-10		0	2024-06-10	?	0	0006931034			20240610.ifs	2024-06-10	2024-06-11
5519549	5519549	DIVIDEND	ADD	464288836		0	0	1	0	.275023		35	2024-03-21	2024-03-22	2024-03-27	2024-03-20		0	2024-03-20	?	0	0006892630			20240320.ifs	2024-03-20	2024-03-21
5501488	5501488	DIVIDEND	CHANGE	464288836		0	0	6	0	2	0	11	2024-03-07	2024-03-04	2024-03-06	2023-12-22		1	2023-12-22	2024-02-21	0	0006847463			20240222.ifs	2024-02-22	2024-02-23
5501489	5501488	DIVIDEND	CHANGE	464288836		0	0	6	0	3	0	11	2024-03-07	2024-03-04	2024-03-06	2023-12-22		1	2023-12-22	2024-02-21	0	0006847463			20240222.ifs	2024-02-22	2024-02-23
5501320	5501320	DIVIDEND	CHANGE	464288836		0	0	6	0	3	0	11	2024-03-07	2024-03-04	2024-03-06	2023-12-22		0	2023-12-22	?	0	0006847463			20240221.ifs	2024-02-21	2024-02-22
5501321	5501320	DIVIDEND	CHANGE	464288836		0	0	6	0	2	0	11	2024-03-07	2024-03-04	2024-03-06	2023-12-22		1	2023-12-22	2024-02-21	0	0006847463			20240221.ifs	2024-02-21	2024-02-22
5460756	5460756	DIVIDEND	CHANGE	464288836		0	0	6	0	2		11	2024-03-07	2024-03-04	2024-03-06	2023-12-22		0	2023-12-22	?	0	0006847463			20231226.ifs	2023-12-26	2023-12-27
5460757	5460756	DIVIDEND	CHANGE	464288836		0	0	6	0	3	0	11	2024-03-07	2024-03-04	2024-03-06	2023-12-22		0	2023-12-22	?	0	0006847463			20231226.ifs	2023-12-26	2023-12-27
5459596	5459596	DIVIDEND	ADD	464288836		0	0	6	0	2		11	2024-03-07	2024-03-04	2024-03-06	2023-12-22		0	2023-12-22	?	0	0006847463			20231222.ifs	2023-12-22	2023-12-23
5459597	5459597	SPLIT	ADD	464288836	.3333333333	2024-03-07	11	2023-12-22	?																20231222.ifs	2023-12-22	2023-12-23
5450356	5450356	DIVIDEND	ADD	464288836		0	0	1	0	.404211		00	2023-12-20	2023-12-21	2023-12-27	2023-12-19		0	2023-12-19	?	0	0006840549			20231219.ifs	2023-12-19	2023-12-20
5380077	5380077	DIVIDEND	ADD	464288836		0	0	1	0	.901829		00	2023-09-26	2023-09-27	2023-10-02	2023-09-25		0	2023-09-25	?	0	0006787308			20230925.ifs	2023-09-25	2023-09-26
5307589	5307589	DIVIDEND	ADD	464288836		0	0	1	0	.590395		00	2023-06-07	2023-06-08	2023-06-13	2023-06-06		0	2023-06-06	?	0	0006737001			20230606.ifs	2023-06-06	2023-06-07
5252894	5252894	DIVIDEND	ADD	464288836		0	0	1	0	.67202		00	2023-03-23	2023-03-24	2023-03-29	2023-03-22		0	2023-03-22	?	0	0006698860			20230322.ifs	2023-03-22	2023-03-23
5162422	5162422	DIVIDEND	ADD	464288836		0	0	1	0	1.337124		00	2022-12-13	2022-12-14	2022-12-19	2022-12-12		0	2022-12-12	?	0	0006629498			20221212.ifs	2022-12-12	2022-12-13
5103563	5103563	DIVIDEND	ADD	464288836		0	0	1	0	.884837		00	2022-09-26	2022-09-27	2022-09-30	2022-09-23		0	2022-09-23	?	0	0006587983			20220923.ifs	2022-09-23	2022-09-24
5030141	5030141	DIVIDEND	ADD	464288836		0	0	1	0	.71711		00	2022-06-09	2022-06-10	2022-06-15	2022-06-08		0	2022-06-08	?	0	0006536790			20220608.ifs	2022-06-08	2022-06-09
4976129	4976129	DIVIDEND	ADD	464288836		0	0	1	0	.793569		00	2022-03-24	2022-03-25	2022-03-30	2022-03-23		0	2022-03-23	?	0	0006498171			20220323.ifs	2022-03-23	2022-03-24
4877091	4877091	DIVIDEND	ADD	464288836		0	0	1	0	.789795		00	2021-12-13	2021-12-14	2021-12-17	2021-12-10		0	2021-12-10	?	0	0006417591			20211210.ifs	2021-12-10	2021-12-11
4808644	4808644	DIVIDEND	ADD	464288836		0	0	1	0	.832138		00	2021-09-24	2021-09-27	2021-09-30	2021-09-23		0	2021-09-23	?	0	0006371657			20210923.ifs	2021-09-23	2021-09-24
4725918	4725918	DIVIDEND	ADD	464288836		0	0	1	0	.720633		00	2021-06-10	2021-06-11	2021-06-16	2021-06-09		0	2021-06-09	?	0	0006320416			20210609.ifs	2021-06-09	2021-06-10
4660995	4660995	DIVIDEND	ADD	464288836		0	0	1	0	.634841		00	2021-03-25	2021-03-26	2021-03-31	2021-03-24		0	2021-03-24	?	0	0006281428			20210324.ifs	2021-03-24	2021-03-25
4539139	4539139	DIVIDEND	ADD	464288836		0	0	1	0	.5261		00	2020-12-14	2020-12-15	2020-12-18	2020-12-11		0	2020-12-11	?	0	0006209250			20201211.ifs	2020-12-11	2020-12-12
4467362	4467362	DIVIDEND	ADD	464288836		0	0	1	0	.708877		00	2020-09-23	2020-09-24	2020-09-29	2020-09-22		0	2020-09-22	?	0	0006161956			20200922.ifs	2020-09-22	2020-09-23
4391019	4391019	DIVIDEND	ADD	464288836		0	0	1	0	.31386		00	2020-06-15	2020-06-16	2020-06-19	2020-06-12		0	2020-06-12	?	0	0006112123			20200612.ifs	2020-06-12	2020-06-13
4252403	4252403	DIVIDEND	ADD	464288836		0	0	1	0	.586574		00	2020-03-25	2020-03-26	2020-03-31	2020-03-24		0	2020-03-24	?	0	0006072820			20200324.ifs	2020-03-24	2020-03-25
4252626	4252626	DIVIDEND	ADD	464288836		0	0	1	0	.586574		00	2020-03-25	2020-03-26	2020-03-31	2020-03-24		0	2020-03-24	?	0	0006072820			20200324.ifs	2020-03-24	2020-03-25
4067949	4067949	DIVIDEND	ADD	464288836		0	0	1	0	.514703		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000078			20191213.ifs	2019-12-13	2019-12-14
4068028	4068028	DIVIDEND	ADD	464288836		0	0	1	0	.514703		00	2019-12-16	2019-12-17	2019-12-20	2019-12-13		0	2019-12-13	?	0	0006000078			20191213.ifs	2019-12-13	2019-12-14
3933962	3933962	DIVIDEND	ADD	464288836		0	0	1	0	.629524		00	2019-09-24	2019-09-25	2019-09-30	2019-09-23		0	2019-09-23	?	0	0005949065			20190923.ifs	2019-09-23	2019-09-24
3933963	3933963	DIVIDEND	ADD	464288836		0	0	1	0	.629524		00	2019-09-24	2019-09-25	2019-09-30	2019-09-23		0	2019-09-23	?	0	0005949065			20190923.ifs	2019-09-23	2019-09-24
3780969	3780969	DIVIDEND	ADD	464288836		0	0	1	0	.535159		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898631			20190614.ifs	2019-06-14	2019-06-15
3780992	3780992	DIVIDEND	ADD	464288836		0	0	1	0	.535159		00	2019-06-17	2019-06-18	2019-06-21	2019-06-14		0	2019-06-14	?	0	0005898631			20190614.ifs	2019-06-14	2019-06-15
3638063	3638063	DIVIDEND	ADD	464288836		0	0	1	0	.556531		00	2019-03-20	2019-03-21	2019-03-26	2019-03-19		0	2019-03-19	?	0	0005854892			20190319.ifs	2019-03-19	2019-03-20
3638066	3638066	DIVIDEND	ADD	464288836		0	0	1	0	.556531		00	2019-03-20	2019-03-21	2019-03-26	2019-03-19		0	2019-03-19	?	0	0005854892			20190319.ifs	2019-03-19	2019-03-20
3442937	3442937	DIVIDEND	ADD	464288836		0	0	1	0	.350527		00	2018-12-17	2018-12-18	2018-12-21	2018-12-14		0	2018-12-14	?	0	0005781483			20181214.ifs	2018-12-14	2018-12-15
3443767	3443767	DIVIDEND	ADD	464288836		0	0	1	0	.350527		00	2018-12-17	2018-12-18	2018-12-21	2018-12-14		0	2018-12-14	?	0	0005781483			20181214.ifs	2018-12-14	2018-12-15
3299129	3299129	DIVIDEND	ADD	464288836		0	0	1	0	.396374		00	2018-09-26	2018-09-27	2018-10-02	2018-09-25		0	2018-09-25	?	0	0005728801			20180925.ifs	2018-09-25	2018-09-26
3299236	3299236	DIVIDEND	ADD	464288836		0	0	1	0	.396374		00	2018-09-26	2018-09-27	2018-10-02	2018-09-25		0	2018-09-25	?	0	0005728801			20180925.ifs	2018-09-25	2018-09-26
3000781	3000781	DIVIDEND	ADD	464288836		0	0	1	0	.530441		00	2018-03-22	2018-03-23	2018-03-28	2018-03-21		0	2018-03-21	?	0	0005632747			20180321.ifs	2018-03-21	2018-03-22
3000802	3000802	DIVIDEND	ADD	464288836		0	0	1	0	.530441		00	2018-03-22	2018-03-23	2018-03-28	2018-03-21		0	2018-03-21	?	0	0005632747			20180321.ifs	2018-03-21	2018-03-22
2839560	2839560	DIVIDEND	ADD	464288836		0	0	1	0	.372485		00	2017-12-19	2017-12-20	2017-12-26	2017-12-18		0	2017-12-18	?	0	0005564354			20171218.ifs	2017-12-18	2017-12-19
2686733	2686733	DIVIDEND	ADD	464288836		0	0	1	0	.449501		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005502006			20170925.ifs	2017-09-25	2017-09-26
2686780	2686780	DIVIDEND	ADD	464288836		0	0	1	0	.449501		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005502006			20170925.ifs	2017-09-25	2017-09-26
2601181	2601181	DIVIDEND	ADD	464288836		0	0	1	0	.91844		00	2017-06-27	2017-06-29	2017-06-30	2017-06-26		0	2017-06-26	?	0	0005454918			20170626.ifs	2017-06-26	2017-06-27
2518848	2518848	DIVIDEND	ADD	464288836		0	0	1	0	.358233		00	2017-03-24	2017-03-28	2017-03-30	2017-03-23		0	2017-03-23	?	0	0005406967			20170323.ifs	2017-03-23	2017-03-24
2439874	2439874	EQUITY	CHANGE	464288836	ISHARES U.S. PHARMACEUTICALS ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-01	?							20170123.ifs	2017-01-23	2017-01-24
2439875	2439874	EQUITY	CHANGE	464288836	ISHARES U.S. PHARMACEUTICALS ETF	0	A	2006-05-05	?	4	no	no		no		2006-05-08	2013-07-01	?							20170123.ifs	2017-01-23	2017-01-24
2388201	2388201	DIVIDEND	ADD	464288836		0	0	1	0	.33773		00	2016-12-21	2016-12-23	2016-12-28	2016-12-20		0	2016-12-20	?	0	0005346390			20161220.ifs	2016-12-20	2016-12-21
2301170	2301170	DIVIDEND	ADD	464288836		0	0	1	0	.315888		00	2016-09-26	2016-09-28	2016-09-30	2016-09-23		0	2016-09-23	?	0	0005285135			20160923.ifs	2016-09-23	2016-09-24
2225290	2225290	DIVIDEND	ADD	464288836		0	0	1	0	.33363		00	2016-06-21	2016-06-23	2016-06-27	2016-06-20		0	2016-06-20	?	0	0005235521			20160620.ifs	2016-06-20	2016-06-21
2140461	2140461	DIVIDEND	ADD	464288836		0	0	1	0	.308019		00	2016-03-23	2016-03-28	2016-03-30	2016-03-22		0	2016-03-22	?	0	0005190716			20160322.ifs	2016-03-22	2016-03-23
2063466	2063466	DIVIDEND	ADD	464288836		8	0	1	9	1.644809		96	2015-12-24	2015-12-29	2015-12-31	2015-12-23		0	2015-12-23	?	1	0005138751			20151223.ifs	2015-12-23	2015-12-24
2063467	2063467	DIVIDEND	ADD	464288836		0	0	1	0	.445543		00	2015-12-24	2015-12-29	2015-12-31	2015-12-23		0	2015-12-23	?	0	0005138749			20151223.ifs	2015-12-23	2015-12-24
1972235	1972235	DIVIDEND	ADD	464288836		0	0	1	0	.381386		00	2015-09-25	2015-09-29	2015-10-01	2015-09-24		0	2015-09-24	?	0	0005067360			20150924.ifs	2015-09-24	2015-09-25
1893616	1893616	DIVIDEND	ADD	464288836		0	0	1	0	.387832		00	2015-06-24	2015-06-26	2015-06-30	2015-06-23		0	2015-06-23	?	0	0005018453			20150623.ifs	2015-06-23	2015-06-24
1819277	1819277	DIVIDEND	ADD	464288836		0	0	1	0	.255405		00	2015-03-25	2015-03-27	2015-03-31	2015-03-24		0	2015-03-24	?	0	0004972942			20150324.ifs	2015-03-24	2015-03-25
1740531	1740531	DIVIDEND	ADD	464288836		0	0	1	0	.385577		00	2014-12-24	2014-12-29	2014-12-31	2014-12-23		0	2014-12-23	?	0	0004919730			20141223.ifs	2014-12-23	2014-12-24
1636506	1636506	DIVIDEND	ADD	464288836		0	0	1	0	.393688		00	2014-09-24	2014-09-26	2014-09-30	2014-09-23		0	2014-09-23	?	0	0004846736			20140923.ifs	2014-09-23	2014-09-24
1557032	1557032	DIVIDEND	ADD	464288836		0	0	1	0	.759272		00	2014-06-24	2014-06-26	2014-06-30	2014-06-23		0	2014-06-23	?	0	0004800705			20140623.ifs	2014-06-23	2014-06-24
1474527	1474527	DIVIDEND	ADD	464288836		0	0	1	0	.279388		00	2014-03-25	2014-03-27	2014-03-31	2014-03-24		0	2014-03-24	?	0	0004754638			20140324.ifs	2014-03-24	2014-03-25
1396978	1396978	DIVIDEND	ADD	464288836		0	0	1	9	.062823		03	2013-12-27	2013-12-31	2014-01-03	2013-12-26		0	2013-12-26	?	0	0004705172			20131226.ifs	2013-12-26	2013-12-27
1389355	1389355	DIVIDEND	ADD	464288836		0	0	1	0	.274841		00	2013-12-23	2013-12-26	2013-12-30	2013-12-20		0	2013-12-20	?	0	0004698570			20131220.ifs	2013-12-20	2013-12-21
1294245	1294245	DIVIDEND	ADD	464288836		0	0	1	0	.289685		00	2013-09-24	2013-09-26	2013-09-30	2013-09-23		0	2013-09-23	?	0	0004632700			20130923.ifs	2013-09-23	2013-09-24
1226640	1226640	CORPACTION	ADD	464288836	04	#	2013-07-01	464288836	04	?															20130701.ifs	2013-07-01	2013-07-02
1226641	1226641	CORPACTIONAUX	ADD	464288836	04	2013-07-01	IHE	ISHARES TR	ISHARES TRUST -	IHE	ISHARES TR	ISHARES U.S. PH	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226642	1226642	EQUITY	CHANGE	464288836	DJ US PHARMCUTLS INDEX FD	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2008-03-14	?							20130701.ifs	2013-07-01	2013-07-02
1226643	1226642	EQUITY	CHANGE	464288836	ISHARES U.S. PHARMACEUTICALS ETF	0	A	2006-05-05	?	0	no	no		no		2006-05-08	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1217515	1217515	DIVIDEND	ADD	464288836		0	0	1	0	.326337		00	2013-06-26	2013-06-28	2013-07-02	2013-06-25		0	2013-06-25	?	0	0004588946			20130625.ifs	2013-06-25	2013-06-26
1140184	1140184	DIVIDEND	ADD	464288836		0	0	1	0	.299652		00	2013-03-25	2013-03-27	2013-04-01	2013-03-22		0	2013-03-22	?	0	0004545078			20130322.ifs	2013-03-22	2013-03-23
1047862	1047862	DIVIDEND	ADD	464288836		0	0	1	0	.403484		00	2012-12-19	2012-12-21	2012-12-26	2012-12-18		0	2012-12-18	?	0	0004485663			20121218.ifs	2012-12-18	2012-12-19
963407	963407	DIVIDEND	ADD	464288836		0	0	1	0	.662392		00	2012-09-25	2012-09-27	2012-10-01	2012-09-24		0	2012-09-24	?	0	0004433159			20120924.ifs	2012-09-24	2012-09-25
887462	887462	DIVIDEND	ADD	464288836		0	0	1	0	.309461		00	2012-06-19	2012-06-21	2012-06-25	2012-06-18		0	2012-06-18	?	0	0004387638			20120618.ifs	2012-06-18	2012-06-19
809520	809520	DIVIDEND	ADD	464288836		0	0	1	0	.29981		00	2012-03-26	2012-03-28	2012-03-30	2012-03-23		0	2012-03-23	?	0	0004349499			20120323.ifs	2012-03-23	2012-03-24
650806	650806	DIVIDEND	ADD	464288836		0	0	1	0	.252454		00	2011-09-23	2011-09-27	2011-09-29	2011-09-22		0	2011-09-22	?	0	0004245764			20110922.ifs	2011-09-22	2011-09-23
568272	568272	DIVIDEND	ADD	464288836		0	0	1	0	.226421		00	2011-06-24	2011-06-28	2011-06-30	2011-06-23		0	2011-06-23	?	0	0004205164			20110623.ifs	2011-06-23	2011-06-24
479643	479643	DIVIDEND	ADD	464288836		0	0	1	0	.207088		00	2011-03-25	2011-03-29	2011-03-31	2011-03-24		0	2011-03-24	?	0	0004163798			20110324.ifs	2011-03-24	2011-03-25
389308	389308	DIVIDEND	ADD	464288836		0	0	1	0	.257507		00	2010-12-22	2010-12-27	2010-12-29	2010-12-21		0	2010-12-21	?	0	0004114322			20101221.ifs	2010-12-21	2010-12-22
302836	302836	DIVIDEND	ADD	464288836		0	0	1	6	0		08	2010-09-23	2010-09-27	2010-09-29	2010-09-07		0	2010-09-07	?	0	0004058578			20100907.ifs	2010-09-07	2010-09-08
226800	226800	DIVIDEND	DELETE	464288836		0	0	1	6	0		08	2010-06-24	2010-06-28	2010-06-30	2010-06-03		0	2010-06-03	?	0	0004016462			20100623.ifs	2010-06-23	2010-06-24
226801	226801	DIVIDEND	ADD	464288836		0	0	1	0	.22217		00	2010-06-24	2010-06-28	2010-06-30	2010-06-03		1	2010-06-03	2010-06-23	0	0004016462			20100623.ifs	2010-06-23	2010-06-24
213129	213129	DIVIDEND	ADD	464288836		0	0	1	6	0		08	2010-06-24	2010-06-28	2010-06-30	2010-06-03		0	2010-06-03	?	0	0004016462			20100603.ifs	2010-06-03	2010-06-04
139600	139600	DIVIDEND	DELETE	464288836		0	0	1	6	0		08	2010-03-25	2010-03-29	2010-03-31	2010-03-18		0	2010-03-18	?	0	0003978839			20100324.ifs	2010-03-24	2010-04-07
139601	139601	DIVIDEND	ADD	464288836		0	0	1	0	.19031		00	2010-03-25	2010-03-29	2010-03-31	2010-03-18		1	2010-03-18	2010-03-24	0	0003978839			20100324.ifs	2010-03-24	2010-04-07
134906	134906	DIVIDEND	ADD	464288836		0	0	1	6	0		08	2010-03-25	2010-03-29	2010-03-31	2010-03-18		0	2010-03-18	?	0	0003978839			20100318.ifs	2010-03-18	2010-04-07
62775	62775	DIVIDEND	ADD	464288836		0	0	1	0	.19701		00	2009-12-23	2009-12-28	2009-12-30	2009-12-22		0	2009-12-22	?	0	0003936258			20091222.ifs	2009-12-22	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 = 152113
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