| INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
| Total Insititutions : | 2557 | 2416 | Update Insititution By Cusips | ||||||||
| % Owned by Insititutions: | 76.45 % | 76.45 % | |||||||||
|
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|
|||||||||||
the compid is:130665 |
|||||||||||
| 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 | ||
| 5567531 | 5567531 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .63 | 00 | 2024-08-16 | 2024-08-16 | 2024-09-05 | 2024-06-03 | 0 | 2024-06-03 | ? | 0 | 0006927886 | 20240603.ifs | 2024-06-03 | 2024-06-04 | |||||||
| 5552482 | 5552482 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .63 | 00 | 2024-05-16 | 2024-05-17 | 2024-06-13 | 2024-05-02 | 0 | 2024-05-02 | ? | 0 | 0006916959 | 20240502.ifs | 2024-05-02 | 2024-05-03 | |||||||
| 5493871 | 5493871 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .59 | 00 | 2024-02-22 | 2024-02-23 | 2024-03-21 | 2024-02-02 | 0 | 2024-02-02 | ? | 0 | 0006874624 | 20240202.ifs | 2024-02-02 | 2024-02-03 | |||||||
| 5394768 | 5394768 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .59 | 00 | 2023-11-16 | 2023-11-17 | 2023-12-14 | 2023-10-11 | 0 | 2023-10-11 | ? | 0 | 0006798534 | 20231011.ifs | 2023-10-11 | 2023-10-12 | |||||||
| 5371022 | 5371022 | DIVIDEND | CHANGE | 75513E101 | 0 | 0 | 1 | 0 | .59 | 00 | 2023-08-17 | 2023-08-18 | 2023-09-07 | 2023-06-05 | 0 | 2023-06-05 | ? | 0 | 0006736648 | 20230911.ifs | 2023-09-11 | 2023-09-12 | |||||||
| 5371023 | 5371022 | DIVIDEND | CHANGE | 75513E101 | 0 | 0 | 1 | 0 | .59 | 00 | 2023-08-17 | 2023-08-18 | 2023-09-07 | 2023-06-05 | 1 | 2023-06-05 | 2023-09-11 | 0 | 0006736648 | 20230911.ifs | 2023-09-11 | 2023-09-12 | |||||||
| 5340200 | 5340200 | CORPACTION | ADD | 75513E101 | 01 | # | 2023-07-27 | 75513E101 | 01 | 2023-07-27 | 20230727.ifs | 2023-07-27 | 2023-07-28 | ||||||||||||||||
| 5340201 | 5340201 | CORPACTIONAUX | ADD | 75513E101 | 01 | 2023-07-27 | RTX | RAYTHEON TECHNOLOGIES CORP | COM | RTX | RTX CORPORATION | COM | ? | 2023-07-27 | 20230727.ifs | 2023-07-27 | 2023-07-28 | ||||||||||||
| 5306839 | 5306839 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .59 | 00 | 2023-08-17 | 2023-08-18 | 2023-09-07 | 2023-06-05 | 0 | 2023-06-05 | ? | 0 | 0006736648 | 20230605.ifs | 2023-06-05 | 2023-06-06 | |||||||
| 5276227 | 5276227 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .59 | 00 | 2023-05-18 | 2023-05-19 | 2023-06-15 | 2023-04-24 | 0 | 2023-04-24 | ? | 0 | 0006714849 | 20230424.ifs | 2023-04-24 | 2023-04-25 | |||||||
| 5226591 | 5226591 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .55 | 00 | 2023-02-23 | 2023-02-24 | 2023-03-23 | 2023-02-03 | 0 | 2023-02-03 | ? | 0 | 0006680672 | 20230203.ifs | 2023-02-03 | 2023-02-04 | |||||||
| 5119956 | 5119956 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .55 | 00 | 2022-11-17 | 2022-11-18 | 2022-12-15 | 2022-10-12 | 0 | 2022-10-12 | ? | 0 | 0006599387 | 20221012.ifs | 2022-10-12 | 2022-10-13 | |||||||
| 5028306 | 5028306 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .55 | 00 | 2022-08-18 | 2022-08-19 | 2022-09-08 | 2022-06-06 | 0 | 2022-06-06 | ? | 0 | 0006535602 | 20220606.ifs | 2022-06-06 | 2022-06-07 | |||||||
| 4997585 | 4997585 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .55 | 00 | 2022-05-19 | 2022-05-20 | 2022-06-16 | 2022-04-25 | 0 | 2022-04-25 | ? | 0 | 0006513230 | 20220425.ifs | 2022-04-25 | 2022-04-26 | |||||||
| 4952582 | 4952582 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .51 | 00 | 2022-02-24 | 2022-02-25 | 2022-03-24 | 2022-02-11 | 0 | 2022-02-11 | ? | 0 | 0006480617 | 20220211.ifs | 2022-02-11 | 2022-02-12 | |||||||
| 4826210 | 4826210 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .51 | 00 | 2021-11-18 | 2021-11-19 | 2021-12-16 | 2021-10-13 | 0 | 2021-10-13 | ? | 0 | 0006383700 | 20211013.ifs | 2021-10-13 | 2021-10-14 | |||||||
| 4733875 | 4733875 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .51 | 00 | 2021-08-19 | 2021-08-20 | 2021-09-09 | 2021-06-21 | 0 | 2021-06-21 | ? | 0 | 0006324874 | 20210621.ifs | 2021-06-21 | 2021-06-22 | |||||||
| 4688138 | 4688138 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .51 | 00 | 2021-05-20 | 2021-05-21 | 2021-06-17 | 2021-04-26 | 0 | 2021-04-26 | ? | 0 | 0006296990 | 20210426.ifs | 2021-04-26 | 2021-04-27 | |||||||
| 4626075 | 4626075 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2021-02-25 | 2021-02-26 | 2021-03-25 | 2021-02-06 | 0 | 2021-02-08 | ? | 0 | 0006262718 | 20210208.ifs | 2021-02-08 | 2021-02-09 | |||||||
| 4523854 | 4523854 | DIVIDEND | CHANGE | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-11-12 | 2020-11-13 | 2020-12-17 | 2020-10-14 | 1 | 2020-10-14 | 2020-11-30 | 0 | 0006175169 | 20201202.ifs | 2020-12-02 | 2020-12-03 | |||||||
| 4523855 | 4523854 | DIVIDEND | CHANGE | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-11-12 | 2020-11-13 | 2020-12-17 | 2020-10-14 | 1 | 2020-10-14 | 2020-12-02 | 0 | 0006175169 | 20201202.ifs | 2020-12-02 | 2020-12-03 | |||||||
| 4517215 | 4517215 | DIVIDEND | CHANGE | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-11-12 | 2020-11-13 | 2020-12-17 | 2020-10-14 | 0 | 2020-10-14 | ? | 0 | 0006175169 | 20201130.ifs | 2020-11-30 | 2020-12-01 | |||||||
| 4517216 | 4517215 | DIVIDEND | CHANGE | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-11-12 | 2020-11-13 | 2020-12-17 | 2020-10-14 | 1 | 2020-10-14 | 2020-11-30 | 0 | 0006175169 | 20201130.ifs | 2020-11-30 | 2020-12-01 | |||||||
| 4506260 | 4506260 | EQUITY | CHANGE | 75513E101 | COM | 0 | 0 | 2020-01-31 | ? | 0 | no | no | no | 2020-04-01 | ? | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
| 4506261 | 4506260 | EQUITY | CHANGE | 75513E101 | COM | 0 | 0 | 2020-01-31 | ? | 4 | no | no | no | 2020-04-01 | 2020-11-13 | ? | 20201113.ifs | 2020-11-13 | 2020-11-14 | ||||||||||
| 4485742 | 4485742 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-11-12 | 2020-11-13 | 2020-12-17 | 2020-10-14 | 0 | 2020-10-14 | ? | 0 | 0006175169 | 20201014.ifs | 2020-10-14 | 2020-10-15 | |||||||
| 4387635 | 4387635 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-08-13 | 2020-08-14 | 2020-09-10 | 2020-06-08 | 0 | 2020-06-08 | ? | 0 | 0006110457 | 20200608.ifs | 2020-06-08 | 2020-06-09 | |||||||
| 4320207 | 4320207 | SPLIT | DELETE | 75513E101 | .58998151 | 2020-04-03 | 20 | ? | 2020-04-29 | 20200504.ifs | 2020-05-04 | 2020-05-05 | |||||||||||||||||
| 4320215 | 4320215 | SPLIT | DELETE | 75513E101 | .58998151 | 2020-04-03 | 20 | ? | 2020-04-29 | 20200504.ifs | 2020-05-04 | 2020-05-05 | |||||||||||||||||
| 4305083 | 4305083 | SPLIT | CHANGE | 75513E101 | .9413374193 | 2020-04-03 | 20 | ? | 2020-04-03 | 20200429.ifs | 2020-04-29 | 2020-04-30 | |||||||||||||||||
| 4305085 | 4305084 | SPLIT | CHANGE | 75513E101 | .58998151 | 2020-04-03 | 20 | ? | 2020-04-29 | 20200429.ifs | 2020-04-29 | 2020-04-30 | |||||||||||||||||
| 4305091 | 4305091 | SPLIT | CHANGE | 75513E101 | .9413374193 | 2020-04-03 | 20 | ? | 2020-04-03 | 20200429.ifs | 2020-04-29 | 2020-04-30 | |||||||||||||||||
| 4305093 | 4305092 | SPLIT | CHANGE | 75513E101 | .58998151 | 2020-04-03 | 20 | ? | 2020-04-29 | 20200429.ifs | 2020-04-29 | 2020-04-30 | |||||||||||||||||
| 4302661 | 4302661 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-05-14 | 2020-05-15 | 2020-06-18 | 2020-04-27 | 0 | 2020-04-27 | ? | 0 | 0006088501 | 20200427.ifs | 2020-04-27 | 2020-04-28 | |||||||
| 4302662 | 4302662 | DIVIDEND | ADD | 75513E101 | 0 | 0 | 1 | 0 | .475 | 00 | 2020-05-14 | 2020-05-15 | 2020-06-18 | 2020-04-27 | 0 | 2020-04-27 | ? | 0 | 0006088501 | 20200427.ifs | 2020-04-27 | 2020-04-28 | |||||||
| 4280577 | 4280577 | EXCHANGE | ADD | 75513E101 | 01 | 2020-04-03 | 2020-04-03 | RTX | 0 | 0 | 2020-04-03 | ? | 20200403.ifs | 2020-04-03 | 2020-04-04 | ||||||||||||||
| 4280582 | 4280582 | SPLIT | ADD | 75513E101 | .9413374193 | 2020-04-03 | 20 | ? | 2020-04-03 | 20200403.ifs | 2020-04-03 | 2020-04-04 | |||||||||||||||||
| 4280650 | 4280650 | EXCHANGE | ADD | 75513E101 | 01 | 2020-04-03 | 2020-04-03 | RTX | 0 | 0 | 2020-04-03 | ? | 20200403.ifs | 2020-04-03 | 2020-04-04 | ||||||||||||||
| 4280655 | 4280655 | SPLIT | ADD | 75513E101 | .9413374193 | 2020-04-03 | 20 | ? | 2020-04-03 | 20200403.ifs | 2020-04-03 | 2020-04-04 | |||||||||||||||||
| 4281890 | 4281890 | EQUITY | CHANGE | 75513E101 | COM | N | 0 | 2020-01-31 | ? | 0 | no | no | no | 2020-04-01 | ? | ? | 20200403.ifs | 2020-04-03 | 2020-04-04 | ||||||||||
| 4281892 | 4281891 | EQUITY | CHANGE | 75513E101 | COM | 0 | 0 | 2020-01-31 | ? | 0 | no | no | no | 2020-04-01 | ? | ? | 20200403.ifs | 2020-04-03 | 2020-04-04 | ||||||||||
| 4281952 | 4281952 | EQUITY | CHANGE | 75513E101 | COM | N | 0 | 2020-01-31 | ? | 0 | no | no | no | 2020-04-01 | ? | ? | 20200403.ifs | 2020-04-03 | 2020-04-04 | ||||||||||
| 4281953 | 4281952 | EQUITY | CHANGE | 75513E101 | COM | 0 | 0 | 2020-01-31 | ? | 0 | no | no | no | 2020-04-01 | ? | ? | 20200403.ifs | 2020-04-03 | 2020-04-04 | ||||||||||
| 4269911 | 4269911 | EQUITY | ADD | 75513E101 | COM | N | 0 | 2020-01-31 | ? | 0 | no | no | no | 2020-04-01 | ? | ? | 20200401.ifs | 2020-04-01 | 2020-04-02 | ||||||||||
| 4269912 | 4269912 | EQUITY | ADD | 75513E101 | COM | N | 0 | 2020-01-31 | ? | 0 | no | no | no | 2020-04-01 | ? | ? | 20200401.ifs | 2020-04-01 | 2020-04-02 |
| 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 = 130665
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