INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 118 | 97 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 19.79 % | 22.55 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:166924 |
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 | ||
5581808 | 5581808 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .32261 | 00 | 2024-06-25 | 2024-06-25 | 2024-06-27 | 2024-06-24 | 0 | 2024-06-24 | ? | 0 | 0006936965 | 20240624.ifs | 2024-06-24 | 2024-06-25 | |||||||
5518115 | 5518115 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .24013 | 00 | 2024-03-19 | 2024-03-20 | 2024-03-22 | 2024-03-18 | 0 | 2024-03-18 | ? | 0 | 0006891432 | 20240318.ifs | 2024-03-18 | 2024-03-19 | |||||||
5447093 | 5447093 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .40754 | 00 | 2023-12-19 | 2023-12-20 | 2023-12-22 | 2023-12-18 | 0 | 2023-12-18 | ? | 0 | 0006837714 | 20231218.ifs | 2023-12-18 | 2023-12-19 | |||||||
5375353 | 5375353 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .28071 | 00 | 2023-09-19 | 2023-09-20 | 2023-09-22 | 2023-09-18 | 0 | 2023-09-18 | ? | 0 | 0006784224 | 20230918.ifs | 2023-09-18 | 2023-09-19 | |||||||
5313148 | 5313148 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .2794 | 00 | 2023-06-20 | 2023-06-21 | 2023-06-23 | 2023-06-16 | 0 | 2023-06-16 | ? | 0 | 0006740678 | 20230616.ifs | 2023-06-16 | 2023-06-17 | |||||||
5251273 | 5251273 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .22153 | 00 | 2023-03-21 | 2023-03-22 | 2023-03-24 | 2023-03-20 | 0 | 2023-03-20 | ? | 0 | 0006697693 | 20230320.ifs | 2023-03-20 | 2023-03-21 | |||||||
5177137 | 5177137 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .36136 | 00 | 2022-12-20 | 2022-12-21 | 2022-12-23 | 2022-12-19 | 0 | 2022-12-19 | ? | 0 | 0006643042 | 20221219.ifs | 2022-12-19 | 2022-12-20 | |||||||
5099683 | 5099683 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .27729 | 00 | 2022-09-20 | 2022-09-21 | 2022-09-23 | 2022-09-19 | 0 | 2022-09-19 | ? | 0 | 0006585288 | 20220919.ifs | 2022-09-19 | 2022-09-20 | |||||||
5035885 | 5035885 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .25082 | 00 | 2022-06-21 | 2022-06-22 | 2022-06-24 | 2022-06-17 | 0 | 2022-06-17 | ? | 0 | 0006540647 | 20220617.ifs | 2022-06-17 | 2022-06-18 | |||||||
4974456 | 4974456 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .18717 | 00 | 2022-03-22 | 2022-03-23 | 2022-03-25 | 2022-03-21 | 0 | 2022-03-21 | ? | 0 | 0006496851 | 20220321.ifs | 2022-03-21 | 2022-03-22 | |||||||
4805599 | 4805599 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .23927 | 00 | 2021-09-21 | 2021-09-22 | 2021-09-24 | 2021-09-20 | 0 | 2021-09-20 | ? | 0 | 0006369824 | 20210920.ifs | 2021-09-20 | 2021-09-21 | |||||||
4734035 | 4734035 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .22706 | 00 | 2021-06-22 | 2021-06-23 | 2021-06-25 | 2021-06-21 | 0 | 2021-06-21 | ? | 0 | 0006325054 | 20210621.ifs | 2021-06-21 | 2021-06-22 | |||||||
4658774 | 4658774 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .18084 | 00 | 2021-03-23 | 2021-03-24 | 2021-03-26 | 2021-03-22 | 0 | 2021-03-22 | ? | 0 | 0006280258 | 20210322.ifs | 2021-03-22 | 2021-03-23 | |||||||
4563641 | 4563641 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .28843 | 00 | 2020-12-22 | 2020-12-23 | 2020-12-28 | 2020-12-21 | 0 | 2020-12-21 | ? | 0 | 0006227304 | 20201221.ifs | 2020-12-21 | 2020-12-22 | |||||||
4466491 | 4466491 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .30478 | 00 | 2020-09-22 | 2020-09-23 | 2020-09-25 | 2020-09-21 | 0 | 2020-09-21 | ? | 0 | 0006161429 | 20200921.ifs | 2020-09-21 | 2020-09-22 | |||||||
4397211 | 4397211 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .20729 | 00 | 2020-06-23 | 2020-06-24 | 2020-06-26 | 2020-06-22 | 0 | 2020-06-22 | ? | 0 | 0006116294 | 20200622.ifs | 2020-06-22 | 2020-06-23 | |||||||
4249264 | 4249264 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .18042 | 00 | 2020-03-24 | 2020-03-25 | 2020-03-27 | 2020-03-23 | 0 | 2020-03-23 | ? | 0 | 0006072272 | 20200323.ifs | 2020-03-23 | 2020-03-24 | |||||||
4249318 | 4249318 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .18042 | 00 | 2020-03-24 | 2020-03-25 | 2020-03-27 | 2020-03-23 | 0 | 2020-03-23 | ? | 0 | 0006072272 | 20200323.ifs | 2020-03-23 | 2020-03-24 | |||||||
4106360 | 4106360 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .28375 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-20 | 0 | 2019-12-20 | ? | 0 | 0006019151 | 20191220.ifs | 2019-12-20 | 2019-12-21 | |||||||
4107223 | 4107223 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .28375 | 00 | 2019-12-23 | 2019-12-24 | 2019-12-27 | 2019-12-20 | 0 | 2019-12-20 | ? | 0 | 0006019151 | 20191220.ifs | 2019-12-20 | 2019-12-21 | |||||||
3933880 | 3933880 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .24364 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949235 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3933881 | 3933881 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 0 | .24364 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-27 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949235 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3797262 | 3797262 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 4 | .26586 | 00 | 2019-06-25 | 2019-06-26 | 2019-06-28 | 2019-06-24 | 0 | 2019-06-24 | ? | 0 | 0005903548 | 20190624.ifs | 2019-06-24 | 2019-06-25 | |||||||
3797263 | 3797263 | DIVIDEND | ADD | 46641Q399 | 0 | 0 | 1 | 4 | .26586 | 00 | 2019-06-25 | 2019-06-26 | 2019-06-28 | 2019-06-24 | 0 | 2019-06-24 | ? | 0 | 0005903548 | 20190624.ifs | 2019-06-24 | 2019-06-25 | |||||||
3625306 | 3625306 | EQUITY | ADD | 46641Q399 | NEW ISSUE | 0 | 0 | 2019-03-13 | ? | 0 | no | no | no | ? | ? | ? | 20190313.ifs | 2019-03-13 | 2019-03-14 | ||||||||||
3625307 | 3625307 | EQUITY | ADD | 46641Q399 | NEW ISSUE | 0 | 0 | 2019-03-13 | ? | 0 | no | no | no | ? | ? | ? | 20190313.ifs | 2019-03-13 | 2019-03-14 | ||||||||||
3625308 | 3625308 | EQUITY | CHANGE | 46641Q399 | NEW ISSUE | 0 | 0 | 2019-03-13 | ? | 0 | no | no | no | ? | ? | ? | 20190313.ifs | 2019-03-13 | 2019-03-14 | ||||||||||
3625309 | 3625308 | EQUITY | CHANGE | 46641Q399 | BETABUILDERS US EQUITY ETF | N | A | 2019-03-13 | ? | 0 | no | no | no | ? | 2019-03-13 | ? | 20190313.ifs | 2019-03-13 | 2019-03-14 | ||||||||||
3625310 | 3625310 | EQUITY | CHANGE | 46641Q399 | NEW ISSUE | 0 | 0 | 2019-03-13 | ? | 0 | no | no | no | ? | ? | ? | 20190313.ifs | 2019-03-13 | 2019-03-14 | ||||||||||
3625311 | 3625310 | EQUITY | CHANGE | 46641Q399 | BETABUILDERS US EQUITY ETF | N | A | 2019-03-13 | ? | 0 | no | no | no | ? | 2019-03-13 | ? | 20190313.ifs | 2019-03-13 | 2019-03-14 |
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 = 166924
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