INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 277 | 241 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 94.34 % | 91.66 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:130746 |
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 | ||
5542754 | 5542754 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2024-05-03 | 2024-05-06 | 2024-05-13 | 2024-04-24 | 0 | 2024-04-24 | ? | 0 | 0006908409 | 20240424.ifs | 2024-04-24 | 2024-04-25 | |||||||
5486012 | 5486012 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2024-02-08 | 2024-02-09 | 2024-02-16 | 2024-01-29 | 0 | 2024-01-29 | ? | 0 | 0006867141 | 20240129.ifs | 2024-01-29 | 2024-01-30 | |||||||
5399242 | 5399242 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2023-11-02 | 2023-11-03 | 2023-11-13 | 2023-10-23 | 0 | 2023-10-24 | ? | 0 | 0006800588 | 20231024.ifs | 2023-10-24 | 2023-10-25 | |||||||
5340402 | 5340402 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2023-08-04 | 2023-08-07 | 2023-08-14 | 2023-07-25 | 0 | 2023-07-27 | ? | 0 | 0006759044 | 20230727.ifs | 2023-07-27 | 2023-07-28 | |||||||
5278313 | 5278313 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2023-05-05 | 2023-05-08 | 2023-05-15 | 2023-04-24 | 0 | 2023-04-27 | ? | 0 | 0006715984 | 20230427.ifs | 2023-04-27 | 2023-04-28 | |||||||
5216914 | 5216914 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2023-02-02 | 2023-02-03 | 2023-02-10 | 2023-01-24 | 0 | 2023-01-26 | ? | 0 | 0006672425 | 20230126.ifs | 2023-01-26 | 2023-01-27 | |||||||
5123132 | 5123132 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2022-10-28 | 2022-10-31 | 2022-11-10 | 2022-10-19 | 0 | 2022-10-20 | ? | 0 | 0006600878 | 20221020.ifs | 2022-10-20 | 2022-10-21 | |||||||
5061714 | 5061714 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2022-07-29 | 2022-08-01 | 2022-08-12 | 2022-07-19 | 0 | 2022-07-21 | ? | 0 | 0006557507 | 20220721.ifs | 2022-07-21 | 2022-07-22 | |||||||
4998031 | 4998031 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2022-05-05 | 2022-05-06 | 2022-05-13 | 2022-04-22 | 0 | 2022-04-26 | ? | 0 | 0006513296 | 20220426.ifs | 2022-04-26 | 2022-04-27 | |||||||
4936797 | 4936797 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2022-02-03 | 2022-02-04 | 2022-02-11 | 2022-01-18 | 0 | 2022-01-20 | ? | 0 | 0006469462 | 20220120.ifs | 2022-01-20 | 2022-01-21 | |||||||
4829940 | 4829940 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2021-10-29 | 2021-11-01 | 2021-11-12 | 2021-10-19 | 0 | 2021-10-21 | ? | 0 | 0006385118 | 20211021.ifs | 2021-10-21 | 2021-10-22 | |||||||
4765404 | 4765404 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2021-08-05 | 2021-08-06 | 2021-08-13 | 2021-07-23 | 0 | 2021-07-27 | ? | 0 | 0006342501 | 20210727.ifs | 2021-07-27 | 2021-07-28 | |||||||
4688981 | 4688981 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .33 | 00 | 2021-05-06 | 2021-05-07 | 2021-05-14 | 2021-04-23 | 0 | 2021-04-27 | ? | 0 | 0006297287 | 20210427.ifs | 2021-04-27 | 2021-04-28 | |||||||
4611860 | 4611860 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .3 | 00 | 2021-02-04 | 2021-02-05 | 2021-02-12 | 2021-01-21 | 0 | 2021-01-26 | ? | 0 | 0006253907 | 20210126.ifs | 2021-01-26 | 2021-01-27 | |||||||
4506304 | 4506304 | EQUITY | CHANGE | 69478X105 | COM | 0 | 0 | 2002-07-19 | ? | 0 | yes | no | yes | 2004-06-14 | 2002-07-19 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4506305 | 4506304 | EQUITY | CHANGE | 69478X105 | COM | 0 | 0 | 2002-07-19 | ? | 4 | yes | no | yes | 2004-06-14 | 2020-11-13 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4491843 | 4491843 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .28 | 00 | 2020-11-05 | 2020-11-06 | 2020-11-13 | 2020-10-23 | 0 | 2020-10-27 | ? | 0 | 0006177884 | 20201027.ifs | 2020-10-27 | 2020-10-28 | |||||||
4424684 | 4424684 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-08-06 | 2020-08-07 | 2020-08-14 | 2020-07-24 | 0 | 2020-07-27 | ? | 0 | 0006133012 | 20200727.ifs | 2020-07-27 | 2020-07-28 | |||||||
4303879 | 4303879 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-05-07 | 2020-05-08 | 2020-05-15 | 2020-04-24 | 0 | 2020-04-28 | ? | 0 | 0006088565 | 20200428.ifs | 2020-04-28 | 2020-04-29 | |||||||
4303880 | 4303880 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-05-07 | 2020-05-08 | 2020-05-15 | 2020-04-24 | 0 | 2020-04-28 | ? | 0 | 0006088565 | 20200428.ifs | 2020-04-28 | 2020-04-29 | |||||||
4175959 | 4175959 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-01-31 | 2020-02-03 | 2020-02-14 | 2020-01-21 | 0 | 2020-01-23 | ? | 0 | 0006044290 | 20200123.ifs | 2020-01-23 | 2020-01-24 | |||||||
4175960 | 4175960 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .25 | 00 | 2020-01-31 | 2020-02-03 | 2020-02-14 | 2020-01-21 | 0 | 2020-01-23 | ? | 0 | 0006044290 | 20200123.ifs | 2020-01-23 | 2020-01-24 | |||||||
3980221 | 3980221 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-15 | 2019-10-18 | 0 | 2019-10-22 | ? | 0 | 0005963813 | 20191022.ifs | 2019-10-22 | 2019-10-23 | |||||||
3980224 | 3980224 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-15 | 2019-10-18 | 0 | 2019-10-22 | ? | 0 | 0005963813 | 20191022.ifs | 2019-10-22 | 2019-10-23 | |||||||
3844458 | 3844458 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-08-01 | 2019-08-02 | 2019-08-15 | 2019-07-19 | 0 | 2019-07-23 | ? | 0 | 0005918568 | 20190723.ifs | 2019-07-23 | 2019-07-24 | |||||||
3844459 | 3844459 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-08-01 | 2019-08-02 | 2019-08-15 | 2019-07-19 | 0 | 2019-07-23 | ? | 0 | 0005918568 | 20190723.ifs | 2019-07-23 | 2019-07-24 | |||||||
3691408 | 3691408 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-04-30 | 2019-05-01 | 2019-05-15 | 2019-04-19 | 0 | 2019-04-23 | ? | 0 | 0005872273 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3691409 | 3691409 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-04-30 | 2019-05-01 | 2019-05-15 | 2019-04-19 | 0 | 2019-04-23 | ? | 0 | 0005872273 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3564285 | 3564285 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-02-14 | 2019-02-15 | 2019-03-01 | 2019-01-28 | 0 | 2019-01-29 | ? | 0 | 0005828913 | 20190129.ifs | 2019-01-29 | 2019-01-30 | |||||||
3564286 | 3564286 | DIVIDEND | ADD | 69478X105 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-02-14 | 2019-02-15 | 2019-03-01 | 2019-01-28 | 0 | 2019-01-29 | ? | 0 | 0005828913 | 20190129.ifs | 2019-01-29 | 2019-01-30 |
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 = 130746
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