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
5586641	5586641	DIVIDEND	ADD	92189F692		0	0	1	0	.3558		00	2024-07-01	2024-07-01	2024-07-05	2024-06-28		0	2024-06-28	?	0	0006941796			20240628.ifs	2024-06-28	2024-06-29
5526186	5526186	DIVIDEND	ADD	92189F692		0	0	1	0	.5328		00	2024-04-01	2024-04-02	2024-04-05	2024-03-28		0	2024-03-28	?	0	0006898390			20240328.ifs	2024-03-28	2024-03-29
5461008	5461008	DIVIDEND	ADD	92189F692		0	0	1	0	.3074		00	2023-12-27	2023-12-28	2023-12-29	2023-12-26		0	2023-12-26	?	0	0006849940			20231226.ifs	2023-12-26	2023-12-27
5384259	5384259	DIVIDEND	ADD	92189F692		0	0	1	0	.3398		00	2023-10-02	2023-10-03	2023-10-06	2023-09-29		0	2023-09-29	?	0	0006791388			20230929.ifs	2023-09-29	2023-09-30
5323298	5323298	DIVIDEND	ADD	92189F692		0	0	1	0	.3891		00	2023-07-03	2023-07-05	2023-07-07	2023-06-30		0	2023-06-30	?	0	0006748806			20230630.ifs	2023-06-30	2023-07-01
5259808	5259808	DIVIDEND	ADD	92189F692		0	0	1	0	.6641		00	2023-04-03	2023-04-04	2023-04-10	2023-03-31		0	2023-03-31	?	0	0006705093			20230331.ifs	2023-03-31	2023-04-01
5190046	5190046	DIVIDEND	ADD	92189F692		0	0	1	0	.24		00	2022-12-28	2022-12-29	2022-12-30	2022-12-27		0	2022-12-27	?	0	0006653831			20221227.ifs	2022-12-27	2022-12-28
5108651	5108651	DIVIDEND	ADD	92189F692		0	0	1	0	.2696		00	2022-10-03	2022-10-04	2022-10-07	2022-09-30		0	2022-09-30	?	0	0006592318			20220930.ifs	2022-09-30	2022-10-01
5046139	5046139	DIVIDEND	ADD	92189F692		0	0	1	0	.2496		00	2022-07-01	2022-07-05	2022-07-08	2022-06-30		0	2022-06-30	?	0	0006548247			20220630.ifs	2022-06-30	2022-07-01
4982101	4982101	DIVIDEND	ADD	92189F692		0	0	1	0	.4429		00	2022-04-01	2022-04-04	2022-04-07	2022-03-31		0	2022-03-31	?	0	0006503634			20220331.ifs	2022-03-31	2022-04-01
4913958	4913958	DIVIDEND	ADD	92189F692		0	0	1	0	.2691		00	2021-12-29	2021-12-30	2021-12-31	2021-12-28		0	2021-12-28	?	0	0006450464			20211228.ifs	2021-12-28	2021-12-29
4814053	4814053	DIVIDEND	ADD	92189F692		0	0	1	0	.3453		00	2021-10-01	2021-10-04	2021-10-07	2021-09-30		0	2021-09-30	?	0	0006375902			20210930.ifs	2021-09-30	2021-10-01
4743125	4743125	DIVIDEND	ADD	92189F692		0	0	1	0	.2859		00	2021-07-01	2021-07-02	2021-07-08	2021-06-30		0	2021-06-30	?	0	0006331434			20210630.ifs	2021-06-30	2021-07-01
4667773	4667773	DIVIDEND	ADD	92189F692		0	0	1	0	.3497		00	2021-04-01	2021-04-05	2021-04-08	2021-03-31		0	2021-03-31	?	0	0006286184			20210331.ifs	2021-03-31	2021-04-01
4574718	4574718	DIVIDEND	ADD	92189F692		0	0	1	0	.2662		00	2020-12-29	2020-12-30	2021-01-05	2020-12-28		0	2020-12-28	?	0	0006233931			20201228.ifs	2020-12-28	2020-12-29
4473290	4473290	DIVIDEND	ADD	92189F692		0	0	1	0	.2493		00	2020-10-01	2020-10-02	2020-10-07	2020-09-30		0	2020-09-30	?	0	0006167345			20200930.ifs	2020-09-30	2020-10-01
4405483	4405483	DIVIDEND	ADD	92189F692		0	0	1	0	.2523		00	2020-07-01	2020-07-02	2020-07-08	2020-06-30		0	2020-06-30	?	0	0006122355			20200630.ifs	2020-06-30	2020-07-01
4264355	4264355	DIVIDEND	ADD	92189F692		0	0	1	0	.3374		00	2020-04-01	2020-04-02	2020-04-07	2020-03-31		0	2020-03-31	?	0	0006077593			20200331.ifs	2020-03-31	2020-04-01
4264452	4264452	DIVIDEND	ADD	92189F692		0	0	1	0	.3374		00	2020-04-01	2020-04-02	2020-04-07	2020-03-31		0	2020-03-31	?	0	0006077593			20200331.ifs	2020-03-31	2020-04-01
4124536	4124536	DIVIDEND	ADD	92189F692		0	0	1	0	.1729		00	2019-12-30	2019-12-31	2020-01-06	2019-12-27		0	2019-12-27	?	0	0006028562			20191227.ifs	2019-12-27	2019-12-28
4124653	4124653	DIVIDEND	ADD	92189F692		0	0	1	0	.1729		00	2019-12-30	2019-12-31	2020-01-06	2019-12-27		0	2019-12-27	?	0	0006028562			20191227.ifs	2019-12-27	2019-12-28
3947481	3947481	DIVIDEND	ADD	92189F692		0	0	1	0	.292		00	2019-10-01	2019-10-02	2019-10-07	2019-09-30		0	2019-09-30	?	0	0005954246			20190930.ifs	2019-09-30	2019-10-01
3947496	3947496	DIVIDEND	ADD	92189F692		0	0	1	0	.292		00	2019-10-01	2019-10-02	2019-10-07	2019-09-30		0	2019-09-30	?	0	0005954246			20190930.ifs	2019-09-30	2019-10-01
3808971	3808971	DIVIDEND	ADD	92189F692		0	0	1	0	.281		00	2019-07-01	2019-07-02	2019-07-08	2019-06-28		0	2019-06-28	?	0	0005908451			20190628.ifs	2019-06-28	2019-06-29
3809054	3809054	DIVIDEND	ADD	92189F692		0	0	1	0	.281		00	2019-07-01	2019-07-02	2019-07-08	2019-06-28		0	2019-06-28	?	0	0005908451			20190628.ifs	2019-06-28	2019-06-29
3657552	3657552	DIVIDEND	ADD	92189F692		0	0	1	0	.39		00	2019-04-01	2019-04-02	2019-04-05	2019-03-29		0	2019-03-29	?	0	0005862337			20190329.ifs	2019-03-29	2019-03-30
3657621	3657621	DIVIDEND	ADD	92189F692		0	0	1	0	.39		00	2019-04-01	2019-04-02	2019-04-05	2019-03-29		0	2019-03-29	?	0	0005862337			20190329.ifs	2019-03-29	2019-03-30
3496240	3496240	DIVIDEND	ADD	92189F692		0	0	1	0	.2032		00	2018-12-27	2018-12-28	2019-01-03	2018-12-26		0	2018-12-26	?	0	0005805893			20181226.ifs	2018-12-26	2018-12-27
3496258	3496258	DIVIDEND	ADD	92189F692		0	0	1	0	.2032		00	2018-12-27	2018-12-28	2019-01-03	2018-12-26		0	2018-12-26	?	0	0005805893			20181226.ifs	2018-12-26	2018-12-27
3304716	3304716	DIVIDEND	ADD	92189F692		0	0	1	0	.2345		00	2018-10-01	2018-10-02	2018-10-05	2018-09-28		0	2018-09-28	?	0	0005732368			20180928.ifs	2018-09-28	2018-09-29
3304729	3304729	DIVIDEND	ADD	92189F692		0	0	1	0	.2345		00	2018-10-01	2018-10-02	2018-10-05	2018-09-28		0	2018-09-28	?	0	0005732368			20180928.ifs	2018-09-28	2018-09-29
3165663	3165663	DIVIDEND	ADD	92189F692		0	0	1	0	.2493		00	2018-07-02	2018-07-03	2018-07-09	2018-06-29		0	2018-06-29	?	0	0005685831			20180629.ifs	2018-06-29	2018-06-30
3165702	3165702	DIVIDEND	ADD	92189F692		0	0	1	0	.2493		00	2018-07-02	2018-07-03	2018-07-09	2018-06-29		0	2018-06-29	?	0	0005685831			20180629.ifs	2018-06-29	2018-06-30
3013794	3013794	DIVIDEND	ADD	92189F692		0	0	1	0	.3943		00	2018-04-02	2018-04-03	2018-04-06	2018-03-29		0	2018-03-29	?	0	0005639181			20180329.ifs	2018-03-29	2018-03-30
2868951	2868951	DIVIDEND	ADD	92189F692		0	0	1	0	.15		00	2017-12-27	2017-12-28	2018-01-03	2017-12-26		0	2017-12-26	?	0	0005580834			20171226.ifs	2017-12-26	2017-12-27
2695223	2695223	DIVIDEND	ADD	92189F692		0	0	1	0	.221		00	2017-10-02	2017-10-03	2017-10-11	2017-09-29		0	2017-09-29	?	0	0005506483			20170929.ifs	2017-09-29	2017-09-30
2695561	2695561	DIVIDEND	ADD	92189F692		0	0	1	0	.221		00	2017-10-02	2017-10-03	2017-10-11	2017-09-29		0	2017-09-29	?	0	0005506483			20170929.ifs	2017-09-29	2017-09-30
2607345	2607345	DIVIDEND	ADD	92189F692		0	0	1	0	.304		00	2017-07-03	2017-07-06	2017-07-10	2017-06-30		0	2017-06-30	?	0	0005459859			20170630.ifs	2017-06-30	2017-07-01
2526248	2526248	DIVIDEND	ADD	92189F692		0	0	1	0	.4651		00	2017-04-03	2017-04-05	2017-04-07	2017-03-31		0	2017-03-31	?	0	0005412319			20170331.ifs	2017-03-31	2017-04-01
2446764	2446764	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	0	A	2016-05-02	?	0	no	no		yes		2016-05-02	2016-05-02	?							20170123.ifs	2017-01-23	2017-01-24
2446765	2446764	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	0	A	2016-05-02	?	4	no	no		yes		2016-05-02	2016-05-02	?							20170123.ifs	2017-01-23	2017-01-24
2422413	2422413	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	0	0	2016-05-02	?	0	no	no		yes		2016-05-02	2016-05-02	?							20170110.ifs	2017-01-10	2017-01-11
2422414	2422413	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	0	A	2016-05-02	?	0	no	no		yes		2016-05-02	2016-05-02	?							20170110.ifs	2017-01-10	2017-01-11
2397673	2397673	DIVIDEND	ADD	92189F692		0	0	1	0	.1449		00	2016-12-28	2016-12-30	2017-01-04	2016-12-27		0	2016-12-27	?	0	0005355724			20161227.ifs	2016-12-27	2016-12-28
2307159	2307159	DIVIDEND	ADD	92189F692		0	0	1	0	.2148		00	2016-10-03	2016-10-05	2016-10-07	2016-09-30		0	2016-09-30	?	0	0005289872			20160930.ifs	2016-09-30	2016-10-01
2236588	2236588	DIVIDEND	ADD	92189F692		0	0	1	0	.2867		00	2016-07-01	2016-07-06	2016-07-08	2016-06-30		0	2016-06-30	?	0	0005243220			20160630.ifs	2016-06-30	2016-07-01
2185476	2185476	EQUITY	ADD	92189F692	PHARMACEUTICAL ETF	N	0	2016-05-02	?	0	no	no		no		2016-05-02	?	?							20160502.ifs	2016-05-02	2016-05-03
2185479	2185479	EXCHANGE	ADD	92189F692	60	2016-05-02	2016-05-02	PPH	0	0	2016-05-02	?													20160502.ifs	2016-05-02	2016-05-03
2185480	2185480	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	N	0	2016-05-02	?	0	no	no		no		2016-05-02	?	?							20160502.ifs	2016-05-02	2016-05-03
2185481	2185480	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	N	0	2016-05-02	?	0	no	no		yes		2016-05-02	2016-05-02	?							20160502.ifs	2016-05-02	2016-05-03
2187025	2187025	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	N	0	2016-05-02	?	0	no	no		yes		2016-05-02	2016-05-02	?							20160502.ifs	2016-05-02	2016-05-03
2187026	2187025	EQUITY	CHANGE	92189F692	PHARMACEUTICAL ETF	0	0	2016-05-02	?	0	no	no		yes		2016-05-02	2016-05-02	?							20160502.ifs	2016-05-02	2016-05-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 = 160402
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