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
1787454	1787454	EQUITY	CHANGE	782474522	EQUITY ETF	L	A	2011-04-15	2015-01-27	0	no	no		no		2011-04-15	2015-01-27	?							20150206.ifs	2015-02-06	2015-02-07
1787455	1787454	EQUITY	CHANGE	782474522	EQUITY ETF	L	A	2011-04-15	2015-02-06	0	no	no		no		2011-04-15	2015-02-06	?							20150206.ifs	2015-02-06	2015-02-07
1787456	1787456	CORPACTION	ADD	782474522	04	L	2015-02-06			?															20150206.ifs	2015-02-06	2015-02-07
1775183	1775183	CORPACTION	ADD	782474522	04	L	2015-01-27			2015-01-27															20150127.ifs	2015-01-27	2015-01-28
1775184	1775184	EQUITY	CHANGE	782474522	EQUITY ETF	0	A	2011-04-15	?	0	no	no		no		2011-04-15	2011-04-15	?							20150127.ifs	2015-01-27	2015-01-28
1775185	1775184	EQUITY	CHANGE	782474522	EQUITY ETF	L	A	2011-04-15	2015-01-27	0	no	no		no		2011-04-15	2015-01-27	?							20150127.ifs	2015-01-27	2015-01-28
1739765	1739765	DIVIDEND	ADD	782474522		0	0	1	0	.250241		00	2014-12-24	2014-12-29	2014-12-31	2014-12-23		0	2014-12-23	?	0	0004919350			20141223.ifs	2014-12-23	2014-12-24
1690159	1690159	DIVIDEND	CHANGE	782474522		0	0	1	0	.117676		00	2014-09-24	2014-09-26	2014-09-30	2014-09-23		0	2014-09-23	?	0	0004846700			20141128.ifs	2014-11-28	2014-11-29
1690160	1690159	DIVIDEND	CHANGE	782474522		0	0	1	0	.117676		00	2014-09-24	2014-09-26	2014-09-30	2014-09-23		1	2014-09-23	2014-11-28	0	0004846700			20141128.ifs	2014-11-28	2014-11-29
1636311	1636311	DIVIDEND	ADD	782474522		0	0	1	0	.117676		00	2014-09-24	2014-09-26	2014-09-30	2014-09-23		0	2014-09-23	?	0	0004846700			20140923.ifs	2014-09-23	2014-09-24
1565756	1565756	DIVIDEND	CHANGE	782474522		0	0	1	0	.315834		00	2014-06-24	2014-06-26	2014-06-30	2014-06-23		0	2014-06-23	?	0	0004800548			20140630.ifs	2014-06-30	2014-07-01
1565757	1565756	DIVIDEND	CHANGE	782474522		0	0	1	0	.32414		00	2014-06-24	2014-06-26	2014-06-30	2014-06-23		1	2014-06-23	2014-06-30	0	0004800548			20140630.ifs	2014-06-30	2014-07-01
1556875	1556875	DIVIDEND	ADD	782474522		0	0	1	0	.315834		00	2014-06-24	2014-06-26	2014-06-30	2014-06-23		0	2014-06-23	?	0	0004800548			20140623.ifs	2014-06-23	2014-06-24
1474353	1474353	DIVIDEND	ADD	782474522		0	0	1	0	.165016		00	2014-03-25	2014-03-27	2014-03-31	2014-03-24		0	2014-03-24	?	0	0004754447			20140324.ifs	2014-03-24	2014-03-25
1395013	1395013	DIVIDEND	ADD	782474522		0	0	1	0	.200356		00	2013-12-26	2013-12-30	2014-01-02	2013-12-24		0	2013-12-24	?	0	0004703354			20131224.ifs	2013-12-24	2013-12-25
1292664	1292664	DIVIDEND	ADD	782474522		0	0	1	0	.029646		00	2013-09-23	2013-09-25	2013-09-27	2013-09-20		0	2013-09-20	?	0	0004632004			20130920.ifs	2013-09-20	2013-09-21
1214482	1214482	DIVIDEND	ADD	782474522		0	0	1	0	.273544		00	2013-06-24	2013-06-26	2013-06-28	2013-06-21		0	2013-06-21	?	0	0004587618			20130621.ifs	2013-06-21	2013-06-22
1140062	1140062	DIVIDEND	ADD	782474522		0	0	1	0	.090598		00	2013-03-25	2013-03-27	2013-04-01	2013-03-22		0	2013-03-22	?	0	0004545051			20130322.ifs	2013-03-22	2013-03-23
1060472	1060472	DIVIDEND	ADD	782474522		0	0	1	0	.502822		00	2012-12-27	2012-12-31	2013-01-02	2012-12-26		0	2012-12-26	?	0	0004495653			20121226.ifs	2012-12-26	2012-12-27
961800	961800	DIVIDEND	ADD	782474522		0	0	1	0	.076808		00	2012-09-24	2012-09-26	2012-09-28	2012-09-21		0	2012-09-21	?	0	0004432588			20120921.ifs	2012-09-21	2012-09-22
891930	891930	DIVIDEND	ADD	782474522		0	0	1	0	.058588		00	2012-06-25	2012-06-27	2012-06-29	2012-06-22		0	2012-06-22	?	0	0004390569			20120622.ifs	2012-06-22	2012-06-23
809430	809430	DIVIDEND	ADD	782474522		0	0	1	0	.040045		00	2012-03-26	2012-03-28	2012-03-30	2012-03-23		0	2012-03-23	?	0	0004349450			20120323.ifs	2012-03-23	2012-03-24
651849	651849	DIVIDEND	ADD	782474522		0	0	1	0	.040413		00	2011-09-26	2011-09-28	2011-09-30	2011-09-23		0	2011-09-23	?	0	0004246367			20110923.ifs	2011-09-23	2011-09-24
569485	569485	DIVIDEND	ADD	782474522		0	0	1	0	.006686		00	2011-06-27	2011-06-29	2011-07-01	2011-06-24		0	2011-06-24	?	0	0004205764			20110624.ifs	2011-06-24	2011-06-25
502595	502595	EQUITY	ADD	782474522	EQUITY ETF	N	7	2011-04-15	?	0	no	no		no		2011-04-15	?	?							20110415.ifs	2011-04-15	2011-04-16
502599	502599	EXCHANGE	ADD	782474522	04	2011-04-15	2011-04-15	ONEF	0	A	2011-04-15	?													20110415.ifs	2011-04-15	2011-04-16
502791	502791	EQUITY	CHANGE	782474522	EQUITY ETF	N	7	2011-04-15	?	0	no	no		no		2011-04-15	?	?							20110415.ifs	2011-04-15	2011-04-16
502792	502791	EQUITY	CHANGE	782474522	EQUITY ETF	N	A	2011-04-15	?	0	no	no		no		2011-04-15	2011-04-15	?							20110415.ifs	2011-04-15	2011-04-16
503289	503289	EQUITY	CHANGE	782474522	EQUITY ETF	N	A	2011-04-15	?	0	no	no		no		2011-04-15	2011-04-15	?							20110415.ifs	2011-04-15	2011-04-16
503290	503289	EQUITY	CHANGE	782474522	EQUITY ETF	0	A	2011-04-15	?	0	no	no		no		2011-04-15	2011-04-15	?							20110415.ifs	2011-04-15	2011-04-16

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