INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 360 | 305 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 53.98 % | 47.37 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:133300 |
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 | ||
5560783 | 5560783 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2024-06-28 | 2024-06-28 | 2024-07-31 | 2024-05-22 | 0 | 2024-05-22 | ? | 0 | 0006921296 | 20240522.ifs | 2024-05-22 | 2024-05-23 | |||||||
5502277 | 5502277 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2024-03-27 | 2024-03-29 | 2024-04-30 | 2024-02-22 | 0 | 2024-02-23 | ? | 0 | 0006879083 | 20240223.ifs | 2024-02-23 | 2024-02-24 | |||||||
5397301 | 5397301 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2023-12-28 | 2023-12-29 | 2024-01-31 | 2023-10-19 | 0 | 2023-10-19 | ? | 0 | 0006799816 | 20231019.ifs | 2023-10-19 | 2023-10-20 | |||||||
5337326 | 5337326 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2023-09-28 | 2023-09-29 | 2023-10-31 | 2023-07-20 | 0 | 2023-07-20 | ? | 0 | 0006757177 | 20230720.ifs | 2023-07-20 | 2023-07-21 | |||||||
5296784 | 5296784 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2023-06-29 | 2023-06-30 | 2023-07-31 | 2023-05-25 | 0 | 2023-05-25 | ? | 0 | 0006728248 | 20230525.ifs | 2023-05-25 | 2023-05-26 | |||||||
5231228 | 5231228 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2023-03-30 | 2023-03-31 | 2023-05-01 | 2023-02-16 | 0 | 2023-02-16 | ? | 0 | 0006683136 | 20230216.ifs | 2023-02-16 | 2023-02-17 | |||||||
5123009 | 5123009 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2022-12-29 | 2022-12-31 | 2023-01-31 | 2022-10-20 | 0 | 2022-10-20 | ? | 0 | 0006601113 | 20221020.ifs | 2022-10-20 | 2022-10-21 | |||||||
5061438 | 5061438 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2022-09-29 | 2022-09-30 | 2022-10-31 | 2022-07-21 | 0 | 2022-07-21 | ? | 0 | 0006557756 | 20220721.ifs | 2022-07-21 | 2022-07-22 | |||||||
5014403 | 5014403 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2022-06-29 | 2022-06-30 | 2022-08-01 | 2022-05-19 | 0 | 2022-05-19 | ? | 0 | 0006525416 | 20220519.ifs | 2022-05-19 | 2022-05-20 | |||||||
4954965 | 4954965 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2022-03-30 | 2022-03-31 | 2022-05-02 | 2022-02-17 | 0 | 2022-02-17 | ? | 0 | 0006481925 | 20220217.ifs | 2022-02-17 | 2022-02-18 | |||||||
4829800 | 4829800 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-12-30 | 2021-12-31 | 2022-01-31 | 2021-10-21 | 0 | 2021-10-21 | ? | 0 | 0006385125 | 20211021.ifs | 2021-10-21 | 2021-10-22 | |||||||
4806144 | 4806144 | CORPACTION | ADD | 98421M106 | 01 | X | 2021-09-21 | 98421M106 | 60 | ? | 20210921.ifs | 2021-09-21 | 2021-09-22 | ||||||||||||||||
4806145 | 4806145 | EXCHANGE | ADD | 98421M106 | 60 | 2021-09-21 | 2021-09-21 | XRX | 0 | 0 | 2021-09-21 | ? | 20210921.ifs | 2021-09-21 | 2021-09-22 | ||||||||||||||
4806146 | 4806146 | EQUITY | CHANGE | 98421M106 | COM NEW | 0 | 0 | 2019-08-01 | ? | 4 | no | no | no | 2019-08-01 | 2020-11-13 | ? | 20210921.ifs | 2021-09-21 | 2021-09-22 | ||||||||||
4806147 | 4806146 | EQUITY | CHANGE | 98421M106 | COM NEW | 0 | 0 | 2019-08-01 | ? | 4 | no | no | yes | 2019-08-01 | 2021-09-21 | ? | 20210921.ifs | 2021-09-21 | 2021-09-22 | ||||||||||
4763043 | 4763043 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-09-29 | 2021-09-30 | 2021-11-01 | 2021-07-22 | 0 | 2021-07-22 | ? | 0 | 0006341875 | 20210722.ifs | 2021-07-22 | 2021-07-23 | |||||||
4708764 | 4708764 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-06-29 | 2021-06-30 | 2021-08-02 | 2021-05-20 | 0 | 2021-05-20 | ? | 0 | 0006309756 | 20210520.ifs | 2021-05-20 | 2021-05-21 | |||||||
4631855 | 4631855 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-03-30 | 2021-03-31 | 2021-04-30 | 2021-02-18 | 0 | 2021-02-18 | ? | 0 | 0006265312 | 20210218.ifs | 2021-02-18 | 2021-02-19 | |||||||
4506032 | 4506032 | EQUITY | CHANGE | 98421M106 | COM NEW | 0 | 0 | 2019-08-01 | ? | 0 | no | no | no | 2019-08-01 | ? | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4506033 | 4506032 | EQUITY | CHANGE | 98421M106 | COM NEW | 0 | 0 | 2019-08-01 | ? | 4 | no | no | no | 2019-08-01 | 2020-11-13 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4489390 | 4489390 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-12-30 | 2020-12-31 | 2021-01-29 | 2020-10-22 | 0 | 2020-10-22 | ? | 0 | 0006176909 | 20201022.ifs | 2020-10-22 | 2020-10-23 | |||||||
4423164 | 4423164 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-09-29 | 2020-09-30 | 2020-10-30 | 2020-07-23 | 0 | 2020-07-23 | ? | 0 | 0006132523 | 20200723.ifs | 2020-07-23 | 2020-07-24 | |||||||
4344781 | 4344781 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-06-29 | 2020-06-30 | 2020-07-31 | 2020-05-21 | 0 | 2020-05-21 | ? | 0 | 0006100855 | 20200521.ifs | 2020-05-21 | 2020-05-22 | |||||||
4344782 | 4344782 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-06-29 | 2020-06-30 | 2020-07-31 | 2020-05-21 | 0 | 2020-05-21 | ? | 0 | 0006100855 | 20200521.ifs | 2020-05-21 | 2020-05-22 | |||||||
4217936 | 4217936 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-03-27 | 2020-03-30 | 2020-04-30 | 2020-02-27 | 0 | 2020-02-27 | ? | 0 | 0006059065 | 20200227.ifs | 2020-02-27 | 2020-02-28 | |||||||
4218033 | 4218033 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-03-27 | 2020-03-30 | 2020-04-30 | 2020-02-27 | 0 | 2020-02-27 | ? | 0 | 0006059065 | 20200227.ifs | 2020-02-27 | 2020-02-28 | |||||||
3982502 | 3982502 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-31 | 2019-10-24 | 0 | 2019-10-24 | ? | 0 | 0005964899 | 20191024.ifs | 2019-10-24 | 2019-10-25 | |||||||
3982552 | 3982552 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-31 | 2019-10-24 | 0 | 2019-10-24 | ? | 0 | 0005964899 | 20191024.ifs | 2019-10-24 | 2019-10-25 | |||||||
3938284 | 3938284 | DIVIDEND | CHANGE | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-31 | 2019-08-28 | 0 | 2019-08-28 | ? | 0 | 0005934306 | 20190925.ifs | 2019-09-25 | 2019-09-26 | |||||||
3938286 | 3938285 | DIVIDEND | CHANGE | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-31 | 2019-08-28 | 1 | 2019-08-28 | 2019-09-25 | 0 | 0005934306 | 20190925.ifs | 2019-09-25 | 2019-09-26 | |||||||
3938312 | 3938312 | DIVIDEND | CHANGE | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-31 | 2019-08-28 | 0 | 2019-08-28 | ? | 0 | 0005934306 | 20190925.ifs | 2019-09-25 | 2019-09-26 | |||||||
3938313 | 3938312 | DIVIDEND | CHANGE | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-31 | 2019-08-28 | 1 | 2019-08-28 | 2019-09-25 | 0 | 0005934306 | 20190925.ifs | 2019-09-25 | 2019-09-26 | |||||||
3893130 | 3893130 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-31 | 2019-08-28 | 0 | 2019-08-28 | ? | 0 | 0005934306 | 20190828.ifs | 2019-08-28 | 2019-08-29 | |||||||
3893135 | 3893135 | DIVIDEND | ADD | 98421M106 | 0 | 0 | 1 | 0 | .25 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-31 | 2019-08-28 | 0 | 2019-08-28 | ? | 0 | 0005934306 | 20190828.ifs | 2019-08-28 | 2019-08-29 | |||||||
3860102 | 3860102 | EQUITY | ADD | 98421M106 | COM NEW | N | 0 | 2019-08-01 | ? | 0 | no | no | no | 2019-08-01 | ? | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 | ||||||||||
3860103 | 3860103 | EQUITY | ADD | 98421M106 | COM NEW | N | 0 | 2019-08-01 | ? | 0 | no | no | no | 2019-08-01 | ? | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 | ||||||||||
3860110 | 3860110 | EXCHANGE | ADD | 98421M106 | 01 | 2019-08-01 | 2019-08-01 | XRX | 0 | 0 | 2019-08-01 | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 | ||||||||||||||
3860111 | 3860111 | EXCHANGE | ADD | 98421M106 | 01 | 2019-08-01 | 2019-08-01 | XRX | 0 | 0 | 2019-08-01 | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 | ||||||||||||||
3860344 | 3860344 | EQUITY | CHANGE | 98421M106 | COM NEW | N | 0 | 2019-08-01 | ? | 0 | no | no | no | 2019-08-01 | ? | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 | ||||||||||
3860345 | 3860345 | EQUITY | CHANGE | 98421M106 | COM NEW | N | 0 | 2019-08-01 | ? | 0 | no | no | no | 2019-08-01 | ? | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 | ||||||||||
3860346 | 3860345 | EQUITY | CHANGE | 98421M106 | COM NEW | 0 | 0 | 2019-08-01 | ? | 0 | no | no | no | 2019-08-01 | ? | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 | ||||||||||
3860347 | 3860346 | EQUITY | CHANGE | 98421M106 | COM NEW | 0 | 0 | 2019-08-01 | ? | 0 | no | no | no | 2019-08-01 | ? | ? | 20190801.ifs | 2019-08-01 | 2019-08-02 |
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 = 133300
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