INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 57 | 51 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 20.64 % | 19.61 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:166944 |
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 | ||
5584365 | 5584365 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .224251 | 00 | 2024-06-27 | 2024-06-27 | 2024-06-28 | 2024-06-26 | 0 | 2024-06-26 | ? | 0 | 0006938371 | 20240626.ifs | 2024-06-26 | 2024-06-27 | |||||||
5523057 | 5523057 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .164993 | 00 | 2024-03-26 | 2024-03-27 | 2024-03-28 | 2024-03-25 | 0 | 2024-03-25 | ? | 0 | 0006894871 | 20240325.ifs | 2024-03-25 | 2024-03-26 | |||||||
5461941 | 5461941 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .288234 | 00 | 2023-12-27 | 2023-12-28 | 2023-12-29 | 2023-12-26 | 0 | 2023-12-26 | ? | 0 | 0006849509 | 20231226.ifs | 2023-12-26 | 2023-12-27 | |||||||
5380941 | 5380941 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .249328 | 00 | 2023-09-27 | 2023-09-28 | 2023-09-29 | 2023-09-26 | 0 | 2023-09-26 | ? | 0 | 0006787656 | 20230926.ifs | 2023-09-26 | 2023-09-27 | |||||||
5319684 | 5319684 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .227856 | 00 | 2023-06-28 | 2023-06-29 | 2023-06-30 | 2023-06-27 | 0 | 2023-06-27 | ? | 0 | 0006744738 | 20230627.ifs | 2023-06-27 | 2023-06-28 | |||||||
5256578 | 5256578 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .13386 | 00 | 2023-03-29 | 2023-03-30 | 2023-03-31 | 2023-03-28 | 0 | 2023-03-28 | ? | 0 | 0006701216 | 20230328.ifs | 2023-03-28 | 2023-03-29 | |||||||
5191130 | 5191130 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .254819 | 00 | 2022-12-28 | 2022-12-29 | 2022-12-30 | 2022-12-27 | 0 | 2022-12-27 | ? | 0 | 0006653136 | 20221227.ifs | 2022-12-27 | 2022-12-28 | |||||||
5095343 | 5095343 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .160515 | 00 | 2022-09-13 | 2022-09-14 | 2022-09-15 | 2022-09-12 | 0 | 2022-09-12 | ? | 0 | 0006582444 | 20220912.ifs | 2022-09-12 | 2022-09-13 | |||||||
5032436 | 5032436 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .065146 | 00 | 2022-06-14 | 2022-06-15 | 2022-06-16 | 2022-06-14 | 0 | ? | 2022-06-14 | 0 | 0006537875 | 20220614.ifs | 2022-06-14 | 2022-06-15 | |||||||
4970778 | 4970778 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .0128 | 00 | 2022-03-15 | 2022-03-16 | 2022-03-17 | 2022-03-14 | 0 | 2022-03-14 | ? | 0 | 0006494381 | 20220314.ifs | 2022-03-14 | 2022-03-15 | |||||||
4915928 | 4915928 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .084197 | 00 | 2021-12-29 | 2021-12-30 | 2021-12-31 | 2021-12-28 | 0 | 2021-12-28 | ? | 0 | 0006450013 | 20211228.ifs | 2021-12-28 | 2021-12-29 | |||||||
4848932 | 4848932 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | .44058 | 95 | 2021-11-17 | 2021-11-18 | 2021-11-19 | 2021-11-16 | 0 | 2021-11-16 | ? | 1 | 0006396860 | 20211116.ifs | 2021-11-16 | 2021-11-17 | |||||||
4848933 | 4848933 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | .0937 | 96 | 2021-11-17 | 2021-11-18 | 2021-11-19 | 2021-11-16 | 0 | 2021-11-16 | ? | 0 | 0006396859 | 20211116.ifs | 2021-11-16 | 2021-11-17 | |||||||
4800957 | 4800957 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .056467 | 00 | 2021-09-14 | 2021-09-15 | 2021-09-16 | 2021-09-13 | 0 | 2021-09-13 | ? | 0 | 0006366963 | 20210913.ifs | 2021-09-13 | 2021-09-14 | |||||||
4728762 | 4728762 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .044102 | 00 | 2021-06-15 | 2021-06-16 | 2021-06-17 | 2021-06-14 | 0 | 2021-06-14 | ? | 0 | 0006321899 | 20210614.ifs | 2021-06-14 | 2021-06-15 | |||||||
4653341 | 4653341 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .04257 | 00 | 2021-03-16 | 2021-03-17 | 2021-03-18 | 2021-03-15 | 0 | 2021-03-15 | ? | 0 | 0006277558 | 20210315.ifs | 2021-03-15 | 2021-03-16 | |||||||
4575936 | 4575936 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .113636 | 00 | 2020-12-29 | 2020-12-30 | 2020-12-31 | 2020-12-28 | 0 | 2020-12-28 | ? | 0 | 0006233911 | 20201228.ifs | 2020-12-28 | 2020-12-29 | |||||||
4508261 | 4508261 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | 1.13521 | 95 | 2020-11-18 | 2020-11-19 | 2020-11-20 | 2020-11-17 | 0 | 2020-11-17 | ? | 1 | 0006188723 | 20201117.ifs | 2020-11-17 | 2020-11-18 | |||||||
4508262 | 4508262 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | .17509 | 96 | 2020-11-18 | 2020-11-19 | 2020-11-20 | 2020-11-17 | 0 | 2020-11-17 | ? | 0 | 0006188722 | 20201117.ifs | 2020-11-17 | 2020-11-18 | |||||||
4461617 | 4461617 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .112849 | 00 | 2020-09-15 | 2020-09-16 | 2020-09-17 | 2020-09-14 | 0 | 2020-09-14 | ? | 0 | 0006158631 | 20200914.ifs | 2020-09-14 | 2020-09-15 | |||||||
4392110 | 4392110 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .062759 | 00 | 2020-06-16 | 2020-06-17 | 2020-06-18 | 2020-06-15 | 0 | 2020-06-15 | ? | 0 | 0006112977 | 20200615.ifs | 2020-06-15 | 2020-06-16 | |||||||
4241622 | 4241622 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .071228 | 00 | 2020-03-17 | 2020-03-18 | 2020-03-19 | 2020-03-16 | 0 | 2020-03-16 | ? | 0 | 0006069315 | 20200316.ifs | 2020-03-16 | 2020-03-17 | |||||||
4241784 | 4241784 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .071228 | 00 | 2020-03-17 | 2020-03-18 | 2020-03-19 | 2020-03-16 | 0 | 2020-03-16 | ? | 0 | 0006069315 | 20200316.ifs | 2020-03-16 | 2020-03-17 | |||||||
4131601 | 4131601 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | .31545 | 95 | 2019-12-30 | 2019-12-31 | 2020-01-02 | 2019-12-27 | 0 | 2019-12-27 | ? | 1 | 0006028610 | 20191227.ifs | 2019-12-27 | 2019-12-28 | |||||||
4131603 | 4131603 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .197509 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-02 | 2019-12-27 | 0 | 2019-12-27 | ? | 0 | 0006028608 | 20191227.ifs | 2019-12-27 | 2019-12-28 | |||||||
4131721 | 4131721 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | .31545 | 95 | 2019-12-30 | 2019-12-31 | 2020-01-02 | 2019-12-27 | 0 | 2019-12-27 | ? | 1 | 0006028610 | 20191227.ifs | 2019-12-27 | 2019-12-28 | |||||||
4131723 | 4131723 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .197509 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-02 | 2019-12-27 | 0 | 2019-12-27 | ? | 0 | 0006028608 | 20191227.ifs | 2019-12-27 | 2019-12-28 | |||||||
3773288 | 3773288 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .13466 | 00 | 2019-06-11 | 2019-06-12 | 2019-06-13 | 2019-06-10 | 0 | 2019-06-10 | ? | 0 | 0005895905 | 20190610.ifs | 2019-06-10 | 2019-06-11 | |||||||
3773293 | 3773293 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .13466 | 00 | 2019-06-11 | 2019-06-12 | 2019-06-13 | 2019-06-10 | 0 | 2019-06-10 | ? | 0 | 0005895905 | 20190610.ifs | 2019-06-10 | 2019-06-11 | |||||||
3623229 | 3623229 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .083985 | 00 | 2019-03-12 | 2019-03-13 | 2019-03-14 | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851388 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3623301 | 3623301 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .083985 | 00 | 2019-03-12 | 2019-03-13 | 2019-03-14 | 2019-03-11 | 0 | 2019-03-11 | ? | 0 | 0005851388 | 20190311.ifs | 2019-03-11 | 2019-03-12 | |||||||
3506874 | 3506874 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | .47 | 95 | 2018-12-28 | 2018-12-31 | 2019-01-02 | 2018-12-27 | 0 | 2018-12-27 | ? | 1 | 0005811219 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3506876 | 3506876 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .145176 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-02 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005811216 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3508638 | 3508638 | DIVIDEND | ADD | 26922A388 | 8 | 0 | 1 | 9 | .47 | 95 | 2018-12-28 | 2018-12-31 | 2019-01-02 | 2018-12-27 | 0 | 2018-12-27 | ? | 1 | 0005811219 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3508640 | 3508640 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 0 | .145176 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-02 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005811216 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3286750 | 3286750 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 4 | .038299 | 00 | 2018-09-18 | 2018-09-19 | 2018-09-20 | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724549 | 20180917.ifs | 2018-09-17 | 2018-09-18 | |||||||
3286751 | 3286751 | DIVIDEND | ADD | 26922A388 | 0 | 0 | 1 | 4 | .038299 | 00 | 2018-09-18 | 2018-09-19 | 2018-09-20 | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724549 | 20180917.ifs | 2018-09-17 | 2018-09-18 | |||||||
3231452 | 3231452 | EQUITY | ADD | 26922A388 | NEW ISSUE | 0 | 0 | 2018-08-07 | ? | 0 | no | no | no | ? | ? | ? | 20180807.ifs | 2018-08-07 | 2018-08-08 | ||||||||||
3231453 | 3231453 | EQUITY | ADD | 26922A388 | NEW ISSUE | 0 | 0 | 2018-08-07 | ? | 0 | no | no | no | ? | ? | ? | 20180807.ifs | 2018-08-07 | 2018-08-08 | ||||||||||
3231454 | 3231454 | EQUITY | CHANGE | 26922A388 | NEW ISSUE | 0 | 0 | 2018-08-07 | ? | 0 | no | no | no | ? | ? | ? | 20180807.ifs | 2018-08-07 | 2018-08-08 | ||||||||||
3231455 | 3231455 | EQUITY | CHANGE | 26922A388 | NEW ISSUE | 0 | 0 | 2018-08-07 | ? | 0 | no | no | no | ? | ? | ? | 20180807.ifs | 2018-08-07 | 2018-08-08 | ||||||||||
3231456 | 3231455 | EQUITY | CHANGE | 26922A388 | APTUS DEFINED RISK ETF | N | A | 2018-08-07 | ? | 0 | no | no | no | ? | 2018-08-07 | ? | 20180807.ifs | 2018-08-07 | 2018-08-08 | ||||||||||
3231457 | 3231456 | EQUITY | CHANGE | 26922A388 | APTUS DEFINED RISK ETF | N | A | 2018-08-07 | ? | 0 | no | no | no | ? | 2018-08-07 | ? | 20180807.ifs | 2018-08-07 | 2018-08-08 |
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 = 166944
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