INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 236 | 220 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 82.88 % | 79.52 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130591 |
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 | ||
5544984 | 5544984 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2024-05-08 | 2024-05-09 | 2024-05-23 | 2024-04-29 | 0 | 2024-04-29 | ? | 0 | 0006909771 | 20240429.ifs | 2024-04-29 | 2024-04-30 | |||||||
5486769 | 5486769 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2024-02-08 | 2024-02-09 | 2024-02-23 | 2024-01-30 | 0 | 2024-01-30 | ? | 0 | 0006867460 | 20240130.ifs | 2024-01-30 | 2024-01-31 | |||||||
5398734 | 5398734 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-11-01 | 2023-11-02 | 2023-11-16 | 2023-10-23 | 0 | 2023-10-23 | ? | 0 | 0006800196 | 20231023.ifs | 2023-10-23 | 2023-10-24 | |||||||
5338856 | 5338856 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-08-02 | 2023-08-03 | 2023-08-17 | 2023-07-24 | 0 | 2023-07-24 | ? | 0 | 0006758096 | 20230724.ifs | 2023-07-24 | 2023-07-25 | |||||||
5276784 | 5276784 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-05-03 | 2023-05-04 | 2023-05-18 | 2023-04-24 | 0 | 2023-04-25 | ? | 0 | 0006714891 | 20230425.ifs | 2023-04-25 | 2023-04-26 | |||||||
5218487 | 5218487 | DIVIDEND | DELETE | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-02-02 | 2023-02-03 | 2023-02-16 | 2023-01-23 | 1 | 2023-01-23 | 2023-01-27 | 0 | 0006671614 | 20230130.ifs | 2023-01-30 | 2023-01-31 | |||||||
5218488 | 5218488 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-02-01 | 2023-02-02 | 2023-02-16 | 2023-01-23 | 2 | 2023-01-23 | 2023-01-30 | 0 | 0006671614 | 20230130.ifs | 2023-01-30 | 2023-01-31 | |||||||
5217773 | 5217773 | DIVIDEND | DELETE | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-02-01 | 2023-02-02 | 2023-02-16 | 2023-01-23 | 0 | 2023-01-23 | ? | 0 | 0006671614 | 20230127.ifs | 2023-01-27 | 2023-01-28 | |||||||
5217774 | 5217774 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-02-02 | 2023-02-03 | 2023-02-16 | 2023-01-23 | 1 | 2023-01-23 | 2023-01-27 | 0 | 0006671614 | 20230127.ifs | 2023-01-27 | 2023-01-28 | |||||||
5215145 | 5215145 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2023-02-01 | 2023-02-02 | 2023-02-16 | 2023-01-23 | 0 | 2023-01-23 | ? | 0 | 0006671614 | 20230123.ifs | 2023-01-23 | 2023-01-24 | |||||||
5124477 | 5124477 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2022-11-02 | 2022-11-03 | 2022-11-17 | 2022-10-24 | 0 | 2022-10-24 | ? | 0 | 0006601622 | 20221024.ifs | 2022-10-24 | 2022-10-25 | |||||||
5060416 | 5060416 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2022-07-28 | 2022-07-29 | 2022-08-12 | 2022-07-19 | 0 | 2022-07-19 | ? | 0 | 0006557065 | 20220719.ifs | 2022-07-19 | 2022-07-20 | |||||||
4994697 | 4994697 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2022-04-27 | 2022-04-28 | 2022-05-12 | 2022-04-18 | 0 | 2022-04-18 | ? | 0 | 0006511593 | 20220418.ifs | 2022-04-18 | 2022-04-19 | |||||||
4938447 | 4938447 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2022-02-02 | 2022-02-03 | 2022-02-17 | 2022-01-24 | 0 | 2022-01-24 | ? | 0 | 0006470197 | 20220124.ifs | 2022-01-24 | 2022-01-25 | |||||||
4831605 | 4831605 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2021-11-03 | 2021-11-04 | 2021-11-18 | 2021-10-25 | 0 | 2021-10-25 | ? | 0 | 0006385833 | 20211025.ifs | 2021-10-25 | 2021-10-26 | |||||||
4761791 | 4761791 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2021-07-29 | 2021-07-30 | 2021-08-13 | 2021-07-20 | 0 | 2021-07-20 | ? | 0 | 0006341205 | 20210720.ifs | 2021-07-20 | 2021-07-21 | |||||||
4689048 | 4689048 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2021-05-06 | 2021-05-07 | 2021-05-21 | 2021-04-27 | 0 | 2021-04-27 | ? | 0 | 0006297480 | 20210427.ifs | 2021-04-27 | 2021-04-28 | |||||||
4611912 | 4611912 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2021-02-04 | 2021-02-05 | 2021-02-19 | 2021-01-26 | 0 | 2021-01-26 | ? | 0 | 0006254122 | 20210126.ifs | 2021-01-26 | 2021-01-27 | |||||||
4488414 | 4488414 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-10-29 | 2020-10-30 | 2020-11-13 | 2020-10-20 | 0 | 2020-10-20 | ? | 0 | 0006176185 | 20201020.ifs | 2020-10-20 | 2020-10-21 | |||||||
4427047 | 4427047 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-08-07 | 2020-08-10 | 2020-08-24 | 2020-07-30 | 0 | 2020-07-30 | ? | 0 | 0006134679 | 20200730.ifs | 2020-07-30 | 2020-07-31 | |||||||
4304406 | 4304406 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-05-07 | 2020-05-08 | 2020-05-22 | 2020-04-28 | 0 | 2020-04-28 | ? | 0 | 0006088990 | 20200428.ifs | 2020-04-28 | 2020-04-29 | |||||||
4304409 | 4304409 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-05-07 | 2020-05-08 | 2020-05-22 | 2020-04-28 | 0 | 2020-04-28 | ? | 0 | 0006088990 | 20200428.ifs | 2020-04-28 | 2020-04-29 | |||||||
4174723 | 4174723 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-02-06 | 2020-02-07 | 2020-02-21 | 2020-01-22 | 0 | 2020-01-22 | ? | 0 | 0006044150 | 20200122.ifs | 2020-01-22 | 2020-01-23 | |||||||
4174736 | 4174736 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-02-06 | 2020-02-07 | 2020-02-21 | 2020-01-22 | 0 | 2020-01-22 | ? | 0 | 0006044150 | 20200122.ifs | 2020-01-22 | 2020-01-23 | |||||||
3973876 | 3973876 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-10-24 | 2019-10-25 | 2019-11-08 | 2019-10-15 | 0 | 2019-10-15 | ? | 0 | 0005962573 | 20191015.ifs | 2019-10-15 | 2019-10-16 | |||||||
3973887 | 3973887 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-10-24 | 2019-10-25 | 2019-11-08 | 2019-10-15 | 0 | 2019-10-15 | ? | 0 | 0005962573 | 20191015.ifs | 2019-10-15 | 2019-10-16 | |||||||
3837248 | 3837248 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-07-25 | 2019-07-26 | 2019-08-09 | 2019-07-16 | 0 | 2019-07-16 | ? | 0 | 0005916881 | 20190716.ifs | 2019-07-16 | 2019-07-17 | |||||||
3837249 | 3837249 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-07-25 | 2019-07-26 | 2019-08-09 | 2019-07-16 | 0 | 2019-07-16 | ? | 0 | 0005916881 | 20190716.ifs | 2019-07-16 | 2019-07-17 | |||||||
3685654 | 3685654 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-04-25 | 2019-04-26 | 2019-05-10 | 2019-04-16 | 0 | 2019-04-16 | ? | 0 | 0005870799 | 20190416.ifs | 2019-04-16 | 2019-04-17 | |||||||
3685655 | 3685655 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-04-25 | 2019-04-26 | 2019-05-10 | 2019-04-16 | 0 | 2019-04-16 | ? | 0 | 0005870799 | 20190416.ifs | 2019-04-16 | 2019-04-17 | |||||||
3556905 | 3556905 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-15 | 2019-01-22 | 0 | 2019-01-22 | ? | 0 | 0005827578 | 20190122.ifs | 2019-01-22 | 2019-01-23 | |||||||
3556914 | 3556914 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-15 | 2019-01-22 | 0 | 2019-01-22 | ? | 0 | 0005827578 | 20190122.ifs | 2019-01-22 | 2019-01-23 | |||||||
3330766 | 3330766 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-10-25 | 2018-10-26 | 2018-11-09 | 2018-10-16 | 0 | 2018-10-16 | ? | 0 | 0005741195 | 20181016.ifs | 2018-10-16 | 2018-10-17 | |||||||
3330767 | 3330767 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-10-25 | 2018-10-26 | 2018-11-09 | 2018-10-16 | 0 | 2018-10-16 | ? | 0 | 0005741195 | 20181016.ifs | 2018-10-16 | 2018-10-17 | |||||||
3196547 | 3196547 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-07-26 | 2018-07-27 | 2018-08-10 | 2018-07-17 | 0 | 2018-07-17 | ? | 0 | 0005694501 | 20180717.ifs | 2018-07-17 | 2018-07-18 | |||||||
3196567 | 3196567 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .14 | 00 | 2018-07-26 | 2018-07-27 | 2018-08-10 | 2018-07-17 | 0 | 2018-07-17 | ? | 0 | 0005694501 | 20180717.ifs | 2018-07-17 | 2018-07-18 | |||||||
3041051 | 3041051 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-04-26 | 2018-04-27 | 2018-05-11 | 2018-04-17 | 0 | 2018-04-17 | ? | 0 | 0005647734 | 20180417.ifs | 2018-04-17 | 2018-04-18 | |||||||
3041078 | 3041078 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-04-26 | 2018-04-27 | 2018-05-11 | 2018-04-17 | 0 | 2018-04-17 | ? | 0 | 0005647734 | 20180417.ifs | 2018-04-17 | 2018-04-18 | |||||||
2930715 | 2930715 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-02-02 | 2018-02-05 | 2018-02-19 | 2018-01-26 | 0 | 2018-01-26 | ? | 0 | 0005604467 | 20180126.ifs | 2018-01-26 | 2018-01-27 | |||||||
2930735 | 2930735 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-02-02 | 2018-02-05 | 2018-02-19 | 2018-01-26 | 0 | 2018-01-26 | ? | 0 | 0005604467 | 20180126.ifs | 2018-01-26 | 2018-01-27 | |||||||
2726502 | 2726502 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-10-30 | 2017-10-31 | 2017-11-14 | 2017-10-17 | 0 | 2017-10-17 | ? | 0 | 0005515393 | 20171017.ifs | 2017-10-17 | 2017-10-18 | |||||||
2726952 | 2726952 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-10-30 | 2017-10-31 | 2017-11-14 | 2017-10-17 | 0 | 2017-10-17 | ? | 0 | 0005515393 | 20171017.ifs | 2017-10-17 | 2017-10-18 | |||||||
2625304 | 2625304 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-07-27 | 2017-07-31 | 2017-08-14 | 2017-07-18 | 0 | 2017-07-18 | ? | 0 | 0005469177 | 20170718.ifs | 2017-07-18 | 2017-07-19 | |||||||
2543471 | 2543471 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .12 | 00 | 2017-04-26 | 2017-04-28 | 2017-05-12 | 2017-04-18 | 0 | 2017-04-18 | ? | 0 | 0005421429 | 20170418.ifs | 2017-04-18 | 2017-04-19 | |||||||
2454528 | 2454528 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .12 | 00 | 2017-02-01 | 2017-02-03 | 2017-02-17 | 2017-01-24 | 0 | 2017-01-24 | ? | 0 | 0005377455 | 20170124.ifs | 2017-01-24 | 2017-01-25 | |||||||
2439482 | 2439482 | EQUITY | CHANGE | 43940T109 | COM | 0 | 0 | 2015-08-03 | ? | 0 | no | no | yes | 2016-07-29 | 2016-07-29 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2439483 | 2439482 | EQUITY | CHANGE | 43940T109 | COM | 0 | 0 | 2015-08-03 | ? | 4 | no | no | yes | 2016-07-29 | 2016-07-29 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2323085 | 2323085 | DIVIDEND | CHANGE | 43940T109 | 0 | 0 | 1 | 0 | .11 | 00 | 2016-10-26 | 2016-10-28 | 2016-11-11 | 2016-10-18 | 0 | 2016-10-18 | ? | 0 | 0005298954 | 20161019.ifs | 2016-10-19 | 2016-10-20 | |||||||
2323086 | 2323085 | DIVIDEND | CHANGE | 43940T109 | 0 | 0 | 1 | 0 | .12 | 00 | 2016-10-26 | 2016-10-28 | 2016-11-11 | 2016-10-18 | 1 | 2016-10-18 | 2016-10-19 | 0 | 0005298954 | 20161019.ifs | 2016-10-19 | 2016-10-20 | |||||||
2322482 | 2322482 | DIVIDEND | ADD | 43940T109 | 0 | 0 | 1 | 0 | .11 | 00 | 2016-10-26 | 2016-10-28 | 2016-11-11 | 2016-10-18 | 0 | 2016-10-18 | ? | 0 | 0005298954 | 20161018.ifs | 2016-10-18 | 2016-10-19 | |||||||
2259840 | 2259840 | EQUITY | ADD | 43940T109 | COM | N | 0 | 2015-08-03 | ? | 0 | no | no | no | 2016-07-29 | ? | ? | 20160729.ifs | 2016-07-29 | 2016-07-30 | ||||||||||
2259841 | 2259841 | EQUITY | CHANGE | 43940T109 | COM | N | 0 | 2015-08-03 | ? | 0 | no | no | no | 2016-07-29 | ? | ? | 20160729.ifs | 2016-07-29 | 2016-07-30 | ||||||||||
2259842 | 2259841 | EQUITY | CHANGE | 43940T109 | COM | N | 0 | 2015-08-03 | ? | 0 | no | no | yes | 2016-07-29 | 2016-07-29 | ? | 20160729.ifs | 2016-07-29 | 2016-07-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 = 130591
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