INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | N/A % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:160388 |
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 | ||
4935490 | 4935490 | CORPACTION | ADD | 902973833 | 01 | C | 2022-01-18 | 2022-01-18 | 20220118.ifs | 2022-01-18 | 2022-01-19 | ||||||||||||||||||
4935491 | 4935491 | EQUITY | CHANGE | 902973833 | DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F | 0 | 1 | 2012-01-19 | ? | 4 | no | no | no | 2012-01-19 | ? | ? | 20220118.ifs | 2022-01-18 | 2022-01-19 | ||||||||||
4935492 | 4935491 | EQUITY | CHANGE | 902973833 | DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F | C | 1 | 2012-01-19 | 2022-01-18 | 4 | no | no | no | 2012-01-19 | 2022-01-18 | ? | 20220118.ifs | 2022-01-18 | 2022-01-19 | ||||||||||
4902522 | 4902522 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2021-12-30 | 2021-12-31 | 2022-01-18 | 2021-12-21 | 0 | 2021-12-21 | ? | 0 | 0006439145 | 20211221.ifs | 2021-12-21 | 2021-12-22 | |||||||
4896862 | 4896862 | DIVIDEND | ADD | 902973833 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2022-01-15 | 2021-12-17 | 0 | ? | 2021-12-17 | 0 | 20211217.ifs | 2021-12-17 | 2021-12-18 | ||||||||
4891826 | 4891826 | DIVIDEND | CHANGE | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2021-09-29 | 2021-09-30 | 2021-10-15 | 2021-09-14 | 0 | 2021-09-14 | ? | 0 | 0006367288 | 20211216.ifs | 2021-12-16 | 2021-12-17 | |||||||
4891827 | 4891826 | DIVIDEND | CHANGE | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2021-09-29 | 2021-09-30 | 2021-10-15 | 2021-09-14 | 1 | 2021-09-14 | 2021-12-16 | 0 | 0006367288 | 20211216.ifs | 2021-12-16 | 2021-12-17 | |||||||
4801396 | 4801396 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2021-09-29 | 2021-09-30 | 2021-10-15 | 2021-09-14 | 0 | 2021-09-14 | ? | 0 | 0006367288 | 20210914.ifs | 2021-09-14 | 2021-09-15 | |||||||
4729592 | 4729592 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2021-06-29 | 2021-06-30 | 2021-07-15 | 2021-06-15 | 0 | 2021-06-15 | ? | 0 | 0006322291 | 20210615.ifs | 2021-06-15 | 2021-06-16 | |||||||
4653931 | 4653931 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2021-03-30 | 2021-03-31 | 2021-04-15 | 2021-03-16 | 0 | 2021-03-16 | ? | 0 | 0006277925 | 20210316.ifs | 2021-03-16 | 2021-03-17 | |||||||
4530710 | 4530710 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2020-12-30 | 2020-12-31 | 2021-01-15 | 2020-12-08 | 0 | 2020-12-08 | ? | 0 | 0006202693 | 20201208.ifs | 2020-12-08 | 2020-12-09 | |||||||
4462143 | 4462143 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2020-09-29 | 2020-09-30 | 2020-10-15 | 2020-09-15 | 0 | 2020-09-15 | ? | 0 | 0006159111 | 20200915.ifs | 2020-09-15 | 2020-09-16 | |||||||
4392689 | 4392689 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2020-06-29 | 2020-06-30 | 2020-07-15 | 2020-06-16 | 0 | 2020-06-16 | ? | 0 | 0006113313 | 20200616.ifs | 2020-06-16 | 2020-06-17 | |||||||
4080119 | 4080119 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-15 | 2019-12-17 | 0 | 2019-12-17 | ? | 0 | 0006004614 | 20191217.ifs | 2019-12-17 | 2019-12-18 | |||||||
4080354 | 4080354 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-12-30 | 2019-12-31 | 2020-01-15 | 2019-12-17 | 0 | 2019-12-17 | ? | 0 | 0006004614 | 20191217.ifs | 2019-12-17 | 2019-12-18 | |||||||
3924678 | 3924678 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-15 | 2019-09-17 | 0 | 2019-09-17 | ? | 0 | 0005946004 | 20190917.ifs | 2019-09-17 | 2019-09-18 | |||||||
3924683 | 3924683 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-09-27 | 2019-09-30 | 2019-10-15 | 2019-09-17 | 0 | 2019-09-17 | ? | 0 | 0005946004 | 20190917.ifs | 2019-09-17 | 2019-09-18 | |||||||
3785348 | 3785348 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-06-27 | 2019-06-28 | 2019-07-15 | 2019-06-18 | 0 | 2019-06-18 | ? | 0 | 0005899620 | 20190618.ifs | 2019-06-18 | 2019-06-19 | |||||||
3785358 | 3785358 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-06-27 | 2019-06-28 | 2019-07-15 | 2019-06-18 | 0 | 2019-06-18 | ? | 0 | 0005899620 | 20190618.ifs | 2019-06-18 | 2019-06-19 | |||||||
3637093 | 3637093 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-03-28 | 2019-03-29 | 2019-04-15 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854075 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3637096 | 3637096 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2019-03-28 | 2019-03-29 | 2019-04-15 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854075 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3457115 | 3457115 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-15 | 2018-12-18 | 0 | 2018-12-18 | ? | 0 | 0005786935 | 20181218.ifs | 2018-12-18 | 2018-12-19 | |||||||
3457116 | 3457116 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-12-28 | 2018-12-31 | 2019-01-15 | 2018-12-18 | 0 | 2018-12-18 | ? | 0 | 0005786935 | 20181218.ifs | 2018-12-18 | 2018-12-19 | |||||||
3287872 | 3287872 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-09-27 | 2018-09-28 | 2018-10-15 | 2018-09-18 | 0 | 2018-09-18 | ? | 0 | 0005724748 | 20180918.ifs | 2018-09-18 | 2018-09-19 | |||||||
3287873 | 3287873 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-09-27 | 2018-09-28 | 2018-10-15 | 2018-09-18 | 0 | 2018-09-18 | ? | 0 | 0005724748 | 20180918.ifs | 2018-09-18 | 2018-09-19 | |||||||
3145482 | 3145482 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-06-28 | 2018-06-29 | 2018-07-16 | 2018-06-19 | 0 | 2018-06-19 | ? | 0 | 0005676741 | 20180619.ifs | 2018-06-19 | 2018-06-20 | |||||||
3145515 | 3145515 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-06-28 | 2018-06-29 | 2018-07-16 | 2018-06-19 | 0 | 2018-06-19 | ? | 0 | 0005676741 | 20180619.ifs | 2018-06-19 | 2018-06-20 | |||||||
2996556 | 2996556 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-03-28 | 2018-03-29 | 2018-04-16 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005630725 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2996563 | 2996563 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2018-03-28 | 2018-03-29 | 2018-04-16 | 2018-03-19 | 0 | 2018-03-19 | ? | 0 | 0005630725 | 20180319.ifs | 2018-03-19 | 2018-03-20 | |||||||
2841734 | 2841734 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-16 | 2017-12-19 | 0 | 2017-12-19 | ? | 0 | 0005564759 | 20171219.ifs | 2017-12-19 | 2017-12-20 | |||||||
2841854 | 2841854 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-16 | 2017-12-19 | 0 | 2017-12-19 | ? | 0 | 0005564759 | 20171219.ifs | 2017-12-19 | 2017-12-20 | |||||||
2677130 | 2677130 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2017-09-28 | 2017-09-29 | 2017-10-16 | 2017-09-19 | 0 | 2017-09-19 | ? | 0 | 0005499004 | 20170919.ifs | 2017-09-19 | 2017-09-20 | |||||||
2677642 | 2677642 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2017-09-28 | 2017-09-29 | 2017-10-16 | 2017-09-19 | 0 | 2017-09-19 | ? | 0 | 0005499004 | 20170919.ifs | 2017-09-19 | 2017-09-20 | |||||||
2595688 | 2595688 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2017-06-28 | 2017-06-30 | 2017-07-17 | 2017-06-20 | 0 | 2017-06-20 | ? | 0 | 0005451521 | 20170620.ifs | 2017-06-20 | 2017-06-21 | |||||||
2517104 | 2517104 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2017-03-29 | 2017-03-31 | 2017-04-17 | 2017-03-21 | 0 | 2017-03-21 | ? | 0 | 0005404904 | 20170321.ifs | 2017-03-21 | 2017-03-22 | |||||||
2446588 | 2446588 | EQUITY | CHANGE | 902973833 | DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F | 0 | 1 | 2012-01-19 | ? | 0 | no | no | no | 2012-01-19 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2446589 | 2446588 | EQUITY | CHANGE | 902973833 | DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F | 0 | 1 | 2012-01-19 | ? | 4 | no | no | no | 2012-01-19 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2383222 | 2383222 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2016-12-28 | 2016-12-30 | 2017-01-17 | 2016-12-19 | 0 | 2016-12-19 | ? | 0 | 0005341495 | 20161219.ifs | 2016-12-19 | 2016-12-20 | |||||||
2296896 | 2296896 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2016-09-28 | 2016-09-30 | 2016-10-17 | 2016-09-19 | 0 | 2016-09-19 | ? | 0 | 0005282339 | 20160919.ifs | 2016-09-19 | 2016-09-20 | |||||||
2220907 | 2220907 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2016-06-28 | 2016-06-30 | 2016-07-15 | 2016-06-15 | 0 | 2016-06-15 | ? | 0 | 0005232651 | 20160615.ifs | 2016-06-15 | 2016-06-16 | |||||||
2135211 | 2135211 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2016-03-29 | 2016-03-31 | 2016-04-15 | 2016-03-15 | 0 | 2016-03-15 | ? | 0 | 0005186747 | 20160315.ifs | 2016-03-15 | 2016-03-16 | |||||||
2039249 | 2039249 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2015-12-29 | 2015-12-31 | 2016-01-15 | 2015-12-15 | 0 | 2015-12-15 | ? | 0 | 0005118058 | 20151215.ifs | 2015-12-15 | 2015-12-16 | |||||||
1965739 | 1965739 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2015-09-28 | 2015-09-30 | 2015-10-15 | 2015-09-15 | 0 | 2015-09-15 | ? | 0 | 0005062420 | 20150915.ifs | 2015-09-15 | 2015-09-16 | |||||||
1887146 | 1887146 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2015-06-26 | 2015-06-30 | 2015-07-15 | 2015-06-16 | 0 | 2015-06-16 | ? | 0 | 0005014010 | 20150616.ifs | 2015-06-16 | 2015-06-17 | |||||||
1803961 | 1803961 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2015-03-27 | 2015-03-31 | 2015-04-15 | 2015-03-03 | 0 | 2015-03-03 | ? | 0 | 0004965311 | 20150303.ifs | 2015-03-03 | 2015-03-04 | |||||||
1703970 | 1703970 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-15 | 2014-12-09 | 0 | 2014-12-09 | ? | 0 | 0004887879 | 20141209.ifs | 2014-12-09 | 2014-12-10 | |||||||
1630963 | 1630963 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2014-09-26 | 2014-09-30 | 2014-10-15 | 2014-09-16 | 0 | 2014-09-16 | ? | 0 | 0004843311 | 20140916.ifs | 2014-09-16 | 2014-09-17 | |||||||
1551308 | 1551308 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2014-06-26 | 2014-06-30 | 2014-07-15 | 2014-06-17 | 0 | 2014-06-17 | ? | 0 | 0004797113 | 20140617.ifs | 2014-06-17 | 2014-06-18 | |||||||
1464815 | 1464815 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2014-03-27 | 2014-03-31 | 2014-04-15 | 2014-03-12 | 0 | 2014-03-12 | ? | 0 | 0004749731 | 20140312.ifs | 2014-03-12 | 2014-03-13 | |||||||
1361737 | 1361737 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2013-12-27 | 2013-12-31 | 2014-01-15 | 2013-12-10 | 0 | 2013-12-10 | ? | 0 | 0004674856 | 20131210.ifs | 2013-12-10 | 2013-12-11 | |||||||
1289149 | 1289149 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2013-09-26 | 2013-09-30 | 2013-10-15 | 2013-09-17 | 0 | 2013-09-17 | ? | 0 | 0004629735 | 20130917.ifs | 2013-09-17 | 2013-09-18 | |||||||
1211654 | 1211654 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2013-06-26 | 2013-06-28 | 2013-07-15 | 2013-06-18 | 0 | 2013-06-18 | ? | 0 | 0004584817 | 20130618.ifs | 2013-06-18 | 2013-06-19 | |||||||
1132903 | 1132903 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2013-03-26 | 2013-03-28 | 2013-04-15 | 2013-03-14 | 0 | 2013-03-14 | ? | 0 | 0004541465 | 20130314.ifs | 2013-03-14 | 2013-03-15 | |||||||
1035232 | 1035232 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2012-12-27 | 2012-12-31 | 2013-01-15 | 2012-12-11 | 0 | 2012-12-11 | ? | 0 | 0004474832 | 20121211.ifs | 2012-12-11 | 2012-12-12 | |||||||
958247 | 958247 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2012-09-26 | 2012-09-28 | 2012-10-15 | 2012-09-18 | 0 | 2012-09-18 | ? | 0 | 0004430157 | 20120918.ifs | 2012-09-18 | 2012-09-19 | |||||||
888127 | 888127 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 0 | .40625 | 00 | 2012-06-27 | 2012-06-29 | 2012-07-16 | 2012-06-19 | 0 | 2012-06-19 | ? | 0 | 0004387801 | 20120619.ifs | 2012-06-19 | 2012-06-20 | |||||||
802002 | 802002 | DIVIDEND | ADD | 902973833 | 0 | 0 | 1 | 4 | .37014 | 00 | 2012-03-28 | 2012-03-30 | 2012-04-16 | 2012-03-13 | 0 | 2012-03-14 | ? | 0 | 0004345469 | 20120314.ifs | 2012-03-14 | 2012-03-15 | |||||||
763685 | 763685 | CORPACTION | ADD | 902973833 | 66 | X | 2012-01-27 | 902973833 | 01 | ? | 20120127.ifs | 2012-01-27 | 2012-01-28 | ||||||||||||||||
763686 | 763686 | EXCHANGE | ADD | 902973833 | 01 | 2012-01-27 | 2012-01-27 | USB_PM | 0 | 1 | 2012-01-27 | ? | 20120127.ifs | 2012-01-27 | 2012-01-28 | ||||||||||||||
758832 | 758832 | EQUITY | ADD | 902973833 | DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F | N | 1 | 2012-01-19 | ? | 0 | no | no | no | 2012-01-19 | ? | ? | 20120119.ifs | 2012-01-19 | 2012-01-20 | ||||||||||
758833 | 758833 | EXCHANGE | ADD | 902973833 | 66 | 2012-01-19 | 2012-01-19 | USBPP | 0 | 1 | 2012-01-19 | ? | 20120119.ifs | 2012-01-19 | 2012-01-20 | ||||||||||||||
759541 | 759541 | EQUITY | CHANGE | 902973833 | DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F | N | 1 | 2012-01-19 | ? | 0 | no | no | no | 2012-01-19 | ? | ? | 20120119.ifs | 2012-01-19 | 2012-01-20 | ||||||||||
759542 | 759541 | EQUITY | CHANGE | 902973833 | DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F | 0 | 1 | 2012-01-19 | ? | 0 | no | no | no | 2012-01-19 | ? | ? | 20120119.ifs | 2012-01-19 | 2012-01-20 |
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 = 160388
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