INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 30 | 26 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 3.78 % | 8.19 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159654 |
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 | ||
5584274 | 5584274 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2658 | 00 | 2024-06-27 | 2024-06-27 | 2024-06-28 | 2024-06-26 | 0 | 2024-06-26 | ? | 0 | 0006938804 | 20240626.ifs | 2024-06-26 | 2024-06-27 | |||||||
5519861 | 5519861 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2024-03-28 | 2024-03-20 | 0 | 2024-03-20 | ? | 0 | 0006892838 | 20240320.ifs | 2024-03-20 | 2024-03-21 | |||||||
5457273 | 5457273 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2232 | 00 | 2023-12-22 | 2023-12-26 | 2023-12-29 | 2023-12-21 | 0 | 2023-12-21 | ? | 0 | 0006847091 | 20231221.ifs | 2023-12-21 | 2023-12-22 | |||||||
5378411 | 5378411 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1204 | 00 | 2023-09-22 | 2023-09-25 | 2023-09-29 | 2023-09-21 | 0 | 2023-09-21 | ? | 0 | 0006786292 | 20230921.ifs | 2023-09-21 | 2023-09-22 | |||||||
5318840 | 5318840 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .3476 | 00 | 2023-06-27 | 2023-06-28 | 2023-06-30 | 2023-06-26 | 0 | 2023-06-26 | ? | 0 | 0006744231 | 20230626.ifs | 2023-06-26 | 2023-06-27 | |||||||
5254102 | 5254102 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1058 | 00 | 2023-03-24 | 2023-03-27 | 2023-03-31 | 2023-03-23 | 0 | 2023-03-23 | ? | 0 | 0006699632 | 20230323.ifs | 2023-03-23 | 2023-03-24 | |||||||
5186816 | 5186816 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2362 | 00 | 2022-12-23 | 2022-12-27 | 2022-12-30 | 2022-12-22 | 0 | 2022-12-22 | ? | 0 | 0006651139 | 20221222.ifs | 2022-12-22 | 2022-12-23 | |||||||
5102658 | 5102658 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1148 | 00 | 2022-09-23 | 2022-09-26 | 2022-09-30 | 2022-09-22 | 0 | 2022-09-22 | ? | 0 | 0006587287 | 20220922.ifs | 2022-09-22 | 2022-09-23 | |||||||
5040137 | 5040137 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2271 | 00 | 2022-06-24 | 2022-06-27 | 2022-06-30 | 2022-06-23 | 0 | 2022-06-23 | ? | 0 | 0006543170 | 20220623.ifs | 2022-06-23 | 2022-06-24 | |||||||
4977279 | 4977279 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0664 | 00 | 2022-03-25 | 2022-03-28 | 2022-03-31 | 2022-03-24 | 0 | 2022-03-24 | ? | 0 | 0006499013 | 20220324.ifs | 2022-03-24 | 2022-03-25 | |||||||
4939392 | 4939392 | CORPACTION | ADD | 33734X309 | 60 | # | 2022-01-26 | 33734X309 | 60 | ? | 20220126.ifs | 2022-01-26 | 2022-01-27 | ||||||||||||||||
4939393 | 4939393 | CORPACTIONAUX | ADD | 33734X309 | 60 | 2022-01-26 | CARZ | FIRST TR EXCHANGE-TRADED FD II | FIRST TRUST EXC | CARZ | FIRST TR EXCHANGE-TRADED FD II | SET NEW DESCRIP | 2022-01-26 | ? | 20220126.ifs | 2022-01-26 | 2022-01-27 | ||||||||||||
4939394 | 4939394 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | 0 | A | 2011-05-10 | ? | 4 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20220126.ifs | 2022-01-26 | 2022-01-27 | ||||||||||
4939395 | 4939394 | EQUITY | CHANGE | 33734X309 | SET NEW DESCRIPTION. NO CUSIP NAME CHANGE" OCCURED." | 0 | A | 2011-05-10 | ? | 4 | no | no | yes | 2011-05-10 | 2022-01-26 | ? | 20220126.ifs | 2022-01-26 | 2022-01-27 | ||||||||||
4909155 | 4909155 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | 1.057 | 00 | 2021-12-23 | 2021-12-27 | 2021-12-31 | 2021-12-22 | 0 | 2021-12-22 | ? | 0 | 0006445376 | 20211222.ifs | 2021-12-22 | 2021-12-23 | |||||||
4807633 | 4807633 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0845 | 00 | 2021-09-23 | 2021-09-24 | 2021-09-30 | 2021-09-22 | 0 | 2021-09-22 | ? | 0 | 0006370792 | 20210922.ifs | 2021-09-22 | 2021-09-23 | |||||||
4736480 | 4736480 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2068 | 00 | 2021-06-24 | 2021-06-25 | 2021-06-30 | 2021-06-23 | 0 | 2021-06-23 | ? | 0 | 0006326296 | 20210623.ifs | 2021-06-23 | 2021-06-24 | |||||||
4661281 | 4661281 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2021-03-31 | 2021-03-24 | 0 | 2021-03-24 | ? | 0 | 0006281265 | 20210324.ifs | 2021-03-24 | 2021-03-25 | |||||||
4572346 | 4572346 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1777 | 00 | 2020-12-24 | 2020-12-28 | 2020-12-31 | 2020-12-23 | 0 | 2020-12-23 | ? | 0 | 0006232379 | 20201223.ifs | 2020-12-23 | 2020-12-24 | |||||||
4468518 | 4468518 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0428 | 00 | 2020-09-24 | 2020-09-25 | 2020-09-30 | 2020-09-23 | 0 | 2020-09-23 | ? | 0 | 0006162650 | 20200923.ifs | 2020-09-23 | 2020-09-24 | |||||||
4399552 | 4399552 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1056 | 00 | 2020-06-25 | 2020-06-26 | 2020-06-30 | 2020-06-24 | 0 | 2020-06-24 | ? | 0 | 0006117770 | 20200624.ifs | 2020-06-24 | 2020-06-25 | |||||||
4255803 | 4255803 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073602 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4255804 | 4255804 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073602 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4062655 | 4062655 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .3022 | 00 | 2019-12-13 | 2019-12-16 | 2019-12-31 | 2019-12-12 | 0 | 2019-12-12 | ? | 0 | 0005996563 | 20191212.ifs | 2019-12-12 | 2019-12-13 | |||||||
4062754 | 4062754 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .3022 | 00 | 2019-12-13 | 2019-12-16 | 2019-12-31 | 2019-12-12 | 0 | 2019-12-12 | ? | 0 | 0005996563 | 20191212.ifs | 2019-12-12 | 2019-12-13 | |||||||
3937019 | 3937019 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2629 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949795 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3937145 | 3937145 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2629 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949795 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3778508 | 3778508 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .4699 | 00 | 2019-06-14 | 2019-06-17 | 2019-06-28 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897613 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3778509 | 3778509 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .4699 | 00 | 2019-06-14 | 2019-06-17 | 2019-06-28 | 2019-06-13 | 0 | 2019-06-13 | ? | 0 | 0005897613 | 20190613.ifs | 2019-06-13 | 2019-06-14 | |||||||
3640438 | 3640438 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0549 | 00 | 2019-03-21 | 2019-03-22 | 2019-03-29 | 2019-03-20 | 0 | 2019-03-20 | ? | 0 | 0005855755 | 20190320.ifs | 2019-03-20 | 2019-03-21 | |||||||
3640439 | 3640439 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0549 | 00 | 2019-03-21 | 2019-03-22 | 2019-03-29 | 2019-03-20 | 0 | 2019-03-20 | ? | 0 | 0005855755 | 20190320.ifs | 2019-03-20 | 2019-03-21 | |||||||
3454463 | 3454463 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2435 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-31 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784843 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3454634 | 3454634 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2435 | 00 | 2018-12-18 | 2018-12-19 | 2018-12-31 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784843 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3281900 | 3281900 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1098 | 00 | 2018-09-14 | 2018-09-17 | 2018-09-28 | 2018-09-13 | 0 | 2018-09-13 | ? | 0 | 0005723026 | 20180913.ifs | 2018-09-13 | 2018-09-14 | |||||||
3281977 | 3281977 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1098 | 00 | 2018-09-14 | 2018-09-17 | 2018-09-28 | 2018-09-13 | 0 | 2018-09-13 | ? | 0 | 0005723026 | 20180913.ifs | 2018-09-13 | 2018-09-14 | |||||||
3149501 | 3149501 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .5397 | 00 | 2018-06-21 | 2018-06-22 | 2018-06-29 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678276 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3149520 | 3149520 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .5397 | 00 | 2018-06-21 | 2018-06-22 | 2018-06-29 | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005678276 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3001176 | 3001176 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-29 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632638 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
3001199 | 3001199 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2018-03-29 | 2018-03-21 | 0 | 2018-03-21 | ? | 0 | 0005632638 | 20180321.ifs | 2018-03-21 | 2018-03-22 | |||||||
2853017 | 2853017 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2674 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-29 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005570457 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2856423 | 2856423 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2674 | 00 | 2017-12-21 | 2017-12-22 | 2017-12-29 | 2017-12-20 | 0 | 2017-12-20 | ? | 0 | 0005570457 | 20171220.ifs | 2017-12-20 | 2017-12-21 | |||||||
2680419 | 2680419 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1664 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-20 | 0 | 2017-09-20 | ? | 0 | 0005500158 | 20170920.ifs | 2017-09-20 | 2017-09-21 | |||||||
2680450 | 2680450 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1664 | 00 | 2017-09-21 | 2017-09-22 | 2017-09-29 | 2017-09-20 | 0 | 2017-09-20 | ? | 0 | 0005500158 | 20170920.ifs | 2017-09-20 | 2017-09-21 | |||||||
2597614 | 2597614 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .4517 | 00 | 2017-06-22 | 2017-06-26 | 2017-06-30 | 2017-06-21 | 0 | 2017-06-21 | ? | 0 | 0005452830 | 20170621.ifs | 2017-06-21 | 2017-06-22 | |||||||
2438190 | 2438190 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | 0 | A | 2011-05-10 | ? | 0 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2438191 | 2438190 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | 0 | A | 2011-05-10 | ? | 4 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2388760 | 2388760 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2596 | 00 | 2016-12-21 | 2016-12-23 | 2016-12-30 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005346771 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2297977 | 2297977 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .128 | 00 | 2016-09-21 | 2016-09-23 | 2016-09-30 | 2016-09-20 | 0 | 2016-09-20 | ? | 0 | 0005283153 | 20160920.ifs | 2016-09-20 | 2016-09-21 | |||||||
2226846 | 2226846 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .3973 | 00 | 2016-06-22 | 2016-06-24 | 2016-06-30 | 2016-06-21 | 0 | 2016-06-21 | ? | 0 | 0005236361 | 20160621.ifs | 2016-06-21 | 2016-06-22 | |||||||
2140767 | 2140767 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0667 | 00 | 2016-03-23 | 2016-03-28 | 2016-03-31 | 2016-03-22 | 0 | 2016-03-22 | ? | 0 | 0005190680 | 20160322.ifs | 2016-03-22 | 2016-03-23 | |||||||
2060148 | 2060148 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1893 | 00 | 2015-12-23 | 2015-12-28 | 2015-12-31 | 2015-12-22 | 0 | 2015-12-22 | ? | 0 | 0005136220 | 20151222.ifs | 2015-12-22 | 2015-12-23 | |||||||
1819442 | 1819442 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0416 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972918 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1737712 | 1737712 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-23 | 2014-12-26 | 2014-12-31 | 2014-01-07 | 1 | 2014-01-07 | 2014-06-23 | 3 | 0004722097 | 20141222.ifs | 2014-12-22 | 2014-12-23 | |||||||
1737713 | 1737713 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2026 | 00 | 2014-12-23 | 2014-12-26 | 2014-12-31 | 2014-12-22 | 2 | 2014-01-07 | 2014-12-22 | 1 | 0004722097 | 20141222.ifs | 2014-12-22 | 2014-12-23 | |||||||
1635574 | 1635574 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-09-23 | 2014-09-25 | 2014-09-30 | 2014-01-07 | 1 | 2014-01-07 | 2014-06-23 | 2 | 0004722096 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1635575 | 1635575 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0122 | 00 | 2014-09-23 | 2014-09-25 | 2014-09-30 | 2014-09-22 | 2 | 2014-01-07 | 2014-09-22 | 0 | 0004722096 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1557444 | 1557444 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-23 | 2014-12-26 | 2014-12-31 | 2014-01-07 | 0 | 2014-01-07 | ? | 3 | 0004722097 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1557445 | 1557444 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-23 | 2014-12-26 | 2014-12-31 | 2014-01-07 | 1 | 2014-01-07 | 2014-06-23 | 3 | 0004722097 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1557446 | 1557446 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-09-23 | 2014-09-25 | 2014-09-30 | 2014-01-07 | 0 | 2014-01-07 | ? | 2 | 0004722096 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1557447 | 1557446 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-09-23 | 2014-09-25 | 2014-09-30 | 2014-01-07 | 1 | 2014-01-07 | 2014-06-23 | 2 | 0004722096 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1557448 | 1557448 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-01-07 | 0 | 2014-01-07 | ? | 1 | 0004722095 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1557449 | 1557449 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .3954 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 1 | 2014-01-07 | 2014-06-23 | 1 | 0004722095 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1474734 | 1474734 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-01-07 | 0 | 2014-01-07 | ? | 0 | 0004722094 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1474735 | 1474735 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0221 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 1 | 2014-01-07 | 2014-03-24 | 0 | 0004722094 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1418773 | 1418773 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-23 | 2014-12-26 | 2014-12-31 | 2014-01-07 | 0 | 2014-01-07 | ? | 3 | 0004722097 | 20140107.ifs | 2014-01-07 | 2014-01-08 | |||||||
1418774 | 1418774 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-09-23 | 2014-09-25 | 2014-09-30 | 2014-01-07 | 0 | 2014-01-07 | ? | 2 | 0004722096 | 20140107.ifs | 2014-01-07 | 2014-01-08 | |||||||
1418775 | 1418775 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-01-07 | 0 | 2014-01-07 | ? | 1 | 0004722095 | 20140107.ifs | 2014-01-07 | 2014-01-08 | |||||||
1418776 | 1418776 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-01-07 | 0 | 2014-01-07 | ? | 0 | 0004722094 | 20140107.ifs | 2014-01-07 | 2014-01-08 | |||||||
1377414 | 1377414 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-18 | 2013-12-20 | 2013-12-31 | 2013-01-08 | 2 | 2013-01-08 | 2013-11-14 | 0 | 0004513030 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1377415 | 1377415 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .065 | 00 | 2013-12-18 | 2013-12-20 | 2013-12-31 | 2013-12-17 | 3 | 2013-01-08 | 2013-12-17 | 0 | 0004513030 | 20131217.ifs | 2013-12-17 | 2013-12-18 | |||||||
1340118 | 1340118 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-20 | 2013-12-24 | 2013-12-31 | 2013-01-08 | 1 | 2013-01-08 | 2013-03-20 | 3 | 0004513030 | 20131114.ifs | 2013-11-14 | 2013-11-15 | |||||||
1340119 | 1340119 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-18 | 2013-12-20 | 2013-12-31 | 2013-01-08 | 2 | 2013-01-08 | 2013-11-14 | 0 | 0004513030 | 20131114.ifs | 2013-11-14 | 2013-11-15 | |||||||
1292060 | 1292060 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-09-20 | 2013-09-24 | 2013-09-30 | 2013-01-08 | 1 | 2013-01-08 | 2013-03-20 | 2 | 0004513029 | 20130920.ifs | 2013-09-20 | 2013-09-21 | |||||||
1292061 | 1292061 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 0 | 58 | ? | ? | 2013-09-30 | 2013-01-08 | 0 | ? | 2013-09-20 | 2 | 0004513029 | 20130920.ifs | 2013-09-20 | 2013-09-21 | ||||||
1213735 | 1213735 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-01-08 | 1 | 2013-01-08 | 2013-03-20 | 1 | 0004513028 | 20130620.ifs | 2013-06-20 | 2013-06-21 | |||||||
1213736 | 1213736 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .2231 | 00 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-06-20 | 2 | 2013-01-08 | 2013-06-20 | 0 | 0004513028 | 20130620.ifs | 2013-06-20 | 2013-06-21 | |||||||
1137796 | 1137796 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-20 | 2013-12-24 | 2013-12-31 | 2013-01-08 | 0 | 2013-01-08 | ? | 3 | 0004513030 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1137797 | 1137796 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-20 | 2013-12-24 | 2013-12-31 | 2013-01-08 | 1 | 2013-01-08 | 2013-03-20 | 3 | 0004513030 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1137798 | 1137798 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-09-20 | 2013-09-24 | 2013-09-30 | 2013-01-08 | 0 | 2013-01-08 | ? | 2 | 0004513029 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1137799 | 1137798 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-09-20 | 2013-09-24 | 2013-09-30 | 2013-01-08 | 1 | 2013-01-08 | 2013-03-20 | 2 | 0004513029 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1137800 | 1137800 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-01-08 | 0 | 2013-01-08 | ? | 1 | 0004513028 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1137801 | 1137800 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-01-08 | 1 | 2013-01-08 | 2013-03-20 | 1 | 0004513028 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1137802 | 1137802 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-03-21 | 2013-03-25 | 2013-03-28 | 2013-01-08 | 0 | 2013-01-08 | ? | 0 | 0004513027 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1137803 | 1137803 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2013-03-28 | 2013-01-08 | 1 | 2013-01-08 | 2013-03-20 | 0 | 0004513027 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1086277 | 1086277 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-12-20 | 2013-12-24 | 2013-12-31 | 2013-01-08 | 0 | 2013-01-08 | ? | 3 | 0004513030 | 20130108.ifs | 2013-01-08 | 2013-01-09 | |||||||
1086278 | 1086278 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-09-20 | 2013-09-24 | 2013-09-30 | 2013-01-08 | 0 | 2013-01-08 | ? | 2 | 0004513029 | 20130108.ifs | 2013-01-08 | 2013-01-09 | |||||||
1086279 | 1086279 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-06-21 | 2013-06-25 | 2013-06-28 | 2013-01-08 | 0 | 2013-01-08 | ? | 1 | 0004513028 | 20130108.ifs | 2013-01-08 | 2013-01-09 | |||||||
1086280 | 1086280 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2013-03-21 | 2013-03-25 | 2013-03-28 | 2013-01-08 | 0 | 2013-01-08 | ? | 0 | 0004513027 | 20130108.ifs | 2013-01-08 | 2013-01-09 | |||||||
1053352 | 1053352 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-01-10 | 2 | 2012-01-10 | 2012-09-20 | 1 | 0004319790 | 20121220.ifs | 2012-12-20 | 2012-12-21 | |||||||
1053353 | 1053353 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0665 | 00 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-01-10 | 3 | 2012-01-10 | 2012-12-20 | 0 | 0004319790 | 20121220.ifs | 2012-12-20 | 2012-12-21 | |||||||
960901 | 960901 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-09-21 | 2012-09-25 | 2012-09-28 | 2012-08-15 | 0 | 2012-08-15 | ? | 0 | 0004416086 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
960902 | 960902 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0247 | 00 | 2012-09-21 | 2012-09-25 | 2012-09-28 | 2012-08-15 | 1 | 2012-08-15 | 2012-09-20 | 0 | 0004416086 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
960903 | 960903 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-01-10 | 1 | 2012-01-10 | 2012-08-15 | 1 | 0004319790 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
960904 | 960903 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-01-10 | 2 | 2012-01-10 | 2012-09-20 | 1 | 0004319790 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
933669 | 933669 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-09-21 | 2012-09-25 | 2012-09-28 | 2012-08-15 | 0 | 2012-08-15 | ? | 0 | 0004416086 | 20120815.ifs | 2012-08-15 | 2012-08-16 | |||||||
933670 | 933670 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-01-10 | 0 | 2012-01-10 | ? | 1 | 0004319790 | 20120815.ifs | 2012-08-15 | 2012-08-16 | |||||||
933671 | 933670 | DIVIDEND | CHANGE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-12-21 | 2012-12-26 | 2012-12-31 | 2012-01-10 | 1 | 2012-01-10 | 2012-08-15 | 1 | 0004319790 | 20120815.ifs | 2012-08-15 | 2012-08-16 | |||||||
889891 | 889891 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-06-21 | 2012-06-25 | 2012-06-29 | 2012-01-10 | 0 | 2012-01-10 | ? | 0 | 0004319789 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
889892 | 889892 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .1362 | 00 | 2012-06-21 | 2012-06-25 | 2012-06-29 | 2012-06-20 | 1 | 2012-01-10 | 2012-06-20 | 0 | 0004319789 | 20120620.ifs | 2012-06-20 | 2012-06-21 | |||||||
806018 | 806018 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-03-21 | 2012-03-23 | 2012-03-30 | 2012-03-14 | 0 | 2012-03-14 | ? | 0 | 0004345300 | 20120320.ifs | 2012-03-20 | 2012-03-21 | |||||||
806019 | 806019 | DIVIDEND | ADD | 33734X309 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2012-03-30 | 2012-03-14 | 1 | 2012-03-14 | 2012-03-20 | 0 | 0004345300 | 20120320.ifs | 2012-03-20 | 2012-03-21 | |||||||
802194 | 802194 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2012-03-21 | 2012-03-23 | 2012-03-30 | 2012-03-14 | 0 | 2012-03-14 | ? | 0 | 0004345300 | 20120314.ifs | 2012-03-14 | 2012-03-15 | |||||||
733357 | 733357 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 4 | 0 | 08 | 2011-12-21 | 2011-12-23 | 2011-12-30 | 2011-05-11 | 0 | 2011-05-11 | ? | 1 | 0004187439 | 20111220.ifs | 2011-12-20 | 2011-12-21 | |||||||
733358 | 733358 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0238 | 00 | 2011-12-21 | 2011-12-23 | 2011-12-30 | 2011-12-20 | 1 | 2011-05-11 | 2011-12-20 | 0 | 0004187439 | 20111220.ifs | 2011-12-20 | 2011-12-21 | |||||||
564539 | 564539 | DIVIDEND | DELETE | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-06-21 | 2011-06-23 | 2011-06-30 | 2011-05-11 | 0 | 2011-05-11 | ? | 0 | 0004187438 | 20110620.ifs | 2011-06-20 | 2011-06-21 | |||||||
564540 | 564540 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 0 | .0474 | 00 | 2011-06-21 | 2011-06-23 | 2011-06-30 | 2011-06-20 | 1 | 2011-05-11 | 2011-06-20 | 0 | 0004187438 | 20110620.ifs | 2011-06-20 | 2011-06-21 | |||||||
524398 | 524398 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 4 | 0 | 08 | 2011-12-21 | 2011-12-23 | 2011-12-30 | 2011-05-11 | 0 | 2011-05-11 | ? | 1 | 0004187439 | 20110511.ifs | 2011-05-11 | 2011-05-12 | |||||||
524399 | 524399 | DIVIDEND | ADD | 33734X309 | 0 | 0 | 1 | 6 | 0 | 08 | 2011-06-21 | 2011-06-23 | 2011-06-30 | 2011-05-11 | 0 | 2011-05-11 | ? | 0 | 0004187438 | 20110511.ifs | 2011-05-11 | 2011-05-12 | |||||||
523394 | 523394 | EQUITY | ADD | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | N | 7 | 2011-05-10 | ? | 0 | no | no | no | 2011-05-10 | ? | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 | ||||||||||
523395 | 523395 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | N | 7 | 2011-05-10 | ? | 0 | no | no | no | 2011-05-10 | ? | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 | ||||||||||
523396 | 523395 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | N | 7 | 2011-05-10 | ? | 0 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 | ||||||||||
523397 | 523397 | EXCHANGE | ADD | 33734X309 | 60 | 2011-05-10 | 2011-05-10 | CARZ | 0 | A | 2011-05-10 | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 | ||||||||||||||
523428 | 523428 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | N | 7 | 2011-05-10 | ? | 0 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 | ||||||||||
523429 | 523428 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | N | A | 2011-05-10 | ? | 0 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 | ||||||||||
523788 | 523788 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | N | A | 2011-05-10 | ? | 0 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 | ||||||||||
523789 | 523788 | EQUITY | CHANGE | 33734X309 | FIRST TR NASDAQ GLOBAL AUTO INDEX FD | 0 | A | 2011-05-10 | ? | 0 | no | no | yes | 2011-05-10 | 2011-05-10 | ? | 20110510.ifs | 2011-05-10 | 2011-05-11 |
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 = 159654
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