INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 11 | 9 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 0.92 % | 0.83 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:166930 |
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 | ||
5582662 | 5582662 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .3348 | 00 | 2024-06-26 | 2024-06-26 | 2024-07-03 | 2024-06-25 | 0 | 2024-06-25 | ? | 0 | 0006937693 | 20240625.ifs | 2024-06-25 | 2024-06-26 | |||||||
5518814 | 5518814 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .202464 | 00 | 2024-03-20 | 2024-03-21 | 2024-03-27 | 2024-03-19 | 0 | 2024-03-19 | ? | 0 | 0006891960 | 20240319.ifs | 2024-03-19 | 2024-03-20 | |||||||
5449392 | 5449392 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .432815 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-28 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840832 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5375924 | 5375924 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .273097 | 00 | 2023-09-20 | 2023-09-21 | 2023-09-27 | 2023-09-19 | 0 | 2023-09-19 | ? | 0 | 0006784895 | 20230919.ifs | 2023-09-19 | 2023-09-20 | |||||||
5314387 | 5314387 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .236979 | 00 | 2023-06-21 | 2023-06-22 | 2023-06-28 | 2023-06-20 | 0 | 2023-06-20 | ? | 0 | 0006741395 | 20230620.ifs | 2023-06-20 | 2023-06-21 | |||||||
5252061 | 5252061 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .206236 | 00 | 2023-03-22 | 2023-03-23 | 2023-03-29 | 2023-03-21 | 0 | 2023-03-21 | ? | 0 | 0006698206 | 20230321.ifs | 2023-03-21 | 2023-03-22 | |||||||
5182828 | 5182828 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .400565 | 00 | 2022-12-22 | 2022-12-23 | 2022-12-30 | 2022-12-21 | 0 | 2022-12-21 | ? | 0 | 0006648712 | 20221221.ifs | 2022-12-21 | 2022-12-22 | |||||||
5100376 | 5100376 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .255416 | 00 | 2022-09-21 | 2022-09-22 | 2022-09-28 | 2022-09-20 | 0 | 2022-09-20 | ? | 0 | 0006585674 | 20220920.ifs | 2022-09-20 | 2022-09-21 | |||||||
5037127 | 5037127 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .234404 | 00 | 2022-06-22 | 2022-06-23 | 2022-06-29 | 2022-06-21 | 0 | 2022-06-21 | ? | 0 | 0006541508 | 20220621.ifs | 2022-06-21 | 2022-06-22 | |||||||
4975252 | 4975252 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .265011 | 00 | 2022-03-23 | 2022-03-24 | 2022-03-30 | 2022-03-22 | 0 | 2022-03-22 | ? | 0 | 0006497589 | 20220322.ifs | 2022-03-22 | 2022-03-23 | |||||||
4907774 | 4907774 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .295469 | 00 | 2021-12-23 | 2021-12-27 | 2021-12-31 | 2021-12-22 | 0 | 2021-12-22 | ? | 0 | 0006446330 | 20211222.ifs | 2021-12-22 | 2021-12-23 | |||||||
4806458 | 4806458 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .349476 | 00 | 2021-09-22 | 2021-09-23 | 2021-09-29 | 2021-09-21 | 0 | 2021-09-21 | ? | 0 | 0006370488 | 20210921.ifs | 2021-09-21 | 2021-09-22 | |||||||
4733973 | 4733973 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .215872 | 00 | 2021-06-22 | 2021-06-23 | 2021-06-29 | 2021-06-21 | 0 | 2021-06-21 | ? | 0 | 0006325043 | 20210621.ifs | 2021-06-21 | 2021-06-22 | |||||||
4658711 | 4658711 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .227475 | 00 | 2021-03-23 | 2021-03-24 | 2021-03-30 | 2021-03-22 | 0 | 2021-03-22 | ? | 0 | 0006280243 | 20210322.ifs | 2021-03-22 | 2021-03-23 | |||||||
4567420 | 4567420 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .338291 | 00 | 2020-12-23 | 2020-12-24 | 2020-12-31 | 2020-12-22 | 0 | 2020-12-22 | ? | 0 | 0006230228 | 20201222.ifs | 2020-12-22 | 2020-12-23 | |||||||
4467242 | 4467242 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .212717 | 00 | 2020-09-23 | 2020-09-24 | 2020-09-30 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006161995 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4398144 | 4398144 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .211242 | 00 | 2020-06-24 | 2020-06-25 | 2020-07-01 | 2020-06-23 | 0 | 2020-06-23 | ? | 0 | 0006116938 | 20200623.ifs | 2020-06-23 | 2020-06-24 | |||||||
4252165 | 4252165 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .196927 | 00 | 2020-03-25 | 2020-03-26 | 2020-04-01 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072741 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252344 | 4252344 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 0 | .196927 | 00 | 2020-03-25 | 2020-03-26 | 2020-04-01 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072741 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4115545 | 4115545 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 4 | .066365 | 00 | 2019-12-24 | 2019-12-26 | 2020-01-02 | 2019-12-23 | 0 | 2019-12-23 | ? | 0 | 0006021838 | 20191223.ifs | 2019-12-23 | 2019-12-24 | |||||||
4115560 | 4115560 | DIVIDEND | ADD | 74347G507 | 0 | 0 | 1 | 4 | .066365 | 00 | 2019-12-24 | 2019-12-26 | 2020-01-02 | 2019-12-23 | 0 | 2019-12-23 | ? | 0 | 0006021838 | 20191223.ifs | 2019-12-23 | 2019-12-24 | |||||||
4008796 | 4008796 | EQUITY | ADD | 74347G507 | NEW ISSUE | 0 | 0 | 2019-11-07 | ? | 0 | no | no | no | ? | ? | ? | 20191107.ifs | 2019-11-07 | 2019-11-08 | ||||||||||
4008798 | 4008798 | EQUITY | CHANGE | 74347G507 | NEW ISSUE | 0 | 0 | 2019-11-07 | ? | 0 | no | no | no | ? | ? | ? | 20191107.ifs | 2019-11-07 | 2019-11-08 | ||||||||||
4008800 | 4008799 | EQUITY | CHANGE | 74347G507 | RUSSELL US DIVID GROWERS ETF | N | A | 2019-11-07 | ? | 0 | no | no | no | ? | 2019-11-07 | ? | 20191107.ifs | 2019-11-07 | 2019-11-08 | ||||||||||
4008983 | 4008983 | EQUITY | ADD | 74347G507 | NEW ISSUE | 0 | 0 | 2019-11-07 | ? | 0 | no | no | no | ? | ? | ? | 20191107.ifs | 2019-11-07 | 2019-11-08 | ||||||||||
4008985 | 4008985 | EQUITY | CHANGE | 74347G507 | NEW ISSUE | 0 | 0 | 2019-11-07 | ? | 0 | no | no | no | ? | ? | ? | 20191107.ifs | 2019-11-07 | 2019-11-08 | ||||||||||
4008986 | 4008985 | EQUITY | CHANGE | 74347G507 | RUSSELL US DIVID GROWERS ETF | N | A | 2019-11-07 | ? | 0 | no | no | no | ? | 2019-11-07 | ? | 20191107.ifs | 2019-11-07 | 2019-11-08 |
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 = 166930
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