INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | N/A % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:145474 |
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 | ||
5555612 | 5555612 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2024-05-30 | 2024-05-30 | 2024-06-20 | 2024-05-06 | 0 | 2024-05-08 | ? | 0 | 0006917988 | 20240508.ifs | 2024-05-08 | 2024-05-09 | |||||||
5501438 | 5501438 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2024-03-05 | 2024-03-06 | 2024-03-20 | 2024-02-20 | 0 | 2024-02-21 | ? | 0 | 0006878241 | 20240221.ifs | 2024-02-21 | 2024-02-22 | |||||||
5409279 | 5409279 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2023-11-29 | 2023-11-30 | 2023-12-20 | 2023-11-01 | 0 | 2023-11-01 | ? | 0 | 0006805619 | 20231101.ifs | 2023-11-01 | 2023-11-02 | |||||||
5349674 | 5349674 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2023-08-29 | 2023-08-30 | 2023-09-20 | 2023-07-31 | 0 | 2023-08-02 | ? | 0 | 0006766717 | 20230802.ifs | 2023-08-02 | 2023-08-03 | |||||||
5287640 | 5287640 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2023-05-29 | 2023-05-30 | 2023-06-20 | 2023-05-03 | 0 | 2023-05-04 | ? | 0 | 0006723581 | 20230504.ifs | 2023-05-04 | 2023-05-05 | |||||||
5234312 | 5234312 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2023-03-03 | 2023-03-06 | 2023-03-20 | 2023-02-22 | 0 | 2023-02-23 | ? | 0 | 0006684700 | 20230223.ifs | 2023-02-23 | 2023-02-24 | |||||||
5136410 | 5136410 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2022-11-29 | 2022-11-30 | 2022-12-20 | 2022-11-03 | 0 | 2022-11-04 | ? | 0 | 0006611177 | 20221104.ifs | 2022-11-04 | 2022-11-05 | |||||||
5075065 | 5075065 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2022-08-30 | 2022-08-31 | 2022-09-20 | 2022-08-03 | 0 | 2022-08-04 | ? | 0 | 0006568000 | 20220804.ifs | 2022-08-04 | 2022-08-05 | |||||||
5008846 | 5008846 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2022-05-27 | 2022-05-30 | 2022-06-20 | 2022-05-04 | 0 | 2022-05-05 | ? | 0 | 0006521946 | 20220505.ifs | 2022-05-05 | 2022-05-06 | |||||||
4957912 | 4957912 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .03 | 15 | 2022-03-03 | 2022-03-04 | 2022-03-21 | 2022-02-22 | 0 | 2022-02-24 | ? | 0 | 0006483390 | 20220224.ifs | 2022-02-24 | 2022-02-25 | |||||||
4854072 | 4854072 | DIVIDEND | CHANGE | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2021-11-29 | 2021-11-30 | 2021-12-20 | 2021-11-01 | 0 | 2021-11-03 | ? | 0 | 0006394516 | 20211126.ifs | 2021-11-26 | 2021-11-27 | |||||||
4854073 | 4854072 | DIVIDEND | CHANGE | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2021-11-29 | 2021-11-30 | 2021-12-20 | 2021-11-01 | 1 | 2021-11-03 | 2021-11-26 | 0 | 0006394516 | 20211126.ifs | 2021-11-26 | 2021-11-27 | |||||||
4854074 | 4854074 | EQUITY | CHANGE | 03074G109 | COM | 0 | 0 | 2002-03-08 | ? | 2 | no | no | no | 2002-05-31 | 2002-03-11 | ? | 20211126.ifs | 2021-11-26 | 2021-11-27 | ||||||||||
4854075 | 4854074 | EQUITY | CHANGE | 03074G109 | COM | 0 | 0 | 2002-03-08 | ? | 4 | no | no | no | 2002-05-31 | 2002-03-11 | ? | 20211126.ifs | 2021-11-26 | 2021-11-27 | ||||||||||
4843435 | 4843435 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2021-11-29 | 2021-11-30 | 2021-12-20 | 2021-11-01 | 0 | 2021-11-03 | ? | 0 | 0006394516 | 20211103.ifs | 2021-11-03 | 2021-11-04 | |||||||
4843436 | 4843436 | EQUITY | CHANGE | 03074G109 | COM | 0 | 0 | 2002-03-08 | ? | 0 | no | no | no | 2002-05-31 | 2002-03-11 | ? | 20211103.ifs | 2021-11-03 | 2021-11-04 | ||||||||||
4843437 | 4843436 | EQUITY | CHANGE | 03074G109 | COM | 0 | 0 | 2002-03-08 | ? | 2 | no | no | no | 2002-05-31 | 2002-03-11 | ? | 20211103.ifs | 2021-11-03 | 2021-11-04 | ||||||||||
1187206 | 1187206 | DIVIDEND | ADD | 03074G109 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-05-29 | 2013-05-16 | 0 | 2013-05-16 | ? | 0 | 0004571916 | 20130516.ifs | 2013-05-16 | 2013-05-17 | |||||||
1007033 | 1007033 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2012-11-15 | 2012-11-19 | 2012-11-29 | 2012-11-07 | 0 | 2012-11-07 | ? | 0 | 0004456918 | 20121107.ifs | 2012-11-07 | 2012-11-08 | |||||||
856584 | 856584 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2012-05-14 | 2012-05-16 | 2012-05-25 | 2012-05-03 | 0 | 2012-05-07 | ? | 0 | 0004372695 | 20120507.ifs | 2012-05-07 | 2012-05-08 | |||||||
693829 | 693829 | DIVIDEND | DELETE | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | ? | 2011-11-16 | 2011-11-30 | 2011-11-02 | 2 | 2011-11-07 | 2011-11-11 | 0 | 0004268424 | 20111114.ifs | 2011-11-14 | 2011-11-15 | |||||||
693830 | 693830 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 0 | 15 | 2011-11-14 | 2011-11-16 | 2011-11-30 | 2011-11-02 | 0 | ? | 2011-11-14 | 0 | 0004268424 | 20111114.ifs | 2011-11-14 | 2011-11-15 | ||||||
694454 | 694454 | DIVIDEND | CHANGE | 03074G109 | A | 0 | 2 | 0 | .02 | 0 | 15 | 2011-11-14 | 2011-11-16 | 2011-11-30 | 2011-11-02 | 0 | ? | 2011-11-14 | 0 | 0004268424 | 20111114.ifs | 2011-11-14 | 2011-11-15 | ||||||
694455 | 694454 | DIVIDEND | CHANGE | 03074G109 | A | 0 | 2 | 0 | .02 | 0 | 15 | 2011-11-14 | 2011-11-16 | 2011-11-30 | 2011-11-02 | 0 | ? | 2011-11-14 | 0 | 0004268424 | 20111114.ifs | 2011-11-14 | 2011-11-15 | ||||||
693794 | 693794 | DIVIDEND | DELETE | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | ? | 2011-11-15 | 2011-11-30 | 2011-11-02 | 1 | 2011-11-07 | 2011-11-09 | 0 | 0004268424 | 20111111.ifs | 2011-11-11 | 2011-11-12 | |||||||
693795 | 693795 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | ? | 2011-11-16 | 2011-11-30 | 2011-11-02 | 2 | 2011-11-07 | 2011-11-11 | 0 | 0004268424 | 20111111.ifs | 2011-11-11 | 2011-11-12 | |||||||
692661 | 692661 | DIVIDEND | DELETE | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2011-11-10 | 2011-11-15 | 2011-11-30 | 2011-11-02 | 0 | 2011-11-07 | ? | 0 | 0004268424 | 20111109.ifs | 2011-11-09 | 2011-11-10 | |||||||
692662 | 692662 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | ? | 2011-11-15 | 2011-11-30 | 2011-11-02 | 1 | 2011-11-07 | 2011-11-09 | 0 | 0004268424 | 20111109.ifs | 2011-11-09 | 2011-11-10 | |||||||
691219 | 691219 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2011-11-10 | 2011-11-15 | 2011-11-30 | 2011-11-02 | 0 | 2011-11-07 | ? | 0 | 0004268424 | 20111107.ifs | 2011-11-07 | 2011-11-08 | |||||||
482423 | 482423 | DIVIDEND | ADD | 03074G109 | A | 0 | 2 | 0 | .02 | 15 | 2011-04-19 | 2011-04-22 | 2011-05-05 | 2011-03-28 | 0 | 2011-03-28 | ? | 0 | 0004164367 | 20110328.ifs | 2011-03-28 | 2011-03-29 |
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 = 145474
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