INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 496 | 463 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 53.82 % | 59.57 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:160362 |
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 | ||
5573818 | 5573818 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.425169 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931196 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5450328 | 5450328 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .821393 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840873 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5307560 | 5307560 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.311269 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006737154 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5162394 | 5162394 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .496935 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629638 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5030112 | 5030112 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.109262 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536709 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4877063 | 4877063 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .634112 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417501 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4725890 | 4725890 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.265077 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320528 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4539111 | 4539111 | DIVIDEND | ADD | 46429B689 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209364 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4441476 | 4441476 | EQUITY | CHANGE | 46429B689 | ISHARES EDGE MSCI MIN VOL EAFE ETF | 0 | A | 2011-10-20 | ? | 2 | no | no | no | 2011-10-20 | 2016-05-12 | ? | 20200818.ifs | 2020-08-18 | 2020-08-19 | ||||||||||
4441477 | 4441476 | EQUITY | CHANGE | 46429B689 | MSCI EAFE MINIMUM VOLATILITY FACTOR ETF | 0 | A | 2011-10-20 | ? | 2 | no | no | no | 2011-10-20 | 2020-08-18 | ? | 20200818.ifs | 2020-08-18 | 2020-08-19 | ||||||||||
4390991 | 4390991 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .9773 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112208 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4067891 | 4067891 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.73438 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000216 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4067970 | 4067970 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.73438 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000216 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3780913 | 3780913 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.385553 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898860 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3780936 | 3780936 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.385553 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898860 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3452310 | 3452310 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .771266 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-24 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005785741 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3452469 | 3452469 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .771266 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-24 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005785741 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3144026 | 3144026 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.452978 | 00 | 2018-06-19 | 2018-06-20 | 2018-06-25 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676530 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
3144027 | 3144027 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.452978 | 00 | 2018-06-19 | 2018-06-20 | 2018-06-25 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676530 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
2839533 | 2839533 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .393831 | 00 | 2017-12-19 | 2017-12-20 | 2017-12-26 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005564359 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2642219 | 2642219 | CORPACTION | ADD | 46429B689 | 04 | X | 2017-08-02 | 46429B689 | 12 | 2017-08-02 | 20170802.ifs | 2017-08-02 | 2017-08-03 | ||||||||||||||||
2595038 | 2595038 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.397018 | 00 | 2017-06-20 | 2017-06-22 | 2017-06-26 | 2017-06-19 | 0 | 2017-06-19 | ? | 0 | 0005451164 | 20170619.ifs | 2017-06-19 | 2017-06-20 | |||||||
2451288 | 2451288 | EQUITY | CHANGE | 46429B689 | ISHARES EDGE MSCI MIN VOL EAFE ETF | 0 | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2016-05-12 | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
2451289 | 2451288 | EQUITY | CHANGE | 46429B689 | ISHARES EDGE MSCI MIN VOL EAFE ETF | 0 | A | 2011-10-20 | ? | 2 | no | no | no | 2011-10-20 | 2016-05-12 | ? | 20170124.ifs | 2017-01-24 | 2017-01-25 | ||||||||||
2388178 | 2388178 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.410869 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-28 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346363 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2226634 | 2226634 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.00308 | 00 | 2016-06-22 | 2016-06-24 | 2016-06-28 | 2016-06-21 | 0 | 2016-06-21 | ? | 0 | 0005236470 | 20160621.ifs | 2016-06-21 | 2016-06-22 | |||||||
2194957 | 2194957 | CORPACTION | ADD | 46429B689 | 04 | # | 2016-05-12 | 46429B689 | 04 | ? | 20160512.ifs | 2016-05-12 | 2016-05-13 | ||||||||||||||||
2194958 | 2194958 | CORPACTIONAUX | ADD | 46429B689 | 04 | 2016-05-12 | EFAV | ISHARES TR | ISHARES TRUST - | EFAV | ISHARES TR | ISHARES EDGE MS | 2016-05-12 | ? | 20160512.ifs | 2016-05-12 | 2016-05-13 | ||||||||||||
2194959 | 2194959 | EQUITY | CHANGE | 46429B689 | ISHARES MSCI EAFE MINIMUM VOLATILITY ETF | 0 | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2013-07-01 | ? | 20160512.ifs | 2016-05-12 | 2016-05-13 | ||||||||||
2194960 | 2194959 | EQUITY | CHANGE | 46429B689 | ISHARES EDGE MSCI MIN VOL EAFE ETF | 0 | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2016-05-12 | ? | 20160512.ifs | 2016-05-12 | 2016-05-13 | ||||||||||
2052946 | 2052946 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .669539 | 00 | 2015-12-21 | 2015-12-23 | 2015-12-28 | 2015-12-18 | 0 | 2015-12-18 | ? | 0 | 0005130255 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
1719521 | 1719521 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .828224 | 00 | 2014-12-17 | 2014-12-19 | 2014-12-24 | 2014-12-16 | 0 | 2014-12-16 | ? | 0 | 0004901998 | 20141216.ifs | 2014-12-16 | 2014-12-17 | |||||||
1558910 | 1558910 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | 1.371699 | 00 | 2014-06-25 | 2014-06-27 | 2014-07-02 | 2014-06-24 | 0 | 2014-06-24 | ? | 0 | 0004801504 | 20140624.ifs | 2014-06-24 | 2014-06-25 | |||||||
1376861 | 1376861 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .77417 | 00 | 2013-12-18 | 2013-12-20 | 2013-12-30 | 2013-12-17 | 0 | 2013-12-17 | ? | 0 | 0004688616 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1227536 | 1227536 | CORPACTION | ADD | 46429B689 | 04 | # | 2013-07-01 | 46429B689 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227537 | 1227537 | CORPACTIONAUX | ADD | 46429B689 | 04 | 2013-07-01 | EFAV | ISHARES TR | MSCI EAFE MINIM | EFAV | ISHARES TR | ISHARES MSCI EA | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227538 | 1227538 | EQUITY | CHANGE | 46429B689 | MSCI EAFE MINIMUM VOLATILITY INDEX FD | 0 | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2011-10-20 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227539 | 1227538 | EQUITY | CHANGE | 46429B689 | ISHARES MSCI EAFE MINIMUM VOLATILITY ETF | 0 | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1218974 | 1218974 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .785648 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-05 | 2013-06-26 | 0 | 2013-06-26 | ? | 0 | 0004590000 | 20130626.ifs | 2013-06-26 | 2013-06-27 | |||||||
1044695 | 1044695 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .500392 | 00 | 2012-12-18 | 2012-12-20 | 2012-12-27 | 2012-12-17 | 0 | 2012-12-17 | ? | 0 | 0004483117 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
895515 | 895515 | DIVIDEND | CHANGE | 46429B689 | 0 | 0 | 1 | 0 | .5786 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 0 | 2012-06-20 | ? | 0 | 0004389167 | 20120627.ifs | 2012-06-27 | 2012-06-28 | |||||||
895516 | 895515 | DIVIDEND | CHANGE | 46429B689 | 0 | 0 | 1 | 0 | .578626 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 1 | 2012-06-20 | 2012-06-27 | 0 | 0004389167 | 20120627.ifs | 2012-06-27 | 2012-06-28 | |||||||
889568 | 889568 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 0 | .5786 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-28 | 2012-06-20 | 0 | 2012-06-20 | ? | 0 | 0004389167 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
730858 | 730858 | DIVIDEND | ADD | 46429B689 | 0 | 0 | 1 | 4 | .23267 | 00 | 2011-12-20 | 2011-12-22 | 2011-12-29 | 2011-12-19 | 0 | 2011-12-19 | ? | 0 | 0004295306 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
675675 | 675675 | EQUITY | ADD | 46429B689 | MSCI EAFE MINIMUM VOLATILITY INDEX FD | N | 7 | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | ? | ? | 20111020.ifs | 2011-10-20 | 2011-10-21 | ||||||||||
675676 | 675676 | EXCHANGE | ADD | 46429B689 | 04 | 2011-10-20 | 2011-10-20 | EFAV | 0 | A | 2011-10-20 | ? | 20111020.ifs | 2011-10-20 | 2011-10-21 | ||||||||||||||
675773 | 675773 | EQUITY | CHANGE | 46429B689 | MSCI EAFE MINIMUM VOLATILITY INDEX FD | N | 7 | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | ? | ? | 20111020.ifs | 2011-10-20 | 2011-10-21 | ||||||||||
675774 | 675773 | EQUITY | CHANGE | 46429B689 | MSCI EAFE MINIMUM VOLATILITY INDEX FD | N | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2011-10-20 | ? | 20111020.ifs | 2011-10-20 | 2011-10-21 | ||||||||||
676476 | 676476 | EQUITY | CHANGE | 46429B689 | MSCI EAFE MINIMUM VOLATILITY INDEX FD | N | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2011-10-20 | ? | 20111020.ifs | 2011-10-20 | 2011-10-21 | ||||||||||
676477 | 676476 | EQUITY | CHANGE | 46429B689 | MSCI EAFE MINIMUM VOLATILITY INDEX FD | 0 | A | 2011-10-20 | ? | 0 | no | no | no | 2011-10-20 | 2011-10-20 | ? | 20111020.ifs | 2011-10-20 | 2011-10-21 |
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 = 160362
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