Update Company
Name Pricing Date  2024-03-31(LQAP)    
CompId   Stop Date volume LQStart
Ticker Price avevol LQEnd
Cusip Last Trade open LQAve
Sector Country high
   
MktCap CompNum low
yearlylow
Shares Out Type1 prevClose
yearlyhigh
Last_ShsOut    Exchange  
     
  09-30 12-25 sic Code      
Description cik  Updated
  Notes PAGE RESET
  Run CARZ Charts Yahoo CARZ Profile
  Run CARZ Institutional Summary Yahoo CARZ Key Statisics
  J3 Open CARZ Pricing Yahoo CARZ Pricing
  J3 CARZ Insider   J3 CARZ Insitutions Yahoo CARZ Holders
     
  Open up Sector/Exchange Map Fidelity CARZ Lookup
  Open up sec.gov For Market Ca MSN CARZ Lookup
     
  2001-01-01 shsout made up date to make % good  
  0009-09-09 sdate Dead Company  
  2010-12-25 shsout Took From Yahoo  
  9000010176 Next Fake CIK to use
   


INSITITUIONS Dynamic newInstitTable Changed the Cusip/Sector/Shs Out?
Old Cusips
33734X309 DELETE RUN
 

Fix Cusip issue where all new and deleted Instittuional Holdings
Current Quarter Date: ie: 2012-06-30
Should We Update The database:
BackUp query is below under BACK UP Institutions before committing.

Total Insititutions : 30 26   Update Insititution By Cusips
% Owned by Insititutions: 3.78 % 8.19 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:159654
New Old Cusip
 

Splits :
 reportDate : 
  ratio : 
  endQuaterAffected : 
  dayFrom  :
  dayTo  :
 

reportDate ratio endQuaterAffected dayFrom dayTo

To Upper  



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


Old 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


Your Name Click here to open the child window


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