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
5584249	5584249	DIVIDEND	ADD	33737J158		0	0	1	0	.3729		00	2024-06-27	2024-06-27	2024-06-28	2024-06-26		0	2024-06-26	?	0	0006938780			20240626.ifs	2024-06-26	2024-06-27
5519837	5519837	DIVIDEND	ADD	33737J158		0	0	1	0	.2998		00	2024-03-21	2024-03-22	2024-03-28	2024-03-20		0	2024-03-20	?	0	0006892770			20240320.ifs	2024-03-20	2024-03-21
5457246	5457246	DIVIDEND	ADD	33737J158		0	0	1	0	1.1164		00	2023-12-22	2023-12-26	2023-12-29	2023-12-21		0	2023-12-21	?	0	0006846987			20231221.ifs	2023-12-21	2023-12-22
5378388	5378388	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2023-09-29	2023-09-21		0	2023-09-21	?	0	0006786304			20230921.ifs	2023-09-21	2023-09-22
5318814	5318814	DIVIDEND	ADD	33737J158		0	0	1	0	.5555		00	2023-06-27	2023-06-28	2023-06-30	2023-06-26		0	2023-06-26	?	0	0006744200			20230626.ifs	2023-06-26	2023-06-27
5254080	5254080	DIVIDEND	ADD	33737J158		0	0	1	0	.0843		00	2023-03-24	2023-03-27	2023-03-31	2023-03-23		0	2023-03-23	?	0	0006699620			20230323.ifs	2023-03-23	2023-03-24
5186792	5186792	DIVIDEND	ADD	33737J158		0	0	1	0	.1635		00	2022-12-23	2022-12-27	2022-12-30	2022-12-22		0	2022-12-22	?	0	0006651116			20221222.ifs	2022-12-22	2022-12-23
5102635	5102635	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2022-09-30	2022-09-22		0	2022-09-22	?	0	0006587295			20220922.ifs	2022-09-22	2022-09-23
5040114	5040114	DIVIDEND	ADD	33737J158		0	0	1	0	.7752		00	2022-06-24	2022-06-27	2022-06-30	2022-06-23		0	2022-06-23	?	0	0006543147			20220623.ifs	2022-06-23	2022-06-24
4977256	4977256	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2022-03-31	2022-03-24		0	2022-03-24	?	0	0006499046			20220324.ifs	2022-03-24	2022-03-25
4909131	4909131	DIVIDEND	ADD	33737J158		0	0	1	0	.687		00	2021-12-23	2021-12-27	2021-12-31	2021-12-22		0	2021-12-22	?	0	0006445354			20211222.ifs	2021-12-22	2021-12-23
4807609	4807609	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2021-09-30	2021-09-22		0	2021-09-22	?	0	0006370860			20210922.ifs	2021-09-22	2021-09-23
4736456	4736456	DIVIDEND	ADD	33737J158		0	0	1	0	.5151		00	2021-06-24	2021-06-25	2021-06-30	2021-06-23		0	2021-06-23	?	0	0006326292			20210623.ifs	2021-06-23	2021-06-24
4661257	4661257	DIVIDEND	ADD	33737J158		0	0	1	0	.0109		00	2021-03-25	2021-03-26	2021-03-31	2021-03-24		0	2021-03-24	?	0	0006281228			20210324.ifs	2021-03-24	2021-03-25
4572320	4572320	DIVIDEND	ADD	33737J158		0	0	1	0	.1709		00	2020-12-24	2020-12-28	2020-12-31	2020-12-23		0	2020-12-23	?	0	0006232326			20201223.ifs	2020-12-23	2020-12-24
4468495	4468495	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2020-09-30	2020-09-23		0	2020-09-23	?	0	0006162667			20200923.ifs	2020-09-23	2020-09-24
4399529	4399529	DIVIDEND	ADD	33737J158		0	0	1	0	.3411		00	2020-06-25	2020-06-26	2020-06-30	2020-06-24		0	2020-06-24	?	0	0006117740			20200624.ifs	2020-06-24	2020-06-25
4255759	4255759	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2020-03-31	2020-03-25		0	2020-03-25	?	0	0006073613			20200325.ifs	2020-03-25	2020-03-26
4255760	4255760	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2020-03-31	2020-03-25		0	2020-03-25	?	0	0006073613			20200325.ifs	2020-03-25	2020-03-26
4062609	4062609	DIVIDEND	ADD	33737J158		0	0	1	0	.8119		00	2019-12-13	2019-12-16	2019-12-31	2019-12-12		0	2019-12-12	?	0	0005996528			20191212.ifs	2019-12-12	2019-12-13
4062708	4062708	DIVIDEND	ADD	33737J158		0	0	1	0	.8119		00	2019-12-13	2019-12-16	2019-12-31	2019-12-12		0	2019-12-12	?	0	0005996528			20191212.ifs	2019-12-12	2019-12-13
3936973	3936973	DIVIDEND	ADD	33737J158		0	0	1	0	.1606		00	2019-09-25	2019-09-26	2019-09-30	2019-09-24		0	2019-09-24	?	0	0005949769			20190924.ifs	2019-09-24	2019-09-25
3937100	3937100	DIVIDEND	ADD	33737J158		0	0	1	0	.1606		00	2019-09-25	2019-09-26	2019-09-30	2019-09-24		0	2019-09-24	?	0	0005949769			20190924.ifs	2019-09-24	2019-09-25
3778462	3778462	DIVIDEND	ADD	33737J158		0	0	1	0	.44		00	2019-06-14	2019-06-17	2019-06-28	2019-06-13		0	2019-06-13	?	0	0005897600			20190613.ifs	2019-06-13	2019-06-14
3778463	3778463	DIVIDEND	ADD	33737J158		0	0	1	0	.44		00	2019-06-14	2019-06-17	2019-06-28	2019-06-13		0	2019-06-13	?	0	0005897600			20190613.ifs	2019-06-13	2019-06-14
3640390	3640390	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2019-03-29	2019-03-20		0	2019-03-20	?	0	0005855713			20190320.ifs	2019-03-20	2019-03-21
3640391	3640391	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2019-03-29	2019-03-20		0	2019-03-20	?	0	0005855713			20190320.ifs	2019-03-20	2019-03-21
3454419	3454419	DIVIDEND	ADD	33737J158		0	0	1	0	.3384		00	2018-12-18	2018-12-19	2018-12-31	2018-12-17		0	2018-12-17	?	0	0005784824			20181217.ifs	2018-12-17	2018-12-18
3454587	3454587	DIVIDEND	ADD	33737J158		0	0	1	0	.3384		00	2018-12-18	2018-12-19	2018-12-31	2018-12-17		0	2018-12-17	?	0	0005784824			20181217.ifs	2018-12-17	2018-12-18
3281860	3281860	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2018-09-28	2018-09-13		0	2018-09-13	?	0	0005723037			20180913.ifs	2018-09-13	2018-09-14
3281935	3281935	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2018-09-28	2018-09-13		0	2018-09-13	?	0	0005723037			20180913.ifs	2018-09-13	2018-09-14
3149455	3149455	DIVIDEND	ADD	33737J158		0	0	1	0	.4027		00	2018-06-21	2018-06-22	2018-06-29	2018-06-20		0	2018-06-20	?	0	0005678302			20180620.ifs	2018-06-20	2018-06-21
3149474	3149474	DIVIDEND	ADD	33737J158		0	0	1	0	.4027		00	2018-06-21	2018-06-22	2018-06-29	2018-06-20		0	2018-06-20	?	0	0005678302			20180620.ifs	2018-06-20	2018-06-21
3001134	3001134	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2018-03-29	2018-03-21		0	2018-03-21	?	0	0005632670			20180321.ifs	2018-03-21	2018-03-22
3001157	3001157	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2018-03-29	2018-03-21		0	2018-03-21	?	0	0005632670			20180321.ifs	2018-03-21	2018-03-22
2852967	2852967	DIVIDEND	ADD	33737J158		0	0	1	0	.4451		00	2017-12-21	2017-12-22	2017-12-29	2017-12-20		0	2017-12-20	?	0	0005570581			20171220.ifs	2017-12-20	2017-12-21
2856398	2856398	DIVIDEND	ADD	33737J158		0	0	1	0	.4451		00	2017-12-21	2017-12-22	2017-12-29	2017-12-20		0	2017-12-20	?	0	0005570581			20171220.ifs	2017-12-20	2017-12-21
2680367	2680367	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2017-09-29	2017-09-20		0	2017-09-20	?	0	0005500091			20170920.ifs	2017-09-20	2017-09-21
2680398	2680398	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2017-09-29	2017-09-20		0	2017-09-20	?	0	0005500091			20170920.ifs	2017-09-20	2017-09-21
2597589	2597589	DIVIDEND	ADD	33737J158		0	0	1	0	.3296		00	2017-06-22	2017-06-26	2017-06-30	2017-06-21		0	2017-06-21	?	0	0005452794			20170621.ifs	2017-06-21	2017-06-22
2438226	2438226	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		yes		2011-04-19	2015-07-15	?							20170123.ifs	2017-01-23	2017-01-24
2438227	2438226	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	4	no	no		yes		2011-04-19	2015-07-15	?							20170123.ifs	2017-01-23	2017-01-24
2388738	2388738	DIVIDEND	ADD	33737J158		0	0	1	0	.4787		00	2016-12-21	2016-12-23	2016-12-30	2016-12-20		0	2016-12-20	?	0	0005346893			20161220.ifs	2016-12-20	2016-12-21
2297953	2297953	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2016-09-30	2016-09-20		0	2016-09-20	?	0	0005283215			20160920.ifs	2016-09-20	2016-09-21
2226822	2226822	DIVIDEND	ADD	33737J158		0	0	1	0	.2139		00	2016-06-22	2016-06-24	2016-06-30	2016-06-21		0	2016-06-21	?	0	0005236370			20160621.ifs	2016-06-21	2016-06-22
2140747	2140747	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2016-03-31	2016-03-22		0	2016-03-22	?	0	0005190794			20160322.ifs	2016-03-22	2016-03-23
2060129	2060129	DIVIDEND	ADD	33737J158		0	0	1	0	.1567		00	2015-12-23	2015-12-28	2015-12-31	2015-12-22		0	2015-12-22	?	0	0005136030			20151222.ifs	2015-12-22	2015-12-23
1917403	1917403	CORPACTION	DELETE	33737J158	60	D	2015-07-14			?															20150716.ifs	2015-07-16	2015-07-17
1917404	1917404	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	D	A	2011-04-19	2015-07-14	0	no	no		yes		2011-04-19	2015-07-15	?							20150716.ifs	2015-07-16	2015-07-17
1917405	1917404	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		yes		2011-04-19	2015-07-15	?							20150716.ifs	2015-07-16	2015-07-17
1916801	1916801	CORPACTION	ADD	33737J158	60	D	2015-07-14			?															20150715.ifs	2015-07-15	2015-07-16
1916802	1916802	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		yes		2011-04-19	2015-07-14	?							20150715.ifs	2015-07-15	2015-07-16
1916803	1916802	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	D	A	2011-04-19	2015-07-14	0	no	no		yes		2011-04-19	2015-07-15	?							20150715.ifs	2015-07-15	2015-07-16
1915603	1915603	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		no		2011-04-19	2011-04-19	?							20150714.ifs	2015-07-14	2015-07-15
1915604	1915603	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		yes		2011-04-19	2015-07-14	?							20150714.ifs	2015-07-14	2015-07-15
1915605	1915605	EXCHANGE	ADD	33737J158	60	2015-07-13	2015-07-14	FJP	0	A	2015-07-14	?													20150714.ifs	2015-07-14	2015-07-15
1915606	1915606	CORPACTION	ADD	33737J158	60	D	2015-07-14			?															20150714.ifs	2015-07-14	2015-07-15
1915607	1915607	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		yes		2011-04-19	2015-07-14	?							20150714.ifs	2015-07-14	2015-07-15
1915608	1915607	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	D	A	2011-04-19	2015-07-14	0	no	no		yes		2011-04-19	2015-07-14	?							20150714.ifs	2015-07-14	2015-07-15
1915862	1915862	CORPACTION	DELETE	33737J158	60	D	2015-07-14			?															20150714.ifs	2015-07-14	2015-07-15
1915863	1915863	CORPACTION	ADD	33737J158	04	X	2015-07-14	33737J158	60	2015-07-14															20150714.ifs	2015-07-14	2015-07-15
1915864	1915864	EXCHANGE	ADD	33737J158	60	2015-07-14	2015-07-14	FJP	0	A	2015-07-14	?													20150714.ifs	2015-07-14	2015-07-15
1915865	1915865	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	D	A	2011-04-19	2015-07-14	0	no	no		yes		2011-04-19	2015-07-14	?							20150714.ifs	2015-07-14	2015-07-15
1915866	1915865	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		yes		2011-04-19	2015-07-14	?							20150714.ifs	2015-07-14	2015-07-15
1915867	1915867	EXCHANGE	DELETE	33737J158	60	2015-07-13	2015-07-14	FJP	0	A	2015-07-14	?													20150714.ifs	2015-07-14	2015-07-15
1819421	1819421	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2015-03-31	2015-03-24		0	2015-03-24	?	0	0004972788			20150324.ifs	2015-03-24	2015-03-25
1737688	1737688	DIVIDEND	ADD	33737J158		0	0	1	0	.1685		00	2014-12-23	2014-12-26	2014-12-31	2014-12-22		0	2014-12-22	?	0	0004916166			20141222.ifs	2014-12-22	2014-12-23
1635550	1635550	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2014-09-30	2014-09-22		0	2014-09-22	?	0	0004846030			20140922.ifs	2014-09-22	2014-09-23
1557411	1557411	DIVIDEND	ADD	33737J158		0	0	1	0	.3168		00	2014-06-24	2014-06-26	2014-06-30	2014-06-23		0	2014-06-23	?	0	0004800554			20140623.ifs	2014-06-23	2014-06-24
1474713	1474713	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2014-03-31	2014-03-24		0	2014-03-24	?	0	0004754594			20140324.ifs	2014-03-24	2014-03-25
1377392	1377392	DIVIDEND	ADD	33737J158		0	0	1	0	.1008		00	2013-12-18	2013-12-20	2013-12-31	2013-12-17		0	2013-12-17	?	0	0004688801			20131217.ifs	2013-12-17	2013-12-18
1291588	1291588	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2013-09-30	2013-09-19		0	2013-09-19	?	0	0004630897			20130919.ifs	2013-09-19	2013-09-20
1213717	1213717	DIVIDEND	ADD	33737J158		0	0	1	0	.2062		00	2013-06-21	2013-06-25	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586665			20130620.ifs	2013-06-20	2013-06-21
1137760	1137760	DIVIDEND	ADD	33737J158		0	0	1	0	.0182		00	2013-03-21	2013-03-25	2013-03-28	2013-03-20		0	2013-03-20	?	0	0004543606			20130320.ifs	2013-03-20	2013-03-21
1053330	1053330	DIVIDEND	ADD	33737J158		0	0	1	0	.3027		00	2012-12-21	2012-12-26	2012-12-31	2012-12-20		0	2012-12-20	?	0	0004489801			20121220.ifs	2012-12-20	2012-12-21
960857	960857	DIVIDEND	ADD	33737J158		0	0	E	0	0		58	?	?	2012-09-28	2012-09-20		0	2012-09-20	?	1	0004431880			20120920.ifs	2012-09-20	2012-09-21
960858	960858	DIVIDEND	CHANGE	33737J158		0	0	1	0	.2817		00	2012-06-21	2012-06-25	2012-06-29	2012-06-20		0	2012-06-20	?	0	0004389084			20120920.ifs	2012-09-20	2012-09-21
960859	960858	DIVIDEND	CHANGE	33737J158		0	0	1	0	.2817		00	2012-06-21	2012-06-25	2012-06-29	2012-06-20		1	2012-06-20	2012-09-20	0	0004389084			20120920.ifs	2012-09-20	2012-09-21
889869	889869	DIVIDEND	ADD	33737J158		0	0	1	0	.2817		00	2012-06-21	2012-06-25	2012-06-29	2012-06-20		0	2012-06-20	?	0	0004389084			20120620.ifs	2012-06-20	2012-06-21
733335	733335	DIVIDEND	ADD	33737J158		0	0	1	4	.231		00	2011-12-21	2011-12-23	2011-12-30	2011-12-20		0	2011-12-20	?	0	0004296778			20111220.ifs	2011-12-20	2011-12-21
504277	504277	EQUITY	ADD	33737J158	JAPAN ALPHADEX FD	N	7	2011-04-19	?	0	no	no		no		2011-04-19	?	?							20110419.ifs	2011-04-19	2011-04-20
504278	504278	EXCHANGE	ADD	33737J158	04	2011-04-19	2011-04-19	FJP	0	A	2011-04-19	?													20110419.ifs	2011-04-19	2011-04-20
504395	504395	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	N	7	2011-04-19	?	0	no	no		no		2011-04-19	?	?							20110419.ifs	2011-04-19	2011-04-20
504396	504395	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	N	A	2011-04-19	?	0	no	no		no		2011-04-19	2011-04-19	?							20110419.ifs	2011-04-19	2011-04-20
504621	504621	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	N	A	2011-04-19	?	0	no	no		no		2011-04-19	2011-04-19	?							20110419.ifs	2011-04-19	2011-04-20
504622	504621	EQUITY	CHANGE	33737J158	JAPAN ALPHADEX FD	0	A	2011-04-19	?	0	no	no		no		2011-04-19	2011-04-19	?							20110419.ifs	2011-04-19	2011-04-20

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