INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | N/A % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:160357 |
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 | ||
3631370 | 3631370 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3631372 | 3631371 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-21 | 5 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3631375 | 3631375 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3631377 | 3631376 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-21 | 5 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3595554 | 3595554 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-21 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595555 | 3595555 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-21 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595556 | 3595555 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595557 | 3595556 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595558 | 3595558 | CORPACTION | ADD | 46138E883 | 04 | L | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3595559 | 3595559 | CORPACTION | ADD | 46138E883 | 04 | L | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3595560 | 3595560 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595561 | 3595561 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595562 | 3595561 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595563 | 3595562 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595625 | 3595624 | CORPACTION | DELETE | 46138E883 | 04 | S | 2019-02-21 | 2019-02-21 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3595627 | 3595626 | CORPACTION | DELETE | 46138E883 | 04 | L | 2019-02-21 | 2019-02-27 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3595629 | 3595629 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595631 | 3595630 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595632 | 3595631 | CORPACTION | DELETE | 46138E883 | 04 | S | 2019-02-21 | 2019-02-21 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3595633 | 3595633 | CORPACTION | DELETE | 46138E883 | 04 | L | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3595634 | 3595633 | CORPACTION | DELETE | 46138E883 | 04 | L | 2019-02-21 | 2019-02-27 | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3595636 | 3595636 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-27 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595639 | 3595638 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | L | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||
3595641 | 3595641 | CORPACTION | DELETE | 46138E883 | 04 | L | 2019-02-27 | ? | 20190227.ifs | 2019-02-27 | 2019-02-28 | ||||||||||||||||||
3589130 | 3589130 | CORPACTION | ADD | 46138E883 | 04 | S | 2019-02-21 | 2019-02-21 | 20190221.ifs | 2019-02-21 | 2019-02-22 | ||||||||||||||||||
3589131 | 3589131 | CORPACTION | ADD | 46138E883 | 04 | S | 2019-02-21 | 2019-02-21 | 20190221.ifs | 2019-02-21 | 2019-02-22 | ||||||||||||||||||
3589132 | 3589132 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | 0 | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20190221.ifs | 2019-02-21 | 2019-02-22 | ||||||||||
3589133 | 3589133 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | 0 | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20190221.ifs | 2019-02-21 | 2019-02-22 | ||||||||||
3589134 | 3589133 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-21 | ? | 20190221.ifs | 2019-02-21 | 2019-02-22 | ||||||||||
3589135 | 3589134 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | S | 0 | 2018-06-04 | 2019-02-21 | 0 | no | no | no | 2018-06-04 | 2019-02-21 | ? | 20190221.ifs | 2019-02-21 | 2019-02-22 | ||||||||||
3589612 | 3589612 | DIVIDEND | ADD | 46138E883 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-02-27 | 2019-02-21 | 0 | 2019-02-21 | ? | 0 | 0005840391 | 20190221.ifs | 2019-02-21 | 2019-02-22 | |||||||
3589613 | 3589613 | DIVIDEND | ADD | 46138E883 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-02-27 | 2019-02-21 | 0 | 2019-02-21 | ? | 0 | 0005840391 | 20190221.ifs | 2019-02-21 | 2019-02-22 | |||||||
3555357 | 3555357 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .0791 | 00 | 2019-01-22 | 2019-01-23 | 2019-01-31 | 2019-01-18 | 0 | 2019-01-18 | ? | 0 | 0005827107 | 20190118.ifs | 2019-01-18 | 2019-01-19 | |||||||
3555378 | 3555378 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .0791 | 00 | 2019-01-22 | 2019-01-23 | 2019-01-31 | 2019-01-18 | 0 | 2019-01-18 | ? | 0 | 0005827107 | 20190118.ifs | 2019-01-18 | 2019-01-19 | |||||||
3489588 | 3489588 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .09289 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-31 | 2018-12-21 | 0 | 2018-12-21 | ? | 0 | 0005803534 | 20181221.ifs | 2018-12-21 | 2018-12-22 | |||||||
3489591 | 3489591 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .09289 | 00 | 2018-12-24 | 2018-12-26 | 2018-12-31 | 2018-12-21 | 0 | 2018-12-21 | ? | 0 | 0005803534 | 20181221.ifs | 2018-12-21 | 2018-12-22 | |||||||
3452589 | 3452589 | DIVIDEND | CHANGE | 46138E883 | 0 | 0 | 1 | 0 | .07384 | 00 | 2018-11-19 | 2018-11-20 | 2018-11-30 | 2018-11-16 | 0 | 2018-11-16 | ? | 0 | 0005755685 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3452591 | 3452590 | DIVIDEND | CHANGE | 46138E883 | 0 | 0 | 1 | 0 | .07384 | 00 | 2018-11-19 | 2018-11-20 | 2018-11-30 | 2018-11-16 | 1 | 2018-11-16 | 2018-12-17 | 0 | 0005755685 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3452751 | 3452751 | DIVIDEND | CHANGE | 46138E883 | 0 | 0 | 1 | 0 | .07384 | 00 | 2018-11-19 | 2018-11-20 | 2018-11-30 | 2018-11-16 | 0 | 2018-11-16 | ? | 0 | 0005755685 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3452753 | 3452752 | DIVIDEND | CHANGE | 46138E883 | 0 | 0 | 1 | 0 | .07384 | 00 | 2018-11-19 | 2018-11-20 | 2018-11-30 | 2018-11-16 | 1 | 2018-11-16 | 2018-12-17 | 0 | 0005755685 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3373773 | 3373773 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .07384 | 00 | 2018-11-19 | 2018-11-20 | 2018-11-30 | 2018-11-16 | 0 | 2018-11-16 | ? | 0 | 0005755685 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3373790 | 3373790 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .07384 | 00 | 2018-11-19 | 2018-11-20 | 2018-11-30 | 2018-11-16 | 0 | 2018-11-16 | ? | 0 | 0005755685 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3334214 | 3334214 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .08104 | 00 | 2018-10-22 | 2018-10-23 | 2018-10-31 | 2018-10-19 | 0 | 2018-10-19 | ? | 0 | 0005742417 | 20181019.ifs | 2018-10-19 | 2018-10-20 | |||||||
3334215 | 3334215 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .08104 | 00 | 2018-10-22 | 2018-10-23 | 2018-10-31 | 2018-10-19 | 0 | 2018-10-19 | ? | 0 | 0005742417 | 20181019.ifs | 2018-10-19 | 2018-10-20 | |||||||
3294271 | 3294271 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .08 | 00 | 2018-09-24 | 2018-09-25 | 2018-09-28 | 2018-09-21 | 0 | 2018-09-21 | ? | 0 | 0005727092 | 20180921.ifs | 2018-09-21 | 2018-09-22 | |||||||
3294278 | 3294278 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .08 | 00 | 2018-09-24 | 2018-09-25 | 2018-09-28 | 2018-09-21 | 0 | 2018-09-21 | ? | 0 | 0005727092 | 20180921.ifs | 2018-09-21 | 2018-09-22 | |||||||
3242620 | 3242620 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .07827 | 00 | 2018-08-20 | 2018-08-21 | 2018-08-31 | 2018-08-17 | 0 | 2018-08-17 | ? | 0 | 0005708938 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3242621 | 3242621 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .07827 | 00 | 2018-08-20 | 2018-08-21 | 2018-08-31 | 2018-08-17 | 0 | 2018-08-17 | ? | 0 | 0005708938 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3201144 | 3201144 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .075 | 00 | 2018-07-23 | 2018-07-24 | 2018-07-31 | 2018-07-20 | 0 | 2018-07-20 | ? | 0 | 0005696027 | 20180720.ifs | 2018-07-20 | 2018-07-21 | |||||||
3201145 | 3201145 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .075 | 00 | 2018-07-23 | 2018-07-24 | 2018-07-31 | 2018-07-20 | 0 | 2018-07-20 | ? | 0 | 0005696027 | 20180720.ifs | 2018-07-20 | 2018-07-21 | |||||||
3141755 | 3141755 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .07332 | 00 | 2018-06-18 | 2018-06-19 | 2018-06-29 | 2018-06-15 | 0 | 2018-06-15 | ? | 0 | 0005675715 | 20180615.ifs | 2018-06-15 | 2018-06-16 | |||||||
3141793 | 3141793 | DIVIDEND | ADD | 46138E883 | 0 | 0 | 1 | 0 | .07332 | 00 | 2018-06-18 | 2018-06-19 | 2018-06-29 | 2018-06-15 | 0 | 2018-06-15 | ? | 0 | 0005675715 | 20180615.ifs | 2018-06-15 | 2018-06-16 | |||||||
3123941 | 3123941 | EQUITY | ADD | 46138E883 | CHINESE YUAN DIM SUM BD ETF | N | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 | ||||||||||
3123942 | 3123942 | EQUITY | ADD | 46138E883 | CHINESE YUAN DIM SUM BD ETF | N | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 | ||||||||||
3123947 | 3123947 | EXCHANGE | ADD | 46138E883 | 04 | 2018-06-04 | 2018-06-04 | DSUM | 0 | 0 | 2018-06-04 | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 | ||||||||||||||
3123948 | 3123948 | EXCHANGE | ADD | 46138E883 | 04 | 2018-06-04 | 2018-06-04 | DSUM | 0 | 0 | 2018-06-04 | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 | ||||||||||||||
3128088 | 3128088 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | N | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 | ||||||||||
3128090 | 3128089 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | 0 | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 | ||||||||||
3128195 | 3128195 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | N | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 | ||||||||||
3128197 | 3128196 | EQUITY | CHANGE | 46138E883 | CHINESE YUAN DIM SUM BD ETF | 0 | 0 | 2018-06-04 | ? | 0 | no | no | no | 2018-06-04 | ? | ? | 20180604.ifs | 2018-06-04 | 2018-06-05 |
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 = 160357
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