INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 28 | 23 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 9.38 % | 19.29 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:151740 |
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 | ||
5569974 | 5569974 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-08-15 | 2024-08-15 | 2024-08-30 | 2024-06-03 | 0 | 2024-06-03 | ? | 2 | 0006925943 | 20240603.ifs | 2024-06-03 | 2024-06-04 | |||||||
5569975 | 5569975 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-07-16 | 2024-07-16 | 2024-07-31 | 2024-06-03 | 0 | 2024-06-03 | ? | 1 | 0006925942 | 20240603.ifs | 2024-06-03 | 2024-06-04 | |||||||
5569976 | 5569976 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-06-17 | 2024-06-17 | 2024-06-28 | 2024-06-03 | 0 | 2024-06-03 | ? | 0 | 0006925941 | 20240603.ifs | 2024-06-03 | 2024-06-04 | |||||||
5492752 | 5492752 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-05-14 | 2024-05-15 | 2024-05-31 | 2024-02-01 | 0 | 2024-02-01 | ? | 3 | 0006872574 | 20240201.ifs | 2024-02-01 | 2024-02-02 | |||||||
5492753 | 5492753 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-04-12 | 2024-04-15 | 2024-04-30 | 2024-02-01 | 0 | 2024-02-01 | ? | 2 | 0006872573 | 20240201.ifs | 2024-02-01 | 2024-02-02 | |||||||
5492754 | 5492754 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-03-14 | 2024-03-15 | 2024-03-28 | 2024-02-01 | 0 | 2024-02-01 | ? | 1 | 0006872572 | 20240201.ifs | 2024-02-01 | 2024-02-02 | |||||||
5492755 | 5492755 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-02-14 | 2024-02-15 | 2024-02-29 | 2024-02-01 | 0 | 2024-02-01 | ? | 0 | 0006872570 | 20240201.ifs | 2024-02-01 | 2024-02-02 | |||||||
5430065 | 5430065 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2024-01-16 | 2024-01-17 | 2024-01-31 | 2023-12-04 | 0 | 2023-12-05 | ? | 0 | 0006822509 | 20231205.ifs | 2023-12-05 | 2023-12-06 | |||||||
5413260 | 5413260 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-12-04 | 2023-12-05 | 2023-12-29 | 2023-11-10 | 0 | 2023-11-10 | ? | 0 | 0006811262 | 20231110.ifs | 2023-11-10 | 2023-11-11 | |||||||
5367034 | 5367034 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-11-02 | 2023-11-03 | 2023-11-30 | 2023-09-01 | 0 | 2023-09-01 | ? | 2 | 0006776040 | 20230901.ifs | 2023-09-01 | 2023-09-02 | |||||||
5367035 | 5367035 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-10-13 | 2023-10-16 | 2023-10-31 | 2023-09-01 | 0 | 2023-09-01 | ? | 1 | 0006776036 | 20230901.ifs | 2023-09-01 | 2023-09-02 | |||||||
5367036 | 5367036 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-09-15 | 2023-09-18 | 2023-09-29 | 2023-09-01 | 0 | 2023-09-01 | ? | 0 | 0006776032 | 20230901.ifs | 2023-09-01 | 2023-09-02 | |||||||
5304681 | 5304681 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-08-14 | 2023-08-15 | 2023-08-31 | 2023-06-01 | 0 | 2023-06-01 | ? | 2 | 0006732235 | 20230601.ifs | 2023-06-01 | 2023-06-02 | |||||||
5304682 | 5304682 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-07-17 | 2023-07-18 | 2023-07-31 | 2023-06-01 | 0 | 2023-06-01 | ? | 1 | 0006732233 | 20230601.ifs | 2023-06-01 | 2023-06-02 | |||||||
5304683 | 5304683 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-06-14 | 2023-06-15 | 2023-06-30 | 2023-06-01 | 0 | 2023-06-01 | ? | 0 | 0006732232 | 20230601.ifs | 2023-06-01 | 2023-06-02 | |||||||
5262947 | 5262947 | CORPACTION | ADD | 231631300 | 01 | # | 2023-04-03 | 231631300 | 01 | 2023-04-03 | 20230403.ifs | 2023-04-03 | 2023-04-04 | ||||||||||||||||
5262948 | 5262948 | CORPACTIONAUX | ADD | 231631300 | 01 | 2023-04-03 | SRV | CUSHING MLP TOTAL RETURN FD | COM PAR | SRV | NXG CUSHING MIDSTREAM ENERGY F | COM PAR | ? | 2023-04-03 | 20230403.ifs | 2023-04-03 | 2023-04-04 | ||||||||||||
5262949 | 5262949 | EXCHANGE | CHANGE | 231631300 | 01 | 2020-06-15 | 2023-03-31 | SRV | 0 | 0 | ? | 2020-06-15 | 20230403.ifs | 2023-04-03 | 2023-04-04 | ||||||||||||||
5262950 | 5262949 | EXCHANGE | CHANGE | 231631300 | 01 | 2020-06-15 | 2023-03-31 | SRV | 0 | 0 | ? | 2023-04-03 | 20230403.ifs | 2023-04-03 | 2023-04-04 | ||||||||||||||
5224593 | 5224593 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-05-12 | 2023-05-15 | 2023-05-31 | 2023-02-01 | 0 | 2023-02-01 | ? | 3 | 0006676332 | 20230201.ifs | 2023-02-01 | 2023-02-02 | |||||||
5224594 | 5224594 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-04-17 | 2023-04-18 | 2023-04-28 | 2023-02-01 | 0 | 2023-02-01 | ? | 2 | 0006676331 | 20230201.ifs | 2023-02-01 | 2023-02-02 | |||||||
5224595 | 5224595 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-03-14 | 2023-03-15 | 2023-03-31 | 2023-02-01 | 0 | 2023-02-01 | ? | 1 | 0006676330 | 20230201.ifs | 2023-02-01 | 2023-02-02 | |||||||
5224596 | 5224596 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-02-14 | 2023-02-15 | 2023-02-28 | 2023-02-01 | 0 | 2023-02-01 | ? | 0 | 0006676329 | 20230201.ifs | 2023-02-01 | 2023-02-02 | |||||||
5152237 | 5152237 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2023-01-17 | 2023-01-18 | 2023-01-31 | 2022-12-01 | 0 | 2022-12-01 | ? | 1 | 0006618971 | 20221201.ifs | 2022-12-01 | 2022-12-02 | |||||||
5152238 | 5152238 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2022-12-12 | 2022-12-13 | 2022-12-30 | 2022-12-01 | 0 | 2022-12-01 | ? | 0 | 0006618968 | 20221201.ifs | 2022-12-01 | 2022-12-02 | |||||||
5091093 | 5091093 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2022-11-14 | 2022-11-15 | 2022-11-30 | 2022-09-01 | 0 | 2022-09-01 | ? | 2 | 0006576473 | 20220901.ifs | 2022-09-01 | 2022-09-02 | |||||||
5091094 | 5091094 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2022-10-14 | 2022-10-17 | 2022-10-31 | 2022-09-01 | 0 | 2022-09-01 | ? | 1 | 0006576472 | 20220901.ifs | 2022-09-01 | 2022-09-02 | |||||||
5091095 | 5091095 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .45 | 00 | 2022-09-16 | 2022-09-19 | 2022-09-30 | 2022-09-01 | 0 | 2022-09-01 | ? | 0 | 0006576471 | 20220901.ifs | 2022-09-01 | 2022-09-02 | |||||||
5024756 | 5024756 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-08-15 | 2022-08-16 | 2022-08-31 | 2022-06-01 | 0 | 2022-06-01 | ? | 2 | 0006530082 | 20220601.ifs | 2022-06-01 | 2022-06-02 | |||||||
5024757 | 5024757 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-07-15 | 2022-07-18 | 2022-07-29 | 2022-06-01 | 0 | 2022-06-01 | ? | 1 | 0006530081 | 20220601.ifs | 2022-06-01 | 2022-06-02 | |||||||
5024758 | 5024758 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-06-13 | 2022-06-14 | 2022-06-30 | 2022-06-01 | 0 | 2022-06-01 | ? | 0 | 0006530080 | 20220601.ifs | 2022-06-01 | 2022-06-02 | |||||||
4946187 | 4946187 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-05-13 | 2022-05-16 | 2022-05-31 | 2022-02-01 | 0 | 2022-02-01 | ? | 3 | 0006474054 | 20220201.ifs | 2022-02-01 | 2022-02-02 | |||||||
4946188 | 4946188 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-04-14 | 2022-04-18 | 2022-04-29 | 2022-02-01 | 0 | 2022-02-01 | ? | 2 | 0006474051 | 20220201.ifs | 2022-02-01 | 2022-02-02 | |||||||
4946189 | 4946189 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-03-14 | 2022-03-15 | 2022-03-31 | 2022-02-01 | 0 | 2022-02-01 | ? | 1 | 0006474048 | 20220201.ifs | 2022-02-01 | 2022-02-02 | |||||||
4946190 | 4946190 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-02-14 | 2022-02-15 | 2022-02-28 | 2022-02-01 | 0 | 2022-02-01 | ? | 0 | 0006474044 | 20220201.ifs | 2022-02-01 | 2022-02-02 | |||||||
4861918 | 4861918 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-12-10 | 2021-12-13 | 2021-12-31 | 2021-12-01 | 0 | 2021-12-01 | ? | 0 | 0006403602 | 20211201.ifs | 2021-12-01 | 2021-12-02 | |||||||
4861919 | 4861919 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2022-01-14 | 2022-01-18 | 2022-01-31 | 2021-12-01 | 0 | 2021-12-01 | ? | 2 | 0006403601 | 20211201.ifs | 2021-12-01 | 2021-12-02 | |||||||
4794890 | 4794890 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-11-12 | 2021-11-15 | 2021-11-30 | 2021-09-01 | 0 | 2021-09-01 | ? | 2 | 0006360395 | 20210901.ifs | 2021-09-01 | 2021-09-02 | |||||||
4794891 | 4794891 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-10-15 | 2021-10-18 | 2021-10-29 | 2021-09-01 | 0 | 2021-09-01 | ? | 1 | 0006360392 | 20210901.ifs | 2021-09-01 | 2021-09-02 | |||||||
4794892 | 4794892 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-09-14 | 2021-09-15 | 2021-09-30 | 2021-09-01 | 0 | 2021-09-01 | ? | 0 | 0006360390 | 20210901.ifs | 2021-09-01 | 2021-09-02 | |||||||
4719507 | 4719507 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-08-13 | 2021-08-16 | 2021-08-31 | 2021-06-01 | 0 | 2021-06-01 | ? | 2 | 0006314173 | 20210601.ifs | 2021-06-01 | 2021-06-02 | |||||||
4719508 | 4719508 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-07-13 | 2021-07-14 | 2021-07-30 | 2021-06-01 | 0 | 2021-06-01 | ? | 1 | 0006314172 | 20210601.ifs | 2021-06-01 | 2021-06-02 | |||||||
4719509 | 4719509 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-06-11 | 2021-06-14 | 2021-06-30 | 2021-06-01 | 0 | 2021-06-01 | ? | 0 | 0006314171 | 20210601.ifs | 2021-06-01 | 2021-06-02 | |||||||
4697905 | 4697905 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-05-14 | 2021-05-17 | 2021-05-28 | 2021-05-03 | 0 | 2021-05-03 | ? | 0 | 0006301426 | 20210503.ifs | 2021-05-03 | 2021-05-04 | |||||||
4621269 | 4621269 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-04-13 | 2021-04-14 | 2021-04-30 | 2021-02-01 | 0 | 2021-02-01 | ? | 2 | 0006257818 | 20210201.ifs | 2021-02-01 | 2021-02-02 | |||||||
4621270 | 4621270 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-03-12 | 2021-03-15 | 2021-03-31 | 2021-02-01 | 0 | 2021-02-01 | ? | 1 | 0006257816 | 20210201.ifs | 2021-02-01 | 2021-02-02 | |||||||
4621271 | 4621271 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-02-12 | 2021-02-16 | 2021-02-26 | 2021-02-01 | 0 | 2021-02-01 | ? | 0 | 0006257815 | 20210201.ifs | 2021-02-01 | 2021-02-02 | |||||||
4522887 | 4522887 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2021-01-15 | 2021-01-19 | 2021-01-29 | 2020-12-01 | 0 | 2020-12-01 | ? | 1 | 0006195170 | 20201201.ifs | 2020-12-01 | 2020-12-02 | |||||||
4522888 | 4522888 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-12-11 | 2020-12-14 | 2020-12-31 | 2020-12-01 | 0 | 2020-12-01 | ? | 0 | 0006195169 | 20201201.ifs | 2020-12-01 | 2020-12-02 | |||||||
4453879 | 4453879 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-11-13 | 2020-11-16 | 2020-11-30 | 2020-09-01 | 0 | 2020-09-01 | ? | 2 | 0006151248 | 20200901.ifs | 2020-09-01 | 2020-09-02 | |||||||
4453880 | 4453880 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-10-16 | 2020-10-19 | 2020-10-30 | 2020-09-01 | 0 | 2020-09-01 | ? | 1 | 0006151247 | 20200901.ifs | 2020-09-01 | 2020-09-02 | |||||||
4453881 | 4453881 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-09-14 | 2020-09-15 | 2020-09-30 | 2020-09-01 | 0 | 2020-09-01 | ? | 0 | 0006151246 | 20200901.ifs | 2020-09-01 | 2020-09-02 | |||||||
4412054 | 4412054 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-08-14 | 2020-08-17 | 2020-08-31 | 2020-07-01 | 0 | 2020-07-01 | ? | 1 | 0006124576 | 20200701.ifs | 2020-07-01 | 2020-07-02 | |||||||
4412055 | 4412055 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .12 | 00 | 2020-07-13 | 2020-07-14 | 2020-07-31 | 2020-07-01 | 0 | 2020-07-01 | ? | 0 | 0006124575 | 20200701.ifs | 2020-07-01 | 2020-07-02 | |||||||
4392482 | 4392482 | DIVIDEND | ADD | 231631300 | 0 | 0 | 1 | 0 | .7676 | 00 | 2020-06-12 | 2020-06-15 | 2020-06-30 | 2020-06-01 | 0 | ? | 2020-06-16 | 0 | 0006111951 | 20200616.ifs | 2020-06-16 | 2020-06-17 | |||||||
4391517 | 4391517 | EQUITY | ADD | 231631300 | NEW ISSUE | 0 | 0 | 2020-06-15 | ? | 0 | no | no | no | ? | ? | ? | 20200615.ifs | 2020-06-15 | 2020-06-16 | ||||||||||
4391518 | 4391518 | EQUITY | CHANGE | 231631300 | NEW ISSUE | 0 | 0 | 2020-06-15 | ? | 0 | no | no | no | ? | ? | ? | 20200615.ifs | 2020-06-15 | 2020-06-16 | ||||||||||
4391519 | 4391518 | EQUITY | CHANGE | 231631300 | COM PAR | N | 0 | 2020-06-15 | ? | 0 | no | no | no | ? | 2020-06-15 | ? | 20200615.ifs | 2020-06-15 | 2020-06-16 | ||||||||||
4391520 | 4391520 | EXCHANGE | ADD | 231631300 | 01 | 2020-06-15 | 2020-06-15 | SRV | 0 | 0 | ? | 2020-06-15 | 20200615.ifs | 2020-06-15 | 2020-06-16 | ||||||||||||||
4391529 | 4391529 | SPLIT | ADD | 231631300 | 4 | 2020-06-15 | 54 | 2020-06-03 | 2020-06-15 | 20200615.ifs | 2020-06-15 | 2020-06-16 | |||||||||||||||||
4391531 | 4391531 | DIVIDEND | ADD | 231631300 | 0 | 0 | 6 | 0 | .25 | 54 | 2020-06-15 | 2020-06-15 | 2020-06-15 | 2020-06-15 | 0 | ? | 2020-06-15 | 0 | 0006109304 | 20200615.ifs | 2020-06-15 | 2020-06-16 | |||||||
4392408 | 4392408 | EQUITY | CHANGE | 231631300 | COM PAR | N | 0 | 2020-06-15 | ? | 0 | no | no | no | ? | 2020-06-15 | ? | 20200615.ifs | 2020-06-15 | 2020-06-16 | ||||||||||
4392409 | 4392408 | EQUITY | CHANGE | 231631300 | COM PAR | 0 | 0 | 2020-06-15 | ? | 0 | no | no | no | ? | 2020-06-15 | ? | 20200615.ifs | 2020-06-15 | 2020-06-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 = 151740
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