INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 473 | 414 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 87.96 % | 82.82 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:167040 |
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 | ||
5538122 | 5538122 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2024-04-25 | 2024-04-26 | 2024-05-10 | 2024-04-11 | 0 | 2024-04-11 | ? | 0 | 0006906009 | 20240411.ifs | 2024-04-11 | 2024-04-12 | |||||||
5479239 | 5479239 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2024-01-25 | 2024-01-26 | 2024-02-09 | 2024-01-09 | 0 | 2024-01-09 | ? | 0 | 0006864024 | 20240109.ifs | 2024-01-09 | 2024-01-10 | |||||||
5396531 | 5396531 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2023-10-30 | 2023-10-31 | 2023-11-14 | 2023-10-17 | 0 | 2023-10-17 | ? | 0 | 0006799156 | 20231017.ifs | 2023-10-17 | 2023-10-18 | |||||||
5335172 | 5335172 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2023-07-25 | 2023-07-26 | 2023-08-10 | 2023-07-13 | 0 | 2023-07-13 | ? | 0 | 0006755897 | 20230713.ifs | 2023-07-13 | 2023-07-14 | |||||||
5270315 | 5270315 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2023-04-25 | 2023-04-26 | 2023-05-10 | 2023-04-11 | 0 | 2023-04-11 | ? | 0 | 0006711874 | 20230411.ifs | 2023-04-11 | 2023-04-12 | |||||||
5213974 | 5213974 | DIVIDEND | DELETE | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 0 | 03 | 2022-10-21 | 2022-10-24 | ? | 2022-10-14 | 0 | ? | 2022-11-10 | 0 | 0006599909 | 20230119.ifs | 2023-01-19 | 2023-01-20 | ||||||
5213975 | 5213975 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 0 | 03 | 2022-10-21 | 2022-10-24 | 2023-01-20 | 2022-10-14 | 0 | ? | 2023-01-19 | 0 | 0006599909 | 20230119.ifs | 2023-01-19 | 2023-01-20 | ||||||
5210683 | 5210683 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2023-01-25 | 2023-01-26 | 2023-02-10 | 2023-01-10 | 0 | 2023-01-10 | ? | 0 | 0006669305 | 20230110.ifs | 2023-01-10 | 2023-01-11 | |||||||
5138378 | 5138378 | DIVIDEND | DELETE | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 03 | 2022-10-21 | 2022-10-24 | 2022-11-07 | 2022-10-14 | 1 | 2022-10-14 | 2022-11-04 | 0 | 0006599909 | 20221110.ifs | 2022-11-10 | 2022-11-11 | |||||||
5138379 | 5138379 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 0 | 03 | 2022-10-21 | 2022-10-24 | ? | 2022-10-14 | 0 | ? | 2022-11-10 | 0 | 0006599909 | 20221110.ifs | 2022-11-10 | 2022-11-11 | ||||||
5138754 | 5138754 | DIVIDEND | CHANGE | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 0 | 03 | 2022-10-21 | 2022-10-24 | ? | 2022-10-14 | 0 | ? | 2022-11-10 | 0 | 0006599909 | 20221110.ifs | 2022-11-10 | 2022-11-11 | ||||||
5138755 | 5138754 | DIVIDEND | CHANGE | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 0 | 03 | 2022-10-21 | 2022-10-24 | ? | 2022-10-14 | 0 | ? | 2022-11-10 | 0 | 0006599909 | 20221110.ifs | 2022-11-10 | 2022-11-11 | ||||||
5136412 | 5136412 | DIVIDEND | CHANGE | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 03 | 2022-10-21 | 2022-10-24 | 2022-11-07 | 2022-10-14 | 0 | 2022-10-14 | ? | 0 | 0006599909 | 20221104.ifs | 2022-11-04 | 2022-11-05 | |||||||
5136413 | 5136412 | DIVIDEND | CHANGE | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 03 | 2022-10-21 | 2022-10-24 | 2022-11-07 | 2022-10-14 | 1 | 2022-10-14 | 2022-11-04 | 0 | 0006599909 | 20221104.ifs | 2022-11-04 | 2022-11-05 | |||||||
5122274 | 5122274 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2022-10-28 | 2022-10-31 | 2022-11-14 | 2022-10-18 | 0 | 2022-10-18 | ? | 0 | 0006600242 | 20221018.ifs | 2022-10-18 | 2022-10-19 | |||||||
5121082 | 5121082 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 9 | 6.85 | 03 | 2022-10-21 | 2022-10-24 | 2022-11-07 | 2022-10-14 | 0 | 2022-10-14 | ? | 0 | 0006599909 | 20221014.ifs | 2022-10-14 | 2022-10-15 | |||||||
5059124 | 5059124 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2022-07-25 | 2022-07-26 | 2022-08-10 | 2022-07-14 | 0 | 2022-07-14 | ? | 0 | 0006555951 | 20220714.ifs | 2022-07-14 | 2022-07-15 | |||||||
4993010 | 4993010 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2022-04-25 | 2022-04-26 | 2022-05-10 | 2022-04-12 | 0 | 2022-04-12 | ? | 0 | 0006510620 | 20220412.ifs | 2022-04-12 | 2022-04-13 | |||||||
4933203 | 4933203 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2022-01-25 | 2022-01-26 | 2022-02-10 | 2022-01-11 | 0 | 2022-01-11 | ? | 0 | 0006467482 | 20220111.ifs | 2022-01-11 | 2022-01-12 | |||||||
4828123 | 4828123 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-10-28 | 2021-10-29 | 2021-11-12 | 2021-10-18 | 0 | 2021-10-18 | ? | 0 | 0006384248 | 20211018.ifs | 2021-10-18 | 2021-10-19 | |||||||
4756993 | 4756993 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .1 | 00 | 2021-07-23 | 2021-07-26 | 2021-08-10 | 2021-07-13 | 0 | 2021-07-13 | ? | 0 | 0006339255 | 20210713.ifs | 2021-07-13 | 2021-07-14 | |||||||
4680857 | 4680857 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .1 | 00 | 2021-04-23 | 2021-04-26 | 2021-05-10 | 2021-04-13 | 0 | 2021-04-13 | ? | 0 | 0006294150 | 20210413.ifs | 2021-04-13 | 2021-04-14 | |||||||
4605206 | 4605206 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 0 | .1 | 00 | 2021-01-25 | 2021-01-26 | 2021-02-10 | 2021-01-12 | 0 | 2021-01-12 | ? | 0 | 0006251409 | 20210112.ifs | 2021-01-12 | 2021-01-13 | |||||||
4505996 | 4505996 | EQUITY | CHANGE | 013091103 | CL A | 0 | 0 | 2015-10-15 | ? | 0 | no | no | no | 2015-10-15 | 2020-06-25 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4505997 | 4505996 | EQUITY | CHANGE | 013091103 | CL A | 0 | 0 | 2015-10-15 | ? | 4 | no | no | no | 2015-10-15 | 2020-11-13 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4485898 | 4485898 | DIVIDEND | ADD | 013091103 | 0 | 0 | 1 | 4 | .1 | 00 | 2020-10-23 | 2020-10-26 | 2020-11-10 | 2020-10-14 | 0 | 2020-10-14 | ? | 0 | 0006175146 | 20201014.ifs | 2020-10-14 | 2020-10-15 | |||||||
4401321 | 4401321 | EXCHANGE | ADD | 013091103 | 01 | 2020-06-26 | 2020-06-26 | ACI | 0 | 0 | 2020-06-26 | ? | 20200626.ifs | 2020-06-26 | 2020-06-27 | ||||||||||||||
4402467 | 4402467 | EQUITY | CHANGE | 013091103 | CL A | N | 0 | 2015-10-15 | ? | 0 | no | no | no | 2015-10-15 | 2020-06-25 | ? | 20200626.ifs | 2020-06-26 | 2020-06-27 | ||||||||||
4402468 | 4402467 | EQUITY | CHANGE | 013091103 | CL A | 0 | 0 | 2015-10-15 | ? | 0 | no | no | no | 2015-10-15 | 2020-06-25 | ? | 20200626.ifs | 2020-06-26 | 2020-06-27 | ||||||||||
4399853 | 4399853 | EQUITY | CHANGE | 013091103 | COM | N | 0 | 2015-10-15 | ? | 0 | no | no | no | 2015-10-15 | ? | ? | 20200625.ifs | 2020-06-25 | 2020-06-26 | ||||||||||
4399854 | 4399853 | EQUITY | CHANGE | 013091103 | CL A | N | 0 | 2015-10-15 | ? | 0 | no | no | no | 2015-10-15 | 2020-06-25 | ? | 20200625.ifs | 2020-06-25 | 2020-06-26 | ||||||||||
1990945 | 1990945 | EQUITY | ADD | 013091103 | COM | N | 0 | 2015-10-15 | ? | 0 | no | no | no | 2015-10-15 | ? | ? | 20151015.ifs | 2015-10-15 | 2015-10-16 | ||||||||||
1990946 | 1990946 | EXCHANGE | ADD | 013091103 | 01 | 2015-10-15 | ? | ABS | 0 | 0 | 2015-10-15 | ? | 20151015.ifs | 2015-10-15 | 2015-10-16 | ||||||||||||||
1991054 | 1991054 | EXCHANGE | DELETE | 013091103 | 01 | 2015-10-15 | ? | ABS | 0 | 0 | 2015-10-15 | ? | 20151015.ifs | 2015-10-15 | 2015-10-16 |
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 = 167040
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