INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 101 | 91 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 8.52 % | 12.76 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:152115 |
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 | ||
5573844 | 5573844 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .092008 | 00 | 2024-06-11 | 2024-06-11 | 2024-06-17 | 2024-06-10 | 0 | 2024-06-10 | ? | 0 | 0006931033 | 20240610.ifs | 2024-06-10 | 2024-06-11 | |||||||
5519548 | 5519548 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .086677 | 00 | 2024-03-21 | 2024-03-22 | 2024-03-27 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892629 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5450355 | 5450355 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .064439 | 00 | 2023-12-20 | 2023-12-21 | 2023-12-27 | 2023-12-19 | 0 | 2023-12-19 | ? | 0 | 0006840548 | 20231219.ifs | 2023-12-19 | 2023-12-20 | |||||||
5380076 | 5380076 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .070817 | 00 | 2023-09-26 | 2023-09-27 | 2023-10-02 | 2023-09-25 | 0 | 2023-09-25 | ? | 0 | 0006787307 | 20230925.ifs | 2023-09-25 | 2023-09-26 | |||||||
5307588 | 5307588 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .011991 | 00 | 2023-06-07 | 2023-06-08 | 2023-06-13 | 2023-06-06 | 0 | 2023-06-06 | ? | 0 | 0006737000 | 20230606.ifs | 2023-06-06 | 2023-06-07 | |||||||
5252893 | 5252893 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .065287 | 00 | 2023-03-23 | 2023-03-24 | 2023-03-29 | 2023-03-22 | 0 | 2023-03-22 | ? | 0 | 0006698859 | 20230322.ifs | 2023-03-22 | 2023-03-23 | |||||||
5162421 | 5162421 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .039166 | 00 | 2022-12-13 | 2022-12-14 | 2022-12-19 | 2022-12-12 | 0 | 2022-12-12 | ? | 0 | 0006629497 | 20221212.ifs | 2022-12-12 | 2022-12-13 | |||||||
5103562 | 5103562 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .035503 | 00 | 2022-09-26 | 2022-09-27 | 2022-09-30 | 2022-09-23 | 0 | 2022-09-23 | ? | 0 | 0006587982 | 20220923.ifs | 2022-09-23 | 2022-09-24 | |||||||
5030140 | 5030140 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .037135 | 00 | 2022-06-09 | 2022-06-10 | 2022-06-15 | 2022-06-08 | 0 | 2022-06-08 | ? | 0 | 0006536789 | 20220608.ifs | 2022-06-08 | 2022-06-09 | |||||||
4976128 | 4976128 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .02625 | 00 | 2022-03-24 | 2022-03-25 | 2022-03-30 | 2022-03-23 | 0 | 2022-03-23 | ? | 0 | 0006498170 | 20220323.ifs | 2022-03-23 | 2022-03-24 | |||||||
4877090 | 4877090 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .03347 | 00 | 2021-12-13 | 2021-12-14 | 2021-12-17 | 2021-12-10 | 0 | 2021-12-10 | ? | 0 | 0006417590 | 20211210.ifs | 2021-12-10 | 2021-12-11 | |||||||
4808643 | 4808643 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .023485 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-30 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371656 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4725917 | 4725917 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .0177 | 00 | 2021-06-10 | 2021-06-11 | 2021-06-16 | 2021-06-09 | 0 | 2021-06-09 | ? | 0 | 0006320415 | 20210609.ifs | 2021-06-09 | 2021-06-10 | |||||||
4660994 | 4660994 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .080301 | 00 | 2021-03-25 | 2021-03-26 | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281427 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4539138 | 4539138 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .025517 | 00 | 2020-12-14 | 2020-12-15 | 2020-12-18 | 2020-12-11 | 0 | 2020-12-11 | ? | 0 | 0006209249 | 20201211.ifs | 2020-12-11 | 2020-12-12 | |||||||
4467361 | 4467361 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .057931 | 00 | 2020-09-23 | 2020-09-24 | 2020-09-29 | 2020-09-22 | 0 | 2020-09-22 | ? | 0 | 0006161955 | 20200922.ifs | 2020-09-22 | 2020-09-23 | |||||||
4391018 | 4391018 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .033562 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-19 | 2020-06-12 | 0 | 2020-06-12 | ? | 0 | 0006112122 | 20200612.ifs | 2020-06-12 | 2020-06-13 | |||||||
4252401 | 4252401 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .1158 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072819 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4252624 | 4252624 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .1158 | 00 | 2020-03-25 | 2020-03-26 | 2020-03-31 | 2020-03-24 | 0 | 2020-03-24 | ? | 0 | 0006072819 | 20200324.ifs | 2020-03-24 | 2020-03-25 | |||||||
4067947 | 4067947 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .124068 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000079 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
4068026 | 4068026 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .124068 | 00 | 2019-12-16 | 2019-12-17 | 2019-12-20 | 2019-12-13 | 0 | 2019-12-13 | ? | 0 | 0006000079 | 20191213.ifs | 2019-12-13 | 2019-12-14 | |||||||
3933960 | 3933960 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .117345 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949064 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3933961 | 3933961 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .117345 | 00 | 2019-09-24 | 2019-09-25 | 2019-09-30 | 2019-09-23 | 0 | 2019-09-23 | ? | 0 | 0005949064 | 20190923.ifs | 2019-09-23 | 2019-09-24 | |||||||
3780967 | 3780967 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .112121 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898630 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3780990 | 3780990 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .112121 | 00 | 2019-06-17 | 2019-06-18 | 2019-06-21 | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898630 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3638061 | 3638061 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .109391 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854891 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3638064 | 3638064 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .109391 | 00 | 2019-03-20 | 2019-03-21 | 2019-03-26 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854891 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3442935 | 3442935 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .088531 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781482 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3443765 | 3443765 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .088531 | 00 | 2018-12-17 | 2018-12-18 | 2018-12-21 | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005781482 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3299127 | 3299127 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .08812 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728800 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3299234 | 3299234 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .08812 | 00 | 2018-09-26 | 2018-09-27 | 2018-10-02 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728800 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3000779 | 3000779 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .107498 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632746 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3000800 | 3000800 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .107498 | 00 | 2018-03-22 | 2018-03-23 | 2018-03-28 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632746 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2839559 | 2839559 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .088395 | 00 | 2017-12-19 | 2017-12-20 | 2017-12-26 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005564353 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2686731 | 2686731 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .976341 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502005 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2686778 | 2686778 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .976341 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005502005 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2601180 | 2601180 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .080305 | 00 | 2017-06-27 | 2017-06-29 | 2017-06-30 | 2017-06-26 | 0 | 2017-06-26 | ? | 0 | 0005454917 | 20170626.ifs | 2017-06-26 | 2017-06-27 | |||||||
2518847 | 2518847 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .081817 | 00 | 2017-03-24 | 2017-03-28 | 2017-03-30 | 2017-03-23 | 0 | 2017-03-23 | ? | 0 | 0005406966 | 20170323.ifs | 2017-03-23 | 2017-03-24 | |||||||
2439876 | 2439876 | EQUITY | CHANGE | 464288844 | ISHARES U.S. OIL EQUIPMENT & SERVICES ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2439877 | 2439876 | EQUITY | CHANGE | 464288844 | ISHARES U.S. OIL EQUIPMENT & SERVICES ETF | 0 | A | 2006-05-05 | ? | 4 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2388200 | 2388200 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .080463 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-28 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346385 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2301169 | 2301169 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .09274 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005285134 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2225289 | 2225289 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .098861 | 00 | 2016-06-21 | 2016-06-23 | 2016-06-27 | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235516 | 20160620.ifs | 2016-06-20 | 2016-06-21 | |||||||
2140460 | 2140460 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .14087 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-30 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190711 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2063465 | 2063465 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .181756 | 00 | 2015-12-24 | 2015-12-29 | 2015-12-31 | 2015-12-23 | 0 | 2015-12-23 | ? | 0 | 0005138813 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
1972234 | 1972234 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .202417 | 00 | 2015-09-25 | 2015-09-29 | 2015-10-01 | 2015-09-24 | 0 | 2015-09-24 | ? | 0 | 0005067359 | 20150924.ifs | 2015-09-24 | 2015-09-25 | |||||||
1893615 | 1893615 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .200523 | 00 | 2015-06-24 | 2015-06-26 | 2015-06-30 | 2015-06-23 | 0 | 2015-06-23 | ? | 0 | 0005018447 | 20150623.ifs | 2015-06-23 | 2015-06-24 | |||||||
1819276 | 1819276 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .272273 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972937 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1740530 | 1740530 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .234233 | 00 | 2014-12-24 | 2014-12-29 | 2014-12-31 | 2014-12-23 | 0 | 2014-12-23 | ? | 0 | 0004919694 | 20141223.ifs | 2014-12-23 | 2014-12-24 | |||||||
1636505 | 1636505 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .202488 | 00 | 2014-09-24 | 2014-09-26 | 2014-09-30 | 2014-09-23 | 0 | 2014-09-23 | ? | 0 | 0004846731 | 20140923.ifs | 2014-09-23 | 2014-09-24 | |||||||
1557031 | 1557031 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .227691 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800699 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474526 | 1474526 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .175306 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754633 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1389354 | 1389354 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .136201 | 00 | 2013-12-23 | 2013-12-26 | 2013-12-30 | 2013-12-20 | 0 | 2013-12-20 | ? | 0 | 0004698569 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1294244 | 1294244 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .146269 | 00 | 2013-09-24 | 2013-09-26 | 2013-09-30 | 2013-09-23 | 0 | 2013-09-23 | ? | 0 | 0004632699 | 20130923.ifs | 2013-09-23 | 2013-09-24 | |||||||
1227491 | 1227491 | CORPACTION | ADD | 464288844 | 04 | # | 2013-07-01 | 464288844 | 04 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||||||
1227492 | 1227492 | CORPACTIONAUX | ADD | 464288844 | 04 | 2013-07-01 | IEZ | ISHARES TR | ISHARES TRUST D | IEZ | ISHARES TR | ISHARES U.S. OI | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||||
1227493 | 1227493 | EQUITY | CHANGE | 464288844 | DJ US OIL EQUIP&SVCS 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 | ||||||||||
1227494 | 1227493 | EQUITY | CHANGE | 464288844 | ISHARES U.S. OIL EQUIPMENT & SERVICES ETF | 0 | A | 2006-05-05 | ? | 0 | no | no | no | 2006-05-08 | 2013-07-01 | ? | 20130701.ifs | 2013-07-01 | 2013-07-02 | ||||||||||
1217514 | 1217514 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .124067 | 00 | 2013-06-26 | 2013-06-28 | 2013-07-02 | 2013-06-25 | 0 | 2013-06-25 | ? | 0 | 0004588945 | 20130625.ifs | 2013-06-25 | 2013-06-26 | |||||||
1140183 | 1140183 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .079854 | 00 | 2013-03-25 | 2013-03-27 | 2013-04-01 | 2013-03-22 | 0 | 2013-03-22 | ? | 0 | 0004545077 | 20130322.ifs | 2013-03-22 | 2013-03-23 | |||||||
1047861 | 1047861 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .107324 | 00 | 2012-12-19 | 2012-12-21 | 2012-12-26 | 2012-12-18 | 0 | 2012-12-18 | ? | 0 | 0004485662 | 20121218.ifs | 2012-12-18 | 2012-12-19 | |||||||
963406 | 963406 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .075186 | 00 | 2012-09-25 | 2012-09-27 | 2012-10-01 | 2012-09-24 | 0 | 2012-09-24 | ? | 0 | 0004433158 | 20120924.ifs | 2012-09-24 | 2012-09-25 | |||||||
887461 | 887461 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .082921 | 00 | 2012-06-19 | 2012-06-21 | 2012-06-25 | 2012-06-18 | 0 | 2012-06-18 | ? | 0 | 0004387637 | 20120618.ifs | 2012-06-18 | 2012-06-19 | |||||||
809519 | 809519 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .059498 | 00 | 2012-03-26 | 2012-03-28 | 2012-03-30 | 2012-03-23 | 0 | 2012-03-23 | ? | 0 | 0004349497 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
650805 | 650805 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .044326 | 00 | 2011-09-23 | 2011-09-27 | 2011-09-29 | 2011-09-22 | 0 | 2011-09-22 | ? | 0 | 0004245763 | 20110922.ifs | 2011-09-22 | 2011-09-23 | |||||||
568271 | 568271 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .051288 | 00 | 2011-06-24 | 2011-06-28 | 2011-06-30 | 2011-06-23 | 0 | 2011-06-23 | ? | 0 | 0004205163 | 20110623.ifs | 2011-06-23 | 2011-06-24 | |||||||
479642 | 479642 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .030669 | 00 | 2011-03-25 | 2011-03-29 | 2011-03-31 | 2011-03-24 | 0 | 2011-03-24 | ? | 0 | 0004163797 | 20110324.ifs | 2011-03-24 | 2011-03-25 | |||||||
389307 | 389307 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .129068 | 00 | 2010-12-22 | 2010-12-27 | 2010-12-29 | 2010-12-21 | 0 | 2010-12-21 | ? | 0 | 0004114321 | 20101221.ifs | 2010-12-21 | 2010-12-22 | |||||||
302835 | 302835 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-09-23 | 2010-09-27 | 2010-09-29 | 2010-09-07 | 0 | 2010-09-07 | ? | 0 | 0004058576 | 20100907.ifs | 2010-09-07 | 2010-09-08 | |||||||
226798 | 226798 | DIVIDEND | DELETE | 464288844 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 0 | 2010-06-03 | ? | 0 | 0004016460 | 20100623.ifs | 2010-06-23 | 2010-06-24 | |||||||
226799 | 226799 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .05397 | 00 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 1 | 2010-06-03 | 2010-06-23 | 0 | 0004016460 | 20100623.ifs | 2010-06-23 | 2010-06-24 | |||||||
213128 | 213128 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-06-24 | 2010-06-28 | 2010-06-30 | 2010-06-03 | 0 | 2010-06-03 | ? | 0 | 0004016460 | 20100603.ifs | 2010-06-03 | 2010-06-04 | |||||||
139598 | 139598 | DIVIDEND | DELETE | 464288844 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 0 | 2010-03-18 | ? | 0 | 0003978838 | 20100324.ifs | 2010-03-24 | 2010-04-07 | |||||||
139599 | 139599 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .06304 | 00 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 1 | 2010-03-18 | 2010-03-24 | 0 | 0003978838 | 20100324.ifs | 2010-03-24 | 2010-04-07 | |||||||
134905 | 134905 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 6 | 0 | 08 | 2010-03-25 | 2010-03-29 | 2010-03-31 | 2010-03-18 | 0 | 2010-03-18 | ? | 0 | 0003978838 | 20100318.ifs | 2010-03-18 | 2010-04-07 | |||||||
62774 | 62774 | DIVIDEND | ADD | 464288844 | 0 | 0 | 1 | 0 | .13481 | 00 | 2009-12-23 | 2009-12-28 | 2009-12-30 | 2009-12-22 | 0 | 2009-12-22 | ? | 0 | 0003936257 | 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 = 152115
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