Administration

Update Company

Name

Pricing Date

2024-03-31(LQAP)

CompId

Stop Date

volume

LQStart

Ticker

Price

avevol

LQEnd

Cusip

Last Trade

open

LQAve

Sector

Country

high

MktCap

CompNum

low

yearlylow

Shares Out

Type1

prevClose

yearlyhigh

Last_ShsOut

Exchange

09-30

12-25

sic Code

Description

cik

Updated

	Notes	PAGE RESET
	Run IOIL Charts	Yahoo IOIL Profile
	Run IOIL Institutional Summary	Yahoo IOIL Key Statisics
	J3 Open IOIL Pricing	Yahoo IOIL Pricing
	J3 IOIL Insider J3 IOIL Insitutions	Yahoo IOIL Holders

	Open up Sector/Exchange Map	Fidelity IOIL Lookup
	Open up sec.gov For Market Ca	MSN IOIL Lookup

	2001-01-01 shsout made up date to make % good
	0009-09-09 sdate Dead Company
	2010-12-25 shsout Took From Yahoo
	9000010176 Next Fake CIK to use

INSITITUIONS

Dynamic

newInstitTable

Changed the Cusip/Sector/Shs Out?

Old Cusips
45409B842	DELETE	RUN

Total Insititutions :

N/A

Update Insititution By Cusips

% Owned by Insititutions:

N/A %

0 %

pricingQuarterAdminPageOn:

2024-03-31

New %

the compid is:159773

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

3004405 3004405 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-19 1 no no no 2011-05-05 2018-03-19 ? 20180323.ifs 2018-03-23 2018-03-24

3004406 3004406 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-19 1 no no no 2011-05-05 2018-03-19 ? 20180323.ifs 2018-03-23 2018-03-24

3004407 3004406 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-23 1 no no no 2011-05-05 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004408 3004407 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-23 1 no no no 2011-05-05 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004409 3004409 CORPACTION ADD 45409B842 04 L 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004410 3004410 CORPACTION ADD 45409B842 04 L 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004411 3004411 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-23 1 no no no 2011-05-05 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004412 3004412 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-23 1 no no no 2011-05-05 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004413 3004412 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF L A 2011-05-05 2018-03-23 1 no no no 2011-05-05 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004414 3004413 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF L A 2011-05-05 2018-03-23 1 no no no 2011-05-05 2018-03-23 ? 20180323.ifs 2018-03-23 2018-03-24

3004535 3004535 CORPACTION DELETE 45409B842 04 S 2018-03-19 2018-03-19 20180323.ifs 2018-03-23 2018-03-24

3004536 3004536 CORPACTION DELETE 45409B842 04 S 2018-03-19 2018-03-19 20180323.ifs 2018-03-23 2018-03-24

2996186 2996186 CORPACTION ADD 45409B842 04 S 2018-03-19 2018-03-19 20180319.ifs 2018-03-19 2018-03-20

2996188 2996188 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF 0 A 2011-05-05 ? 1 no no no 2011-05-05 2011-05-05 ? 20180319.ifs 2018-03-19 2018-03-20

2996189 2996189 CORPACTION ADD 45409B842 04 S 2018-03-19 2018-03-19 20180319.ifs 2018-03-19 2018-03-20

2996190 2996189 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-19 1 no no no 2011-05-05 2018-03-19 ? 20180319.ifs 2018-03-19 2018-03-20

2996191 2996191 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF 0 A 2011-05-05 ? 1 no no no 2011-05-05 2011-05-05 ? 20180319.ifs 2018-03-19 2018-03-20

2996193 2996192 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF S A 2011-05-05 2018-03-19 1 no no no 2011-05-05 2018-03-19 ? 20180319.ifs 2018-03-19 2018-03-20

2930698 2930698 DIVIDEND CHANGE 45409B842 0 0 1 0 .1777 00 2017-12-28 2017-12-29 2018-01-03 2017-12-27 0 2017-12-27 ? 0 0005584861 20180126.ifs 2018-01-26 2018-01-27

2930699 2930698 DIVIDEND CHANGE 45409B842 0 0 1 0 .1777 00 2017-12-28 2017-12-29 2018-01-03 2017-12-27 1 2017-12-27 2018-01-26 0 0005584861 20180126.ifs 2018-01-26 2018-01-27

2930716 2930716 DIVIDEND CHANGE 45409B842 0 0 1 0 .1777 00 2017-12-28 2017-12-29 2018-01-03 2017-12-27 0 2017-12-27 ? 0 0005584861 20180126.ifs 2018-01-26 2018-01-27

2930718 2930717 DIVIDEND CHANGE 45409B842 0 0 1 0 .1777 00 2017-12-28 2017-12-29 2018-01-03 2017-12-27 1 2017-12-27 2018-01-26 0 0005584861 20180126.ifs 2018-01-26 2018-01-27

2874485 2874485 DIVIDEND ADD 45409B842 0 0 1 0 .1777 00 2017-12-28 2017-12-29 2018-01-03 2017-12-27 0 2017-12-27 ? 0 0005584861 20171227.ifs 2017-12-27 2017-12-28

2880754 2880754 DIVIDEND ADD 45409B842 0 0 1 0 .1777 00 2017-12-28 2017-12-29 2018-01-03 2017-12-27 0 2017-12-27 ? 0 0005584861 20171227.ifs 2017-12-27 2017-12-28

2461457 2461457 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF 0 A 2011-05-05 ? 0 no no no 2011-05-05 2011-05-05 ? 20170126.ifs 2017-01-26 2017-01-27

2461458 2461457 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF 0 A 2011-05-05 ? 1 no no no 2011-05-05 2011-05-05 ? 20170126.ifs 2017-01-26 2017-01-27

2398577 2398577 DIVIDEND ADD 45409B842 0 0 1 0 .361 00 2016-12-28 2016-12-30 2017-01-04 2016-12-27 0 2016-12-27 ? 0 0005355623 20161227.ifs 2016-12-27 2016-12-28

2066774 2066774 DIVIDEND ADD 45409B842 0 0 1 0 .28896 00 2015-12-29 2015-12-31 2016-01-05 2015-12-28 0 2015-12-28 ? 0 0005141160 20151228.ifs 2015-12-28 2015-12-29

1743944 1743944 DIVIDEND ADD 45409B842 0 0 1 0 .28982 00 2014-12-29 2014-12-31 2015-01-05 2014-12-26 0 2014-12-26 ? 0 0004922105 20141226.ifs 2014-12-26 2014-12-27

1397011 1397011 DIVIDEND ADD 45409B842 0 0 1 0 .15442 00 2013-12-27 2013-12-31 2014-01-03 2013-12-26 0 2013-12-26 ? 0 0004704953 20131226.ifs 2013-12-26 2013-12-27

1061002 1061002 DIVIDEND ADD 45409B842 0 0 1 0 .30234 00 2012-12-27 2012-12-31 2013-01-04 2012-12-26 0 2012-12-26 ? 0 0004495758 20121226.ifs 2012-12-26 2012-12-27

739358 739358 DIVIDEND ADD 45409B842 0 0 1 4 .12378 00 2011-12-28 2011-12-30 2012-01-04 2011-12-27 0 2011-12-27 ? 0 0004304455 20111227.ifs 2011-12-27 2011-12-28

520677 520677 EQUITY ADD 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF N 7 2011-05-05 ? 0 no no no 2011-05-05 ? ? 20110505.ifs 2011-05-05 2011-05-06

520678 520678 EXCHANGE ADD 45409B842 04 2011-05-05 2011-05-05 IOIL 0 A 2011-05-05 ? 20110505.ifs 2011-05-05 2011-05-06

520769 520769 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF N 7 2011-05-05 ? 0 no no no 2011-05-05 ? ? 20110505.ifs 2011-05-05 2011-05-06

520770 520769 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF N A 2011-05-05 ? 0 no no no 2011-05-05 2011-05-05 ? 20110505.ifs 2011-05-05 2011-05-06

521175 521175 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF N A 2011-05-05 ? 0 no no no 2011-05-05 2011-05-05 ? 20110505.ifs 2011-05-05 2011-05-06

521176 521175 EQUITY CHANGE 45409B842 IQ GLOBAL CRUDE OIL SMALL EQUITY ETF 0 A 2011-05-05 ? 0 no no no 2011-05-05 2011-05-05 ? 20110505.ifs 2011-05-05 2011-05-06

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

Splits	:
reportDate :		ratio :		endQuaterAffected :		dayFrom :		dayTo :

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
3004405	3004405	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-19	1	no	no		no		2011-05-05	2018-03-19	?							20180323.ifs	2018-03-23	2018-03-24
3004406	3004406	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-19	1	no	no		no		2011-05-05	2018-03-19	?							20180323.ifs	2018-03-23	2018-03-24
3004407	3004406	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-23	1	no	no		no		2011-05-05	2018-03-23	?							20180323.ifs	2018-03-23	2018-03-24
3004408	3004407	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-23	1	no	no		no		2011-05-05	2018-03-23	?							20180323.ifs	2018-03-23	2018-03-24
3004409	3004409	CORPACTION	ADD	45409B842	04	L	2018-03-23			?															20180323.ifs	2018-03-23	2018-03-24
3004410	3004410	CORPACTION	ADD	45409B842	04	L	2018-03-23			?															20180323.ifs	2018-03-23	2018-03-24
3004411	3004411	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-23	1	no	no		no		2011-05-05	2018-03-23	?							20180323.ifs	2018-03-23	2018-03-24
3004412	3004412	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-23	1	no	no		no		2011-05-05	2018-03-23	?							20180323.ifs	2018-03-23	2018-03-24
3004413	3004412	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	L	A	2011-05-05	2018-03-23	1	no	no		no		2011-05-05	2018-03-23	?							20180323.ifs	2018-03-23	2018-03-24
3004414	3004413	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	L	A	2011-05-05	2018-03-23	1	no	no		no		2011-05-05	2018-03-23	?							20180323.ifs	2018-03-23	2018-03-24
3004535	3004535	CORPACTION	DELETE	45409B842	04	S	2018-03-19			2018-03-19															20180323.ifs	2018-03-23	2018-03-24
3004536	3004536	CORPACTION	DELETE	45409B842	04	S	2018-03-19			2018-03-19															20180323.ifs	2018-03-23	2018-03-24
2996186	2996186	CORPACTION	ADD	45409B842	04	S	2018-03-19			2018-03-19															20180319.ifs	2018-03-19	2018-03-20
2996188	2996188	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	0	A	2011-05-05	?	1	no	no		no		2011-05-05	2011-05-05	?							20180319.ifs	2018-03-19	2018-03-20
2996189	2996189	CORPACTION	ADD	45409B842	04	S	2018-03-19			2018-03-19															20180319.ifs	2018-03-19	2018-03-20
2996190	2996189	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-19	1	no	no		no		2011-05-05	2018-03-19	?							20180319.ifs	2018-03-19	2018-03-20
2996191	2996191	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	0	A	2011-05-05	?	1	no	no		no		2011-05-05	2011-05-05	?							20180319.ifs	2018-03-19	2018-03-20
2996193	2996192	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	S	A	2011-05-05	2018-03-19	1	no	no		no		2011-05-05	2018-03-19	?							20180319.ifs	2018-03-19	2018-03-20
2930698	2930698	DIVIDEND	CHANGE	45409B842		0	0	1	0	.1777		00	2017-12-28	2017-12-29	2018-01-03	2017-12-27		0	2017-12-27	?	0	0005584861			20180126.ifs	2018-01-26	2018-01-27
2930699	2930698	DIVIDEND	CHANGE	45409B842		0	0	1	0	.1777		00	2017-12-28	2017-12-29	2018-01-03	2017-12-27		1	2017-12-27	2018-01-26	0	0005584861			20180126.ifs	2018-01-26	2018-01-27
2930716	2930716	DIVIDEND	CHANGE	45409B842		0	0	1	0	.1777		00	2017-12-28	2017-12-29	2018-01-03	2017-12-27		0	2017-12-27	?	0	0005584861			20180126.ifs	2018-01-26	2018-01-27
2930718	2930717	DIVIDEND	CHANGE	45409B842		0	0	1	0	.1777		00	2017-12-28	2017-12-29	2018-01-03	2017-12-27		1	2017-12-27	2018-01-26	0	0005584861			20180126.ifs	2018-01-26	2018-01-27
2874485	2874485	DIVIDEND	ADD	45409B842		0	0	1	0	.1777		00	2017-12-28	2017-12-29	2018-01-03	2017-12-27		0	2017-12-27	?	0	0005584861			20171227.ifs	2017-12-27	2017-12-28
2880754	2880754	DIVIDEND	ADD	45409B842		0	0	1	0	.1777		00	2017-12-28	2017-12-29	2018-01-03	2017-12-27		0	2017-12-27	?	0	0005584861			20171227.ifs	2017-12-27	2017-12-28
2461457	2461457	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	0	A	2011-05-05	?	0	no	no		no		2011-05-05	2011-05-05	?							20170126.ifs	2017-01-26	2017-01-27
2461458	2461457	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	0	A	2011-05-05	?	1	no	no		no		2011-05-05	2011-05-05	?							20170126.ifs	2017-01-26	2017-01-27
2398577	2398577	DIVIDEND	ADD	45409B842		0	0	1	0	.361		00	2016-12-28	2016-12-30	2017-01-04	2016-12-27		0	2016-12-27	?	0	0005355623			20161227.ifs	2016-12-27	2016-12-28
2066774	2066774	DIVIDEND	ADD	45409B842		0	0	1	0	.28896		00	2015-12-29	2015-12-31	2016-01-05	2015-12-28		0	2015-12-28	?	0	0005141160			20151228.ifs	2015-12-28	2015-12-29
1743944	1743944	DIVIDEND	ADD	45409B842		0	0	1	0	.28982		00	2014-12-29	2014-12-31	2015-01-05	2014-12-26		0	2014-12-26	?	0	0004922105			20141226.ifs	2014-12-26	2014-12-27
1397011	1397011	DIVIDEND	ADD	45409B842		0	0	1	0	.15442		00	2013-12-27	2013-12-31	2014-01-03	2013-12-26		0	2013-12-26	?	0	0004704953			20131226.ifs	2013-12-26	2013-12-27
1061002	1061002	DIVIDEND	ADD	45409B842		0	0	1	0	.30234		00	2012-12-27	2012-12-31	2013-01-04	2012-12-26		0	2012-12-26	?	0	0004495758			20121226.ifs	2012-12-26	2012-12-27
739358	739358	DIVIDEND	ADD	45409B842		0	0	1	4	.12378		00	2011-12-28	2011-12-30	2012-01-04	2011-12-27		0	2011-12-27	?	0	0004304455			20111227.ifs	2011-12-27	2011-12-28
520677	520677	EQUITY	ADD	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	N	7	2011-05-05	?	0	no	no		no		2011-05-05	?	?							20110505.ifs	2011-05-05	2011-05-06
520678	520678	EXCHANGE	ADD	45409B842	04	2011-05-05	2011-05-05	IOIL	0	A	2011-05-05	?													20110505.ifs	2011-05-05	2011-05-06
520769	520769	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	N	7	2011-05-05	?	0	no	no		no		2011-05-05	?	?							20110505.ifs	2011-05-05	2011-05-06
520770	520769	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	N	A	2011-05-05	?	0	no	no		no		2011-05-05	2011-05-05	?							20110505.ifs	2011-05-05	2011-05-06
521175	521175	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	N	A	2011-05-05	?	0	no	no		no		2011-05-05	2011-05-05	?							20110505.ifs	2011-05-05	2011-05-06
521176	521175	EQUITY	CHANGE	45409B842	IQ GLOBAL CRUDE OIL SMALL EQUITY ETF	0	A	2011-05-05	?	0	no	no		no		2011-05-05	2011-05-05	?							20110505.ifs	2011-05-05	2011-05-06