INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 180 | 174 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 26.31 % | 29.49 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:152112 |
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 | ||
5573851 | 5573851 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .33964 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931037 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5519555 | 5519555 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .30376 | 00 | 2024-03-21 | 2024-03-22 | 2024-03-27 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892633 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5450362 | 5450362 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .481558 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840552 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5380083 | 5380083 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .498787 | 00 | 2023-09-26 | 2023-09-27 | 2023-10-02 | 2023-09-25 | 0 | 2023-09-25 | ? | 0 | 0006787311 | 20230925.ifs | 2023-09-25 | 2023-09-26 | |||||||
5307595 | 5307595 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .310132 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006737004 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5252900 | 5252900 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .198082 | 00 | 2023-03-23 | 2023-03-24 | 2023-03-29 | 2023-03-22 | 0 | 2023-03-22 | ? | 0 | 0006698863 | 20230322.ifs | 2023-03-22 | 2023-03-23 | |||||||
5162428 | 5162428 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .464892 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629501 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5103569 | 5103569 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .430175 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-30 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006587986 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5030147 | 5030147 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .340699 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536791 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4976135 | 4976135 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .250542 | 00 | 2022-03-24 | 2022-03-25 | 2022-03-30 | 2022-03-23 | 0 | 2022-03-23 | ? | 0 | 0006498172 | 20220323.ifs | 2022-03-23 | 2022-03-24 | |||||||
4877097 | 4877097 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .39812 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417592 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4808650 | 4808650 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .329555 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-30 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371658 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4725924 | 4725924 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .248998 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320417 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4661001 | 4661001 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .184754 | 00 | 2021-03-25 | 2021-03-26 | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281429 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4539145 | 4539145 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .38229 | 00 | 2020-12-14 | 2020-12-15 | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209251 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4467368 | 4467368 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .373492 | 00 | 2020-09-23 | 2020-09-24 | 2020-09-29 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006161957 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4391025 | 4391025 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .277124 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112124 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4252414 | 4252414 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .270098 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072821 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252638 | 4252638 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .270098 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072821 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4067961 | 4067961 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .40554 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000072 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4068040 | 4068040 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .40554 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000072 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3933974 | 3933974 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .353435 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949066 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3933975 | 3933975 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .353435 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949066 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3780981 | 3780981 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .294216 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898632 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3781004 | 3781004 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .294216 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898632 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3638075 | 3638075 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .21424 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854893 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3638078 | 3638078 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .21424 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854893 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3442949 | 3442949 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .360839 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781484 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3443779 | 3443779 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .360839 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781484 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3299141 | 3299141 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .255574 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728802 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3299248 | 3299248 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .255574 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728802 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3000793 | 3000793 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .14933 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632749 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3000814 | 3000814 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .14933 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632749 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2839566 | 2839566 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .261601 | 00 | 2017-12-19 | 2017-12-20 | 2017-12-26 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005564356 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2686745 | 2686745 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .20504 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502008 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686792 | 2686792 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .20504 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502008 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2601187 | 2601187 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .182649 | 00 | 2017-06-27 | 2017-06-29 | 2017-06-30 | 2017-06-26 | 0 | 2017-06-26 | ? | 0 | 0005454920 | 20170626.ifs | 2017-06-26 | 2017-06-27 | |||||||
2518854 | 2518854 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .116571 | 00 | 2017-03-24 | 2017-03-28 | 2017-03-30 | 2017-03-23 | 0 | 2017-03-23 | ? | 0 | 0005406969 | 20170323.ifs | 2017-03-23 | 2017-03-24 | |||||||
2439862 | 2439862 | EQUITY | CHANGE | 464288778 | ISHARES U.S. REGIONAL BANKS ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2439863 | 2439862 | EQUITY | CHANGE | 464288778 | ISHARES U.S. REGIONAL BANKS ETF | 0 | A | 2006-05-05 | ? | 4 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2388207 | 2388207 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .172905 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-28 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346378 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2301176 | 2301176 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .194966 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005285137 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2225298 | 2225298 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .178342 | 00 | 2016-06-21 | 2016-06-23 | 2016-06-27 | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235506 | 20160620.ifs | 2016-06-20 | 2016-06-21 | |||||||
2140467 | 2140467 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .143024 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-30 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190704 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2063473 | 2063473 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .188883 | 00 | 2015-12-24 | 2015-12-29 | 2015-12-31 | 2015-12-23 | 0 | 2015-12-23 | ? | 0 | 0005138781 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
1972241 | 1972241 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .134947 | 00 | 2015-09-25 | 2015-09-29 | 2015-10-01 | 2015-09-24 | 0 | 2015-09-24 | ? | 0 | 0005067362 | 20150924.ifs | 2015-09-24 | 2015-09-25 | |||||||
1893622 | 1893622 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .200078 | 00 | 2015-06-24 | 2015-06-26 | 2015-06-30 | 2015-06-23 | 0 | 2015-06-23 | ? | 0 | 0005018437 | 20150623.ifs | 2015-06-23 | 2015-06-24 | |||||||
1819283 | 1819283 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .099533 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972930 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1740537 | 1740537 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .20513 | 00 | 2014-12-24 | 2014-12-29 | 2014-12-31 | 2014-12-23 | 0 | 2014-12-23 | ? | 0 | 0004919684 | 20141223.ifs | 2014-12-23 | 2014-12-24 | |||||||
1636512 | 1636512 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .151602 | 00 | 2014-09-24 | 2014-09-26 | 2014-09-30 | 2014-09-23 | 0 | 2014-09-23 | ? | 0 | 0004846725 | 20140923.ifs | 2014-09-23 | 2014-09-24 | |||||||
1557038 | 1557038 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .141215 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800694 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474533 | 1474533 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .08933 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754626 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1389361 | 1389361 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .193523 | 00 | 2013-12-23 | 2013-12-26 | 2013-12-30 | 2013-12-20 | 0 | 2013-12-20 | ? | 0 | 0004698572 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1294251 | 1294251 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .119208 | 00 | 2013-09-24 | 2013-09-26 | 2013-09-30 | 2013-09-23 | 0 | 2013-09-23 | ? | 0 | 0004632702 | 20130923.ifs | 2013-09-23 | 2013-09-24 | |||||||
1227061 | 1227061 | CORPACTION | ADD | 464288778 | 04 | # | 2013-07-01 | 464288778 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227062 | 1227062 | CORPACTIONAUX | ADD | 464288778 | 04 | 2013-07-01 | IAT | ISHARES TR | ISHARES TRUST - | IAT | ISHARES TR | ISHARES U.S. RE | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227063 | 1227063 | EQUITY | CHANGE | 464288778 | DJ US REGNL BKS INDEX FD | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2008-03-13 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1227064 | 1227063 | EQUITY | CHANGE | 464288778 | ISHARES U.S. REGIONAL BANKS ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1217521 | 1217521 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .124951 | 00 | 2013-06-26 | 2013-06-28 | 2013-07-02 | 2013-06-25 | 0 | 2013-06-25 | ? | 0 | 0004588948 | 20130625.ifs | 2013-06-25 | 2013-06-26 | |||||||
1140190 | 1140190 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .078 | 00 | 2013-03-25 | 2013-03-27 | 2013-04-01 | 2013-03-22 | 0 | 2013-03-22 | ? | 0 | 0004545080 | 20130322.ifs | 2013-03-22 | 2013-03-23 | |||||||
1060967 | 1060967 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 9 | .012303 | 03 | 2012-12-27 | 2012-12-31 | 2013-01-03 | 2012-12-26 | 0 | 2012-12-26 | ? | 0 | 0004496066 | 20121226.ifs | 2012-12-26 | 2012-12-27 | |||||||
1047868 | 1047868 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .170579 | 00 | 2012-12-19 | 2012-12-21 | 2012-12-26 | 2012-12-18 | 0 | 2012-12-18 | ? | 0 | 0004485665 | 20121218.ifs | 2012-12-18 | 2012-12-19 | |||||||
963413 | 963413 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .101048 | 00 | 2012-09-25 | 2012-09-27 | 2012-10-01 | 2012-09-24 | 0 | 2012-09-24 | ? | 0 | 0004433161 | 20120924.ifs | 2012-09-24 | 2012-09-25 | |||||||
887468 | 887468 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .129139 | 00 | 2012-06-19 | 2012-06-21 | 2012-06-25 | 2012-06-18 | 0 | 2012-06-18 | ? | 0 | 0004387640 | 20120618.ifs | 2012-06-18 | 2012-06-19 | |||||||
809526 | 809526 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .066971 | 00 | 2012-03-26 | 2012-03-28 | 2012-03-30 | 2012-03-23 | 0 | 2012-03-23 | ? | 0 | 0004349518 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
650812 | 650812 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .113204 | 00 | 2011-09-23 | 2011-09-27 | 2011-09-29 | 2011-09-22 | 0 | 2011-09-22 | ? | 0 | 0004245766 | 20110922.ifs | 2011-09-22 | 2011-09-23 | |||||||
568278 | 568278 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .099316 | 00 | 2011-06-24 | 2011-06-28 | 2011-06-30 | 2011-06-23 | 0 | 2011-06-23 | ? | 0 | 0004205166 | 20110623.ifs | 2011-06-23 | 2011-06-24 | |||||||
479649 | 479649 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .061038 | 00 | 2011-03-25 | 2011-03-29 | 2011-03-31 | 2011-03-24 | 0 | 2011-03-24 | ? | 0 | 0004163800 | 20110324.ifs | 2011-03-24 | 2011-03-25 | |||||||
389314 | 389314 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .081174 | 00 | 2010-12-22 | 2010-12-27 | 2010-12-29 | 2010-12-21 | 0 | 2010-12-21 | ? | 0 | 0004114324 | 20101221.ifs | 2010-12-21 | 2010-12-22 | |||||||
302841 | 302841 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-09-23 | 2010-09-27 | 2010-09-29 | 2010-09-07 | 0 | 2010-09-07 | ? | 0 | 0004058551 | 20100907.ifs | 2010-09-07 | 2010-09-08 | |||||||
226810 | 226810 | DIVIDEND | DELETE | 464288778 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 0 | 2010-06-03 | ? | 0 | 0004016440 | 20100623.ifs | 2010-06-23 | 2010-06-24 | |||||||
226811 | 226811 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .06587 | 00 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 1 | 2010-06-03 | 2010-06-23 | 0 | 0004016440 | 20100623.ifs | 2010-06-23 | 2010-06-24 | |||||||
213134 | 213134 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 0 | 2010-06-03 | ? | 0 | 0004016440 | 20100603.ifs | 2010-06-03 | 2010-06-04 | |||||||
139610 | 139610 | DIVIDEND | DELETE | 464288778 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 0 | 2010-03-18 | ? | 0 | 0003978841 | 20100324.ifs | 2010-03-24 | 2010-04-07 | |||||||
139611 | 139611 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .05069 | 00 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 1 | 2010-03-18 | 2010-03-24 | 0 | 0003978841 | 20100324.ifs | 2010-03-24 | 2010-04-07 | |||||||
134911 | 134911 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 0 | 2010-03-18 | ? | 0 | 0003978841 | 20100318.ifs | 2010-03-18 | 2010-04-07 | |||||||
62780 | 62780 | DIVIDEND | ADD | 464288778 | 0 | 0 | 1 | 0 | .08577 | 00 | 2009-12-23 | 2009-12-28 | 2009-12-30 | 2009-12-22 | 0 | 2009-12-22 | ? | 0 | 0003936254 | 20091222.ifs | 2009-12-22 | 2010-04-07 |
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 = 152112
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