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:159805 |
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 | ||
4725497 | 4725497 | CORPACTION | ADD | 61760E846 | 04 | C | 2021-06-09 | ? | 20210609.ifs | 2021-06-09 | 2021-06-10 | ||||||||||||||||||
4725498 | 4725498 | EQUITY | CHANGE | 61760E846 | CUSHING MLP HIGH INCOME INDEX ETN | 0 | 0 | 2011-03-17 | ? | 4 | no | no | no | 2011-03-17 | 2011-03-18 | ? | 20210609.ifs | 2021-06-09 | 2021-06-10 | ||||||||||
4725499 | 4725498 | EQUITY | CHANGE | 61760E846 | CUSHING MLP HIGH INCOME INDEX ETN | C | 0 | 2011-03-17 | 2021-06-09 | 4 | no | no | no | 2011-03-17 | 2021-06-09 | ? | 20210609.ifs | 2021-06-09 | 2021-06-10 | ||||||||||
4679452 | 4679452 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .0809 | 00 | 2021-04-12 | 2021-04-13 | 2021-04-21 | 2021-04-09 | 0 | 2021-04-09 | ? | 0 | 0006293765 | 20210409.ifs | 2021-04-09 | 2021-04-10 | |||||||
4604475 | 4604475 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .0779 | 00 | 2021-01-12 | 2021-01-13 | 2021-01-22 | 2021-01-11 | 0 | 2021-01-11 | ? | 0 | 0006251387 | 20210111.ifs | 2021-01-11 | 2021-01-12 | |||||||
4484508 | 4484508 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .0885 | 00 | 2020-10-09 | 2020-10-13 | 2020-10-21 | 2020-10-08 | 0 | 2020-10-08 | ? | 0 | 0006174379 | 20201008.ifs | 2020-10-08 | 2020-10-09 | |||||||
4417599 | 4417599 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .0745 | 00 | 2020-07-13 | 2020-07-14 | 2020-07-22 | 2020-07-10 | 0 | 2020-07-10 | ? | 0 | 0006130022 | 20200710.ifs | 2020-07-10 | 2020-07-11 | |||||||
4284563 | 4284563 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1445 | 00 | 2020-04-09 | 2020-04-13 | 2020-04-21 | 2020-04-08 | 0 | 2020-04-08 | ? | 0 | 0006084604 | 20200408.ifs | 2020-04-08 | 2020-04-09 | |||||||
4284568 | 4284568 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1445 | 00 | 2020-04-09 | 2020-04-13 | 2020-04-21 | 2020-04-08 | 0 | 2020-04-08 | ? | 0 | 0006084604 | 20200408.ifs | 2020-04-08 | 2020-04-09 | |||||||
4167206 | 4167206 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1396 | 00 | 2020-01-10 | 2020-01-13 | 2020-01-22 | 2020-01-09 | 0 | 2020-01-09 | ? | 0 | 0006042243 | 20200109.ifs | 2020-01-09 | 2020-01-10 | |||||||
4167537 | 4167537 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1396 | 00 | 2020-01-10 | 2020-01-13 | 2020-01-22 | 2020-01-09 | 0 | 2020-01-09 | ? | 0 | 0006042243 | 20200109.ifs | 2020-01-09 | 2020-01-10 | |||||||
3969492 | 3969492 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .135 | 00 | 2019-10-10 | 2019-10-11 | 2019-10-21 | 2019-10-09 | 0 | 2019-10-09 | ? | 0 | 0005961750 | 20191009.ifs | 2019-10-09 | 2019-10-10 | |||||||
3969616 | 3969616 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .135 | 00 | 2019-10-10 | 2019-10-11 | 2019-10-21 | 2019-10-09 | 0 | 2019-10-09 | ? | 0 | 0005961750 | 20191009.ifs | 2019-10-09 | 2019-10-10 | |||||||
3833159 | 3833159 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1377 | 00 | 2019-07-12 | 2019-07-15 | 2019-07-23 | 2019-07-11 | 0 | 2019-07-11 | ? | 0 | 0005916084 | 20190711.ifs | 2019-07-11 | 2019-07-12 | |||||||
3833298 | 3833298 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1377 | 00 | 2019-07-12 | 2019-07-15 | 2019-07-23 | 2019-07-11 | 0 | 2019-07-11 | ? | 0 | 0005916084 | 20190711.ifs | 2019-07-11 | 2019-07-12 | |||||||
3680059 | 3680059 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1539 | 00 | 2019-04-11 | 2019-04-12 | 2019-04-23 | 2019-04-09 | 0 | 2019-04-09 | ? | 0 | 0005869633 | 20190409.ifs | 2019-04-09 | 2019-04-10 | |||||||
3680062 | 3680062 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1539 | 00 | 2019-04-11 | 2019-04-12 | 2019-04-23 | 2019-04-09 | 0 | 2019-04-09 | ? | 0 | 0005869633 | 20190409.ifs | 2019-04-09 | 2019-04-10 | |||||||
3547131 | 3547131 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1465 | 00 | 2019-01-11 | 2019-01-14 | 2019-01-23 | 2019-01-10 | 0 | 2019-01-10 | ? | 0 | 0005825392 | 20190110.ifs | 2019-01-10 | 2019-01-11 | |||||||
3547645 | 3547645 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1465 | 00 | 2019-01-11 | 2019-01-14 | 2019-01-23 | 2019-01-10 | 0 | 2019-01-10 | ? | 0 | 0005825392 | 20190110.ifs | 2019-01-10 | 2019-01-11 | |||||||
3326683 | 3326683 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1643 | 00 | 2018-10-11 | 2018-10-12 | 2018-10-22 | 2018-10-09 | 0 | 2018-10-09 | ? | 0 | 0005740153 | 20181009.ifs | 2018-10-09 | 2018-10-10 | |||||||
3326742 | 3326742 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1643 | 00 | 2018-10-11 | 2018-10-12 | 2018-10-22 | 2018-10-09 | 0 | 2018-10-09 | ? | 0 | 0005740153 | 20181009.ifs | 2018-10-09 | 2018-10-10 | |||||||
3188870 | 3188870 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1541 | 00 | 2018-07-13 | 2018-07-16 | 2018-07-24 | 2018-07-10 | 0 | 2018-07-10 | ? | 0 | 0005692766 | 20180710.ifs | 2018-07-10 | 2018-07-11 | |||||||
3188871 | 3188871 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1541 | 00 | 2018-07-13 | 2018-07-16 | 2018-07-24 | 2018-07-10 | 0 | 2018-07-10 | ? | 0 | 0005692766 | 20180710.ifs | 2018-07-10 | 2018-07-11 | |||||||
3036339 | 3036339 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1586 | 00 | 2018-04-12 | 2018-04-13 | 2018-04-23 | 2018-04-11 | 0 | 2018-04-11 | ? | 0 | 0005646545 | 20180411.ifs | 2018-04-11 | 2018-04-12 | |||||||
3036410 | 3036410 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1586 | 00 | 2018-04-12 | 2018-04-13 | 2018-04-23 | 2018-04-11 | 0 | 2018-04-11 | ? | 0 | 0005646545 | 20180411.ifs | 2018-04-11 | 2018-04-12 | |||||||
2917462 | 2917462 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1457 | 00 | 2018-01-12 | 2018-01-16 | 2018-01-24 | 2018-01-11 | 0 | 2018-01-11 | ? | 0 | 0005601565 | 20180111.ifs | 2018-01-11 | 2018-01-12 | |||||||
2917492 | 2917492 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1457 | 00 | 2018-01-12 | 2018-01-16 | 2018-01-24 | 2018-01-11 | 0 | 2018-01-11 | ? | 0 | 0005601565 | 20180111.ifs | 2018-01-11 | 2018-01-12 | |||||||
2719989 | 2719989 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1614 | 00 | 2017-10-12 | 2017-10-13 | 2017-10-23 | 2017-10-10 | 0 | 2017-10-10 | ? | 0 | 0005514143 | 20171010.ifs | 2017-10-10 | 2017-10-11 | |||||||
2617855 | 2617855 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1464 | 00 | 2017-07-12 | 2017-07-14 | 2017-07-24 | 2017-07-07 | 0 | 2017-07-07 | ? | 0 | 0005466899 | 20170707.ifs | 2017-07-07 | 2017-07-08 | |||||||
2538173 | 2538173 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1603 | 00 | 2017-04-10 | 2017-04-12 | 2017-04-21 | 2017-04-06 | 0 | 2017-04-06 | ? | 0 | 0005419699 | 20170406.ifs | 2017-04-06 | 2017-04-07 | |||||||
2442062 | 2442062 | EQUITY | CHANGE | 61760E846 | CUSHING MLP HIGH INCOME INDEX ETN | 0 | 0 | 2011-03-17 | ? | 0 | no | no | no | 2011-03-17 | 2011-03-18 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2442063 | 2442062 | EQUITY | CHANGE | 61760E846 | CUSHING MLP HIGH INCOME INDEX ETN | 0 | 0 | 2011-03-17 | ? | 4 | no | no | no | 2011-03-17 | 2011-03-18 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2421243 | 2421243 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1472 | 00 | 2017-01-11 | 2017-01-13 | 2017-01-24 | 2017-01-09 | 0 | 2017-01-09 | ? | 0 | 0005373333 | 20170109.ifs | 2017-01-09 | 2017-01-10 | |||||||
2319138 | 2319138 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1621 | 00 | 2016-10-11 | 2016-10-13 | 2016-10-21 | 2016-10-10 | 0 | 2016-10-10 | ? | 0 | 0005297447 | 20161010.ifs | 2016-10-10 | 2016-10-11 | |||||||
2248558 | 2248558 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .1505 | 00 | 2016-07-12 | 2016-07-14 | 2016-07-22 | 2016-07-08 | 0 | 2016-07-08 | ? | 0 | 0005250561 | 20160708.ifs | 2016-07-08 | 2016-07-09 | |||||||
2160663 | 2160663 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .2201 | 00 | 2016-04-08 | 2016-04-12 | 2016-04-20 | 2016-04-07 | 0 | 2016-04-07 | ? | 0 | 0005204389 | 20160407.ifs | 2016-04-07 | 2016-04-08 | |||||||
2089535 | 2089535 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .2409 | 00 | 2016-01-11 | 2016-01-13 | 2016-01-22 | 2016-01-07 | 0 | 2016-01-07 | ? | 0 | 0005158836 | 20160107.ifs | 2016-01-07 | 2016-01-08 | |||||||
1987136 | 1987136 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .2805 | 00 | 2015-10-08 | 2015-10-13 | 2015-10-21 | 2015-10-06 | 0 | 2015-10-06 | ? | 0 | 0005078624 | 20151006.ifs | 2015-10-06 | 2015-10-07 | |||||||
1836535 | 1836535 | DIVIDEND | DELETE | 61760E846 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2015-01-30 | 2015-01-29 | 0 | 2015-01-29 | ? | 0 | 0004944980 | 20150407.ifs | 2015-04-07 | 2015-04-08 | |||||||
1836536 | 1836536 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3335 | 00 | 2015-04-09 | 2015-04-13 | 2015-04-21 | 2015-01-29 | 1 | 2015-01-29 | 2015-04-07 | 0 | 0004944980 | 20150407.ifs | 2015-04-07 | 2015-04-08 | |||||||
1777891 | 1777891 | DIVIDEND | ADD | 61760E846 | 0 | 0 | C | 0 | 25 | 12 | ? | ? | 2015-01-30 | 2015-01-30 | 0 | ? | 2015-01-30 | 0 | 20150130.ifs | 2015-01-30 | 2015-01-31 | ||||||||
1777072 | 1777072 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 6 | 0 | 08 | ? | ? | 2015-01-30 | 2015-01-29 | 0 | 2015-01-29 | ? | 0 | 0004944980 | 20150129.ifs | 2015-01-29 | 2015-01-30 | |||||||
1769326 | 1769326 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 0 | .3593 | 00 | 2015-01-09 | 2015-01-13 | 2015-01-22 | 2015-01-07 | 0 | 2015-01-07 | ? | 0 | 0004940813 | 20150115.ifs | 2015-01-15 | 2015-01-16 | |||||||
1769327 | 1769326 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 0 | .3601 | 00 | 2015-01-09 | 2015-01-13 | 2015-01-22 | 2015-01-07 | 1 | 2015-01-07 | 2015-01-15 | 0 | 0004940813 | 20150115.ifs | 2015-01-15 | 2015-01-16 | |||||||
1766023 | 1766023 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3593 | 00 | 2015-01-09 | 2015-01-13 | 2015-01-22 | 2015-01-07 | 0 | 2015-01-07 | ? | 0 | 0004940813 | 20150107.ifs | 2015-01-07 | 2015-01-08 | |||||||
1652513 | 1652513 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3342 | 00 | 2014-10-08 | 2014-10-13 | 2014-10-21 | 2014-10-03 | 0 | 2014-10-03 | ? | 0 | 0004857782 | 20141003.ifs | 2014-10-03 | 2014-10-04 | |||||||
1575921 | 1575921 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3333 | 00 | 2014-07-10 | 2014-07-14 | 2014-07-22 | 2014-07-07 | 0 | 2014-07-07 | ? | 0 | 0004813791 | 20140707.ifs | 2014-07-07 | 2014-07-08 | |||||||
1491132 | 1491132 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .348 | 00 | 2014-04-09 | 2014-04-11 | 2014-04-22 | 2014-04-03 | 0 | 2014-04-03 | ? | 0 | 0004766190 | 20140403.ifs | 2014-04-03 | 2014-04-04 | |||||||
1416769 | 1416769 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3297 | 00 | 2014-01-09 | 2014-01-13 | 2014-01-22 | 2014-01-03 | 0 | 2014-01-03 | ? | 0 | 0004721083 | 20140103.ifs | 2014-01-03 | 2014-01-04 | |||||||
1312617 | 1312617 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3488 | 00 | 2013-10-09 | 2013-10-11 | 2013-10-21 | 2013-10-07 | 0 | 2013-10-07 | ? | 0 | 0004644532 | 20131007.ifs | 2013-10-07 | 2013-10-08 | |||||||
1236863 | 1236863 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3407 | 00 | 2013-07-11 | 2013-07-15 | 2013-07-23 | 2013-07-08 | 0 | 2013-07-08 | ? | 0 | 0004600398 | 20130708.ifs | 2013-07-08 | 2013-07-09 | |||||||
1203978 | 1203978 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 0 | .3309 | 00 | 2013-04-10 | 2013-04-12 | 2013-04-22 | 2013-04-04 | 0 | 2013-04-04 | ? | 0 | 0004556372 | 20130604.ifs | 2013-06-04 | 2013-06-05 | |||||||
1203979 | 1203978 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 0 | .3309 | 00 | 2013-04-10 | 2013-04-12 | 2013-04-22 | 2013-04-04 | 1 | 2013-04-04 | 2013-06-04 | 1 | 0004556372 | 20130604.ifs | 2013-06-04 | 2013-06-05 | |||||||
1203980 | 1203980 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 0 | .3224 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2013-01-08 | 0 | 2013-01-08 | ? | 0 | 0004512751 | 20130604.ifs | 2013-06-04 | 2013-06-05 | |||||||
1203981 | 1203980 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 0 | .3224 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2013-01-08 | 1 | 2013-01-08 | 2013-06-04 | 0 | 0004512751 | 20130604.ifs | 2013-06-04 | 2013-06-05 | |||||||
1155455 | 1155455 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3309 | 00 | 2013-04-10 | 2013-04-12 | 2013-04-22 | 2013-04-04 | 0 | 2013-04-04 | ? | 0 | 0004556372 | 20130404.ifs | 2013-04-04 | 2013-04-05 | |||||||
1085956 | 1085956 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3224 | 00 | 2013-01-10 | 2013-01-14 | 2013-01-23 | 2013-01-08 | 0 | 2013-01-08 | ? | 0 | 0004512751 | 20130108.ifs | 2013-01-08 | 2013-01-09 | |||||||
981466 | 981466 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .3408 | 00 | 2012-10-10 | 2012-10-12 | 2012-10-22 | 2012-10-05 | 0 | 2012-10-05 | ? | 0 | 0004443997 | 20121005.ifs | 2012-10-05 | 2012-10-06 | |||||||
830463 | 830463 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .2861 | 00 | 2012-04-11 | 2012-04-13 | 2012-04-23 | 2012-04-04 | 0 | 2012-04-04 | ? | 0 | 0004359517 | 20120404.ifs | 2012-04-04 | 2012-04-05 | |||||||
750001 | 750001 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .2721 | 00 | 2012-01-11 | 2012-01-13 | 2012-01-24 | 2012-01-04 | 0 | 2012-01-04 | ? | 0 | 0004317708 | 20120104.ifs | 2012-01-04 | 2012-01-05 | |||||||
668325 | 668325 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 0 | .2762 | 00 | 2011-10-11 | 2011-10-13 | 2011-10-21 | 2011-10-05 | 0 | 2011-10-05 | ? | 0 | 0004255761 | 20111005.ifs | 2011-10-05 | 2011-10-06 | |||||||
668326 | 668326 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 4 | .2684 | 00 | 2011-07-12 | 2011-07-14 | 2011-07-22 | 2011-06-30 | 0 | 2011-06-30 | ? | 0 | 0004208089 | 20111005.ifs | 2011-10-05 | 2011-10-06 | |||||||
668327 | 668326 | DIVIDEND | CHANGE | 61760E846 | 0 | 0 | 1 | 0 | .2684 | 00 | 2011-07-12 | 2011-07-14 | 2011-07-22 | 2011-06-30 | 1 | 2011-06-30 | 2011-10-05 | 0 | 0004208089 | 20111005.ifs | 2011-10-05 | 2011-10-06 | |||||||
574936 | 574936 | DIVIDEND | ADD | 61760E846 | 0 | 0 | 1 | 4 | .2684 | 00 | 2011-07-12 | 2011-07-14 | 2011-07-22 | 2011-06-30 | 0 | 2011-06-30 | ? | 0 | 0004208089 | 20110630.ifs | 2011-06-30 | 2011-07-01 | |||||||
474167 | 474167 | EQUITY | CHANGE | 61760E846 | COM | 0 | 0 | 2011-03-17 | ? | 0 | no | no | no | 2011-03-17 | ? | ? | 20110318.ifs | 2011-03-18 | 2011-03-19 | ||||||||||
474168 | 474167 | EQUITY | CHANGE | 61760E846 | CUSHING MLP HIGH INCOME INDEX ETN | 0 | 0 | 2011-03-17 | ? | 0 | no | no | no | 2011-03-17 | 2011-03-18 | ? | 20110318.ifs | 2011-03-18 | 2011-03-19 | ||||||||||
473273 | 473273 | EQUITY | ADD | 61760E846 | COM | N | 0 | 2011-03-17 | ? | 0 | no | no | no | 2011-03-17 | ? | ? | 20110317.ifs | 2011-03-17 | 2011-03-18 | ||||||||||
473274 | 473274 | EXCHANGE | ADD | 61760E846 | 04 | 2011-03-17 | 2011-03-17 | MLPY | 0 | 0 | 2011-03-17 | ? | 20110317.ifs | 2011-03-17 | 2011-03-18 | ||||||||||||||
474123 | 474123 | EQUITY | CHANGE | 61760E846 | COM | N | 0 | 2011-03-17 | ? | 0 | no | no | no | 2011-03-17 | ? | ? | 20110317.ifs | 2011-03-17 | 2011-03-18 | ||||||||||
474124 | 474123 | EQUITY | CHANGE | 61760E846 | COM | 0 | 0 | 2011-03-17 | ? | 0 | no | no | no | 2011-03-17 | ? | ? | 20110317.ifs | 2011-03-17 | 2011-03-18 |
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 = 159805
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