INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 99 | 84 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 49.80 % | 44.93 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159710 |
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 | ||
5573955 | 5573955 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .293422 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931048 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5519618 | 5519618 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .305794 | 00 | 2024-03-21 | 2024-03-22 | 2024-03-27 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892644 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5450466 | 5450466 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .383354 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840563 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5380146 | 5380146 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .329032 | 00 | 2023-09-26 | 2023-09-27 | 2023-10-02 | 2023-09-25 | 0 | 2023-09-25 | ? | 0 | 0006787322 | 20230925.ifs | 2023-09-25 | 2023-09-26 | |||||||
5307700 | 5307700 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .27702 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006737015 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5252954 | 5252954 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .305159 | 00 | 2023-03-23 | 2023-03-24 | 2023-03-29 | 2023-03-22 | 0 | 2023-03-22 | ? | 0 | 0006698874 | 20230322.ifs | 2023-03-22 | 2023-03-23 | |||||||
5162532 | 5162532 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .282798 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629510 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5103632 | 5103632 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .410378 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-30 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006587997 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5030251 | 5030251 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .264678 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536813 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4976196 | 4976196 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .303343 | 00 | 2022-03-24 | 2022-03-25 | 2022-03-30 | 2022-03-23 | 0 | 2022-03-23 | ? | 0 | 0006498180 | 20220323.ifs | 2022-03-23 | 2022-03-24 | |||||||
4877199 | 4877199 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .318897 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417613 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4808713 | 4808713 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .330738 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-30 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371666 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4726025 | 4726025 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .229394 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320345 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4661064 | 4661064 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .220293 | 00 | 2021-03-25 | 2021-03-26 | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281377 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4539249 | 4539249 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .222686 | 00 | 2020-12-14 | 2020-12-15 | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209177 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4467430 | 4467430 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .262069 | 00 | 2020-09-23 | 2020-09-24 | 2020-09-29 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006161965 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4391127 | 4391127 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .238558 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112145 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4252531 | 4252531 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .322419 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072829 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252781 | 4252781 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .322419 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072829 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4068195 | 4068195 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .318685 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0005999990 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4068270 | 4068270 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .318685 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0005999990 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3934100 | 3934100 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .201445 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949074 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3934101 | 3934101 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .201445 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949074 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3781185 | 3781185 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .244177 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898653 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3781208 | 3781208 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .244177 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898653 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3638201 | 3638201 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .19153 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854901 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3638204 | 3638204 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .19153 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854901 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3504288 | 3504288 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .042122 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-04 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005810393 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3506037 | 3506037 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .042122 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-04 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005810393 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3443071 | 3443071 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .247122 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781491 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3443900 | 3443900 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .247122 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781491 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3299267 | 3299267 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .285753 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728810 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3299374 | 3299374 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .285753 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728810 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3000921 | 3000921 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .193334 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632711 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3000942 | 3000942 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .193334 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632711 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2852172 | 2852172 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .247379 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-28 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005571846 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2856001 | 2856001 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .247379 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-28 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005571846 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2686873 | 2686873 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .218004 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501970 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686918 | 2686918 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .218004 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501970 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2601237 | 2601237 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .209014 | 00 | 2017-06-27 | 2017-06-29 | 2017-06-30 | 2017-06-26 | 0 | 2017-06-26 | ? | 0 | 0005454886 | 20170626.ifs | 2017-06-26 | 2017-06-27 | |||||||
2518918 | 2518918 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .159392 | 00 | 2017-03-24 | 2017-03-28 | 2017-03-30 | 2017-03-23 | 0 | 2017-03-23 | ? | 0 | 0005406922 | 20170323.ifs | 2017-03-23 | 2017-03-24 | |||||||
2391717 | 2391717 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .243562 | 00 | 2016-12-22 | 2016-12-27 | 2016-12-29 | 2016-12-21 | 0 | 2016-12-21 | ? | 0 | 0005349810 | 20161221.ifs | 2016-12-21 | 2016-12-22 | |||||||
2301241 | 2301241 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .172126 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005285086 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2225371 | 2225371 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .186021 | 00 | 2016-06-21 | 2016-06-23 | 2016-06-27 | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235499 | 20160620.ifs | 2016-06-20 | 2016-06-21 | |||||||
2140532 | 2140532 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .151805 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-30 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190699 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2075775 | 2075775 | DIVIDEND | CHANGE | 464286681 | 0 | 0 | 1 | 9 | .05066 | 03 | 2015-12-29 | 2015-12-31 | 2016-01-05 | 2015-12-28 | 0 | 2015-12-28 | ? | 0 | 0005141260 | 20151230.ifs | 2015-12-30 | 2015-12-31 | |||||||
2075776 | 2075775 | DIVIDEND | CHANGE | 464286681 | 0 | 0 | 1 | 9 | .056066 | 03 | 2015-12-29 | 2015-12-31 | 2016-01-05 | 2015-12-28 | 1 | 2015-12-28 | 2015-12-30 | 0 | 0005141260 | 20151230.ifs | 2015-12-30 | 2015-12-31 | |||||||
2066763 | 2066763 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 9 | .05066 | 03 | 2015-12-29 | 2015-12-31 | 2016-01-05 | 2015-12-28 | 0 | 2015-12-28 | ? | 0 | 0005141260 | 20151228.ifs | 2015-12-28 | 2015-12-29 | |||||||
2063559 | 2063559 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .262305 | 00 | 2015-12-24 | 2015-12-29 | 2015-12-31 | 2015-12-23 | 0 | 2015-12-23 | ? | 0 | 0005138771 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
1972306 | 1972306 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .206107 | 00 | 2015-09-25 | 2015-09-29 | 2015-10-01 | 2015-09-24 | 0 | 2015-09-24 | ? | 0 | 0005067308 | 20150924.ifs | 2015-09-24 | 2015-09-25 | |||||||
1957695 | 1957695 | EQUITY | CHANGE | 464286681 | ISHARES MSCI USA EQUAL WEIGHTED ETF | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2015-09-01 | ? | 20150902.ifs | 2015-09-02 | 2015-09-03 | ||||||||||
1957696 | 1957695 | EQUITY | CHANGE | 464286681 | ISHARES MSCI USA EQUAL WEIGHTED ETF | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2015-09-02 | ? | 20150902.ifs | 2015-09-02 | 2015-09-03 | ||||||||||
1953939 | 1953939 | CORPACTION | ADD | 464286681 | 04 | # | 2015-09-01 | 464286681 | 04 | ? | 20150901.ifs | 2015-09-01 | 2015-09-02 | ||||||||||||||||
1953940 | 1953940 | CORPACTIONAUX | ADD | 464286681 | 04 | 2015-09-01 | EUSA | ISHARES INC | ISHARES INC. - | EUSA | ISHARES INC | ISHARES MSCI US | 2015-09-01 | ? | 20150901.ifs | 2015-09-01 | 2015-09-02 | ||||||||||||
1953941 | 1953941 | EQUITY | CHANGE | 464286681 | ISHARES MSCI USA ETF | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2013-07-01 | ? | 20150901.ifs | 2015-09-01 | 2015-09-02 | ||||||||||
1953942 | 1953941 | EQUITY | CHANGE | 464286681 | ISHARES MSCI USA EQUAL WEIGHTED ETF | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2015-09-01 | ? | 20150901.ifs | 2015-09-01 | 2015-09-02 | ||||||||||
1893699 | 1893699 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .202937 | 00 | 2015-06-24 | 2015-06-26 | 2015-06-30 | 2015-06-23 | 0 | 2015-06-23 | ? | 0 | 0005018429 | 20150623.ifs | 2015-06-23 | 2015-06-24 | |||||||
1819344 | 1819344 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .206825 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972925 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1740625 | 1740625 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .186429 | 00 | 2014-12-24 | 2014-12-29 | 2014-12-31 | 2014-12-23 | 0 | 2014-12-23 | ? | 0 | 0004919680 | 20141223.ifs | 2014-12-23 | 2014-12-24 | |||||||
1636588 | 1636588 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .207129 | 00 | 2014-09-24 | 2014-09-26 | 2014-09-30 | 2014-09-23 | 0 | 2014-09-23 | ? | 0 | 0004846717 | 20140923.ifs | 2014-09-23 | 2014-09-24 | |||||||
1558993 | 1558993 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .308418 | 00 | 2014-06-25 | 2014-06-27 | 2014-07-01 | 2014-06-24 | 0 | 2014-06-24 | ? | 0 | 0004801516 | 20140624.ifs | 2014-06-24 | 2014-06-25 | |||||||
1474626 | 1474626 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .145842 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754620 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1389426 | 1389426 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .279655 | 00 | 2013-12-23 | 2013-12-26 | 2013-12-30 | 2013-12-20 | 0 | 2013-12-20 | ? | 0 | 0004698517 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1294316 | 1294316 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .169241 | 00 | 2013-09-24 | 2013-09-26 | 2013-09-30 | 2013-09-23 | 0 | 2013-09-23 | ? | 0 | 0004632649 | 20130923.ifs | 2013-09-23 | 2013-09-24 | |||||||
1226804 | 1226804 | CORPACTION | ADD | 464286681 | 04 | # | 2013-07-01 | 464286681 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1226805 | 1226805 | CORPACTIONAUX | ADD | 464286681 | 04 | 2013-07-01 | EUSA | ISHARES INC | ISHARES INC. - | EUSA | ISHARES INC | ISHARES MSCI US | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1226806 | 1226806 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX FD | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2011-08-08 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1226807 | 1226806 | EQUITY | CHANGE | 464286681 | ISHARES MSCI USA ETF | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1219043 | 1219043 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .175675 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-03 | 2013-06-26 | 0 | 2013-06-26 | ? | 0 | 0004590012 | 20130626.ifs | 2013-06-26 | 2013-06-27 | |||||||
1140259 | 1140259 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .154723 | 00 | 2013-03-25 | 2013-03-27 | 2013-04-01 | 2013-03-22 | 0 | 2013-03-22 | ? | 0 | 0004545100 | 20130322.ifs | 2013-03-22 | 2013-03-23 | |||||||
1047935 | 1047935 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .207616 | 00 | 2012-12-19 | 2012-12-21 | 2012-12-26 | 2012-12-18 | 0 | 2012-12-18 | ? | 0 | 0004485686 | 20121218.ifs | 2012-12-18 | 2012-12-19 | |||||||
961931 | 961931 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .157921 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-21 | 0 | 2012-09-21 | ? | 0 | 0004432598 | 20120921.ifs | 2012-09-21 | 2012-09-22 | |||||||
891195 | 891195 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .141055 | 00 | 2012-06-22 | 2012-06-26 | 2012-06-28 | 2012-06-21 | 0 | 2012-06-21 | ? | 0 | 0004390083 | 20120621.ifs | 2012-06-21 | 2012-06-22 | |||||||
808523 | 808523 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .12962 | 00 | 2012-03-23 | 2012-03-27 | 2012-03-29 | 2012-03-22 | 0 | 2012-03-22 | ? | 0 | 0004348941 | 20120322.ifs | 2012-03-22 | 2012-03-23 | |||||||
651976 | 651976 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .069127 | 00 | 2011-09-26 | 2011-09-28 | 2011-09-30 | 2011-09-23 | 0 | 2011-09-23 | ? | 0 | 0004246404 | 20110923.ifs | 2011-09-23 | 2011-09-24 | |||||||
607293 | 607293 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX FD | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2010-09-24 | ? | 20110808.ifs | 2011-08-08 | 2011-08-09 | ||||||||||
607294 | 607293 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX FD | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2011-08-08 | ? | 20110808.ifs | 2011-08-08 | 2011-08-09 | ||||||||||
607295 | 607295 | EXCHANGE | CHANGE | 464286681 | 04 | 2010-05-07 | 2011-08-05 | EUSA | 0 | A | ? | 2010-05-11 | 20110808.ifs | 2011-08-08 | 2011-08-09 | ||||||||||||||
607296 | 607295 | EXCHANGE | CHANGE | 464286681 | 04 | 2010-05-07 | 2011-08-05 | EUSA | 0 | A | ? | 2011-08-08 | 20110808.ifs | 2011-08-08 | 2011-08-09 | ||||||||||||||
567255 | 567255 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .064379 | 00 | 2011-06-23 | 2011-06-27 | 2011-06-29 | 2011-06-22 | 0 | 2011-06-22 | ? | 0 | 0004204616 | 20110622.ifs | 2011-06-22 | 2011-06-23 | |||||||
478604 | 478604 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .114314 | 00 | 2011-03-24 | 2011-03-28 | 2011-03-30 | 2011-03-23 | 0 | 2011-03-23 | ? | 0 | 0004163067 | 20110323.ifs | 2011-03-23 | 2011-03-24 | |||||||
391372 | 391372 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .20404 | 00 | 2010-12-23 | 2010-12-28 | 2010-12-30 | 2010-12-22 | 0 | 2010-12-22 | ? | 0 | 0004116132 | 20101222.ifs | 2010-12-22 | 2010-12-23 | |||||||
313515 | 313515 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX FD | 0 | A | 2000-05-18 | ? | 0 | no | no | no | ? | 2010-05-11 | ? | 20100924.ifs | 2010-09-24 | 2010-09-25 | ||||||||||
313516 | 313515 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX FD | 0 | A | 2000-05-18 | ? | 4 | no | no | no | ? | 2010-09-24 | ? | 20100924.ifs | 2010-09-24 | 2010-09-25 | ||||||||||
313215 | 313215 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 0 | .128562 | 00 | 2010-09-24 | 2010-09-28 | 2010-09-30 | 2010-09-23 | 0 | 2010-09-23 | ? | 0 | 0004063839 | 20100923.ifs | 2010-09-23 | 2010-09-24 | |||||||
225722 | 225722 | DIVIDEND | ADD | 464286681 | 0 | 0 | 1 | 4 | .06626 | 00 | 2010-06-23 | 2010-06-25 | 2010-06-29 | 2010-06-22 | 0 | 2010-06-22 | ? | 0 | 0004022014 | 20100622.ifs | 2010-06-22 | 2010-06-23 | |||||||
189562 | 189562 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX | 0 | A | 2000-05-18 | ? | 0 | no | no | no | ? | 2010-05-10 | ? | 20100511.ifs | 2010-05-11 | 2010-05-12 | ||||||||||
189563 | 189562 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX FD | 0 | A | 2000-05-18 | ? | 0 | no | no | no | ? | 2010-05-11 | ? | 20100511.ifs | 2010-05-11 | 2010-05-12 | ||||||||||
189564 | 189564 | EXCHANGE | ADD | 464286681 | 04 | 2010-05-10 | 2010-05-10 | EUSA | 0 | A | ? | 2010-05-11 | 20100511.ifs | 2010-05-11 | 2010-05-12 | ||||||||||||||
189565 | 189565 | EXCHANGE | DELETE | 464286681 | 04 | 2010-05-10 | 2010-05-10 | EUSA | 0 | A | ? | 2010-05-11 | 20100511.ifs | 2010-05-11 | 2010-05-12 | ||||||||||||||
189566 | 189566 | EXCHANGE | ADD | 464286681 | 04 | 2010-05-07 | 2010-05-07 | EUSA | 0 | A | ? | 2010-05-11 | 20100511.ifs | 2010-05-11 | 2010-05-12 | ||||||||||||||
188534 | 188534 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX | 0 | 7 | 2000-05-18 | ? | 0 | no | no | no | ? | 2000-05-18 | ? | 20100510.ifs | 2010-05-10 | 2010-05-11 | ||||||||||
188535 | 188534 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX | 0 | A | 2000-05-18 | ? | 0 | no | no | no | ? | 2010-05-10 | ? | 20100510.ifs | 2010-05-10 | 2010-05-11 | ||||||||||
188536 | 188536 | EXCHANGE | DELETE | 464286681 | 04 | 2010-05-07 | 2010-05-07 | EUSA | 0 | A | 2010-05-07 | ? | 20100510.ifs | 2010-05-10 | 2010-05-11 | ||||||||||||||
187370 | 187370 | EXCHANGE | ADD | 464286681 | 04 | 2010-05-07 | 2010-05-07 | EUSA | 0 | 7 | 2010-05-07 | ? | 20100507.ifs | 2010-05-07 | 2010-05-08 | ||||||||||||||
188367 | 188367 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX | N | 7 | 2000-05-18 | ? | 0 | no | no | no | ? | 2000-05-18 | ? | 20100507.ifs | 2010-05-07 | 2010-05-08 | ||||||||||
188368 | 188367 | EQUITY | CHANGE | 464286681 | MSCI USA INDEX | 0 | 7 | 2000-05-18 | ? | 0 | no | no | no | ? | 2000-05-18 | ? | 20100507.ifs | 2010-05-07 | 2010-05-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 = 159710
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