INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 17 | 14 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 24.70 % | 19.28 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159753 |
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 | ||
5582620 | 5582620 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .43494 | 00 | 2024-06-26 | 2024-06-26 | 2024-07-03 | 2024-06-25 | 0 | 2024-06-25 | ? | 0 | 0006937551 | 20240625.ifs | 2024-06-25 | 2024-06-26 | |||||||
5518768 | 5518768 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .36281 | 00 | 2024-03-20 | 2024-03-21 | 2024-03-27 | 2024-03-19 | 0 | 2024-03-19 | ? | 0 | 0006891822 | 20240319.ifs | 2024-03-19 | 2024-03-20 | |||||||
5449342 | 5449342 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .515467 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-28 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840410 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5375879 | 5375879 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .604411 | 00 | 2023-09-20 | 2023-09-21 | 2023-09-27 | 2023-09-19 | 0 | 2023-09-19 | ? | 0 | 0006784821 | 20230919.ifs | 2023-09-19 | 2023-09-20 | |||||||
5314345 | 5314345 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .31534 | 00 | 2023-06-21 | 2023-06-22 | 2023-06-28 | 2023-06-20 | 0 | 2023-06-20 | ? | 0 | 0006741233 | 20230620.ifs | 2023-06-20 | 2023-06-21 | |||||||
5252017 | 5252017 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .256961 | 00 | 2023-03-22 | 2023-03-23 | 2023-03-29 | 2023-03-21 | 0 | 2023-03-21 | ? | 0 | 0006698144 | 20230321.ifs | 2023-03-21 | 2023-03-22 | |||||||
5182784 | 5182784 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .184812 | 00 | 2022-12-22 | 2022-12-23 | 2022-12-30 | 2022-12-21 | 0 | 2022-12-21 | ? | 0 | 0006648301 | 20221221.ifs | 2022-12-21 | 2022-12-22 | |||||||
5100347 | 5100347 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-09-28 | 2022-09-20 | 0 | 2022-09-20 | ? | 0 | 0006585686 | 20220920.ifs | 2022-09-20 | 2022-09-21 | |||||||
5037098 | 5037098 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-06-29 | 2022-06-21 | 0 | 2022-06-21 | ? | 0 | 0006541480 | 20220621.ifs | 2022-06-21 | 2022-06-22 | |||||||
4975222 | 4975222 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-03-30 | 2022-03-22 | 0 | 2022-03-22 | ? | 0 | 0006497670 | 20220322.ifs | 2022-03-22 | 2022-03-23 | |||||||
4907733 | 4907733 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-12-31 | 2021-12-22 | 0 | 2021-12-22 | ? | 0 | 0006445944 | 20211222.ifs | 2021-12-22 | 2021-12-23 | |||||||
4806428 | 4806428 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-09-29 | 2021-09-21 | 0 | 2021-09-21 | ? | 0 | 0006370434 | 20210921.ifs | 2021-09-21 | 2021-09-22 | |||||||
4733941 | 4733941 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-06-29 | 2021-06-21 | 0 | 2021-06-21 | ? | 0 | 0006324969 | 20210621.ifs | 2021-06-21 | 2021-06-22 | |||||||
4658683 | 4658683 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-03-30 | 2021-03-22 | 0 | 2021-03-22 | ? | 0 | 0006280187 | 20210322.ifs | 2021-03-22 | 2021-03-23 | |||||||
4567384 | 4567384 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-12-31 | 2020-12-22 | 0 | 2020-12-22 | ? | 0 | 0006230243 | 20201222.ifs | 2020-12-22 | 2020-12-23 | |||||||
4467215 | 4467215 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-09-30 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006161898 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4398116 | 4398116 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-07-01 | 2020-06-23 | 0 | 2020-06-23 | ? | 0 | 0006116795 | 20200623.ifs | 2020-06-23 | 2020-06-24 | |||||||
4252115 | 4252115 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .042077 | 00 | 2020-03-25 | 2020-03-26 | 2020-04-01 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072633 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252283 | 4252283 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .042077 | 00 | 2020-03-25 | 2020-03-26 | 2020-04-01 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072633 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4115489 | 4115489 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .092563 | 00 | 2019-12-24 | 2019-12-26 | 2020-01-02 | 2019-12-23 | 0 | 2019-12-23 | ? | 0 | 0006021437 | 20191223.ifs | 2019-12-23 | 2019-12-24 | |||||||
4115504 | 4115504 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .092563 | 00 | 2019-12-24 | 2019-12-26 | 2020-01-02 | 2019-12-23 | 0 | 2019-12-23 | ? | 0 | 0006021437 | 20191223.ifs | 2019-12-23 | 2019-12-24 | |||||||
3936221 | 3936221 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .12532 | 00 | 2019-09-25 | 2019-09-26 | 2019-10-02 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949554 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3936351 | 3936351 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .12532 | 00 | 2019-09-25 | 2019-09-26 | 2019-10-02 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949554 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3796611 | 3796611 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .149741 | 00 | 2019-06-25 | 2019-06-26 | 2019-07-02 | 2019-06-24 | 0 | 2019-06-24 | ? | 0 | 0005903351 | 20190624.ifs | 2019-06-24 | 2019-06-25 | |||||||
3796618 | 3796618 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .149741 | 00 | 2019-06-25 | 2019-06-26 | 2019-07-02 | 2019-06-24 | 0 | 2019-06-24 | ? | 0 | 0005903351 | 20190624.ifs | 2019-06-24 | 2019-06-25 | |||||||
3637471 | 3637471 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .138859 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-27 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854729 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3637474 | 3637474 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .138859 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-27 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854729 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3630386 | 3630386 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | 0 | A | 2011-07-14 | ? | 0 | no | no | no | 2011-07-14 | 2011-07-14 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3630388 | 3630387 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | 0 | A | 2011-07-14 | ? | 4 | no | no | no | 2011-07-14 | 2011-07-14 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3630391 | 3630391 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | 0 | A | 2011-07-14 | ? | 0 | no | no | no | 2011-07-14 | 2011-07-14 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3630393 | 3630392 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | 0 | A | 2011-07-14 | ? | 4 | no | no | no | 2011-07-14 | 2011-07-14 | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3494790 | 3494790 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .079968 | 00 | 2018-12-26 | 2018-12-27 | 2019-01-03 | 2018-12-24 | 0 | 2018-12-24 | ? | 0 | 0005804374 | 20181224.ifs | 2018-12-24 | 2018-12-25 | |||||||
3298684 | 3298684 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .080882 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-03 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728655 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3298796 | 3298796 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .080882 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-03 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728655 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3145647 | 3145647 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .05657 | 00 | 2018-06-20 | 2018-06-21 | 2018-06-27 | 2018-06-19 | 0 | 2018-06-19 | ? | 0 | 0005677402 | 20180619.ifs | 2018-06-19 | 2018-06-20 | |||||||
3145678 | 3145678 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .05657 | 00 | 2018-06-20 | 2018-06-21 | 2018-06-27 | 2018-06-19 | 0 | 2018-06-19 | ? | 0 | 0005677402 | 20180619.ifs | 2018-06-19 | 2018-06-20 | |||||||
2998147 | 2998147 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .004219 | 00 | 2018-03-21 | 2018-03-22 | 2018-03-28 | 2018-03-20 | 0 | 2018-03-20 | ? | 0 | 0005631966 | 20180320.ifs | 2018-03-20 | 2018-03-21 | |||||||
2998292 | 2998292 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .004219 | 00 | 2018-03-21 | 2018-03-22 | 2018-03-28 | 2018-03-20 | 0 | 2018-03-20 | ? | 0 | 0005631966 | 20180320.ifs | 2018-03-20 | 2018-03-21 | |||||||
2864743 | 2864743 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-01-04 | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005579333 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2864807 | 2864807 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-01-04 | 2017-12-22 | 0 | 2017-12-22 | ? | 0 | 0005579333 | 20171222.ifs | 2017-12-22 | 2017-12-23 | |||||||
2687895 | 2687895 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2017-10-05 | 2017-09-26 | 0 | 2017-09-26 | ? | 0 | 0005502614 | 20170926.ifs | 2017-09-26 | 2017-09-27 | |||||||
2595772 | 2595772 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2017-06-29 | 2017-06-20 | 0 | 2017-06-20 | ? | 0 | 0005452186 | 20170620.ifs | 2017-06-20 | 2017-06-21 | |||||||
2517177 | 2517177 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2017-03-30 | 2017-03-21 | 0 | 2017-03-21 | ? | 0 | 0005405496 | 20170321.ifs | 2017-03-21 | 2017-03-22 | |||||||
2386635 | 2386635 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-12-30 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346093 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2297713 | 2297713 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-09-29 | 2016-09-20 | 0 | 2016-09-20 | ? | 0 | 0005283336 | 20160920.ifs | 2016-09-20 | 2016-09-21 | |||||||
2226421 | 2226421 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-06-30 | 2016-06-21 | 0 | 2016-06-21 | ? | 0 | 0005236581 | 20160621.ifs | 2016-06-21 | 2016-06-22 | |||||||
2140347 | 2140347 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-04-01 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190846 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2055826 | 2055826 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 0 | .00032 | 00 | 2015-12-22 | 2015-12-24 | 2015-12-31 | 2015-12-21 | 0 | 2015-12-21 | ? | 0 | 0005132808 | 20151221.ifs | 2015-12-21 | 2015-12-22 | |||||||
2055827 | 2055827 | DIVIDEND | CHANGE | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-12-31 | 2013-12-23 | 0 | 2013-12-23 | ? | 0 | 0004702622 | 20151221.ifs | 2015-12-21 | 2015-12-22 | |||||||
2055828 | 2055827 | DIVIDEND | CHANGE | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-12-31 | 2013-12-23 | 1 | 2013-12-23 | 2015-12-21 | 0 | 0004702622 | 20151221.ifs | 2015-12-21 | 2015-12-22 | |||||||
1392680 | 1392680 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-12-31 | 2013-12-23 | 0 | 2013-12-23 | ? | 0 | 0004702622 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1295619 | 1295619 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-10-01 | 2013-09-24 | 0 | 2013-09-24 | ? | 0 | 0004633149 | 20130924.ifs | 2013-09-24 | 2013-09-25 | |||||||
1217227 | 1217227 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-07-02 | 2013-06-25 | 0 | 2013-06-25 | ? | 0 | 0004588894 | 20130625.ifs | 2013-06-25 | 2013-06-26 | |||||||
1136232 | 1136232 | DIVIDEND | ADD | 74347X294 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-03-26 | 2013-03-19 | 0 | 2013-03-19 | ? | 0 | 0004543115 | 20130319.ifs | 2013-03-19 | 2013-03-20 | |||||||
1059074 | 1059074 | DIVIDEND | ADD | 74347X294 | 0 | 0 | 1 | 4 | .053002 | 00 | 2012-12-26 | 2012-12-28 | 2013-01-03 | 2012-12-24 | 0 | 2012-12-24 | ? | 0 | 0004494467 | 20121224.ifs | 2012-12-24 | 2012-12-25 | |||||||
587812 | 587812 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | N | A | 2011-07-14 | ? | 0 | no | no | no | 2011-07-14 | 2011-07-14 | ? | 20110715.ifs | 2011-07-15 | 2011-07-16 | ||||||||||
587813 | 587812 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | 0 | A | 2011-07-14 | ? | 0 | no | no | no | 2011-07-14 | 2011-07-14 | ? | 20110715.ifs | 2011-07-15 | 2011-07-16 | ||||||||||
587067 | 587067 | EQUITY | ADD | 74347X294 | HEDGE REPLICATION ETF | N | 7 | 2011-07-14 | ? | 0 | no | no | no | 2011-07-14 | ? | ? | 20110714.ifs | 2011-07-14 | 2011-07-15 | ||||||||||
587068 | 587068 | EXCHANGE | ADD | 74347X294 | 04 | 2011-07-14 | 2011-07-14 | HDG | 0 | A | 2011-07-14 | ? | 20110714.ifs | 2011-07-14 | 2011-07-15 | ||||||||||||||
587245 | 587245 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | N | 7 | 2011-07-14 | ? | 0 | no | no | no | 2011-07-14 | ? | ? | 20110714.ifs | 2011-07-14 | 2011-07-15 | ||||||||||
587246 | 587245 | EQUITY | CHANGE | 74347X294 | HEDGE REPLICATION ETF | N | A | 2011-07-14 | ? | 0 | no | no | no | 2011-07-14 | 2011-07-14 | ? | 20110714.ifs | 2011-07-14 | 2011-07-15 |
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 = 159753
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