INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 198 | 173 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 31.01 % | 54.83 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:152114 |
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 | ||
5573843 | 5573843 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .505014 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931212 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5519547 | 5519547 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .594297 | 00 | 2024-03-21 | 2024-03-22 | 2024-03-27 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892826 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5450354 | 5450354 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .96786 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840893 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5380075 | 5380075 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .499183 | 00 | 2023-09-26 | 2023-09-27 | 2023-10-02 | 2023-09-25 | 0 | 2023-09-25 | ? | 0 | 0006787375 | 20230925.ifs | 2023-09-25 | 2023-09-26 | |||||||
5307587 | 5307587 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .54681 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006737187 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5253835 | 5253835 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .785189 | 00 | 2023-03-23 | 2023-03-24 | 2023-03-29 | 2023-03-22 | 0 | 2023-03-23 | ? | 0 | 0006698975 | 20230323.ifs | 2023-03-23 | 2023-03-24 | |||||||
5162420 | 5162420 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | 1.136398 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629702 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5103561 | 5103561 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | 1.223231 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-30 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006588026 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5030139 | 5030139 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .575448 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536934 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4976127 | 4976127 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .570048 | 00 | 2022-03-24 | 2022-03-25 | 2022-03-30 | 2022-03-23 | 0 | 2022-03-23 | ? | 0 | 0006498241 | 20220323.ifs | 2022-03-23 | 2022-03-24 | |||||||
4877089 | 4877089 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .566144 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417735 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4808642 | 4808642 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .565735 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-30 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371815 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4725916 | 4725916 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .210691 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320561 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4660993 | 4660993 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .260116 | 00 | 2021-03-25 | 2021-03-26 | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281493 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4539137 | 4539137 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .221311 | 00 | 2020-12-14 | 2020-12-15 | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209413 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4467360 | 4467360 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .426312 | 00 | 2020-09-23 | 2020-09-24 | 2020-09-29 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006162000 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4391017 | 4391017 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .190617 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112213 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4252399 | 4252399 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .299614 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072881 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252621 | 4252621 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .299614 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072881 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4067945 | 4067945 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .306515 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000248 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4068024 | 4068024 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .306515 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000248 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3933958 | 3933958 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .253283 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949142 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3933959 | 3933959 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .253283 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949142 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3780965 | 3780965 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .237799 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898868 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3780988 | 3780988 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .237799 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898868 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3638059 | 3638059 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .228635 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005855004 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3638062 | 3638062 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .228635 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005855004 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3442933 | 3442933 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .339539 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781553 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3443763 | 3443763 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .339539 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781553 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3299125 | 3299125 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .172831 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728840 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3299232 | 3299232 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .172831 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728840 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3000777 | 3000777 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .179825 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632769 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3000798 | 3000798 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .179825 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632769 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2839558 | 2839558 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .158252 | 00 | 2017-12-19 | 2017-12-20 | 2017-12-26 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005564372 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2686729 | 2686729 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .153647 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502057 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686776 | 2686776 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .153647 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502057 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2642246 | 2642246 | CORPACTION | ADD | 464288851 | 04 | X | 2017-08-02 | 464288851 | 12 | 2017-08-02 | 20170802.ifs | 2017-08-02 | 2017-08-03 | ||||||||||||||||
2601179 | 2601179 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .171774 | 00 | 2017-06-27 | 2017-06-29 | 2017-06-30 | 2017-06-26 | 0 | 2017-06-26 | ? | 0 | 0005454916 | 20170626.ifs | 2017-06-26 | 2017-06-27 | |||||||
2518846 | 2518846 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .12918 | 00 | 2017-03-24 | 2017-03-28 | 2017-03-30 | 2017-03-23 | 0 | 2017-03-23 | ? | 0 | 0005406965 | 20170323.ifs | 2017-03-23 | 2017-03-24 | |||||||
2439878 | 2439878 | EQUITY | CHANGE | 464288851 | ISHARES U.S. OIL & GAS EXPLORATION & PRODUCTION ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2439879 | 2439878 | EQUITY | CHANGE | 464288851 | ISHARES U.S. OIL & GAS EXPLORATION & PRODUCTION ETF | 0 | A | 2006-05-05 | ? | 4 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2388199 | 2388199 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .136985 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-28 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346382 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2301168 | 2301168 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .156089 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005285133 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2225288 | 2225288 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .173283 | 00 | 2016-06-21 | 2016-06-23 | 2016-06-27 | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235513 | 20160620.ifs | 2016-06-20 | 2016-06-21 | |||||||
2140459 | 2140459 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .177992 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-30 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190709 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2063464 | 2063464 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .251239 | 00 | 2015-12-24 | 2015-12-29 | 2015-12-31 | 2015-12-23 | 0 | 2015-12-23 | ? | 0 | 0005138811 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
1972233 | 1972233 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .286835 | 00 | 2015-09-25 | 2015-09-29 | 2015-10-01 | 2015-09-24 | 0 | 2015-09-24 | ? | 0 | 0005067358 | 20150924.ifs | 2015-09-24 | 2015-09-25 | |||||||
1893614 | 1893614 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .277394 | 00 | 2015-06-24 | 2015-06-26 | 2015-06-30 | 2015-06-23 | 0 | 2015-06-23 | ? | 0 | 0005018444 | 20150623.ifs | 2015-06-23 | 2015-06-24 | |||||||
1819275 | 1819275 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .260881 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972935 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1740529 | 1740529 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .262473 | 00 | 2014-12-24 | 2014-12-29 | 2014-12-31 | 2014-12-23 | 0 | 2014-12-23 | ? | 0 | 0004919706 | 20141223.ifs | 2014-12-23 | 2014-12-24 | |||||||
1636504 | 1636504 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .235844 | 00 | 2014-09-24 | 2014-09-26 | 2014-09-30 | 2014-09-23 | 0 | 2014-09-23 | ? | 0 | 0004846729 | 20140923.ifs | 2014-09-23 | 2014-09-24 | |||||||
1557030 | 1557030 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .213608 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800697 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474525 | 1474525 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .215131 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754631 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1389353 | 1389353 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .191164 | 00 | 2013-12-23 | 2013-12-26 | 2013-12-30 | 2013-12-20 | 0 | 2013-12-20 | ? | 0 | 0004698568 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1294243 | 1294243 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .155228 | 00 | 2013-09-24 | 2013-09-26 | 2013-09-30 | 2013-09-23 | 0 | 2013-09-23 | ? | 0 | 0004632698 | 20130923.ifs | 2013-09-23 | 2013-09-24 | |||||||
1226885 | 1226885 | CORPACTION | ADD | 464288851 | 04 | # | 2013-07-01 | 464288851 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1226886 | 1226886 | CORPACTIONAUX | ADD | 464288851 | 04 | 2013-07-01 | IEO | ISHARES TR | ISHARES TRUST - | IEO | ISHARES TR | ISHARES U.S. OI | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1226887 | 1226887 | EQUITY | CHANGE | 464288851 | DJ US OIL&GAS EXPL&PRODCTN INDEX FD | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2008-03-14 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1226888 | 1226887 | EQUITY | CHANGE | 464288851 | ISHARES U.S. OIL & GAS EXPLORATION & PRODUCTION ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1217513 | 1217513 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .21304 | 00 | 2013-06-26 | 2013-06-28 | 2013-07-02 | 2013-06-25 | 0 | 2013-06-25 | ? | 0 | 0004588944 | 20130625.ifs | 2013-06-25 | 2013-06-26 | |||||||
1140182 | 1140182 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .162918 | 00 | 2013-03-25 | 2013-03-27 | 2013-04-01 | 2013-03-22 | 0 | 2013-03-22 | ? | 0 | 0004545076 | 20130322.ifs | 2013-03-22 | 2013-03-23 | |||||||
1047860 | 1047860 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .147513 | 00 | 2012-12-19 | 2012-12-21 | 2012-12-26 | 2012-12-18 | 0 | 2012-12-18 | ? | 0 | 0004485661 | 20121218.ifs | 2012-12-18 | 2012-12-19 | |||||||
963405 | 963405 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .12966 | 00 | 2012-09-25 | 2012-09-27 | 2012-10-01 | 2012-09-24 | 0 | 2012-09-24 | ? | 0 | 0004433157 | 20120924.ifs | 2012-09-24 | 2012-09-25 | |||||||
887460 | 887460 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .116849 | 00 | 2012-06-19 | 2012-06-21 | 2012-06-25 | 2012-06-18 | 0 | 2012-06-18 | ? | 0 | 0004387636 | 20120618.ifs | 2012-06-18 | 2012-06-19 | |||||||
809518 | 809518 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .098705 | 00 | 2012-03-26 | 2012-03-28 | 2012-03-30 | 2012-03-23 | 0 | 2012-03-23 | ? | 0 | 0004349496 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
650804 | 650804 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .065473 | 00 | 2011-09-23 | 2011-09-27 | 2011-09-29 | 2011-09-22 | 0 | 2011-09-22 | ? | 0 | 0004245762 | 20110922.ifs | 2011-09-22 | 2011-09-23 | |||||||
568270 | 568270 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .052293 | 00 | 2011-06-24 | 2011-06-28 | 2011-06-30 | 2011-06-23 | 0 | 2011-06-23 | ? | 0 | 0004205162 | 20110623.ifs | 2011-06-23 | 2011-06-24 | |||||||
479641 | 479641 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .150236 | 00 | 2011-03-25 | 2011-03-29 | 2011-03-31 | 2011-03-24 | 0 | 2011-03-24 | ? | 0 | 0004163796 | 20110324.ifs | 2011-03-24 | 2011-03-25 | |||||||
396702 | 396702 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 9 | .00688 | 03 | 2010-12-29 | 2010-12-31 | 2011-01-05 | 2010-12-28 | 0 | 2010-12-28 | ? | 0 | 0004119742 | 20101228.ifs | 2010-12-28 | 2010-12-29 | |||||||
389306 | 389306 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .042145 | 00 | 2010-12-22 | 2010-12-27 | 2010-12-29 | 2010-12-21 | 0 | 2010-12-21 | ? | 0 | 0004114320 | 20101221.ifs | 2010-12-21 | 2010-12-22 | |||||||
302834 | 302834 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-09-23 | 2010-09-27 | 2010-09-29 | 2010-09-07 | 0 | 2010-09-07 | ? | 0 | 0004058573 | 20100907.ifs | 2010-09-07 | 2010-09-08 | |||||||
226796 | 226796 | DIVIDEND | DELETE | 464288851 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 0 | 2010-06-03 | ? | 0 | 0004016457 | 20100623.ifs | 2010-06-23 | 2010-06-24 | |||||||
226797 | 226797 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .0467 | 00 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 1 | 2010-06-03 | 2010-06-23 | 0 | 0004016457 | 20100623.ifs | 2010-06-23 | 2010-06-24 | |||||||
213127 | 213127 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 0 | 2010-06-03 | ? | 0 | 0004016457 | 20100603.ifs | 2010-06-03 | 2010-06-04 | |||||||
139596 | 139596 | DIVIDEND | DELETE | 464288851 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 0 | 2010-03-18 | ? | 0 | 0003978837 | 20100324.ifs | 2010-03-24 | 2010-04-07 | |||||||
139597 | 139597 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .03584 | 00 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 1 | 2010-03-18 | 2010-03-24 | 0 | 0003978837 | 20100324.ifs | 2010-03-24 | 2010-04-07 | |||||||
134904 | 134904 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 0 | 2010-03-18 | ? | 0 | 0003978837 | 20100318.ifs | 2010-03-18 | 2010-04-07 | |||||||
62773 | 62773 | DIVIDEND | ADD | 464288851 | 0 | 0 | 1 | 0 | .06622 | 00 | 2009-12-23 | 2009-12-28 | 2009-12-30 | 2009-12-22 | 0 | 2009-12-22 | ? | 0 | 0003936256 | 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 = 152114
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