INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | Update Insititution By Cusips | |||||||||
% Owned by Insititutions: | N/A % | % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:142846 |
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 | ||
4791552 | 4791552 | CORPACTION | ADD | 879433852 | 01 | C | 2021-09-01 | ? | 20210901.ifs | 2021-09-01 | 2021-09-02 | ||||||||||||||||||
4791553 | 4791553 | EQUITY | CHANGE | 879433852 | SR NT | 0 | 0 | 2005-04-12 | ? | 4 | no | no | no | 2005-04-13 | 2005-04-15 | ? | 20210901.ifs | 2021-09-01 | 2021-09-02 | ||||||||||
4791554 | 4791553 | EQUITY | CHANGE | 879433852 | SR NT | C | 0 | 2005-04-12 | 2021-09-01 | 4 | no | no | no | 2005-04-13 | 2021-09-01 | ? | 20210901.ifs | 2021-09-01 | 2021-09-02 | ||||||||||
4774521 | 4774521 | DIVIDEND | ADD | 879433852 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2021-09-01 | 2021-08-02 | 0 | ? | 2021-08-03 | 0 | 20210803.ifs | 2021-08-03 | 2021-08-04 | ||||||||
4771244 | 4771244 | DIVIDEND | CHANGE | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2021-06-28 | 2021-06-29 | 2021-06-30 | 2020-05-13 | 0 | 2021-05-13 | ? | 0 | 0006308045 | 20210802.ifs | 2021-08-02 | 2021-08-03 | |||||||
4771245 | 4771244 | DIVIDEND | CHANGE | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2021-06-28 | 2021-06-29 | 2021-06-30 | 2020-05-13 | 1 | 2021-05-13 | 2021-08-02 | 0 | 0006308045 | 20210802.ifs | 2021-08-02 | 2021-08-03 | |||||||
4704900 | 4704900 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2021-06-28 | 2021-06-29 | 2021-06-30 | 2020-05-13 | 0 | 2021-05-13 | ? | 0 | 0006308045 | 20210513.ifs | 2021-05-13 | 2021-05-14 | |||||||
4638456 | 4638456 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2021-03-29 | 2021-03-30 | 2021-03-31 | 2020-02-26 | 0 | 2021-02-26 | ? | 0 | 0006268498 | 20210226.ifs | 2021-02-26 | 2021-02-27 | |||||||
4437574 | 4437574 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2020-12-29 | 2020-12-30 | 2020-12-31 | 2020-08-07 | 0 | 2020-08-07 | ? | 1 | 0006143257 | 20200807.ifs | 2020-08-07 | 2020-08-08 | |||||||
4437575 | 4437575 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2020-09-28 | 2020-09-29 | 2020-09-30 | 2020-08-07 | 0 | 2020-08-07 | ? | 0 | 0006143255 | 20200807.ifs | 2020-08-07 | 2020-08-08 | |||||||
4216417 | 4216417 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2020-06-26 | 2020-06-29 | 2020-06-30 | 2020-02-26 | 0 | 2020-02-26 | ? | 1 | 0006058273 | 20200226.ifs | 2020-02-26 | 2020-02-27 | |||||||
4216418 | 4216418 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2020-06-26 | 2020-06-29 | 2020-06-30 | 2020-02-26 | 0 | 2020-02-26 | ? | 1 | 0006058273 | 20200226.ifs | 2020-02-26 | 2020-02-27 | |||||||
4216419 | 4216419 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2020-03-27 | 2020-03-30 | 2020-03-31 | 2020-02-26 | 0 | 2020-02-26 | ? | 0 | 0006058272 | 20200226.ifs | 2020-02-26 | 2020-02-27 | |||||||
4216420 | 4216420 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2020-03-27 | 2020-03-30 | 2020-03-31 | 2020-02-26 | 0 | 2020-02-26 | ? | 0 | 0006058272 | 20200226.ifs | 2020-02-26 | 2020-02-27 | |||||||
3877422 | 3877422 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-12-27 | 2019-12-30 | 2019-12-31 | 2019-08-12 | 0 | 2019-08-12 | ? | 1 | 0005929984 | 20190812.ifs | 2019-08-12 | 2019-08-13 | |||||||
3877423 | 3877423 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-12-27 | 2019-12-30 | 2019-12-31 | 2019-08-12 | 0 | 2019-08-12 | ? | 1 | 0005929984 | 20190812.ifs | 2019-08-12 | 2019-08-13 | |||||||
3877424 | 3877424 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-09-26 | 2019-09-27 | 2019-09-30 | 2019-08-12 | 0 | 2019-08-12 | ? | 0 | 0005929983 | 20190812.ifs | 2019-08-12 | 2019-08-13 | |||||||
3877425 | 3877425 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-09-26 | 2019-09-27 | 2019-09-30 | 2019-08-12 | 0 | 2019-08-12 | ? | 0 | 0005929983 | 20190812.ifs | 2019-08-12 | 2019-08-13 | |||||||
3589354 | 3589354 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-06-27 | 2019-06-28 | 2019-07-01 | 2019-02-21 | 0 | 2019-02-21 | ? | 1 | 0005840598 | 20190221.ifs | 2019-02-21 | 2019-02-22 | |||||||
3589355 | 3589355 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-06-27 | 2019-06-28 | 2019-07-01 | 2019-02-21 | 0 | 2019-02-21 | ? | 1 | 0005840598 | 20190221.ifs | 2019-02-21 | 2019-02-22 | |||||||
3589356 | 3589356 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-03-28 | 2019-03-29 | 2019-04-01 | 2019-02-21 | 0 | 2019-02-21 | ? | 0 | 0005840597 | 20190221.ifs | 2019-02-21 | 2019-02-22 | |||||||
3589357 | 3589357 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2019-03-28 | 2019-03-29 | 2019-04-01 | 2019-02-21 | 0 | 2019-02-21 | ? | 0 | 0005840597 | 20190221.ifs | 2019-02-21 | 2019-02-22 | |||||||
3242404 | 3242404 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-12-27 | 2018-12-28 | 2018-12-31 | 2018-08-17 | 0 | 2018-08-17 | ? | 1 | 0005709043 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3242405 | 3242405 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-12-27 | 2018-12-28 | 2018-12-31 | 2018-08-17 | 0 | 2018-08-17 | ? | 1 | 0005709043 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3242406 | 3242406 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-09-27 | 2018-09-28 | 2018-10-01 | 2018-08-17 | 0 | 2018-08-17 | ? | 0 | 0005709042 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
3242407 | 3242407 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-09-27 | 2018-09-28 | 2018-10-01 | 2018-08-17 | 0 | 2018-08-17 | ? | 0 | 0005709042 | 20180817.ifs | 2018-08-17 | 2018-08-18 | |||||||
2985356 | 2985356 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-06-28 | 2018-06-29 | 2018-07-02 | 2018-03-01 | 0 | 2018-03-08 | ? | 1 | 0005627917 | 20180308.ifs | 2018-03-08 | 2018-03-09 | |||||||
2985358 | 2985358 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-03-28 | 2018-03-29 | 2018-04-02 | 2018-03-01 | 0 | 2018-03-08 | ? | 0 | 0005627916 | 20180308.ifs | 2018-03-08 | 2018-03-09 | |||||||
2985434 | 2985434 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-06-28 | 2018-06-29 | 2018-07-02 | 2018-03-01 | 0 | 2018-03-08 | ? | 1 | 0005627917 | 20180308.ifs | 2018-03-08 | 2018-03-09 | |||||||
2985436 | 2985436 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2018-03-28 | 2018-03-29 | 2018-04-02 | 2018-03-01 | 0 | 2018-03-08 | ? | 0 | 0005627916 | 20180308.ifs | 2018-03-08 | 2018-03-09 | |||||||
2580827 | 2580827 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-02 | 2017-05-31 | 0 | 2017-06-01 | ? | 2 | 0005443459 | 20170601.ifs | 2017-06-01 | 2017-06-02 | |||||||
2580828 | 2580828 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2017-09-28 | 2017-09-29 | 2017-10-02 | 2017-05-31 | 0 | 2017-06-01 | ? | 1 | 0005443458 | 20170601.ifs | 2017-06-01 | 2017-06-02 | |||||||
2580829 | 2580829 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2017-06-27 | 2017-06-29 | 2017-06-30 | 2017-05-31 | 0 | 2017-06-01 | ? | 0 | 0005443457 | 20170601.ifs | 2017-06-01 | 2017-06-02 | |||||||
2446020 | 2446020 | EQUITY | CHANGE | 879433852 | SR NT | 0 | 0 | 2005-04-12 | ? | 0 | no | no | no | 2005-04-13 | 2005-04-15 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2446021 | 2446020 | EQUITY | CHANGE | 879433852 | SR NT | 0 | 0 | 2005-04-12 | ? | 4 | no | no | no | 2005-04-13 | 2005-04-15 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2423577 | 2423577 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2017-03-28 | 2017-03-30 | 2017-03-31 | 2017-01-09 | 0 | 2017-01-10 | ? | 0 | 0005374087 | 20170110.ifs | 2017-01-10 | 2017-01-11 | |||||||
2277882 | 2277882 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2016-12-28 | 2016-12-30 | 2016-12-31 | 2016-08-24 | 0 | 2016-08-26 | ? | 1 | 0005269655 | 20160826.ifs | 2016-08-26 | 2016-08-27 | |||||||
2277883 | 2277883 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2016-09-27 | 2016-09-29 | 2016-09-30 | 2016-08-24 | 0 | 2016-08-26 | ? | 0 | 0005269654 | 20160826.ifs | 2016-08-26 | 2016-08-27 | |||||||
2164058 | 2164058 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2016-06-27 | 2016-06-29 | 2016-06-30 | 2016-04-14 | 0 | 2016-04-14 | ? | 0 | 0005205463 | 20160414.ifs | 2016-04-14 | 2016-04-15 | |||||||
2116343 | 2116343 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2016-03-28 | 2016-03-30 | 2016-03-31 | 2016-02-22 | 0 | 2016-02-22 | ? | 0 | 0005174397 | 20160222.ifs | 2016-02-22 | 2016-02-23 | |||||||
2026530 | 2026530 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2015-12-28 | 2015-12-30 | 2015-12-31 | 2015-12-07 | 0 | 2015-12-07 | ? | 0 | 0005106996 | 20151207.ifs | 2015-12-07 | 2015-12-08 | |||||||
1965795 | 1965795 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2015-09-25 | 2015-09-29 | 2015-09-30 | 2015-09-15 | 0 | 2015-09-15 | ? | 0 | 0005062303 | 20150915.ifs | 2015-09-15 | 2015-09-16 | |||||||
1809949 | 1809949 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2015-06-25 | 2015-06-29 | 2015-06-30 | 2015-03-11 | 0 | 2015-03-11 | ? | 0 | 0004967477 | 20150311.ifs | 2015-03-11 | 2015-03-12 | |||||||
1808415 | 1808415 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2015-03-26 | 2015-03-30 | 2015-03-31 | 2015-03-09 | 0 | 2015-03-09 | ? | 0 | 0004966753 | 20150309.ifs | 2015-03-09 | 2015-03-10 | |||||||
1702954 | 1702954 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2014-12-26 | 2014-12-30 | 2014-12-31 | 2014-12-05 | 0 | 2014-12-08 | ? | 0 | 0004887000 | 20141208.ifs | 2014-12-08 | 2014-12-09 | |||||||
1612995 | 1612995 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2014-09-25 | 2014-09-29 | 2014-09-30 | 2014-08-25 | 0 | 2014-08-26 | ? | 0 | 0004831607 | 20140826.ifs | 2014-08-26 | 2014-08-27 | |||||||
1500352 | 1500352 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2014-06-25 | 2014-06-27 | 2014-06-30 | 2014-04-23 | 0 | 2014-04-23 | ? | 0 | 0004770270 | 20140423.ifs | 2014-04-23 | 2014-04-24 | |||||||
1246594 | 1246594 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2013-12-26 | 2013-12-30 | 2013-12-31 | 2013-07-24 | 0 | 2013-07-25 | ? | 1 | 0004604313 | 20130725.ifs | 2013-07-25 | 2013-07-26 | |||||||
1246595 | 1246595 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2013-09-25 | 2013-09-27 | 2013-09-30 | 2013-07-24 | 0 | 2013-07-25 | ? | 0 | 0004604140 | 20130725.ifs | 2013-07-25 | 2013-07-26 | |||||||
1110678 | 1110678 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2013-06-26 | 2013-06-28 | 2013-07-01 | 2013-02-07 | 0 | 2013-02-11 | ? | 0 | 0004527391 | 20130211.ifs | 2013-02-11 | 2013-02-12 | |||||||
1097957 | 1097957 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2013-03-26 | 2013-03-28 | 2013-04-01 | 2013-01-28 | 0 | 2013-01-29 | ? | 0 | 0004518524 | 20130129.ifs | 2013-01-29 | 2013-01-30 | |||||||
1011150 | 1011150 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2012-12-26 | 2012-12-28 | 2012-12-31 | 2012-11-16 | 0 | 2012-11-16 | ? | 0 | 0004458954 | 20121116.ifs | 2012-11-16 | 2012-11-17 | |||||||
953309 | 953309 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2012-09-26 | 2012-09-28 | 2012-10-01 | 2012-09-10 | 0 | 2012-09-10 | ? | 0 | 0004427738 | 20120910.ifs | 2012-09-10 | 2012-09-11 | |||||||
763909 | 763909 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2012-03-27 | 2012-03-29 | 2012-03-30 | 2012-01-27 | 0 | 2012-01-27 | ? | 0 | 0004323479 | 20120127.ifs | 2012-01-27 | 2012-01-28 | |||||||
639376 | 639376 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2011-09-27 | 2011-09-29 | 2011-09-30 | 2011-09-08 | 0 | 2011-09-08 | ? | 0 | 0004241188 | 20110908.ifs | 2011-09-08 | 2011-09-09 | |||||||
557646 | 557646 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2011-06-27 | 2011-06-29 | 2011-06-30 | 2011-06-10 | 0 | 2011-06-10 | ? | 0 | 0004200307 | 20110610.ifs | 2011-06-10 | 2011-06-11 | |||||||
471903 | 471903 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2011-03-28 | 2011-03-30 | 2011-03-31 | 2011-03-15 | 0 | 2011-03-15 | ? | 0 | 0004159601 | 20110315.ifs | 2011-03-15 | 2011-03-16 | |||||||
376544 | 376544 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2010-12-28 | 2010-12-30 | 2010-12-31 | 2010-12-14 | 0 | 2010-12-14 | ? | 0 | 0004104738 | 20101214.ifs | 2010-12-14 | 2010-12-15 | |||||||
296306 | 296306 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .414063 | 00 | 2010-09-27 | 2010-09-29 | 2010-09-30 | 2010-09-01 | 0 | 2010-09-01 | ? | 0 | 0004057081 | 20100901.ifs | 2010-09-01 | 2010-09-02 | |||||||
220299 | 220299 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .41406 | 00 | 2010-06-25 | 2010-06-29 | 2010-06-30 | 2010-06-16 | 0 | 2010-06-16 | ? | 0 | 0004018757 | 20100616.ifs | 2010-06-16 | 2010-06-17 | |||||||
131929 | 131929 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .41406 | 00 | 2010-03-26 | 2010-03-30 | 2010-03-31 | 2010-03-12 | 0 | 2010-03-12 | ? | 0 | 0003977737 | 20100312.ifs | 2010-03-12 | 2010-04-07 | |||||||
44665 | 44665 | DIVIDEND | ADD | 879433852 | 0 | 0 | 1 | 0 | .41406 | 00 | 2009-12-28 | 2009-12-30 | 2009-12-31 | 2009-12-09 | 0 | 2009-12-09 | ? | 0 | 0003922919 | 20091209.ifs | 2009-12-09 | 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 = 142846
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