INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 90 | 85 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 42.88 % | 40.54 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159727 |
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 | ||
5584238 | 5584238 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2024-06-28 | 2024-06-26 | 0 | 2024-06-26 | ? | 0 | 0006938846 | 20240626.ifs | 2024-06-26 | 2024-06-27 | |||||||
5519826 | 5519826 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2024-03-28 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892824 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5457235 | 5457235 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0619 | 00 | 2023-12-22 | 2023-12-26 | 2023-12-29 | 2023-12-21 | 0 | 2023-12-21 | ? | 0 | 0006846842 | 20231221.ifs | 2023-12-21 | 2023-12-22 | |||||||
5378377 | 5378377 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2023-09-29 | 2023-09-21 | 0 | 2023-09-21 | ? | 0 | 0006786298 | 20230921.ifs | 2023-09-21 | 2023-09-22 | |||||||
5318803 | 5318803 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0218 | 00 | 2023-06-27 | 2023-06-28 | 2023-06-30 | 2023-06-26 | 0 | 2023-06-26 | ? | 0 | 0006744184 | 20230626.ifs | 2023-06-26 | 2023-06-27 | |||||||
5254069 | 5254069 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .083 | 00 | 2023-03-24 | 2023-03-27 | 2023-03-31 | 2023-03-23 | 0 | 2023-03-23 | ? | 0 | 0006699589 | 20230323.ifs | 2023-03-23 | 2023-03-24 | |||||||
5186780 | 5186780 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .1112 | 00 | 2022-12-23 | 2022-12-27 | 2022-12-30 | 2022-12-22 | 0 | 2022-12-22 | ? | 0 | 0006651123 | 20221222.ifs | 2022-12-22 | 2022-12-23 | |||||||
5102624 | 5102624 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0225 | 00 | 2022-09-23 | 2022-09-26 | 2022-09-30 | 2022-09-22 | 0 | 2022-09-22 | ? | 0 | 0006587272 | 20220922.ifs | 2022-09-22 | 2022-09-23 | |||||||
5040103 | 5040103 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-06-30 | 2022-06-23 | 0 | 2022-06-23 | ? | 0 | 0006543174 | 20220623.ifs | 2022-06-23 | 2022-06-24 | |||||||
4977245 | 4977245 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2022-03-31 | 2022-03-24 | 0 | 2022-03-24 | ? | 0 | 0006499033 | 20220324.ifs | 2022-03-24 | 2022-03-25 | |||||||
4909119 | 4909119 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-12-31 | 2021-12-22 | 0 | 2021-12-22 | ? | 0 | 0006445403 | 20211222.ifs | 2021-12-22 | 2021-12-23 | |||||||
4807598 | 4807598 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-09-30 | 2021-09-22 | 0 | 2021-09-22 | ? | 0 | 0006370862 | 20210922.ifs | 2021-09-22 | 2021-09-23 | |||||||
4736445 | 4736445 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-06-30 | 2021-06-23 | 0 | 2021-06-23 | ? | 0 | 0006326309 | 20210623.ifs | 2021-06-23 | 2021-06-24 | |||||||
4661246 | 4661246 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281259 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4572303 | 4572303 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0697 | 00 | 2020-12-24 | 2020-12-28 | 2020-12-31 | 2020-12-23 | 0 | 2020-12-23 | ? | 0 | 0006232334 | 20201223.ifs | 2020-12-23 | 2020-12-24 | |||||||
4468480 | 4468480 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0897 | 00 | 2020-09-24 | 2020-09-25 | 2020-09-30 | 2020-09-23 | 0 | 2020-09-23 | ? | 0 | 0006162606 | 20200923.ifs | 2020-09-23 | 2020-09-24 | |||||||
4399514 | 4399514 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-30 | 2020-06-24 | 0 | 2020-06-24 | ? | 0 | 0006117783 | 20200624.ifs | 2020-06-24 | 2020-06-25 | |||||||
4255727 | 4255727 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0039 | 00 | 2020-03-26 | 2020-03-27 | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073702 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4255728 | 4255728 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0039 | 00 | 2020-03-26 | 2020-03-27 | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073702 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4062581 | 4062581 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .1074 | 00 | 2019-12-13 | 2019-12-16 | 2019-12-31 | 2019-12-12 | 0 | 2019-12-12 | ? | 0 | 0005996536 | 20191212.ifs | 2019-12-12 | 2019-12-13 | |||||||
4062680 | 4062680 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .1074 | 00 | 2019-12-13 | 2019-12-16 | 2019-12-31 | 2019-12-12 | 0 | 2019-12-12 | ? | 0 | 0005996536 | 20191212.ifs | 2019-12-12 | 2019-12-13 | |||||||
3936943 | 3936943 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0247 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949781 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3937070 | 3937070 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0247 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949781 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3778432 | 3778432 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-06-28 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897678 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3778433 | 3778433 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-06-28 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897678 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3640360 | 3640360 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-03-29 | 2019-03-20 | 0 | 2019-03-20 | ? | 0 | 0005855765 | 20190320.ifs | 2019-03-20 | 2019-03-21 | |||||||
3640361 | 3640361 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2019-03-29 | 2019-03-20 | 0 | 2019-03-20 | ? | 0 | 0005855765 | 20190320.ifs | 2019-03-20 | 2019-03-21 | |||||||
3454391 | 3454391 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0207 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-31 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784798 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3454557 | 3454557 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0207 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-31 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784798 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3281834 | 3281834 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-09-28 | 2018-09-13 | 0 | 2018-09-13 | ? | 0 | 0005723035 | 20180913.ifs | 2018-09-13 | 2018-09-14 | |||||||
3281904 | 3281904 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-09-28 | 2018-09-13 | 0 | 2018-09-13 | ? | 0 | 0005723035 | 20180913.ifs | 2018-09-13 | 2018-09-14 | |||||||
3149423 | 3149423 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-06-29 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678313 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3149442 | 3149442 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-06-29 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678313 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3001104 | 3001104 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-29 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632671 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3001127 | 3001127 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-29 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632671 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2852933 | 2852933 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0458 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-29 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005570423 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2856381 | 2856381 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0458 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-29 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005570423 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2680337 | 2680337 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0072 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-20 | 0 | 2017-09-20 | ? | 0 | 0005500148 | 20170920.ifs | 2017-09-20 | 2017-09-21 | |||||||
2680368 | 2680368 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0072 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-20 | 0 | 2017-09-20 | ? | 0 | 0005500148 | 20170920.ifs | 2017-09-20 | 2017-09-21 | |||||||
2597574 | 2597574 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .029 | 00 | 2017-06-22 | 2017-06-26 | 2017-06-30 | 2017-06-21 | 0 | 2017-06-21 | ? | 0 | 0005452852 | 20170621.ifs | 2017-06-21 | 2017-06-22 | |||||||
2438242 | 2438242 | EQUITY | CHANGE | 33737M102 | MID CAP GROWTH ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | yes | 2011-04-19 | 2016-04-07 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2438243 | 2438242 | EQUITY | CHANGE | 33737M102 | MID CAP GROWTH ALPHADEX FD | N | A | 2011-04-19 | ? | 4 | no | no | yes | 2011-04-19 | 2016-04-07 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2388723 | 2388723 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .1151 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-30 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346913 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2297938 | 2297938 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0269 | 00 | 2016-09-21 | 2016-09-23 | 2016-09-30 | 2016-09-20 | 0 | 2016-09-20 | ? | 0 | 0005283174 | 20160920.ifs | 2016-09-20 | 2016-09-21 | |||||||
2226810 | 2226810 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0276 | 00 | 2016-06-22 | 2016-06-24 | 2016-06-30 | 2016-06-21 | 0 | 2016-06-21 | ? | 0 | 0005236401 | 20160621.ifs | 2016-06-21 | 2016-06-22 | |||||||
2161208 | 2161208 | CORPACTION | ADD | 33737M102 | 04 | X | 2016-04-08 | 33737M102 | 60 | ? | 20160408.ifs | 2016-04-08 | 2016-04-09 | ||||||||||||||||
2161209 | 2161209 | EXCHANGE | ADD | 33737M102 | 60 | 2016-04-08 | 2016-04-08 | FNY | 0 | A | 2016-04-08 | ? | 20160408.ifs | 2016-04-08 | 2016-04-09 | ||||||||||||||
2160227 | 2160227 | EQUITY | CHANGE | 33737M102 | MID CAP GROWTH ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | 2011-04-19 | ? | 20160407.ifs | 2016-04-07 | 2016-04-08 | ||||||||||
2160228 | 2160227 | EQUITY | CHANGE | 33737M102 | MID CAP GROWTH ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | yes | 2011-04-19 | 2016-04-07 | ? | 20160407.ifs | 2016-04-07 | 2016-04-08 | ||||||||||
2140734 | 2140734 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0175 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-31 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190676 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2060118 | 2060118 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0364 | 00 | 2015-12-23 | 2015-12-28 | 2015-12-31 | 2015-12-22 | 0 | 2015-12-22 | ? | 0 | 0005135692 | 20151222.ifs | 2015-12-22 | 2015-12-23 | |||||||
1819406 | 1819406 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0724 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972637 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1737671 | 1737671 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0299 | 00 | 2014-12-23 | 2014-12-26 | 2014-12-31 | 2014-12-22 | 0 | 2014-12-22 | ? | 0 | 0004916111 | 20141222.ifs | 2014-12-22 | 2014-12-23 | |||||||
1635535 | 1635535 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0185 | 00 | 2014-09-23 | 2014-09-25 | 2014-09-30 | 2014-09-22 | 0 | 2014-09-22 | ? | 0 | 0004846070 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1557392 | 1557392 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0134 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800526 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474698 | 1474698 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0015 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754588 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1377377 | 1377377 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-12-31 | 2013-12-17 | 0 | 2013-12-17 | ? | 0 | 0004688854 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1291573 | 1291573 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0651 | 00 | 2013-09-20 | 2013-09-24 | 2013-09-30 | 2013-09-19 | 0 | 2013-09-19 | ? | 0 | 0004630866 | 20130919.ifs | 2013-09-19 | 2013-09-20 | |||||||
1213702 | 1213702 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0345 | 00 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-06-20 | 0 | 2013-06-20 | ? | 0 | 0004586678 | 20130620.ifs | 2013-06-20 | 2013-06-21 | |||||||
1137745 | 1137745 | DIVIDEND | ADD | 33737M102 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-03-28 | 2013-03-20 | 0 | 2013-03-20 | ? | 0 | 0004543635 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1056891 | 1056891 | DIVIDEND | CHANGE | 33737M102 | 0 | 0 | 1 | 0 | .2648 | 00 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-12-20 | 0 | 2012-12-20 | ? | 0 | 0004489679 | 20121221.ifs | 2012-12-21 | 2012-12-22 | |||||||
1056892 | 1056891 | DIVIDEND | CHANGE | 33737M102 | 0 | 0 | 1 | 0 | .0983 | 00 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-12-20 | 1 | 2012-12-20 | 2012-12-21 | 0 | 0004489679 | 20121221.ifs | 2012-12-21 | 2012-12-22 | |||||||
1053315 | 1053315 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .2648 | 00 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-12-20 | 0 | 2012-12-20 | ? | 0 | 0004489679 | 20121220.ifs | 2012-12-20 | 2012-12-21 | |||||||
889855 | 889855 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 0 | .0056 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-29 | 2012-06-20 | 0 | 2012-06-20 | ? | 0 | 0004389092 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
733329 | 733329 | DIVIDEND | ADD | 33737M102 | 0 | 0 | 1 | 4 | .004 | 00 | 2011-12-21 | 2011-12-23 | 2011-12-30 | 2011-12-20 | 0 | 2011-12-20 | ? | 0 | 0004296792 | 20111220.ifs | 2011-12-20 | 2011-12-21 | |||||||
504348 | 504348 | EQUITY | ADD | 33737M102 | MID CAP GROWTH ALPHADEX FD | N | 7 | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | ? | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||
504349 | 504349 | EXCHANGE | ADD | 33737M102 | 04 | 2011-04-19 | ? | FNY | 0 | A | 2011-04-19 | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||||||
504403 | 504403 | EQUITY | CHANGE | 33737M102 | MID CAP GROWTH ALPHADEX FD | N | 7 | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | ? | ? | 20110419.ifs | 2011-04-19 | 2011-04-20 | ||||||||||
504404 | 504403 | EQUITY | CHANGE | 33737M102 | MID CAP GROWTH ALPHADEX FD | N | A | 2011-04-19 | ? | 0 | no | no | no | 2011-04-19 | 2011-04-19 | ? | 20110419.ifs | 2011-04-19 | 2011-04-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 = 159727
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