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:130596 |
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 | ||
3059359 | 3059359 | CORPACTION | ADD | 00305P106 | 02 | M | 2018-04-30 | 00301W105 | 02 | ? | 20180430.ifs | 2018-04-30 | 2018-05-01 | ||||||||||||||||
3059361 | 3059361 | EQUITY | CHANGE | 00305P106 | COM | 0 | A | 2010-04-14 | ? | 0 | no | no | no | 2010-04-14 | 2010-04-14 | ? | 20180430.ifs | 2018-04-30 | 2018-05-01 | ||||||||||
3059362 | 3059362 | CORPACTION | ADD | 00305P106 | 02 | M | 2018-04-30 | 00301W105 | 02 | ? | 20180430.ifs | 2018-04-30 | 2018-05-01 | ||||||||||||||||
3059363 | 3059362 | EQUITY | CHANGE | 00305P106 | COM | M | A | 2010-04-14 | 2018-04-30 | 0 | no | no | 00301W105 | no | 2010-04-14 | 2018-04-30 | ? | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||||
3059364 | 3059364 | EQUITY | CHANGE | 00305P106 | COM | 0 | A | 2010-04-14 | ? | 0 | no | no | no | 2010-04-14 | 2010-04-14 | ? | 20180430.ifs | 2018-04-30 | 2018-05-01 | ||||||||||
3059366 | 3059365 | EQUITY | CHANGE | 00305P106 | COM | M | A | 2010-04-14 | 2018-04-30 | 0 | no | no | 00301W105 | no | 2010-04-14 | 2018-04-30 | ? | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||||
3065491 | 3065491 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .03182 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-08 | 2017-12-19 | 1 | 2017-12-19 | 2018-04-13 | 0 | 0005567333 | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||
3065493 | 3065492 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .03182 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-08 | 2017-12-19 | 2 | 2017-12-19 | 2018-04-30 | 0 | 0005567333 | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||
3065494 | 3065494 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .03182 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-08 | 2017-12-19 | 1 | 2017-12-19 | 2018-04-13 | 0 | 0005567333 | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||
3065496 | 3065495 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .03182 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-08 | 2017-12-19 | 2 | 2017-12-19 | 2018-04-30 | 0 | 0005567333 | 20180430.ifs | 2018-04-30 | 2018-05-01 | |||||||
2847373 | 2847373 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .03182 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-08 | 2017-12-19 | 0 | 2017-12-19 | ? | 0 | 0005567333 | 20171219.ifs | 2017-12-19 | 2017-12-20 | |||||||
2847473 | 2847473 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .03182 | 00 | 2017-12-28 | 2017-12-29 | 2018-01-08 | 2017-12-19 | 0 | 2017-12-19 | ? | 0 | 0005567333 | 20171219.ifs | 2017-12-19 | 2017-12-20 | |||||||
2718769 | 2718769 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .01983 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-12 | 0 | 2017-09-14 | ? | 0 | 0005496454 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2718770 | 2718769 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .01983 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-12 | 1 | 2017-09-14 | 2017-10-06 | 0 | 0005496454 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2718928 | 2718928 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .01983 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-12 | 0 | 2017-09-14 | ? | 0 | 0005496454 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2718929 | 2718928 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .01983 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-12 | 1 | 2017-09-14 | 2017-10-06 | 0 | 0005496454 | 20171006.ifs | 2017-10-06 | 2017-10-07 | |||||||
2671488 | 2671488 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .01983 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-12 | 0 | 2017-09-14 | ? | 0 | 0005496454 | 20170914.ifs | 2017-09-14 | 2017-09-15 | |||||||
2671824 | 2671824 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .01983 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-12 | 0 | 2017-09-14 | ? | 0 | 0005496454 | 20170914.ifs | 2017-09-14 | 2017-09-15 | |||||||
2291913 | 2291913 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .0304 | 96 | 2016-09-19 | 2016-09-21 | 2016-09-28 | 2016-09-12 | 0 | 2016-09-12 | ? | 0 | 0005279473 | 20160912.ifs | 2016-09-12 | 2016-09-13 | |||||||
2054605 | 2054605 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .14852 | 96 | 2015-12-29 | 2015-12-31 | 2016-01-12 | 2015-12-18 | 0 | 2015-12-18 | ? | 1 | 0005128534 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
2054606 | 2054606 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .00052 | 00 | 2015-12-29 | 2015-12-31 | 2016-01-12 | 2015-12-18 | 0 | 2015-12-18 | ? | 0 | 0005128398 | 20151218.ifs | 2015-12-18 | 2015-12-19 | |||||||
1963396 | 1963396 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .06975 | 00 | 2015-09-17 | 2015-09-21 | 2015-09-28 | 2015-09-10 | 0 | 2015-09-10 | ? | 0 | 0005061307 | 20150910.ifs | 2015-09-10 | 2015-09-11 | |||||||
1734449 | 1734449 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .39588 | 96 | 2014-12-29 | 2014-12-31 | 2015-01-12 | 2014-12-19 | 0 | 2014-12-19 | ? | 1 | 0004913253 | 20141219.ifs | 2014-12-19 | 2014-12-20 | |||||||
1734450 | 1734450 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .04973 | 00 | 2014-12-29 | 2014-12-31 | 2015-01-12 | 2014-12-19 | 0 | 2014-12-19 | ? | 0 | 0004912085 | 20141219.ifs | 2014-12-19 | 2014-12-20 | |||||||
1627757 | 1627757 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .1099 | 00 | 2014-09-18 | 2014-09-22 | 2014-09-30 | 2014-09-10 | 0 | 2014-09-10 | ? | 0 | 0004841720 | 20140910.ifs | 2014-09-10 | 2014-09-11 | |||||||
1391071 | 1391071 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .03321 | 95 | 2013-12-27 | 2013-12-31 | 2014-01-17 | 2013-12-20 | 0 | 2013-12-20 | ? | 2 | 0004696766 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1391072 | 1391072 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | 1.10366 | 96 | 2013-12-27 | 2013-12-31 | 2014-01-17 | 2013-12-20 | 0 | 2013-12-20 | ? | 1 | 0004696765 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1391073 | 1391073 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .05746 | 00 | 2013-12-27 | 2013-12-31 | 2014-01-17 | 2013-12-20 | 0 | 2013-12-20 | ? | 0 | 0004696762 | 20131220.ifs | 2013-12-20 | 2013-12-21 | |||||||
1285958 | 1285958 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .21861 | 96 | 2013-09-26 | 2013-09-30 | 2013-10-18 | 2013-09-11 | 0 | 2013-09-11 | ? | 1 | 0004627955 | 20130911.ifs | 2013-09-11 | 2013-09-12 | |||||||
1285959 | 1285959 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .00724 | 00 | 2013-09-26 | 2013-09-30 | 2013-10-18 | 2013-09-11 | 0 | 2013-09-11 | ? | 0 | 0004627954 | 20130911.ifs | 2013-09-11 | 2013-09-12 | |||||||
1102639 | 1102639 | DIVIDEND | CHANGE | 00305P106 | 8 | 0 | 1 | 9 | .0105 | 95 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 0 | 2012-12-07 | ? | 2 | 0004471903 | 20130131.ifs | 2013-01-31 | 2013-02-01 | |||||||
1102640 | 1102639 | DIVIDEND | CHANGE | 00305P106 | 8 | 0 | 1 | 9 | .0105 | 95 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 1 | 2012-12-07 | 2013-01-31 | 2 | 0004471903 | 20130131.ifs | 2013-01-31 | 2013-02-01 | |||||||
1102641 | 1102641 | DIVIDEND | CHANGE | 00305P106 | 8 | 0 | 1 | 9 | 2.16034 | 96 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 0 | 2012-12-07 | ? | 1 | 0004471898 | 20130131.ifs | 2013-01-31 | 2013-02-01 | |||||||
1102642 | 1102641 | DIVIDEND | CHANGE | 00305P106 | 8 | 0 | 1 | 9 | 2.16034 | 96 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 1 | 2012-12-07 | 2013-01-31 | 1 | 0004471898 | 20130131.ifs | 2013-01-31 | 2013-02-01 | |||||||
1102643 | 1102643 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .10866 | 00 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 0 | 2012-12-07 | ? | 0 | 0004471895 | 20130131.ifs | 2013-01-31 | 2013-02-01 | |||||||
1102644 | 1102643 | DIVIDEND | CHANGE | 00305P106 | 0 | 0 | 1 | 0 | .10866 | 00 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 1 | 2012-12-07 | 2013-01-31 | 0 | 0004471895 | 20130131.ifs | 2013-01-31 | 2013-02-01 | |||||||
1033058 | 1033058 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .0105 | 95 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 0 | 2012-12-07 | ? | 2 | 0004471903 | 20121207.ifs | 2012-12-07 | 2012-12-08 | |||||||
1033059 | 1033059 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | 2.16034 | 96 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 0 | 2012-12-07 | ? | 1 | 0004471898 | 20121207.ifs | 2012-12-07 | 2012-12-08 | |||||||
1033060 | 1033060 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .10866 | 00 | 2012-12-19 | 2012-12-21 | 2013-01-31 | 2012-12-07 | 0 | 2012-12-07 | ? | 0 | 0004471895 | 20121207.ifs | 2012-12-07 | 2012-12-08 | |||||||
951590 | 951590 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .0257 | 95 | 2012-09-26 | 2012-09-28 | 2012-10-12 | 2012-09-06 | 0 | 2012-09-06 | ? | 2 | 0004426717 | 20120906.ifs | 2012-09-06 | 2012-09-07 | |||||||
951591 | 951591 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .1763 | 96 | 2012-09-26 | 2012-09-28 | 2012-10-12 | 2012-09-06 | 0 | 2012-09-06 | ? | 1 | 0004426716 | 20120906.ifs | 2012-09-06 | 2012-09-07 | |||||||
951592 | 951592 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .0029 | 00 | 2012-09-26 | 2012-09-28 | 2012-10-12 | 2012-09-06 | 0 | 2012-09-06 | ? | 0 | 0004426713 | 20120906.ifs | 2012-09-06 | 2012-09-07 | |||||||
640543 | 640543 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .21229 | 96 | 2011-09-28 | 2011-09-30 | 2011-10-14 | 2011-09-09 | 0 | 2011-09-09 | ? | 1 | 0004241350 | 20110909.ifs | 2011-09-09 | 2011-09-10 | |||||||
640544 | 640544 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .01543 | 00 | 2011-09-28 | 2011-09-30 | 2011-10-14 | 2011-09-09 | 0 | 2011-09-09 | ? | 0 | 0004241347 | 20110909.ifs | 2011-09-09 | 2011-09-10 | |||||||
392587 | 392587 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .41084 | 95 | 2010-12-28 | 2010-12-30 | 2011-01-14 | 2010-12-22 | 0 | 2010-12-22 | ? | 2 | 0004114905 | 20101222.ifs | 2010-12-22 | 2010-12-23 | |||||||
392588 | 392588 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .49821 | 96 | 2010-12-28 | 2010-12-30 | 2011-01-14 | 2010-12-22 | 0 | 2010-12-22 | ? | 1 | 0004114903 | 20101222.ifs | 2010-12-22 | 2010-12-23 | |||||||
392589 | 392589 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .05984 | 00 | 2010-12-28 | 2010-12-30 | 2011-01-14 | 2010-12-22 | 0 | 2010-12-22 | ? | 0 | 0004114901 | 20101222.ifs | 2010-12-22 | 2010-12-23 | |||||||
299108 | 299108 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .047 | 95 | 2010-09-10 | 2010-09-14 | 2010-10-08 | 2010-09-01 | 0 | 2010-09-01 | ? | 2 | 0004056155 | 20100901.ifs | 2010-09-01 | 2010-09-02 | |||||||
299109 | 299109 | DIVIDEND | ADD | 00305P106 | 8 | 0 | 1 | 9 | .016 | 96 | 2010-09-10 | 2010-09-14 | 2010-10-08 | 2010-09-01 | 0 | 2010-09-01 | ? | 1 | 0004056154 | 20100901.ifs | 2010-09-01 | 2010-09-02 | |||||||
299110 | 299110 | DIVIDEND | ADD | 00305P106 | 0 | 0 | 1 | 0 | .012 | 00 | 2010-09-10 | 2010-09-14 | 2010-10-08 | 2010-09-01 | 0 | 2010-09-01 | ? | 0 | 0004056152 | 20100901.ifs | 2010-09-01 | 2010-09-02 | |||||||
158924 | 158924 | EQUITY | ADD | 00305P106 | COM | N | 0 | 2010-04-14 | ? | 0 | no | no | no | 2010-04-14 | ? | ? | 20100414.ifs | 2010-04-14 | 2010-04-15 | ||||||||||
158928 | 158928 | EXCHANGE | ADD | 00305P106 | 02 | 2010-04-14 | 2010-04-14 | IF | 0 | A | 2010-04-14 | ? | 20100414.ifs | 2010-04-14 | 2010-04-15 | ||||||||||||||
159056 | 159056 | EQUITY | CHANGE | 00305P106 | COM | N | 0 | 2010-04-14 | ? | 0 | no | no | no | 2010-04-14 | ? | ? | 20100414.ifs | 2010-04-14 | 2010-04-15 | ||||||||||
159057 | 159056 | EQUITY | CHANGE | 00305P106 | COM | N | A | 2010-04-14 | ? | 0 | no | no | no | 2010-04-14 | 2010-04-14 | ? | 20100414.ifs | 2010-04-14 | 2010-04-15 | ||||||||||
159339 | 159339 | EQUITY | CHANGE | 00305P106 | COM | N | A | 2010-04-14 | ? | 0 | no | no | no | 2010-04-14 | 2010-04-14 | ? | 20100414.ifs | 2010-04-14 | 2010-04-15 | ||||||||||
159340 | 159339 | EQUITY | CHANGE | 00305P106 | COM | 0 | A | 2010-04-14 | ? | 0 | no | no | no | 2010-04-14 | 2010-04-14 | ? | 20100414.ifs | 2010-04-14 | 2010-04-15 |
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 = 130596
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