INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 507 | 432 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 57.54 % | 57.83 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:130815 |
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 | ||
5555956 | 5555956 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .44 | 00 | 2024-05-17 | 2024-05-20 | 2024-06-03 | 2024-05-08 | 0 | 2024-05-09 | ? | 0 | 0006918471 | 20240509.ifs | 2024-05-09 | 2024-05-10 | |||||||
5499227 | 5499227 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .42 | 00 | 2024-02-23 | 2024-02-26 | 2024-03-07 | 2024-02-15 | 0 | 2024-02-15 | ? | 0 | 0006877118 | 20240215.ifs | 2024-02-15 | 2024-02-16 | |||||||
5400660 | 5400660 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .41 | 00 | 2023-11-03 | 2023-11-06 | 2023-12-01 | 2023-10-26 | 0 | 2023-10-26 | ? | 0 | 0006801891 | 20231026.ifs | 2023-10-26 | 2023-10-27 | |||||||
5355039 | 5355039 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .39 | 00 | 2023-08-25 | 2023-08-28 | 2023-09-07 | 2023-08-17 | 0 | 2023-08-17 | ? | 0 | 0006770014 | 20230817.ifs | 2023-08-17 | 2023-08-18 | |||||||
5287280 | 5287280 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .38 | 00 | 2023-05-12 | 2023-05-15 | 2023-06-01 | 2023-05-04 | 0 | 2023-05-04 | ? | 0 | 0006723768 | 20230504.ifs | 2023-05-04 | 2023-05-05 | |||||||
5228300 | 5228300 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .37 | 00 | 2023-02-17 | 2023-02-21 | 2023-03-01 | 2023-02-09 | 0 | 2023-02-09 | ? | 0 | 0006681448 | 20230209.ifs | 2023-02-09 | 2023-02-10 | |||||||
5123159 | 5123159 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .35 | 00 | 2022-11-07 | 2022-11-08 | 2022-12-01 | 2022-10-20 | 0 | 2022-10-20 | ? | 0 | 0006601027 | 20221020.ifs | 2022-10-20 | 2022-10-21 | |||||||
5079394 | 5079394 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .32 | 00 | 2022-08-29 | 2022-08-30 | 2022-09-08 | 2022-08-18 | 0 | 2022-08-18 | ? | 0 | 0006570770 | 20220818.ifs | 2022-08-18 | 2022-08-19 | |||||||
5008618 | 5008618 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .31 | 00 | 2022-05-16 | 2022-05-17 | 2022-06-01 | 2022-05-05 | 0 | 2022-05-05 | ? | 0 | 0006522201 | 20220505.ifs | 2022-05-05 | 2022-05-06 | |||||||
4951715 | 4951715 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .29 | 00 | 2022-02-17 | 2022-02-21 | 2022-03-03 | 2022-02-10 | 0 | 2022-02-10 | ? | 0 | 0006480375 | 20220210.ifs | 2022-02-10 | 2022-02-11 | |||||||
4833006 | 4833006 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .29 | 00 | 2021-11-05 | 2021-11-08 | 2021-12-01 | 2021-10-27 | 0 | 2021-10-27 | ? | 0 | 0006386933 | 20211027.ifs | 2021-10-27 | 2021-10-28 | |||||||
4783835 | 4783835 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-08-27 | 2021-08-30 | 2021-09-09 | 2021-08-19 | 0 | 2021-08-19 | ? | 0 | 0006354777 | 20210819.ifs | 2021-08-19 | 2021-08-20 | |||||||
4700422 | 4700422 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-05-14 | 2021-05-17 | 2021-06-01 | 2021-05-05 | 0 | 2021-05-05 | ? | 0 | 0006306008 | 20210505.ifs | 2021-05-05 | 2021-05-06 | |||||||
4628343 | 4628343 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 0 | .25 | 00 | 2021-02-19 | 2021-02-22 | 2021-03-04 | 2021-02-11 | 0 | 2021-02-11 | ? | 0 | 0006263621 | 20210211.ifs | 2021-02-11 | 2021-02-12 | |||||||
4506452 | 4506452 | EQUITY | CHANGE | 626755102 | COM | 0 | 0 | 2013-08-28 | ? | 0 | no | no | no | ? | 2013-10-24 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4506453 | 4506452 | EQUITY | CHANGE | 626755102 | COM | 0 | 0 | 2013-08-28 | ? | 4 | no | no | no | ? | 2020-11-13 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
4492611 | 4492611 | DIVIDEND | ADD | 626755102 | 0 | 0 | 1 | 4 | .25 | 00 | 2020-11-12 | 2020-11-13 | 2020-12-01 | 2020-10-22 | 0 | 2020-10-28 | ? | 0 | 0006178781 | 20201028.ifs | 2020-10-28 | 2020-10-29 | |||||||
1322019 | 1322019 | EXCHANGE | DELETE | 626755102 | 01 | 2013-09-02 | 2013-10-23 | MUSA | 0 | 0 | 2013-09-03 | 2013-09-03 | 20131024.ifs | 2013-10-24 | 2013-10-25 | ||||||||||||||
1322020 | 1322020 | EXCHANGE | ADD | 626755102 | 01 | 2013-09-03 | 2013-10-23 | MUSA | 0 | 0 | ? | 2013-10-24 | 20131024.ifs | 2013-10-24 | 2013-10-25 | ||||||||||||||
1322021 | 1322021 | EQUITY | CHANGE | 626755102 | COM | N | 0 | 2013-08-28 | ? | 0 | no | no | no | ? | 2013-08-28 | ? | 20131024.ifs | 2013-10-24 | 2013-10-25 | ||||||||||
1322022 | 1322021 | EQUITY | CHANGE | 626755102 | COM | 0 | 0 | 2013-08-28 | ? | 0 | no | no | no | ? | 2013-10-24 | ? | 20131024.ifs | 2013-10-24 | 2013-10-25 | ||||||||||
1276997 | 1276997 | EXCHANGE | ADD | 626755102 | 01 | 2013-09-02 | 2013-09-03 | MUSA_I | 0 | 0 | 2013-09-03 | ? | 20130903.ifs | 2013-09-03 | 2013-09-04 | ||||||||||||||
1276998 | 1276998 | CORPACTION | ADD | 626755102 | 01 | # | 2013-09-03 | 626755102 | 01 | ? | 20130903.ifs | 2013-09-03 | 2013-09-04 | ||||||||||||||||
1276999 | 1276999 | CORPACTIONAUX | ADD | 626755102 | 01 | 2013-09-03 | MUSA_I | MURPHY USA INC | COM | MUSA | MURPHY USA INC | COM | 2013-09-03 | ? | 20130903.ifs | 2013-09-03 | 2013-09-04 | ||||||||||||
1277000 | 1277000 | EXCHANGE | CHANGE | 626755102 | 01 | 2013-09-02 | 2013-09-03 | MUSA_I | 0 | 0 | 2013-09-03 | ? | 20130903.ifs | 2013-09-03 | 2013-09-04 | ||||||||||||||
1277001 | 1277000 | EXCHANGE | CHANGE | 626755102 | 01 | 2013-09-02 | 2013-09-03 | MUSA | 0 | 0 | 2013-09-03 | 2013-09-03 | 20130903.ifs | 2013-09-03 | 2013-09-04 | ||||||||||||||
1277106 | 1277106 | CORPACTION | DELETE | 626755102 | 01 | # | 2013-09-03 | 626755102 | 01 | ? | 20130903.ifs | 2013-09-03 | 2013-09-04 | ||||||||||||||||
1277108 | 1277107 | CORPACTION | DELETE | 626755102 | 01 | 2013-09-03 | MUSA_I | MURPHY USA INC | COM | MUSA | MURPHY USA INC | COM | 2013-09-03 | ? | 20130903.ifs | 2013-09-03 | 2013-09-04 | ||||||||||||
1271373 | 1271373 | EQUITY | ADD | 626755102 | NEW ISSUE | 0 | 0 | 2013-08-28 | ? | 0 | no | no | no | ? | ? | ? | 20130828.ifs | 2013-08-28 | 2013-08-29 | ||||||||||
1271374 | 1271374 | EQUITY | CHANGE | 626755102 | NEW ISSUE | 0 | 0 | 2013-08-28 | ? | 0 | no | no | no | ? | ? | ? | 20130828.ifs | 2013-08-28 | 2013-08-29 | ||||||||||
1271375 | 1271374 | EQUITY | CHANGE | 626755102 | COM | N | 0 | 2013-08-28 | ? | 0 | no | no | no | ? | 2013-08-28 | ? | 20130828.ifs | 2013-08-28 | 2013-08-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 = 130815
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