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
5500386	5500386	CORPACTION	ADD	37950E507	04	S	2024-02-20			2024-02-20															20240220.ifs	2024-02-20	2024-02-21
5500387	5500387	EQUITY	CHANGE	37950E507	GLOBAL X MSCI CHINA ENERGY ETF	0	A	2009-12-16	?	2	no	no		no		2009-12-16	2018-12-06	?							20240220.ifs	2024-02-20	2024-02-21
5500388	5500387	EQUITY	CHANGE	37950E507	GLOBAL X MSCI CHINA ENERGY ETF	S	A	2009-12-16	2024-02-20	2	no	no		no		2009-12-16	2024-02-20	?							20240220.ifs	2024-02-20	2024-02-21
5483193	5483193	DIVIDEND	CHANGE	37950E507		0	0	1	0	1.017175		00	2023-12-28	2023-12-29	2024-01-08	2023-12-27		0	2023-12-27	?	0	0006852776			20240122.ifs	2024-01-22	2024-01-23
5483194	5483193	DIVIDEND	CHANGE	37950E507		0	0	1	0	1.017175		00	2023-12-28	2023-12-29	2024-01-08	2023-12-27		1	2023-12-27	2024-01-22	0	0006852776			20240122.ifs	2024-01-22	2024-01-23
5464975	5464975	DIVIDEND	ADD	37950E507		0	0	1	0	1.017175		00	2023-12-28	2023-12-29	2024-01-08	2023-12-27		0	2023-12-27	?	0	0006852776			20231227.ifs	2023-12-27	2023-12-28
5320748	5320748	DIVIDEND	ADD	37950E507		0	0	1	0	.427373		00	2023-06-29	2023-06-30	2023-07-10	2023-06-28		0	2023-06-28	?	0	0006745547			20230628.ifs	2023-06-28	2023-06-29
5194561	5194561	DIVIDEND	ADD	37950E507		0	0	1	0	.4671		00	2022-12-29	2022-12-30	2023-01-09	2022-12-28		0	2022-12-28	?	0	0006657750			20221228.ifs	2022-12-28	2022-12-29
5043474	5043474	DIVIDEND	ADD	37950E507		0	0	1	0	.11526		00	2022-06-29	2022-06-30	2022-07-08	2022-06-28		0	2022-06-28	?	0	0006545225			20220628.ifs	2022-06-28	2022-06-29
4920459	4920459	DIVIDEND	ADD	37950E507		0	0	1	0	.164216		00	2021-12-30	2021-12-31	2022-01-07	2021-12-29		0	2021-12-29	?	0	0006454647			20211229.ifs	2021-12-29	2021-12-30
4740242	4740242	DIVIDEND	ADD	37950E507		0	0	1	0	.068876		00	2021-06-29	2021-06-30	2021-07-08	2021-06-28		0	2021-06-28	?	0	0006328723			20210628.ifs	2021-06-28	2021-06-29
4581446	4581446	DIVIDEND	ADD	37950E507		0	0	1	0	.20177		00	2020-12-30	2020-12-31	2021-01-08	2020-12-29		0	2020-12-29	?	0	0006237979			20201229.ifs	2020-12-29	2020-12-30
4529650	4529650	EQUITY	CHANGE	37950E507	GLOBAL X MSCI CHINA ENERGY ETF	0	A	2009-12-16	?	1	no	no		no		2009-12-16	2018-12-06	?							20201208.ifs	2020-12-08	2020-12-09
4529651	4529650	EQUITY	CHANGE	37950E507	GLOBAL X MSCI CHINA ENERGY ETF	0	A	2009-12-16	?	2	no	no		no		2009-12-16	2018-12-06	?							20201208.ifs	2020-12-08	2020-12-09
4402316	4402316	DIVIDEND	ADD	37950E507		0	0	1	0	.128367		00	2020-06-29	2020-06-30	2020-07-08	2020-06-26		0	2020-06-26	?	0	0006119462			20200626.ifs	2020-06-26	2020-06-27
4130539	4130539	DIVIDEND	ADD	37950E507		0	0	1	0	.288119		00	2019-12-30	2019-12-31	2020-01-08	2019-12-27		0	2019-12-27	?	0	0006028007			20191227.ifs	2019-12-27	2019-12-28
4130650	4130650	DIVIDEND	ADD	37950E507		0	0	1	0	.288119		00	2019-12-30	2019-12-31	2020-01-08	2019-12-27		0	2019-12-27	?	0	0006028007			20191227.ifs	2019-12-27	2019-12-28
3802608	3802608	DIVIDEND	ADD	37950E507		0	0	1	0	.186721		00	2019-06-27	2019-06-28	2019-07-08	2019-06-26		0	2019-06-26	?	1	0005905161			20190626.ifs	2019-06-26	2019-06-27
3802610	3802610	DIVIDEND	CHANGE	37950E507		0	0	1	0	.382218		00	2018-12-28	2018-12-31	2019-01-08	2018-12-27		0	2018-12-27	?	0	0005810225			20190626.ifs	2019-06-26	2019-06-27
3802612	3802611	DIVIDEND	CHANGE	37950E507		0	0	1	0	.382218		00	2018-12-28	2018-12-31	2019-01-08	2018-12-27		1	2018-12-27	2019-06-26	0	0005810225			20190626.ifs	2019-06-26	2019-06-27
3802617	3802617	DIVIDEND	ADD	37950E507		0	0	1	0	.186721		00	2019-06-27	2019-06-28	2019-07-08	2019-06-26		0	2019-06-26	?	1	0005905161			20190626.ifs	2019-06-26	2019-06-27
3802619	3802619	DIVIDEND	CHANGE	37950E507		0	0	1	0	.382218		00	2018-12-28	2018-12-31	2019-01-08	2018-12-27		0	2018-12-27	?	0	0005810225			20190626.ifs	2019-06-26	2019-06-27
3802621	3802620	DIVIDEND	CHANGE	37950E507		0	0	1	0	.382218		00	2018-12-28	2018-12-31	2019-01-08	2018-12-27		1	2018-12-27	2019-06-26	0	0005810225			20190626.ifs	2019-06-26	2019-06-27
3505871	3505871	DIVIDEND	ADD	37950E507		0	0	1	0	.382218		00	2018-12-28	2018-12-31	2019-01-08	2018-12-27		0	2018-12-27	?	0	0005810225			20181227.ifs	2018-12-27	2018-12-28
3507634	3507634	DIVIDEND	ADD	37950E507		0	0	1	0	.382218		00	2018-12-28	2018-12-31	2019-01-08	2018-12-27		0	2018-12-27	?	0	0005810225			20181227.ifs	2018-12-27	2018-12-28
3406209	3406209	CORPACTION	ADD	37950E507	04	#	2018-12-06	37950E507	04	?															20181206.ifs	2018-12-06	2018-12-07
3406210	3406210	CORPACTION	ADD	37950E507	04	#	2018-12-06	37950E507	04	?															20181206.ifs	2018-12-06	2018-12-07
3406211	3406211	CORPACTIONAUX	ADD	37950E507	04	2018-12-06	CHIE	GLOBAL X FDS	GLOBAL X FUNDS	CHIE	GLOBAL X FDS	GLOBAL X MSCI C	2018-12-06	?											20181206.ifs	2018-12-06	2018-12-07
3406212	3406212	CORPACTIONAUX	ADD	37950E507	04	2018-12-06	CHIE	GLOBAL X FDS	GLOBAL X FUNDS	CHIE	GLOBAL X FDS	GLOBAL X MSCI C	2018-12-06	?											20181206.ifs	2018-12-06	2018-12-07
3406213	3406213	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	0	A	2009-12-16	?	1	no	no		no		2009-12-16	2009-12-16	?							20181206.ifs	2018-12-06	2018-12-07
3406214	3406214	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	0	A	2009-12-16	?	1	no	no		no		2009-12-16	2009-12-16	?							20181206.ifs	2018-12-06	2018-12-07
3406215	3406214	EQUITY	CHANGE	37950E507	GLOBAL X MSCI CHINA ENERGY ETF	0	A	2009-12-16	?	1	no	no		no		2009-12-16	2018-12-06	?							20181206.ifs	2018-12-06	2018-12-07
3406216	3406215	EQUITY	CHANGE	37950E507	GLOBAL X MSCI CHINA ENERGY ETF	0	A	2009-12-16	?	1	no	no		no		2009-12-16	2018-12-06	?							20181206.ifs	2018-12-06	2018-12-07
2875236	2875236	DIVIDEND	ADD	37950E507		0	0	1	0	.411674		00	2017-12-28	2017-12-29	2018-01-09	2017-12-27		0	2017-12-27	?	0	0005585439			20171227.ifs	2017-12-27	2017-12-28
2881505	2881505	DIVIDEND	ADD	37950E507		0	0	1	0	.411674		00	2017-12-28	2017-12-29	2018-01-09	2017-12-27		0	2017-12-27	?	0	0005585439			20171227.ifs	2017-12-27	2017-12-28
2460057	2460057	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	0	A	2009-12-16	?	0	no	no		no		2009-12-16	2009-12-16	?							20170126.ifs	2017-01-26	2017-01-27
2460058	2460057	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	0	A	2009-12-16	?	1	no	no		no		2009-12-16	2009-12-16	?							20170126.ifs	2017-01-26	2017-01-27
2398685	2398685	DIVIDEND	ADD	37950E507		0	0	1	0	.214887		00	2016-12-28	2016-12-30	2017-01-06	2016-12-27		0	2016-12-27	?	0	0005355943			20161227.ifs	2016-12-27	2016-12-28
2066867	2066867	DIVIDEND	ADD	37950E507		0	0	1	0	.32892		00	2015-12-29	2015-12-31	2016-01-08	2015-12-28		0	2015-12-28	?	0	0005141279			20151228.ifs	2015-12-28	2015-12-29
1744014	1744014	DIVIDEND	ADD	37950E507		0	0	1	0	.326516		00	2014-12-29	2014-12-31	2015-01-08	2014-12-26		0	2014-12-26	?	0	0004922531			20141226.ifs	2014-12-26	2014-12-27
1397053	1397053	DIVIDEND	ADD	37950E507		0	0	1	0	.283337		00	2013-12-27	2013-12-31	2014-01-08	2013-12-26		0	2013-12-26	?	0	0004705386			20131226.ifs	2013-12-26	2013-12-27
1061067	1061067	DIVIDEND	ADD	37950E507		0	0	1	0	.253286		00	2012-12-27	2012-12-31	2013-01-09	2012-12-26		0	2012-12-26	?	0	0004495893			20121226.ifs	2012-12-26	2012-12-27
739435	739435	DIVIDEND	ADD	37950E507		0	0	1	0	.261107		00	2011-12-28	2011-12-30	2012-01-09	2011-12-27		0	2011-12-27	?	0	0004304122			20111227.ifs	2011-12-27	2011-12-28
396975	396975	DIVIDEND	ADD	37950E507		0	0	1	4	.136647		00	2010-12-29	2010-12-31	2011-01-07	2010-12-28		0	2010-12-28	?	0	0004119799			20101228.ifs	2010-12-28	2010-12-29
50908	50908	EQUITY	ADD	37950E507	GLOBAL X CHINA ENERGY ETF	N	7	2009-12-16	?	0	no	no		no		2009-12-16	?	?							20091216.ifs	2009-12-16	2010-04-07
50909	50909	EXCHANGE	ADD	37950E507	04	2009-12-16	2009-12-16	CHIE	0	A	2009-12-16	?													20091216.ifs	2009-12-16	2010-04-07
51014	51014	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	N	7	2009-12-16	?	0	no	no		no		2009-12-16	?	?							20091216.ifs	2009-12-16	2010-04-07
51015	51014	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	N	A	2009-12-16	?	0	no	no		no		2009-12-16	2009-12-16	?							20091216.ifs	2009-12-16	2010-04-07
51065	51065	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	N	A	2009-12-16	?	0	no	no		no		2009-12-16	2009-12-16	?							20091216.ifs	2009-12-16	2010-04-07
51066	51065	EQUITY	CHANGE	37950E507	GLOBAL X CHINA ENERGY ETF	0	A	2009-12-16	?	0	no	no		no		2009-12-16	2009-12-16	?							20091216.ifs	2009-12-16	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 = 159663
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