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:159711 |
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 | ||
3032606 | 3032606 | CORPACTION | ADD | 78355W585 | 04 | Q | 2018-04-09 | 739371656 | 04 | ? | 20180409.ifs | 2018-04-09 | 2018-04-10 | ||||||||||||||||
3032607 | 3032607 | CORPACTION | ADD | 78355W585 | 04 | Q | 2018-04-09 | 739371656 | 04 | ? | 20180409.ifs | 2018-04-09 | 2018-04-10 | ||||||||||||||||
3032610 | 3032610 | EQUITY | CHANGE | 78355W585 | GUGGENHEIM RUSSELL 2000 EQUAL WEIGHT ETF | 0 | A | 2010-12-08 | ? | 4 | no | no | no | ? | 2012-03-01 | ? | 20180409.ifs | 2018-04-09 | 2018-04-10 | ||||||||||
3032611 | 3032611 | EQUITY | CHANGE | 78355W585 | GUGGENHEIM RUSSELL 2000 EQUAL WEIGHT ETF | 0 | A | 2010-12-08 | ? | 4 | no | no | no | ? | 2012-03-01 | ? | 20180409.ifs | 2018-04-09 | 2018-04-10 | ||||||||||
3032612 | 3032611 | EQUITY | CHANGE | 78355W585 | GUGGENHEIM RUSSELL 2000 EQUAL WEIGHT ETF | Q | A | 2010-12-08 | 2018-04-09 | 4 | no | no | 739371656 | no | ? | 2018-04-09 | ? | 20180409.ifs | 2018-04-09 | 2018-04-10 | |||||||||
3032613 | 3032612 | EQUITY | CHANGE | 78355W585 | GUGGENHEIM RUSSELL 2000 EQUAL WEIGHT ETF | Q | A | 2010-12-08 | 2018-04-09 | 4 | no | no | 739371656 | no | ? | 2018-04-09 | ? | 20180409.ifs | 2018-04-09 | 2018-04-10 | |||||||||
3033402 | 3033402 | DIVIDEND | CHANGE | 78355W585 | 0 | 0 | 1 | 0 | .1834 | 00 | 2018-03-16 | 2018-03-19 | 2018-03-29 | 2018-03-15 | 0 | 2018-03-15 | ? | 0 | 0005629930 | 20180409.ifs | 2018-04-09 | 2018-04-10 | |||||||
3033403 | 3033402 | DIVIDEND | CHANGE | 78355W585 | 0 | 0 | 1 | 0 | .1834 | 00 | 2018-03-16 | 2018-03-19 | 2018-03-29 | 2018-03-15 | 1 | 2018-03-15 | 2018-04-09 | 0 | 0005629930 | 20180409.ifs | 2018-04-09 | 2018-04-10 | |||||||
3033404 | 3033404 | DIVIDEND | CHANGE | 78355W585 | 0 | 0 | 1 | 0 | .1834 | 00 | 2018-03-16 | 2018-03-19 | 2018-03-29 | 2018-03-15 | 0 | 2018-03-15 | ? | 0 | 0005629930 | 20180409.ifs | 2018-04-09 | 2018-04-10 | |||||||
3033405 | 3033404 | DIVIDEND | CHANGE | 78355W585 | 0 | 0 | 1 | 0 | .1834 | 00 | 2018-03-16 | 2018-03-19 | 2018-03-29 | 2018-03-15 | 1 | 2018-03-15 | 2018-04-09 | 0 | 0005629930 | 20180409.ifs | 2018-04-09 | 2018-04-10 | |||||||
2992571 | 2992571 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .1834 | 00 | 2018-03-16 | 2018-03-19 | 2018-03-29 | 2018-03-15 | 0 | 2018-03-15 | ? | 0 | 0005629930 | 20180315.ifs | 2018-03-15 | 2018-03-16 | |||||||
2992674 | 2992674 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .1834 | 00 | 2018-03-16 | 2018-03-19 | 2018-03-29 | 2018-03-15 | 0 | 2018-03-15 | ? | 0 | 0005629930 | 20180315.ifs | 2018-03-15 | 2018-03-16 | |||||||
2670143 | 2670143 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .1268 | 00 | 2017-09-15 | 2017-09-18 | 2017-09-29 | 2017-09-14 | 0 | 2017-09-14 | ? | 0 | 0005497379 | 20170914.ifs | 2017-09-14 | 2017-09-15 | |||||||
2670537 | 2670537 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .1268 | 00 | 2017-09-15 | 2017-09-18 | 2017-09-29 | 2017-09-14 | 0 | 2017-09-14 | ? | 0 | 0005497379 | 20170914.ifs | 2017-09-14 | 2017-09-15 | |||||||
2591715 | 2591715 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .096 | 00 | 2017-06-16 | 2017-06-20 | 2017-06-30 | 2017-06-15 | 0 | 2017-06-15 | ? | 0 | 0005450216 | 20170615.ifs | 2017-06-15 | 2017-06-16 | |||||||
2513883 | 2513883 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .1536 | 00 | 2017-03-17 | 2017-03-21 | 2017-03-31 | 2017-03-16 | 0 | 2017-03-16 | ? | 0 | 0005403804 | 20170316.ifs | 2017-03-16 | 2017-03-17 | |||||||
2375562 | 2375562 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .048658 | 00 | 2016-12-16 | 2016-12-20 | 2016-12-30 | 2016-12-15 | 0 | 2016-12-15 | ? | 0 | 0005337123 | 20161215.ifs | 2016-12-15 | 2016-12-16 | |||||||
2293892 | 2293892 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .092104 | 00 | 2016-09-16 | 2016-09-20 | 2016-09-30 | 2016-09-15 | 0 | 2016-09-15 | ? | 0 | 0005281337 | 20160915.ifs | 2016-09-15 | 2016-09-16 | |||||||
2222312 | 2222312 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .05671 | 00 | 2016-06-17 | 2016-06-21 | 2016-06-30 | 2016-06-16 | 0 | 2016-06-16 | ? | 0 | 0005234200 | 20160616.ifs | 2016-06-16 | 2016-06-17 | |||||||
2137000 | 2137000 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .112027 | 00 | 2016-03-18 | 2016-03-22 | 2016-03-31 | 2016-03-17 | 0 | 2016-03-17 | ? | 0 | 0005188455 | 20160317.ifs | 2016-03-17 | 2016-03-18 | |||||||
2098835 | 2098835 | CORPACTION | ADD | 78355W585 | 04 | # | 2016-01-27 | 78355W585 | 04 | ? | 20160127.ifs | 2016-01-27 | 2016-01-28 | ||||||||||||||||
2098836 | 2098836 | CORPACTIONAUX | ADD | 78355W585 | 04 | 2016-01-27 | EWRS | RYDEX ETF TR | GUGGENHEIM RUSS | EWSC | RYDEX ETF TR | GUGGENHEIM RUSS | 2016-01-27 | ? | 20160127.ifs | 2016-01-27 | 2016-01-28 | ||||||||||||
2098837 | 2098837 | EXCHANGE | CHANGE | 78355W585 | 04 | 2010-12-08 | 2016-01-26 | EWRS | 0 | A | ? | 2010-12-08 | 20160127.ifs | 2016-01-27 | 2016-01-28 | ||||||||||||||
2098838 | 2098837 | EXCHANGE | CHANGE | 78355W585 | 04 | 2010-12-08 | 2016-01-26 | EWSC | 0 | A | ? | 2016-01-27 | 20160127.ifs | 2016-01-27 | 2016-01-28 | ||||||||||||||
2045496 | 2045496 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .097118 | 00 | 2015-12-18 | 2015-12-22 | 2015-12-31 | 2015-12-17 | 0 | 2015-12-17 | ? | 0 | 0005124972 | 20151217.ifs | 2015-12-17 | 2015-12-18 | |||||||
1967720 | 1967720 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .123642 | 00 | 2015-09-18 | 2015-09-22 | 2015-09-30 | 2015-09-17 | 0 | 2015-09-17 | ? | 0 | 0005063856 | 20150917.ifs | 2015-09-17 | 2015-09-18 | |||||||
1889102 | 1889102 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .131703 | 00 | 2015-06-19 | 2015-06-23 | 2015-06-30 | 2015-06-18 | 0 | 2015-06-18 | ? | 0 | 0005016083 | 20150618.ifs | 2015-06-18 | 2015-06-19 | |||||||
1815694 | 1815694 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .146052 | 00 | 2015-03-20 | 2015-03-24 | 2015-03-31 | 2015-03-19 | 0 | 2015-03-19 | ? | 0 | 0004970700 | 20150319.ifs | 2015-03-19 | 2015-03-20 | |||||||
1726513 | 1726513 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .147456 | 00 | 2014-12-19 | 2014-12-23 | 2014-12-31 | 2014-12-18 | 0 | 2014-12-18 | ? | 0 | 0004909080 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1632708 | 1632708 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .111928 | 00 | 2014-09-19 | 2014-09-23 | 2014-09-30 | 2014-09-18 | 0 | 2014-09-18 | ? | 0 | 0004844669 | 20140918.ifs | 2014-09-18 | 2014-09-19 | |||||||
1553496 | 1553496 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .108703 | 00 | 2014-06-20 | 2014-06-24 | 2014-06-30 | 2014-06-19 | 0 | 2014-06-19 | ? | 0 | 0004798881 | 20140619.ifs | 2014-06-19 | 2014-06-20 | |||||||
1471688 | 1471688 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .092899 | 00 | 2014-03-21 | 2014-03-25 | 2014-03-31 | 2014-03-20 | 0 | 2014-03-20 | ? | 0 | 0004753289 | 20140320.ifs | 2014-03-20 | 2014-03-21 | |||||||
1383702 | 1383702 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .102048 | 00 | 2013-12-20 | 2013-12-24 | 2013-12-31 | 2013-12-19 | 0 | 2013-12-19 | ? | 0 | 0004695679 | 20131219.ifs | 2013-12-19 | 2013-12-20 | |||||||
1291013 | 1291013 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .091477 | 00 | 2013-09-20 | 2013-09-24 | 2013-09-30 | 2013-09-19 | 0 | 2013-09-19 | ? | 0 | 0004631159 | 20130919.ifs | 2013-09-19 | 2013-09-20 | |||||||
1213158 | 1213158 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .099783 | 00 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-06-20 | 0 | 2013-06-20 | ? | 0 | 0004586887 | 20130620.ifs | 2013-06-20 | 2013-06-21 | |||||||
1133001 | 1133001 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .073025 | 00 | 2013-03-15 | 2013-03-19 | 2013-03-28 | 2013-03-14 | 0 | 2013-03-14 | ? | 0 | 0004541486 | 20130314.ifs | 2013-03-14 | 2013-03-15 | |||||||
1052271 | 1052271 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .327428 | 00 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-12-20 | 0 | 2012-12-20 | ? | 0 | 0004489874 | 20121220.ifs | 2012-12-20 | 2012-12-21 | |||||||
960254 | 960254 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .101489 | 00 | 2012-09-21 | 2012-09-25 | 2012-09-28 | 2012-09-20 | 0 | 2012-09-20 | ? | 0 | 0004431979 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
885042 | 885042 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .086477 | 00 | 2012-06-15 | 2012-06-19 | 2012-06-29 | 2012-06-14 | 0 | 2012-06-14 | ? | 0 | 0004386520 | 20120614.ifs | 2012-06-14 | 2012-06-15 | |||||||
802884 | 802884 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .048596 | 00 | 2012-03-16 | 2012-03-20 | 2012-03-30 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004346143 | 20120315.ifs | 2012-03-15 | 2012-03-16 | |||||||
791710 | 791710 | CORPACTION | ADD | 78355W585 | 04 | # | 2012-03-01 | 78355W585 | 04 | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 | ||||||||||||||||
791711 | 791711 | CORPACTIONAUX | ADD | 78355W585 | 04 | 2012-03-01 | EWRS | RYDEX ETF TR | RYDEX ETF TRUST | EWRS | RYDEX ETF TR | GUGGENHEIM RUSS | 2012-03-01 | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 | ||||||||||||
791712 | 791712 | EQUITY | CHANGE | 78355W585 | RUSSELL 2000 EQUAL WEIGHT ETF | 0 | A | 2010-12-08 | ? | 0 | no | no | no | ? | 2010-12-08 | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 | ||||||||||
791713 | 791712 | EQUITY | CHANGE | 78355W585 | GUGGENHEIM RUSSELL 2000 EQUAL WEIGHT ETF | 0 | A | 2010-12-08 | ? | 0 | no | no | no | ? | 2012-03-01 | ? | 20120301.ifs | 2012-03-01 | 2012-03-02 | ||||||||||
723420 | 723420 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .09531 | 00 | 2011-12-16 | 2011-12-20 | 2011-12-30 | 2011-12-15 | 0 | 2011-12-15 | ? | 0 | 0004289765 | 20111215.ifs | 2011-12-15 | 2011-12-16 | |||||||
643844 | 643844 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .054257 | 00 | 2011-09-16 | 2011-09-20 | 2011-09-30 | 2011-09-15 | 0 | 2011-09-15 | ? | 0 | 0004243014 | 20110915.ifs | 2011-09-15 | 2011-09-16 | |||||||
561636 | 561636 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .056746 | 00 | 2011-06-17 | 2011-06-21 | 2011-06-30 | 2011-06-16 | 0 | 2011-06-16 | ? | 0 | 0004201906 | 20110616.ifs | 2011-06-16 | 2011-06-17 | |||||||
473490 | 473490 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 0 | .025485 | 00 | 2011-03-18 | 2011-03-22 | 2011-03-31 | 2011-03-17 | 0 | 2011-03-17 | ? | 0 | 0004160557 | 20110317.ifs | 2011-03-17 | 2011-03-18 | |||||||
380129 | 380129 | DIVIDEND | ADD | 78355W585 | 0 | 0 | 1 | 4 | .04238 | 00 | 2010-12-17 | 2010-12-21 | 2010-12-31 | 2010-12-16 | 0 | 2010-12-16 | ? | 0 | 0004107234 | 20101216.ifs | 2010-12-16 | 2010-12-17 | |||||||
372754 | 372754 | EQUITY | ADD | 78355W585 | NEW ISSUE | 0 | 0 | 2010-12-08 | ? | 0 | no | no | no | ? | ? | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 | ||||||||||
372755 | 372755 | EQUITY | CHANGE | 78355W585 | NEW ISSUE | 0 | 0 | 2010-12-08 | ? | 0 | no | no | no | ? | ? | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 | ||||||||||
372756 | 372755 | EQUITY | CHANGE | 78355W585 | RUSSELL 2000 EQUAL WEIGHT ETF | N | A | 2010-12-08 | ? | 0 | no | no | no | ? | 2010-12-08 | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 | ||||||||||
372757 | 372757 | EXCHANGE | ADD | 78355W585 | 04 | 2010-12-08 | 2010-12-08 | EWRS | 0 | A | ? | 2010-12-08 | 20101208.ifs | 2010-12-08 | 2010-12-09 | ||||||||||||||
372836 | 372836 | EQUITY | CHANGE | 78355W585 | RUSSELL 2000 EQUAL WEIGHT ETF | N | A | 2010-12-08 | ? | 0 | no | no | no | ? | 2010-12-08 | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 | ||||||||||
372837 | 372836 | EQUITY | CHANGE | 78355W585 | RUSSELL 2000 EQUAL WEIGHT ETF | 0 | A | 2010-12-08 | ? | 0 | no | no | no | ? | 2010-12-08 | ? | 20101208.ifs | 2010-12-08 | 2010-12-09 |
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 = 159711
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