INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 229 | 207 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 162.02 % | 32.1 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:152117 |
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 | ||
5573846 | 5573846 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .027035 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931030 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5519550 | 5519550 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .105377 | 35 | 2024-03-21 | 2024-03-22 | 2024-03-27 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892626 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5501486 | 5501486 | DIVIDEND | CHANGE | 464288828 | 0 | 0 | 6 | 0 | 4 | 0 | 11 | 2024-03-07 | 2024-03-04 | 2024-03-06 | 2023-12-19 | 1 | 2023-12-22 | 2024-02-21 | 0 | 0006847469 | 20240222.ifs | 2024-02-22 | 2024-02-23 | ||||||
5501487 | 5501486 | DIVIDEND | CHANGE | 464288828 | 0 | 0 | 6 | 0 | 5 | 0 | 11 | 2024-03-07 | 2024-03-04 | 2024-03-06 | 2023-12-19 | 1 | 2023-12-22 | 2024-02-21 | 0 | 0006847469 | 20240222.ifs | 2024-02-22 | 2024-02-23 | ||||||
5501322 | 5501322 | DIVIDEND | CHANGE | 464288828 | 0 | 0 | 6 | 0 | 5 | 0 | 11 | 2024-03-07 | 2024-03-04 | 2024-03-06 | 2023-12-19 | 0 | 2023-12-22 | ? | 0 | 0006847469 | 20240221.ifs | 2024-02-21 | 2024-02-22 | ||||||
5501323 | 5501322 | DIVIDEND | CHANGE | 464288828 | 0 | 0 | 6 | 0 | 4 | 0 | 11 | 2024-03-07 | 2024-03-04 | 2024-03-06 | 2023-12-19 | 1 | 2023-12-22 | 2024-02-21 | 0 | 0006847469 | 20240221.ifs | 2024-02-21 | 2024-02-22 | ||||||
5460758 | 5460758 | DIVIDEND | CHANGE | 464288828 | 0 | 0 | 6 | 0 | 4 | 11 | 2024-03-07 | 2024-03-04 | 2024-03-06 | 2023-12-19 | 0 | 2023-12-22 | ? | 0 | 0006847469 | 20231226.ifs | 2023-12-26 | 2023-12-27 | |||||||
5460759 | 5460758 | DIVIDEND | CHANGE | 464288828 | 0 | 0 | 6 | 0 | 5 | 0 | 11 | 2024-03-07 | 2024-03-04 | 2024-03-06 | 2023-12-19 | 0 | 2023-12-22 | ? | 0 | 0006847469 | 20231226.ifs | 2023-12-26 | 2023-12-27 | ||||||
5459598 | 5459598 | DIVIDEND | ADD | 464288828 | 0 | 0 | 6 | 0 | 4 | 11 | 2024-03-07 | 2024-03-04 | 2024-03-06 | 2023-12-19 | 0 | 2023-12-22 | ? | 0 | 0006847469 | 20231222.ifs | 2023-12-22 | 2023-12-23 | |||||||
5459599 | 5459599 | SPLIT | ADD | 464288828 | .2 | 2024-03-07 | 11 | 2023-12-22 | ? | 20231222.ifs | 2023-12-22 | 2023-12-23 | |||||||||||||||||
5450357 | 5450357 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .504815 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840545 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5380078 | 5380078 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .955631 | 00 | 2023-09-26 | 2023-09-27 | 2023-10-02 | 2023-09-25 | 0 | 2023-09-25 | ? | 0 | 0006787304 | 20230925.ifs | 2023-09-25 | 2023-09-26 | |||||||
5307590 | 5307590 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .120602 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006736997 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5252895 | 5252895 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .495355 | 00 | 2023-03-23 | 2023-03-24 | 2023-03-29 | 2023-03-22 | 0 | 2023-03-22 | ? | 0 | 0006698856 | 20230322.ifs | 2023-03-22 | 2023-03-23 | |||||||
5162423 | 5162423 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .710886 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629494 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5103564 | 5103564 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .667646 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-30 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006587979 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5030142 | 5030142 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .170201 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536786 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4976130 | 4976130 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .42687 | 00 | 2022-03-24 | 2022-03-25 | 2022-03-30 | 2022-03-23 | 0 | 2022-03-23 | ? | 0 | 0006498167 | 20220323.ifs | 2022-03-23 | 2022-03-24 | |||||||
4877092 | 4877092 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .359507 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417587 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4808645 | 4808645 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .684083 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-30 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371653 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4725919 | 4725919 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .174456 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320412 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4660996 | 4660996 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .420315 | 00 | 2021-03-25 | 2021-03-26 | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281424 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4539140 | 4539140 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .275225 | 00 | 2020-12-14 | 2020-12-15 | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209246 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4467363 | 4467363 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .504201 | 00 | 2020-09-23 | 2020-09-24 | 2020-09-29 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006161952 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4391020 | 4391020 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .173845 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112119 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4252404 | 4252404 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .29865 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072816 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252628 | 4252628 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .29865 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072816 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4067951 | 4067951 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .415253 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000077 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4068030 | 4068030 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .415253 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000077 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3933964 | 3933964 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .497595 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949061 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3933965 | 3933965 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .497595 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949061 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3780971 | 3780971 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .126706 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898627 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3780994 | 3780994 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .126706 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898627 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3638065 | 3638065 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .125104 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854889 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3638068 | 3638068 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .125104 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854889 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3504270 | 3504270 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | 6.212357 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-04 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005810387 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3506019 | 3506019 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | 6.212357 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-04 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005810387 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3442939 | 3442939 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .094887 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781479 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3443769 | 3443769 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .094887 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781479 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3299131 | 3299131 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .110338 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728797 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3299238 | 3299238 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .110338 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728797 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3000783 | 3000783 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .117031 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632743 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3000804 | 3000804 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .117031 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632743 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2839561 | 2839561 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .095021 | 00 | 2017-12-19 | 2017-12-20 | 2017-12-26 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005564350 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2686735 | 2686735 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .072357 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502002 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686782 | 2686782 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .072357 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502002 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2601182 | 2601182 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .079257 | 00 | 2017-06-27 | 2017-06-29 | 2017-06-30 | 2017-06-26 | 0 | 2017-06-26 | ? | 0 | 0005454911 | 20170626.ifs | 2017-06-26 | 2017-06-27 | |||||||
2518849 | 2518849 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .050699 | 00 | 2017-03-24 | 2017-03-28 | 2017-03-30 | 2017-03-23 | 0 | 2017-03-23 | ? | 0 | 0005406960 | 20170323.ifs | 2017-03-23 | 2017-03-24 | |||||||
2439872 | 2439872 | EQUITY | CHANGE | 464288828 | ISHARES U.S. HEALTHCARE PROVIDERS ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2439873 | 2439872 | EQUITY | CHANGE | 464288828 | ISHARES U.S. HEALTHCARE PROVIDERS ETF | 0 | A | 2006-05-05 | ? | 4 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2388202 | 2388202 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .103918 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-28 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346391 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2301171 | 2301171 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .070888 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005285128 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2225291 | 2225291 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .087694 | 00 | 2016-06-21 | 2016-06-23 | 2016-06-27 | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235522 | 20160620.ifs | 2016-06-20 | 2016-06-21 | |||||||
2140462 | 2140462 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .055679 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-30 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190717 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2063468 | 2063468 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .132518 | 00 | 2015-12-24 | 2015-12-29 | 2015-12-31 | 2015-12-23 | 0 | 2015-12-23 | ? | 0 | 0005138818 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
1972236 | 1972236 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .032967 | 00 | 2015-09-25 | 2015-09-29 | 2015-10-01 | 2015-09-24 | 0 | 2015-09-24 | ? | 0 | 0005067353 | 20150924.ifs | 2015-09-24 | 2015-09-25 | |||||||
1893617 | 1893617 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .047959 | 00 | 2015-06-24 | 2015-06-26 | 2015-06-30 | 2015-06-23 | 0 | 2015-06-23 | ? | 0 | 0005018454 | 20150623.ifs | 2015-06-23 | 2015-06-24 | |||||||
1819278 | 1819278 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .039325 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972943 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1740532 | 1740532 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .075137 | 00 | 2014-12-24 | 2014-12-29 | 2014-12-31 | 2014-12-23 | 0 | 2014-12-23 | ? | 0 | 0004919653 | 20141223.ifs | 2014-12-23 | 2014-12-24 | |||||||
1636507 | 1636507 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .041707 | 00 | 2014-09-24 | 2014-09-26 | 2014-09-30 | 2014-09-23 | 0 | 2014-09-23 | ? | 0 | 0004846737 | 20140923.ifs | 2014-09-23 | 2014-09-24 | |||||||
1557033 | 1557033 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .057467 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800706 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474528 | 1474528 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .042162 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754639 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1389356 | 1389356 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .052934 | 00 | 2013-12-23 | 2013-12-26 | 2013-12-30 | 2013-12-20 | 0 | 2013-12-20 | ? | 0 | 0004698562 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1294246 | 1294246 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .086554 | 00 | 2013-09-24 | 2013-09-26 | 2013-09-30 | 2013-09-23 | 0 | 2013-09-23 | ? | 0 | 0004632693 | 20130923.ifs | 2013-09-23 | 2013-09-24 | |||||||
1226933 | 1226933 | CORPACTION | ADD | 464288828 | 04 | # | 2013-07-01 | 464288828 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1226934 | 1226934 | CORPACTIONAUX | ADD | 464288828 | 04 | 2013-07-01 | IHF | ISHARES TR | ISHARES TRUST D | IHF | ISHARES TR | ISHARES U.S. HE | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1226935 | 1226935 | EQUITY | CHANGE | 464288828 | DJ US HLTHCR PROVDRS INDX FD | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2008-03-14 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1226936 | 1226935 | EQUITY | CHANGE | 464288828 | ISHARES U.S. HEALTHCARE PROVIDERS ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1217516 | 1217516 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .039725 | 00 | 2013-06-26 | 2013-06-28 | 2013-07-02 | 2013-06-25 | 0 | 2013-06-25 | ? | 0 | 0004588938 | 20130625.ifs | 2013-06-25 | 2013-06-26 | |||||||
1140185 | 1140185 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .038724 | 00 | 2013-03-25 | 2013-03-27 | 2013-04-01 | 2013-03-22 | 0 | 2013-03-22 | ? | 0 | 0004545070 | 20130322.ifs | 2013-03-22 | 2013-03-23 | |||||||
1047863 | 1047863 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .417917 | 00 | 2012-12-19 | 2012-12-21 | 2012-12-26 | 2012-12-18 | 0 | 2012-12-18 | ? | 0 | 0004485654 | 20121218.ifs | 2012-12-18 | 2012-12-19 | |||||||
963408 | 963408 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .040381 | 00 | 2012-09-25 | 2012-09-27 | 2012-10-01 | 2012-09-24 | 0 | 2012-09-24 | ? | 0 | 0004433150 | 20120924.ifs | 2012-09-24 | 2012-09-25 | |||||||
887463 | 887463 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .029217 | 00 | 2012-06-19 | 2012-06-21 | 2012-06-25 | 2012-06-18 | 0 | 2012-06-18 | ? | 0 | 0004387629 | 20120618.ifs | 2012-06-18 | 2012-06-19 | |||||||
809521 | 809521 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .135939 | 00 | 2012-03-26 | 2012-03-28 | 2012-03-30 | 2012-03-23 | 0 | 2012-03-23 | ? | 0 | 0004349500 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
650807 | 650807 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .024509 | 00 | 2011-09-23 | 2011-09-27 | 2011-09-29 | 2011-09-22 | 0 | 2011-09-22 | ? | 0 | 0004245755 | 20110922.ifs | 2011-09-22 | 2011-09-23 | |||||||
568273 | 568273 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .018533 | 00 | 2011-06-24 | 2011-06-28 | 2011-06-30 | 2011-06-23 | 0 | 2011-06-23 | ? | 0 | 0004205156 | 20110623.ifs | 2011-06-23 | 2011-06-24 | |||||||
479644 | 479644 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .002587 | 00 | 2011-03-25 | 2011-03-29 | 2011-03-31 | 2011-03-24 | 0 | 2011-03-24 | ? | 0 | 0004163790 | 20110324.ifs | 2011-03-24 | 2011-03-25 | |||||||
389309 | 389309 | DIVIDEND | ADD | 464288828 | 0 | 0 | 1 | 0 | .081062 | 00 | 2010-12-22 | 2010-12-27 | 2010-12-29 | 2010-12-21 | 0 | 2010-12-21 | ? | 0 | 0004114346 | 20101221.ifs | 2010-12-21 | 2010-12-22 |
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 = 152117
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