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:130892 |
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 | ||
3562703 | 3562703 | CORPACTION | ADD | 29336U107 | 01 | M | 2019-01-28 | 29336T100 | 01 | 2019-01-28 | 20190128.ifs | 2019-01-28 | 2019-01-29 | ||||||||||||||||
3562704 | 3562704 | CORPACTION | ADD | 29336U107 | 01 | M | 2019-01-28 | 29336T100 | 01 | 2019-01-28 | 20190128.ifs | 2019-01-28 | 2019-01-29 | ||||||||||||||||
3562705 | 3562705 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 4 | no | no | no | 2014-03-07 | 2019-01-25 | ? | 20190128.ifs | 2019-01-28 | 2019-01-29 | ||||||||||
3562706 | 3562706 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 4 | no | no | no | 2014-03-07 | 2019-01-25 | ? | 20190128.ifs | 2019-01-28 | 2019-01-29 | ||||||||||
3562707 | 3562706 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | M | 0 | 2014-03-06 | 2019-01-28 | 4 | no | no | 29336T100 | no | 2014-03-07 | 2019-01-28 | ? | 20190128.ifs | 2019-01-28 | 2019-01-29 | |||||||||
3562708 | 3562707 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | M | 0 | 2014-03-06 | 2019-01-28 | 4 | no | no | 29336T100 | no | 2014-03-07 | 2019-01-28 | ? | 20190128.ifs | 2019-01-28 | 2019-01-29 | |||||||||
3561580 | 3561580 | CORPACTION | ADD | 29336U107 | 01 | M | 2019-01-25 | 29336T100 | 01 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||||||||
3561582 | 3561582 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 4 | no | no | no | 2014-03-07 | ? | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||
3561584 | 3561583 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | M | 0 | 2014-03-06 | 2019-01-25 | 4 | no | no | 29336T100 | no | 2014-03-07 | 2019-01-25 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||||
3561591 | 3561591 | CORPACTION | ADD | 29336U107 | 01 | M | 2019-01-25 | 29336T100 | 01 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||||||||
3561593 | 3561593 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 4 | no | no | no | 2014-03-07 | ? | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||
3561595 | 3561594 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | M | 0 | 2014-03-06 | 2019-01-25 | 4 | no | no | 29336T100 | no | 2014-03-07 | 2019-01-25 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||||
3561651 | 3561651 | CORPACTION | DELETE | 29336U107 | 01 | M | 2019-01-25 | 29336T100 | 01 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||||||||
3561653 | 3561653 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | M | 0 | 2014-03-06 | 2019-01-25 | 4 | no | no | 29336T100 | no | 2014-03-07 | 2019-01-25 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||||
3561655 | 3561654 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 4 | no | no | no | 2014-03-07 | 2019-01-25 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||
3561664 | 3561664 | CORPACTION | DELETE | 29336U107 | 01 | M | 2019-01-25 | 29336T100 | 01 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||||||||
3561666 | 3561666 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | M | 0 | 2014-03-06 | 2019-01-25 | 4 | no | no | 29336T100 | no | 2014-03-07 | 2019-01-25 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||||
3561669 | 3561668 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 4 | no | no | no | 2014-03-07 | 2019-01-25 | ? | 20190125.ifs | 2019-01-25 | 2019-01-26 | ||||||||||
3562080 | 3562080 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2019-01-23 | 2019-01-24 | 2019-02-13 | 2019-01-14 | 0 | 2019-01-14 | ? | 1 | 0005825785 | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||
3562082 | 3562081 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2019-01-23 | 2019-01-24 | 2019-02-13 | 2019-01-14 | 1 | 2019-01-14 | 2019-01-25 | 1 | 0005825785 | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||
3562095 | 3562095 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2019-01-23 | 2019-01-24 | 2019-02-13 | 2019-01-14 | 0 | 2019-01-14 | ? | 1 | 0005825785 | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||
3562097 | 3562096 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2019-01-23 | 2019-01-24 | 2019-02-13 | 2019-01-14 | 1 | 2019-01-14 | 2019-01-25 | 1 | 0005825785 | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||
3549518 | 3549518 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2019-01-23 | 2019-01-24 | 2019-02-13 | 2019-01-14 | 0 | 2019-01-14 | ? | 1 | 0005825785 | 20190114.ifs | 2019-01-14 | 2019-01-15 | |||||||
3549520 | 3549520 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-13 | 2018-10-18 | 0 | 2018-10-18 | ? | 0 | 0005741589 | 20190114.ifs | 2019-01-14 | 2019-01-15 | |||||||
3549521 | 3549520 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-13 | 2018-10-18 | 1 | 2018-10-18 | 2019-01-14 | 0 | 0005741589 | 20190114.ifs | 2019-01-14 | 2019-01-15 | |||||||
3549522 | 3549522 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2019-01-23 | 2019-01-24 | 2019-02-13 | 2019-01-14 | 0 | 2019-01-14 | ? | 1 | 0005825785 | 20190114.ifs | 2019-01-14 | 2019-01-15 | |||||||
3549524 | 3549524 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-13 | 2018-10-18 | 0 | 2018-10-18 | ? | 0 | 0005741589 | 20190114.ifs | 2019-01-14 | 2019-01-15 | |||||||
3549525 | 3549524 | DIVIDEND | CHANGE | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-13 | 2018-10-18 | 1 | 2018-10-18 | 2019-01-14 | 0 | 0005741589 | 20190114.ifs | 2019-01-14 | 2019-01-15 | |||||||
3332473 | 3332473 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-13 | 2018-10-18 | 0 | 2018-10-18 | ? | 0 | 0005741589 | 20181018.ifs | 2018-10-18 | 2018-10-19 | |||||||
3333146 | 3333146 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-10-26 | 2018-10-29 | 2018-11-13 | 2018-10-18 | 0 | 2018-10-18 | ? | 0 | 0005741589 | 20181018.ifs | 2018-10-18 | 2018-10-19 | |||||||
3197986 | 3197986 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-07-27 | 2018-07-30 | 2018-08-13 | 2018-07-18 | 0 | 2018-07-18 | ? | 0 | 0005694552 | 20180718.ifs | 2018-07-18 | 2018-07-19 | |||||||
3197987 | 3197987 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-07-27 | 2018-07-30 | 2018-08-13 | 2018-07-18 | 0 | 2018-07-18 | ? | 0 | 0005694552 | 20180718.ifs | 2018-07-18 | 2018-07-19 | |||||||
3044070 | 3044070 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-04-27 | 2018-04-30 | 2018-05-14 | 2018-04-19 | 0 | 2018-04-19 | ? | 0 | 0005648095 | 20180419.ifs | 2018-04-19 | 2018-04-20 | |||||||
3044083 | 3044083 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-04-27 | 2018-04-30 | 2018-05-14 | 2018-04-19 | 0 | 2018-04-19 | ? | 0 | 0005648095 | 20180419.ifs | 2018-04-19 | 2018-04-20 | |||||||
2921497 | 2921497 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-01-30 | 2018-01-31 | 2018-02-13 | 2018-01-18 | 0 | 2018-01-18 | ? | 0 | 0005602419 | 20180118.ifs | 2018-01-18 | 2018-01-19 | |||||||
2921503 | 2921503 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2018-01-30 | 2018-01-31 | 2018-02-13 | 2018-01-18 | 0 | 2018-01-18 | ? | 0 | 0005602419 | 20180118.ifs | 2018-01-18 | 2018-01-19 | |||||||
2730990 | 2730990 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2017-10-31 | 2017-11-01 | 2017-11-13 | 2017-10-20 | 0 | 2017-10-20 | ? | 0 | 0005516265 | 20171020.ifs | 2017-10-20 | 2017-10-21 | |||||||
2730997 | 2730997 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2017-10-31 | 2017-11-01 | 2017-11-13 | 2017-10-20 | 0 | 2017-10-20 | ? | 0 | 0005516265 | 20171020.ifs | 2017-10-20 | 2017-10-21 | |||||||
2627655 | 2627655 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2017-07-28 | 2017-08-01 | 2017-08-11 | 2017-07-20 | 0 | 2017-07-20 | ? | 0 | 0005469551 | 20170720.ifs | 2017-07-20 | 2017-07-21 | |||||||
2545840 | 2545840 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2017-04-28 | 2017-05-02 | 2017-05-12 | 2017-04-21 | 0 | 2017-04-21 | ? | 0 | 0005422697 | 20170421.ifs | 2017-04-21 | 2017-04-22 | |||||||
2437486 | 2437486 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 0 | no | no | no | 2014-03-07 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2437487 | 2437486 | EQUITY | CHANGE | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 4 | no | no | no | 2014-03-07 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2428638 | 2428638 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2017-01-27 | 2017-01-31 | 2017-02-13 | 2017-01-19 | 0 | 2017-01-19 | ? | 0 | 0005376274 | 20170119.ifs | 2017-01-19 | 2017-01-20 | |||||||
2323992 | 2323992 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2016-10-27 | 2016-10-31 | 2016-11-11 | 2016-10-20 | 0 | 2016-10-20 | ? | 0 | 0005299672 | 20161020.ifs | 2016-10-20 | 2016-10-21 | |||||||
2254246 | 2254246 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2016-07-28 | 2016-08-01 | 2016-08-11 | 2016-07-20 | 0 | 2016-07-20 | ? | 0 | 0005252642 | 20160720.ifs | 2016-07-20 | 2016-07-21 | |||||||
2168751 | 2168751 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2016-04-28 | 2016-05-02 | 2016-05-12 | 2016-04-21 | 0 | 2016-04-21 | ? | 0 | 0005206889 | 20160421.ifs | 2016-04-21 | 2016-04-22 | |||||||
2096355 | 2096355 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2016-01-28 | 2016-02-01 | 2016-02-11 | 2016-01-21 | 0 | 2016-01-21 | ? | 0 | 0005161301 | 20160121.ifs | 2016-01-21 | 2016-01-22 | |||||||
1994415 | 1994415 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .39 | 00 | 2015-10-29 | 2015-11-02 | 2015-11-12 | 2015-10-21 | 0 | 2015-10-21 | ? | 0 | 0005080881 | 20151021.ifs | 2015-10-21 | 2015-10-22 | |||||||
1920243 | 1920243 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .385 | 00 | 2015-07-29 | 2015-07-31 | 2015-08-13 | 2015-07-21 | 0 | 2015-07-21 | ? | 0 | 0005034085 | 20150721.ifs | 2015-07-21 | 2015-07-22 | |||||||
1846161 | 1846161 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .38 | 00 | 2015-04-29 | 2015-05-01 | 2015-05-14 | 2015-04-23 | 0 | 2015-04-23 | ? | 0 | 0004988451 | 20150423.ifs | 2015-04-23 | 2015-04-24 | |||||||
1771333 | 1771333 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .375 | 00 | 2015-01-29 | 2015-02-02 | 2015-02-12 | 2015-01-20 | 0 | 2015-01-20 | ? | 0 | 0004942449 | 20150120.ifs | 2015-01-20 | 2015-01-21 | |||||||
1661398 | 1661398 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .37 | 00 | 2014-10-30 | 2014-11-03 | 2014-11-13 | 2014-10-22 | 0 | 2014-10-22 | ? | 0 | 0004861071 | 20141022.ifs | 2014-10-22 | 2014-10-23 | |||||||
1586908 | 1586908 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .365 | 00 | 2014-07-31 | 2014-08-04 | 2014-08-13 | 2014-07-25 | 0 | 2014-07-25 | ? | 0 | 0004817524 | 20140725.ifs | 2014-07-25 | 2014-07-26 | |||||||
1502467 | 1502467 | DIVIDEND | ADD | 29336U107 | 0 | 0 | 1 | 0 | .36 | 00 | 2014-05-01 | 2014-05-05 | 2014-05-14 | 2014-04-25 | 0 | 2014-04-25 | ? | 0 | 0004771042 | 20140425.ifs | 2014-04-25 | 2014-04-26 | |||||||
1462077 | 1462077 | EQUITY | ADD | 29336U107 | COM UNITS REPSTG LTD PARTNER INT | 0 | 0 | 2014-03-06 | ? | 0 | no | no | no | 2014-03-07 | ? | ? | 20140307.ifs | 2014-03-07 | 2014-03-08 |
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 = 130892
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