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
5443255	5443255	DIVIDEND	ADD	92189F676		0	0	1	0	1.0427		35	2023-12-18	2023-12-19	2023-12-22	2023-12-15		0	2023-12-15	?	0	0006835840			20231215.ifs	2023-12-15	2023-12-16
5272030	5272030	DIVIDEND	ADD	92189F676		0	0	6	0	1		11	2023-05-05	2023-05-03	2023-05-04	2023-04-11		0	2023-04-14	?	0	0006712681			20230414.ifs	2023-04-14	2023-04-15
5272031	5272031	SPLIT	ADD	92189F676	.5	2023-05-05	11	2023-04-14	?																20230414.ifs	2023-04-14	2023-04-15
5172794	5172794	DIVIDEND	ADD	92189F676		0	0	1	0	2.401		00	2022-12-19	2022-12-20	2022-12-23	2022-12-16		0	2022-12-16	?	0	0006640560			20221216.ifs	2022-12-16	2022-12-17
4897565	4897565	DIVIDEND	CHANGE	92189F676		0	0	1	0	1.5022		00	2020-12-21	2020-12-22	2020-12-28	2020-12-18		0	2020-12-18	?	0	0006224437			20211217.ifs	2021-12-17	2021-12-18
4897566	4897565	DIVIDEND	CHANGE	92189F676		0	0	1	0	1.5022		00	2020-12-21	2020-12-22	2020-12-28	2020-12-18		1	2020-12-18	2021-12-17	0	0006224437			20211217.ifs	2021-12-17	2021-12-18
4897567	4897567	DIVIDEND	ADD	92189F676		0	0	1	0	1.5733		00	2021-12-20	2021-12-21	2021-12-27	2021-12-17		0	2021-12-17	?	0	0006435670			20211217.ifs	2021-12-17	2021-12-18
4554334	4554334	DIVIDEND	ADD	92189F676		0	0	1	0	1.5022		00	2020-12-21	2020-12-22	2020-12-28	2020-12-18		0	2020-12-18	?	0	0006224437			20201218.ifs	2020-12-18	2020-12-19
4102801	4102801	DIVIDEND	ADD	92189F676		0	0	1	0	2.1222		00	2019-12-23	2019-12-24	2019-12-30	2019-12-20		0	2019-12-20	?	0	0006018507			20191220.ifs	2019-12-20	2019-12-21
4103667	4103667	DIVIDEND	ADD	92189F676		0	0	1	0	2.1222		00	2019-12-23	2019-12-24	2019-12-30	2019-12-20		0	2019-12-20	?	0	0006018507			20191220.ifs	2019-12-20	2019-12-21
4052047	4052047	CORPACTION	ADD	92189F676	04	X	2019-12-11	92189F676	60	?															20191211.ifs	2019-12-11	2019-12-12
4052049	4052049	EXCHANGE	ADD	92189F676	60	2019-12-11	2019-12-11	SMH	0	A	2019-12-11	?													20191211.ifs	2019-12-11	2019-12-12
4052051	4052051	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	A	2016-04-25	?	1	no	no		no		2016-04-26	?	?							20191211.ifs	2019-12-11	2019-12-12
4052053	4052052	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	A	2016-04-25	?	1	no	no		yes		2016-04-26	2019-12-11	?							20191211.ifs	2019-12-11	2019-12-12
4052202	4052202	CORPACTION	ADD	92189F676	04	X	2019-12-11	92189F676	60	?															20191211.ifs	2019-12-11	2019-12-12
4052204	4052204	EXCHANGE	ADD	92189F676	60	2019-12-11	2019-12-11	SMH	0	A	2019-12-11	?													20191211.ifs	2019-12-11	2019-12-12
4052206	4052206	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	A	2016-04-25	?	1	no	no		no		2016-04-26	?	?							20191211.ifs	2019-12-11	2019-12-12
4052208	4052207	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	A	2016-04-25	?	1	no	no		yes		2016-04-26	2019-12-11	?							20191211.ifs	2019-12-11	2019-12-12
3465420	3465420	DIVIDEND	ADD	92189F676		0	0	1	0	1.638		00	2018-12-20	2018-12-21	2018-12-27	2018-12-19		0	2018-12-19	?	0	0005792603			20181219.ifs	2018-12-19	2018-12-20
3466085	3466085	DIVIDEND	ADD	92189F676		0	0	1	0	1.638		00	2018-12-20	2018-12-21	2018-12-27	2018-12-19		0	2018-12-19	?	0	0005792603			20181219.ifs	2018-12-19	2018-12-20
2832052	2832052	DIVIDEND	ADD	92189F676		0	0	1	0	1.396		00	2017-12-18	2017-12-19	2017-12-22	2017-12-15		0	2017-12-15	?	0	0005561164			20171215.ifs	2017-12-15	2017-12-16
2470671	2470671	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	A	2016-04-25	?	0	no	no		no		2016-04-26	?	?							20170126.ifs	2017-01-26	2017-01-27
2470672	2470671	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	A	2016-04-25	?	1	no	no		no		2016-04-26	?	?							20170126.ifs	2017-01-26	2017-01-27
2422275	2422275	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	0	2016-04-25	?	0	no	no		no		2016-04-26	?	?							20170110.ifs	2017-01-10	2017-01-11
2422276	2422275	EQUITY	CHANGE	92189F676	SEMICONDUCTOR ETF	0	A	2016-04-25	?	0	no	no		no		2016-04-26	?	?							20170110.ifs	2017-01-10	2017-01-11
2379060	2379060	DIVIDEND	ADD	92189F676		0	0	1	0	.576		00	2016-12-19	2016-12-21	2016-12-23	2016-12-16		0	2016-12-16	?	0	0005340882			20161216.ifs	2016-12-16	2016-12-17
2185568	2185568	EXCHANGE	ADD	92189F676	04	2016-05-02	2016-05-02	SMH	0	0	2016-05-02	?													20160502.ifs	2016-05-02	2016-05-03
2178580	2178580	EQUITY	ADD	92189F676	SEMICONDUCTOR ETF	0	0	2016-04-25	?	0	no	no		no		2016-04-26	?	?							20160426.ifs	2016-04-26	2016-04-27

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