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:159734 |
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 | ||
5101561 | 5101561 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | S | A | 2011-06-21 | 2022-09-01 | 5 | no | no | no | 2011-06-21 | 2022-09-01 | ? | 20220922.ifs | 2022-09-22 | 2022-09-23 | ||||||||||
5101562 | 5101561 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | S | A | 2011-06-21 | 2022-09-07 | 5 | no | no | no | 2011-06-21 | 2022-09-22 | ? | 20220922.ifs | 2022-09-22 | 2022-09-23 | ||||||||||
5101563 | 5101563 | CORPACTION | ADD | 00768Y834 | 04 | L | 2022-09-07 | ? | 20220922.ifs | 2022-09-22 | 2022-09-23 | ||||||||||||||||||
5101564 | 5101564 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | S | A | 2011-06-21 | 2022-09-07 | 5 | no | no | no | 2011-06-21 | 2022-09-22 | ? | 20220922.ifs | 2022-09-22 | 2022-09-23 | ||||||||||
5101565 | 5101564 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | L | A | 2011-06-21 | 2022-09-07 | 5 | no | no | no | 2011-06-21 | 2022-09-22 | ? | 20220922.ifs | 2022-09-22 | 2022-09-23 | ||||||||||
5087817 | 5087817 | CORPACTION | ADD | 00768Y834 | 04 | S | 2022-09-01 | 2022-09-01 | 20220901.ifs | 2022-09-01 | 2022-09-02 | ||||||||||||||||||
5087818 | 5087818 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | 0 | A | 2011-06-21 | ? | 5 | no | no | no | 2011-06-21 | 2019-04-01 | ? | 20220901.ifs | 2022-09-01 | 2022-09-02 | ||||||||||
5087819 | 5087818 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | S | A | 2011-06-21 | 2022-09-01 | 5 | no | no | no | 2011-06-21 | 2022-09-01 | ? | 20220901.ifs | 2022-09-01 | 2022-09-02 | ||||||||||
5080712 | 5080712 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04389 | 00 | 2022-08-23 | 2022-08-24 | 2022-08-31 | 2022-08-22 | 0 | 2022-08-22 | ? | 0 | 0006571332 | 20220822.ifs | 2022-08-22 | 2022-08-23 | |||||||
5080198 | 5080198 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .05183 | 00 | 2022-07-25 | 2022-07-26 | 2022-07-29 | 2022-07-22 | 0 | 2022-07-22 | ? | 0 | 0006558287 | 20220819.ifs | 2022-08-19 | 2022-08-20 | |||||||
5080199 | 5080198 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .05183 | 00 | 2022-07-25 | 2022-07-26 | 2022-07-29 | 2022-07-22 | 1 | 2022-07-22 | 2022-08-19 | 0 | 0006558287 | 20220819.ifs | 2022-08-19 | 2022-08-20 | |||||||
5062500 | 5062500 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05183 | 00 | 2022-07-25 | 2022-07-26 | 2022-07-29 | 2022-07-22 | 0 | 2022-07-22 | ? | 0 | 0006558287 | 20220722.ifs | 2022-07-22 | 2022-07-23 | |||||||
5037911 | 5037911 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04088 | 00 | 2022-06-22 | 2022-06-23 | 2022-06-30 | 2022-06-21 | 0 | 2022-06-21 | ? | 0 | 0006541422 | 20220621.ifs | 2022-06-21 | 2022-06-22 | |||||||
5015484 | 5015484 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0393 | 00 | 2022-05-23 | 2022-05-24 | 2022-05-31 | 2022-05-20 | 0 | 2022-05-20 | ? | 0 | 0006525916 | 20220520.ifs | 2022-05-20 | 2022-05-21 | |||||||
4997208 | 4997208 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04419 | 00 | 2022-04-25 | 2022-04-26 | 2022-04-29 | 2022-04-22 | 0 | 2022-04-22 | ? | 0 | 0006512940 | 20220422.ifs | 2022-04-22 | 2022-04-23 | |||||||
4974844 | 4974844 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .03107 | 00 | 2022-03-22 | 2022-03-23 | 2022-03-31 | 2022-03-21 | 0 | 2022-03-21 | ? | 0 | 0006496883 | 20220321.ifs | 2022-03-21 | 2022-03-22 | |||||||
4956111 | 4956111 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .03132 | 00 | 2022-02-22 | 2022-02-23 | 2022-02-28 | 2022-02-18 | 0 | 2022-02-18 | ? | 0 | 0006482634 | 20220218.ifs | 2022-02-18 | 2022-02-19 | |||||||
4937869 | 4937869 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04666 | 00 | 2022-01-24 | 2022-01-25 | 2022-01-31 | 2022-01-21 | 0 | 2022-01-21 | ? | 0 | 0006470086 | 20220121.ifs | 2022-01-21 | 2022-01-22 | |||||||
4910117 | 4910117 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .00973 | 00 | 2021-12-23 | 2021-12-27 | 2021-12-31 | 2021-12-22 | 0 | 2021-12-22 | ? | 0 | 0006446210 | 20211222.ifs | 2021-12-22 | 2021-12-23 | |||||||
4851449 | 4851449 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02436 | 00 | 2021-11-23 | 2021-11-24 | 2021-11-30 | 2021-11-22 | 0 | 2021-11-22 | ? | 0 | 0006398393 | 20211122.ifs | 2021-11-22 | 2021-11-23 | |||||||
4837848 | 4837848 | CORPACTION | ADD | 00768Y834 | 04 | # | 2021-11-01 | 00768Y834 | 04 | ? | 20211101.ifs | 2021-11-01 | 2021-11-02 | ||||||||||||||||
4837849 | 4837849 | CORPACTIONAUX | ADD | 00768Y834 | 04 | 2021-11-01 | FWDB | ADVISORSHARES TR | ADVISORSHARES F | MENV | ADVISORSHARES TR | ADVISORSHARES F | 2021-11-01 | ? | 20211101.ifs | 2021-11-01 | 2021-11-02 | ||||||||||||
4837850 | 4837850 | EXCHANGE | CHANGE | 00768Y834 | 04 | 2011-06-21 | 2021-10-29 | FWDB | 0 | A | 2011-06-21 | 2011-07-13 | 20211101.ifs | 2021-11-01 | 2021-11-02 | ||||||||||||||
4837851 | 4837850 | EXCHANGE | CHANGE | 00768Y834 | 04 | 2011-06-21 | 2021-10-29 | MENV | 0 | A | 2011-06-21 | 2021-11-01 | 20211101.ifs | 2021-11-01 | 2021-11-02 | ||||||||||||||
4831144 | 4831144 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04205 | 00 | 2021-10-25 | 2021-10-26 | 2021-10-29 | 2021-10-22 | 0 | 2021-10-22 | ? | 0 | 0006385686 | 20211022.ifs | 2021-10-22 | 2021-10-23 | |||||||
4808960 | 4808960 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0752 | 00 | 2021-09-24 | 2021-09-27 | 2021-09-30 | 2021-09-23 | 0 | 2021-09-23 | ? | 0 | 0006371750 | 20210923.ifs | 2021-09-23 | 2021-09-24 | |||||||
4786474 | 4786474 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04931 | 00 | 2021-08-25 | 2021-08-26 | 2021-08-31 | 2021-08-24 | 0 | 2021-08-24 | ? | 0 | 0006355925 | 20210824.ifs | 2021-08-24 | 2021-08-25 | |||||||
4764355 | 4764355 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06067 | 00 | 2021-07-26 | 2021-07-27 | 2021-07-30 | 2021-07-23 | 0 | 2021-07-23 | ? | 0 | 0006342253 | 20210723.ifs | 2021-07-23 | 2021-07-24 | |||||||
4736859 | 4736859 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02741 | 00 | 2021-06-24 | 2021-06-25 | 2021-06-30 | 2021-06-23 | 0 | 2021-06-23 | ? | 0 | 0006326378 | 20210623.ifs | 2021-06-23 | 2021-06-24 | |||||||
4709132 | 4709132 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .03223 | 00 | 2021-05-21 | 2021-05-24 | 2021-05-28 | 2021-05-20 | 0 | 2021-05-20 | ? | 0 | 0006309820 | 20210520.ifs | 2021-05-20 | 2021-05-21 | |||||||
4686781 | 4686781 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02875 | 00 | 2021-04-23 | 2021-04-26 | 2021-04-30 | 2021-04-22 | 0 | 2021-04-22 | ? | 0 | 0006296655 | 20210422.ifs | 2021-04-22 | 2021-04-23 | |||||||
4662578 | 4662578 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04477 | 00 | 2021-03-26 | 2021-03-29 | 2021-03-31 | 2021-03-25 | 0 | 2021-03-25 | ? | 0 | 0006282165 | 20210325.ifs | 2021-03-25 | 2021-03-26 | |||||||
4633257 | 4633257 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02526 | 00 | 2021-02-22 | 2021-02-23 | 2021-02-26 | 2021-02-19 | 0 | 2021-02-19 | ? | 0 | 0006265828 | 20210219.ifs | 2021-02-19 | 2021-02-20 | |||||||
4610535 | 4610535 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .01638 | 00 | 2021-01-25 | 2021-01-26 | 2021-01-29 | 2021-01-22 | 0 | 2021-01-22 | ? | 0 | 0006253619 | 20210122.ifs | 2021-01-22 | 2021-01-23 | |||||||
4573566 | 4573566 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .15163 | 00 | 2020-12-24 | 2020-12-28 | 2020-12-31 | 2020-12-23 | 0 | 2020-12-23 | ? | 0 | 0006232687 | 20201223.ifs | 2020-12-23 | 2020-12-24 | |||||||
4512339 | 4512339 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05432 | 00 | 2020-11-24 | 2020-11-25 | 2020-11-30 | 2020-11-23 | 0 | 2020-11-23 | ? | 0 | 0006190380 | 20201123.ifs | 2020-11-23 | 2020-11-24 | |||||||
4490413 | 4490413 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .03445 | 00 | 2020-10-26 | 2020-10-27 | 2020-10-30 | 2020-10-23 | 0 | 2020-10-23 | ? | 0 | 0006177252 | 20201023.ifs | 2020-10-23 | 2020-10-24 | |||||||
4468714 | 4468714 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02852 | 00 | 2020-09-24 | 2020-09-25 | 2020-09-30 | 2020-09-23 | 0 | 2020-09-23 | ? | 0 | 0006162729 | 20200923.ifs | 2020-09-23 | 2020-09-24 | |||||||
4445164 | 4445164 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0236 | 00 | 2020-08-25 | 2020-08-26 | 2020-08-31 | 2020-08-24 | 0 | 2020-08-24 | ? | 0 | 0006146557 | 20200824.ifs | 2020-08-24 | 2020-08-25 | |||||||
4424050 | 4424050 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02443 | 00 | 2020-07-27 | 2020-07-28 | 2020-07-31 | 2020-07-24 | 0 | 2020-07-24 | ? | 0 | 0006132924 | 20200724.ifs | 2020-07-24 | 2020-07-25 | |||||||
4398575 | 4398575 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .01829 | 00 | 2020-06-24 | 2020-06-25 | 2020-06-30 | 2020-06-23 | 0 | 2020-06-23 | ? | 0 | 0006116976 | 20200623.ifs | 2020-06-23 | 2020-06-24 | |||||||
4345683 | 4345683 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02555 | 00 | 2020-05-22 | 2020-05-26 | 2020-05-29 | 2020-05-21 | 0 | 2020-05-21 | ? | 0 | 0006101070 | 20200521.ifs | 2020-05-21 | 2020-05-22 | |||||||
4345684 | 4345684 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .02555 | 00 | 2020-05-22 | 2020-05-26 | 2020-05-29 | 2020-05-21 | 0 | 2020-05-21 | ? | 0 | 0006101070 | 20200521.ifs | 2020-05-21 | 2020-05-22 | |||||||
4300345 | 4300345 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .01695 | 00 | 2020-04-24 | 2020-04-27 | 2020-04-30 | 2020-04-23 | 0 | 2020-04-23 | ? | 0 | 0006087858 | 20200423.ifs | 2020-04-23 | 2020-04-24 | |||||||
4300346 | 4300346 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .01695 | 00 | 2020-04-24 | 2020-04-27 | 2020-04-30 | 2020-04-23 | 0 | 2020-04-23 | ? | 0 | 0006087858 | 20200423.ifs | 2020-04-23 | 2020-04-24 | |||||||
4256141 | 4256141 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05833 | 00 | 2020-03-26 | 2020-03-27 | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073735 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4256146 | 4256146 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05833 | 00 | 2020-03-26 | 2020-03-27 | 2020-03-31 | 2020-03-25 | 0 | 2020-03-25 | ? | 0 | 0006073735 | 20200325.ifs | 2020-03-25 | 2020-03-26 | |||||||
4213080 | 4213080 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04352 | 00 | 2020-02-24 | 2020-02-25 | 2020-02-28 | 2020-02-21 | 0 | 2020-02-21 | ? | 0 | 0006057406 | 20200221.ifs | 2020-02-21 | 2020-02-22 | |||||||
4213174 | 4213174 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04352 | 00 | 2020-02-24 | 2020-02-25 | 2020-02-28 | 2020-02-21 | 0 | 2020-02-21 | ? | 0 | 0006057406 | 20200221.ifs | 2020-02-21 | 2020-02-22 | |||||||
4178257 | 4178257 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-01-31 | 2020-01-24 | 0 | 2020-01-24 | ? | 0 | 0006045054 | 20200124.ifs | 2020-01-24 | 2020-01-25 | |||||||
4178266 | 4178266 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-01-31 | 2020-01-24 | 0 | 2020-01-24 | ? | 0 | 0006045054 | 20200124.ifs | 2020-01-24 | 2020-01-25 | |||||||
4123482 | 4123482 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .26146 | 00 | 2019-12-27 | 2019-12-30 | 2019-12-31 | 2019-12-26 | 0 | 2019-12-26 | ? | 0 | 0006024279 | 20191226.ifs | 2019-12-26 | 2019-12-27 | |||||||
4123499 | 4123499 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .26146 | 00 | 2019-12-27 | 2019-12-30 | 2019-12-31 | 2019-12-26 | 0 | 2019-12-26 | ? | 0 | 0006024279 | 20191226.ifs | 2019-12-26 | 2019-12-27 | |||||||
4029542 | 4029542 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .04245 | 00 | 2019-11-26 | 2019-11-27 | 2019-11-29 | 2019-11-25 | 0 | 2019-11-25 | ? | 0 | 0005978320 | 20191126.ifs | 2019-11-26 | 2019-11-27 | |||||||
4029543 | 4029543 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .04245 | 00 | 2019-11-26 | 2019-11-27 | 2019-11-29 | 2019-11-25 | 0 | 2019-11-25 | ? | 0 | 0005978320 | 20191126.ifs | 2019-11-26 | 2019-11-27 | |||||||
4029544 | 4029543 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .04245 | 00 | 2019-11-26 | 2019-11-27 | 2019-11-29 | 2019-11-25 | 1 | 2019-11-25 | 2019-11-26 | 0 | 0005978320 | 20191126.ifs | 2019-11-26 | 2019-11-27 | |||||||
4029545 | 4029544 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .04245 | 00 | 2019-11-26 | 2019-11-27 | 2019-11-29 | 2019-11-25 | 1 | 2019-11-25 | 2019-11-26 | 0 | 0005978320 | 20191126.ifs | 2019-11-26 | 2019-11-27 | |||||||
4026710 | 4026710 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04245 | 00 | 2019-11-26 | 2019-11-27 | 2019-11-29 | 2019-11-25 | 0 | 2019-11-25 | ? | 0 | 0005978320 | 20191125.ifs | 2019-11-25 | 2019-11-26 | |||||||
4026739 | 4026739 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04245 | 00 | 2019-11-26 | 2019-11-27 | 2019-11-29 | 2019-11-25 | 0 | 2019-11-25 | ? | 0 | 0005978320 | 20191125.ifs | 2019-11-25 | 2019-11-26 | |||||||
3984842 | 3984842 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04604 | 00 | 2019-10-28 | 2019-10-29 | 2019-10-31 | 2019-10-25 | 0 | 2019-10-25 | ? | 0 | 0005965320 | 20191025.ifs | 2019-10-25 | 2019-10-26 | |||||||
3984843 | 3984843 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04604 | 00 | 2019-10-28 | 2019-10-29 | 2019-10-31 | 2019-10-25 | 0 | 2019-10-25 | ? | 0 | 0005965320 | 20191025.ifs | 2019-10-25 | 2019-10-26 | |||||||
3937348 | 3937348 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .21083 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949720 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3937443 | 3937443 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .21083 | 00 | 2019-09-25 | 2019-09-26 | 2019-09-30 | 2019-09-24 | 0 | 2019-09-24 | ? | 0 | 0005949720 | 20190924.ifs | 2019-09-24 | 2019-09-25 | |||||||
3890818 | 3890818 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06027 | 00 | 2019-08-27 | 2019-08-28 | 2019-08-30 | 2019-08-26 | 0 | 2019-08-26 | ? | 0 | 0005933266 | 20190826.ifs | 2019-08-26 | 2019-08-27 | |||||||
3890819 | 3890819 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06027 | 00 | 2019-08-27 | 2019-08-28 | 2019-08-30 | 2019-08-26 | 0 | 2019-08-26 | ? | 0 | 0005933266 | 20190826.ifs | 2019-08-26 | 2019-08-27 | |||||||
3848630 | 3848630 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05267 | 00 | 2019-07-26 | 2019-07-29 | 2019-07-31 | 2019-07-25 | 0 | 2019-07-25 | ? | 0 | 0005919679 | 20190725.ifs | 2019-07-25 | 2019-07-26 | |||||||
3848635 | 3848635 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05267 | 00 | 2019-07-26 | 2019-07-29 | 2019-07-31 | 2019-07-25 | 0 | 2019-07-25 | ? | 0 | 0005919679 | 20190725.ifs | 2019-07-25 | 2019-07-26 | |||||||
3797994 | 3797994 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07135 | 00 | 2019-06-25 | 2019-06-26 | 2019-06-28 | 2019-06-24 | 0 | 2019-06-24 | ? | 0 | 0005903607 | 20190624.ifs | 2019-06-24 | 2019-06-25 | |||||||
3797995 | 3797995 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07135 | 00 | 2019-06-25 | 2019-06-26 | 2019-06-28 | 2019-06-24 | 0 | 2019-06-24 | ? | 0 | 0005903607 | 20190624.ifs | 2019-06-24 | 2019-06-25 | |||||||
3738449 | 3738449 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06979 | 00 | 2019-05-28 | 2019-05-29 | 2019-05-31 | 2019-05-24 | 0 | 2019-05-24 | ? | 0 | 0005886694 | 20190524.ifs | 2019-05-24 | 2019-05-25 | |||||||
3738456 | 3738456 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06979 | 00 | 2019-05-28 | 2019-05-29 | 2019-05-31 | 2019-05-24 | 0 | 2019-05-24 | ? | 0 | 0005886694 | 20190524.ifs | 2019-05-24 | 2019-05-25 | |||||||
3693220 | 3693220 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .13524 | 00 | 2019-04-25 | 2019-04-26 | 2019-04-30 | 2019-04-24 | 0 | 2019-04-24 | ? | 0 | 0005872856 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||||
3693233 | 3693233 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .13524 | 00 | 2019-04-25 | 2019-04-26 | 2019-04-30 | 2019-04-24 | 0 | 2019-04-24 | ? | 0 | 0005872856 | 20190424.ifs | 2019-04-24 | 2019-04-25 | |||||||
3663015 | 3663015 | CORPACTION | ADD | 00768Y834 | 04 | # | 2019-04-01 | 00768Y834 | 04 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||||||||
3663017 | 3663017 | CORPACTIONAUX | ADD | 00768Y834 | 04 | 2019-04-01 | FWDB | ADVISORSHARES TR | ADVISORSHARES T | FWDB | ADVISORSHARES TR | ADVISORSHARES F | 2019-04-01 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||||
3663019 | 3663019 | EQUITY | CHANGE | 00768Y834 | MADRONA GLOBAL BD ETF | 0 | A | 2011-06-21 | ? | 5 | no | no | no | 2011-06-21 | 2011-07-13 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||
3663020 | 3663019 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | 0 | A | 2011-06-21 | ? | 5 | no | no | no | 2011-06-21 | 2019-04-01 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||
3663031 | 3663031 | CORPACTION | ADD | 00768Y834 | 04 | # | 2019-04-01 | 00768Y834 | 04 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||||||||
3663033 | 3663033 | CORPACTIONAUX | ADD | 00768Y834 | 04 | 2019-04-01 | FWDB | ADVISORSHARES TR | ADVISORSHARES T | FWDB | ADVISORSHARES TR | ADVISORSHARES F | 2019-04-01 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||||
3663035 | 3663035 | EQUITY | CHANGE | 00768Y834 | MADRONA GLOBAL BD ETF | 0 | A | 2011-06-21 | ? | 5 | no | no | no | 2011-06-21 | 2011-07-13 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||
3663037 | 3663036 | EQUITY | CHANGE | 00768Y834 | ADVISORSHARES FOLIOBEYOND SMART CORE BOND ETF | 0 | A | 2011-06-21 | ? | 5 | no | no | no | 2011-06-21 | 2019-04-01 | ? | 20190401.ifs | 2019-04-01 | 2019-04-02 | ||||||||||
3647265 | 3647265 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0549 | 00 | 2019-03-26 | 2019-03-27 | 2019-03-29 | 2019-03-25 | 0 | 2019-03-25 | ? | 0 | 0005857613 | 20190325.ifs | 2019-03-25 | 2019-03-26 | |||||||
3647343 | 3647343 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0549 | 00 | 2019-03-26 | 2019-03-27 | 2019-03-29 | 2019-03-25 | 0 | 2019-03-25 | ? | 0 | 0005857613 | 20190325.ifs | 2019-03-25 | 2019-03-26 | |||||||
3622134 | 3622134 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .09991 | 00 | 2019-02-26 | 2019-02-27 | 2019-02-28 | 2019-02-25 | 0 | 2019-02-25 | ? | 0 | 0005841457 | 20190308.ifs | 2019-03-08 | 2019-03-09 | |||||||
3622136 | 3622135 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .09991 | 00 | 2019-02-26 | 2019-02-27 | 2019-02-28 | 2019-02-25 | 1 | 2019-02-25 | 2019-03-08 | 0 | 0005841457 | 20190308.ifs | 2019-03-08 | 2019-03-09 | |||||||
3622143 | 3622143 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .09991 | 00 | 2019-02-26 | 2019-02-27 | 2019-02-28 | 2019-02-25 | 0 | 2019-02-25 | ? | 0 | 0005841457 | 20190308.ifs | 2019-03-08 | 2019-03-09 | |||||||
3622145 | 3622144 | DIVIDEND | CHANGE | 00768Y834 | 0 | 0 | 1 | 0 | .09991 | 00 | 2019-02-26 | 2019-02-27 | 2019-02-28 | 2019-02-25 | 1 | 2019-02-25 | 2019-03-08 | 0 | 0005841457 | 20190308.ifs | 2019-03-08 | 2019-03-09 | |||||||
3593558 | 3593558 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .09991 | 00 | 2019-02-26 | 2019-02-27 | 2019-02-28 | 2019-02-25 | 0 | 2019-02-25 | ? | 0 | 0005841457 | 20190225.ifs | 2019-02-25 | 2019-02-26 | |||||||
3593559 | 3593559 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .09991 | 00 | 2019-02-26 | 2019-02-27 | 2019-02-28 | 2019-02-25 | 0 | 2019-02-25 | ? | 0 | 0005841457 | 20190225.ifs | 2019-02-25 | 2019-02-26 | |||||||
3562258 | 3562258 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0598 | 00 | 2019-01-28 | 2019-01-29 | 2019-01-31 | 2019-01-25 | 0 | 2019-01-25 | ? | 0 | 0005828663 | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||
3562277 | 3562277 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0598 | 00 | 2019-01-28 | 2019-01-29 | 2019-01-31 | 2019-01-25 | 0 | 2019-01-25 | ? | 0 | 0005828663 | 20190125.ifs | 2019-01-25 | 2019-01-26 | |||||||
3498943 | 3498943 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .21309 | 00 | 2018-12-27 | 2018-12-28 | 2018-12-31 | 2018-12-26 | 0 | 2018-12-26 | ? | 0 | 0005805803 | 20181226.ifs | 2018-12-26 | 2018-12-27 | |||||||
3498957 | 3498957 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .21309 | 00 | 2018-12-27 | 2018-12-28 | 2018-12-31 | 2018-12-26 | 0 | 2018-12-26 | ? | 0 | 0005805803 | 20181226.ifs | 2018-12-26 | 2018-12-27 | |||||||
3382054 | 3382054 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .08102 | 00 | 2018-11-27 | 2018-11-28 | 2018-11-30 | 2018-11-26 | 0 | 2018-11-26 | ? | 0 | 0005757542 | 20181126.ifs | 2018-11-26 | 2018-11-27 | |||||||
3382188 | 3382188 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .08102 | 00 | 2018-11-27 | 2018-11-28 | 2018-11-30 | 2018-11-26 | 0 | 2018-11-26 | ? | 0 | 0005757542 | 20181126.ifs | 2018-11-26 | 2018-11-27 | |||||||
3339767 | 3339767 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0828 | 00 | 2018-10-26 | 2018-10-29 | 2018-10-31 | 2018-10-25 | 0 | 2018-10-25 | ? | 0 | 0005743888 | 20181025.ifs | 2018-10-25 | 2018-10-26 | |||||||
3339877 | 3339877 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0828 | 00 | 2018-10-26 | 2018-10-29 | 2018-10-31 | 2018-10-25 | 0 | 2018-10-25 | ? | 0 | 0005743888 | 20181025.ifs | 2018-10-25 | 2018-10-26 | |||||||
3300032 | 3300032 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07112 | 00 | 2018-09-26 | 2018-09-27 | 2018-09-28 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728563 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3300112 | 3300112 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07112 | 00 | 2018-09-26 | 2018-09-27 | 2018-09-28 | 2018-09-25 | 0 | 2018-09-25 | ? | 0 | 0005728563 | 20180925.ifs | 2018-09-25 | 2018-09-26 | |||||||
3250326 | 3250326 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07137 | 00 | 2018-08-27 | 2018-08-28 | 2018-08-31 | 2018-08-24 | 0 | 2018-08-24 | ? | 0 | 0005711371 | 20180824.ifs | 2018-08-24 | 2018-08-25 | |||||||
3250327 | 3250327 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07137 | 00 | 2018-08-27 | 2018-08-28 | 2018-08-31 | 2018-08-24 | 0 | 2018-08-24 | ? | 0 | 0005711371 | 20180824.ifs | 2018-08-24 | 2018-08-25 | |||||||
3205741 | 3205741 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0897 | 00 | 2018-07-26 | 2018-07-27 | 2018-07-31 | 2018-07-25 | 0 | 2018-07-25 | ? | 0 | 0005697126 | 20180725.ifs | 2018-07-25 | 2018-07-26 | |||||||
3205748 | 3205748 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0897 | 00 | 2018-07-26 | 2018-07-27 | 2018-07-31 | 2018-07-25 | 0 | 2018-07-25 | ? | 0 | 0005697126 | 20180725.ifs | 2018-07-25 | 2018-07-26 | |||||||
3102219 | 3102219 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0528 | 00 | 2018-05-25 | 2018-05-29 | 2018-05-31 | 2018-05-24 | 0 | 2018-05-24 | ? | 0 | 0005664187 | 20180524.ifs | 2018-05-24 | 2018-05-25 | |||||||
3102258 | 3102258 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0528 | 00 | 2018-05-25 | 2018-05-29 | 2018-05-31 | 2018-05-24 | 0 | 2018-05-24 | ? | 0 | 0005664187 | 20180524.ifs | 2018-05-24 | 2018-05-25 | |||||||
3051927 | 3051927 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07451 | 00 | 2018-04-25 | 2018-04-26 | 2018-04-30 | 2018-04-24 | 0 | 2018-04-24 | ? | 0 | 0005649841 | 20180424.ifs | 2018-04-24 | 2018-04-25 | |||||||
3051930 | 3051930 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07451 | 00 | 2018-04-25 | 2018-04-26 | 2018-04-30 | 2018-04-24 | 0 | 2018-04-24 | ? | 0 | 0005649841 | 20180424.ifs | 2018-04-24 | 2018-04-25 | |||||||
3006147 | 3006147 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07236 | 00 | 2018-03-26 | 2018-03-27 | 2018-03-29 | 2018-03-23 | 0 | 2018-03-23 | ? | 0 | 0005634032 | 20180323.ifs | 2018-03-23 | 2018-03-24 | |||||||
3006148 | 3006148 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07236 | 00 | 2018-03-26 | 2018-03-27 | 2018-03-29 | 2018-03-23 | 0 | 2018-03-23 | ? | 0 | 0005634032 | 20180323.ifs | 2018-03-23 | 2018-03-24 | |||||||
2963309 | 2963309 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06982 | 00 | 2018-02-26 | 2018-02-27 | 2018-02-28 | 2018-02-23 | 0 | 2018-02-23 | ? | 0 | 0005617925 | 20180223.ifs | 2018-02-23 | 2018-02-24 | |||||||
2963310 | 2963310 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06982 | 00 | 2018-02-26 | 2018-02-27 | 2018-02-28 | 2018-02-23 | 0 | 2018-02-23 | ? | 0 | 0005617925 | 20180223.ifs | 2018-02-23 | 2018-02-24 | |||||||
2928832 | 2928832 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04004 | 00 | 2018-01-26 | 2018-01-29 | 2018-01-31 | 2018-01-25 | 0 | 2018-01-25 | ? | 0 | 0005604379 | 20180125.ifs | 2018-01-25 | 2018-01-26 | |||||||
2928910 | 2928910 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04004 | 00 | 2018-01-26 | 2018-01-29 | 2018-01-31 | 2018-01-25 | 0 | 2018-01-25 | ? | 0 | 0005604379 | 20180125.ifs | 2018-01-25 | 2018-01-26 | |||||||
2870791 | 2870791 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .15045 | 00 | 2017-12-27 | 2017-12-28 | 2017-12-29 | 2017-12-26 | 0 | 2017-12-26 | ? | 0 | 0005580738 | 20171226.ifs | 2017-12-26 | 2017-12-27 | |||||||
2776303 | 2776303 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06965 | 00 | 2017-11-28 | 2017-11-29 | 2017-11-30 | 2017-11-27 | 0 | 2017-11-27 | ? | 0 | 0005533011 | 20171127.ifs | 2017-11-27 | 2017-11-28 | |||||||
2776343 | 2776343 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06965 | 00 | 2017-11-28 | 2017-11-29 | 2017-11-30 | 2017-11-27 | 0 | 2017-11-27 | ? | 0 | 0005533011 | 20171127.ifs | 2017-11-27 | 2017-11-28 | |||||||
2737088 | 2737088 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0767 | 00 | 2017-10-27 | 2017-10-30 | 2017-10-31 | 2017-10-26 | 0 | 2017-10-26 | ? | 0 | 0005518736 | 20171026.ifs | 2017-10-26 | 2017-10-27 | |||||||
2737111 | 2737111 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0767 | 00 | 2017-10-27 | 2017-10-30 | 2017-10-31 | 2017-10-26 | 0 | 2017-10-26 | ? | 0 | 0005518736 | 20171026.ifs | 2017-10-26 | 2017-10-27 | |||||||
2687315 | 2687315 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07043 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501826 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2687359 | 2687359 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07043 | 00 | 2017-09-26 | 2017-09-27 | 2017-09-29 | 2017-09-25 | 0 | 2017-09-25 | ? | 0 | 0005501826 | 20170925.ifs | 2017-09-25 | 2017-09-26 | |||||||
2654469 | 2654469 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07108 | 00 | 2017-08-25 | 2017-08-29 | 2017-08-31 | 2017-08-24 | 0 | 2017-08-24 | ? | 0 | 0005485553 | 20170824.ifs | 2017-08-24 | 2017-08-25 | |||||||
2631038 | 2631038 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .08397 | 00 | 2017-07-26 | 2017-07-28 | 2017-07-31 | 2017-07-25 | 0 | 2017-07-25 | ? | 0 | 0005471179 | 20170725.ifs | 2017-07-25 | 2017-07-26 | |||||||
2600452 | 2600452 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06664 | 00 | 2017-06-26 | 2017-06-28 | 2017-06-30 | 2017-06-23 | 0 | 2017-06-23 | ? | 0 | 0005454268 | 20170623.ifs | 2017-06-23 | 2017-06-24 | |||||||
2572445 | 2572445 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07443 | 00 | 2017-05-24 | 2017-05-26 | 2017-05-31 | 2017-05-23 | 0 | 2017-05-23 | ? | 0 | 0005437403 | 20170523.ifs | 2017-05-23 | 2017-05-24 | |||||||
2546011 | 2546011 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05085 | 00 | 2017-04-24 | 2017-04-26 | 2017-04-28 | 2017-04-21 | 0 | 2017-04-21 | ? | 0 | 0005422950 | 20170421.ifs | 2017-04-21 | 2017-04-22 | |||||||
2493960 | 2493960 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04998 | 00 | 2017-02-23 | 2017-02-27 | 2017-02-28 | 2017-02-22 | 0 | 2017-02-22 | ? | 0 | 0005390431 | 20170222.ifs | 2017-02-22 | 2017-02-23 | |||||||
2454706 | 2454706 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .00458 | 00 | 2017-01-25 | 2017-01-27 | 2017-01-31 | 2017-01-24 | 0 | 2017-01-24 | ? | 0 | 0005377408 | 20170124.ifs | 2017-01-24 | 2017-01-25 | |||||||
2429214 | 2429214 | EQUITY | CHANGE | 00768Y834 | MADRONA GLOBAL BD ETF | 0 | A | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | 2011-07-13 | ? | 20170120.ifs | 2017-01-20 | 2017-01-21 | ||||||||||
2429215 | 2429214 | EQUITY | CHANGE | 00768Y834 | MADRONA GLOBAL BD ETF | 0 | A | 2011-06-21 | ? | 5 | no | no | no | 2011-06-21 | 2011-07-13 | ? | 20170120.ifs | 2017-01-20 | 2017-01-21 | ||||||||||
2395713 | 2395713 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .1624 | 00 | 2016-12-23 | 2016-12-28 | 2016-12-30 | 2016-12-22 | 0 | 2016-12-22 | ? | 0 | 0005352597 | 20161222.ifs | 2016-12-22 | 2016-12-23 | |||||||
2347957 | 2347957 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06527 | 00 | 2016-11-23 | 2016-11-28 | 2016-11-30 | 2016-11-22 | 0 | 2016-11-22 | ? | 0 | 0005313730 | 20161122.ifs | 2016-11-22 | 2016-11-23 | |||||||
2325717 | 2325717 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07241 | 00 | 2016-10-25 | 2016-10-27 | 2016-10-31 | 2016-10-24 | 0 | 2016-10-24 | ? | 0 | 0005300390 | 20161024.ifs | 2016-10-24 | 2016-10-25 | |||||||
2301477 | 2301477 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06552 | 00 | 2016-09-26 | 2016-09-28 | 2016-09-30 | 2016-09-23 | 0 | 2016-09-23 | ? | 0 | 0005284942 | 20160923.ifs | 2016-09-23 | 2016-09-24 | |||||||
2276071 | 2276071 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06989 | 00 | 2016-08-25 | 2016-08-29 | 2016-08-31 | 2016-08-24 | 0 | 2016-08-24 | ? | 0 | 0005268722 | 20160824.ifs | 2016-08-24 | 2016-08-25 | |||||||
2255858 | 2255858 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05287 | 00 | 2016-07-25 | 2016-07-27 | 2016-07-29 | 2016-07-22 | 0 | 2016-07-22 | ? | 0 | 0005253625 | 20160722.ifs | 2016-07-22 | 2016-07-23 | |||||||
2229458 | 2229458 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06181 | 00 | 2016-06-24 | 2016-06-28 | 2016-06-30 | 2016-06-23 | 0 | 2016-06-23 | ? | 0 | 0005237904 | 20160623.ifs | 2016-06-23 | 2016-06-24 | |||||||
2201796 | 2201796 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0671 | 00 | 2016-05-24 | 2016-05-26 | 2016-05-31 | 2016-05-23 | 0 | 2016-05-23 | ? | 0 | 0005221222 | 20160523.ifs | 2016-05-23 | 2016-05-24 | |||||||
2169674 | 2169674 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06368 | 00 | 2016-04-25 | 2016-04-27 | 2016-04-29 | 2016-04-22 | 0 | 2016-04-22 | ? | 0 | 0005207507 | 20160422.ifs | 2016-04-22 | 2016-04-23 | |||||||
2141938 | 2141938 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06819 | 00 | 2016-03-24 | 2016-03-29 | 2016-03-31 | 2016-03-23 | 0 | 2016-03-23 | ? | 0 | 0005191370 | 20160323.ifs | 2016-03-23 | 2016-03-24 | |||||||
2116704 | 2116704 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05052 | 00 | 2016-02-23 | 2016-02-25 | 2016-02-29 | 2016-02-22 | 0 | 2016-02-22 | ? | 0 | 0005174491 | 20160222.ifs | 2016-02-22 | 2016-02-23 | |||||||
2097094 | 2097094 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .01106 | 00 | 2016-01-25 | 2016-01-27 | 2016-01-29 | 2016-01-22 | 0 | 2016-01-22 | ? | 0 | 0005161777 | 20160122.ifs | 2016-01-22 | 2016-01-23 | |||||||
2064509 | 2064509 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .14918 | 00 | 2015-12-24 | 2015-12-29 | 2015-12-31 | 2015-12-23 | 0 | 2015-12-23 | ? | 0 | 0005138652 | 20151223.ifs | 2015-12-23 | 2015-12-24 | |||||||
2013373 | 2013373 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05503 | 00 | 2015-11-23 | 2015-11-25 | 2015-11-30 | 2015-11-20 | 0 | 2015-11-20 | ? | 0 | 0005095376 | 20151120.ifs | 2015-11-20 | 2015-11-21 | |||||||
1995856 | 1995856 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05665 | 00 | 2015-10-26 | 2015-10-28 | 2015-10-30 | 2015-10-23 | 0 | 2015-10-23 | ? | 0 | 0005081913 | 20151023.ifs | 2015-10-23 | 2015-10-24 | |||||||
1971516 | 1971516 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06376 | 00 | 2015-09-24 | 2015-09-28 | 2015-09-30 | 2015-09-23 | 0 | 2015-09-23 | ? | 0 | 0005066488 | 20150923.ifs | 2015-09-23 | 2015-09-24 | |||||||
1946309 | 1946309 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05422 | 00 | 2015-08-25 | 2015-08-27 | 2015-08-31 | 2015-08-24 | 0 | 2015-08-24 | ? | 0 | 0005049869 | 20150824.ifs | 2015-08-24 | 2015-08-25 | |||||||
1922148 | 1922148 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06215 | 00 | 2015-07-24 | 2015-07-28 | 2015-07-30 | 2015-07-23 | 0 | 2015-07-23 | ? | 0 | 0005035277 | 20150723.ifs | 2015-07-23 | 2015-07-24 | |||||||
1868539 | 1868539 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05522 | 00 | 2015-05-22 | 2015-05-27 | 2015-05-29 | 2015-05-21 | 0 | 2015-05-21 | ? | 0 | 0005002443 | 20150521.ifs | 2015-05-21 | 2015-05-22 | |||||||
1846348 | 1846348 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05272 | 00 | 2015-04-24 | 2015-04-28 | 2015-04-30 | 2015-04-23 | 0 | 2015-04-23 | ? | 0 | 0004988814 | 20150423.ifs | 2015-04-23 | 2015-04-24 | |||||||
1819853 | 1819853 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05754 | 00 | 2015-03-25 | 2015-03-27 | 2015-03-31 | 2015-03-24 | 0 | 2015-03-24 | ? | 0 | 0004972877 | 20150324.ifs | 2015-03-24 | 2015-03-25 | |||||||
1793365 | 1793365 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05505 | 00 | 2015-02-23 | 2015-02-25 | 2015-02-27 | 2015-02-20 | 0 | 2015-02-20 | ? | 0 | 0004956429 | 20150220.ifs | 2015-02-20 | 2015-02-21 | |||||||
1774191 | 1774191 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04475 | 00 | 2015-01-26 | 2015-01-28 | 2015-01-30 | 2015-01-23 | 0 | 2015-01-23 | ? | 0 | 0004943750 | 20150123.ifs | 2015-01-23 | 2015-01-24 | |||||||
1741680 | 1741680 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .13051 | 00 | 2014-12-24 | 2014-12-29 | 2014-12-31 | 2014-12-23 | 0 | 2014-12-23 | ? | 0 | 0004919140 | 20141223.ifs | 2014-12-23 | 2014-12-24 | |||||||
1685158 | 1685158 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06118 | 00 | 2014-11-21 | 2014-11-25 | 2014-11-28 | 2014-11-20 | 0 | 2014-11-20 | ? | 0 | 0004874809 | 20141120.ifs | 2014-11-20 | 2014-11-21 | |||||||
1663028 | 1663028 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05416 | 00 | 2014-10-27 | 2014-10-29 | 2014-10-31 | 2014-10-24 | 0 | 2014-10-24 | ? | 0 | 0004862228 | 20141024.ifs | 2014-10-24 | 2014-10-25 | |||||||
1636871 | 1636871 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07437 | 00 | 2014-09-24 | 2014-09-26 | 2014-09-30 | 2014-09-23 | 0 | 2014-09-23 | ? | 0 | 0004846720 | 20140923.ifs | 2014-09-23 | 2014-09-24 | |||||||
1611825 | 1611825 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06534 | 00 | 2014-08-25 | 2014-08-27 | 2014-08-29 | 2014-08-22 | 0 | 2014-08-22 | ? | 0 | 0004830992 | 20140822.ifs | 2014-08-22 | 2014-08-23 | |||||||
1586289 | 1586289 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06862 | 00 | 2014-07-25 | 2014-07-29 | 2014-07-31 | 2014-07-24 | 0 | 2014-07-24 | ? | 0 | 0004817500 | 20140724.ifs | 2014-07-24 | 2014-07-25 | |||||||
1557831 | 1557831 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07764 | 00 | 2014-06-24 | 2014-06-26 | 2014-06-30 | 2014-06-23 | 0 | 2014-06-23 | ? | 0 | 0004800628 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1529999 | 1529999 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06597 | 00 | 2014-05-23 | 2014-05-28 | 2014-05-30 | 2014-05-22 | 0 | 2014-05-23 | ? | 0 | 0004784632 | 20140523.ifs | 2014-05-23 | 2014-05-24 | |||||||
1500837 | 1500837 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07414 | 00 | 2014-04-24 | 2014-04-28 | 2014-04-30 | 2014-04-23 | 0 | 2014-04-23 | ? | 0 | 0004770454 | 20140423.ifs | 2014-04-23 | 2014-04-24 | |||||||
1475148 | 1475148 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07542 | 00 | 2014-03-25 | 2014-03-27 | 2014-03-31 | 2014-03-24 | 0 | 2014-03-24 | ? | 0 | 0004754606 | 20140324.ifs | 2014-03-24 | 2014-03-25 | |||||||
1447963 | 1447963 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06444 | 00 | 2014-02-24 | 2014-02-26 | 2014-02-28 | 2014-02-21 | 0 | 2014-02-21 | ? | 0 | 0004738685 | 20140221.ifs | 2014-02-21 | 2014-02-22 | |||||||
1427585 | 1427585 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .01487 | 00 | 2014-01-27 | 2014-01-29 | 2014-01-31 | 2014-01-24 | 0 | 2014-01-24 | ? | 0 | 0004726103 | 20140124.ifs | 2014-01-24 | 2014-01-25 | |||||||
1394216 | 1394216 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .15896 | 00 | 2013-12-24 | 2013-12-27 | 2013-12-31 | 2013-12-23 | 0 | 2013-12-23 | ? | 0 | 0004702647 | 20131223.ifs | 2013-12-23 | 2013-12-24 | |||||||
1343819 | 1343819 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06645 | 00 | 2013-11-22 | 2013-11-26 | 2013-11-29 | 2013-11-21 | 0 | 2013-11-21 | ? | 0 | 0004660500 | 20131121.ifs | 2013-11-21 | 2013-11-22 | |||||||
1322657 | 1322657 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0669 | 00 | 2013-10-25 | 2013-10-29 | 2013-10-31 | 2013-10-24 | 0 | 2013-10-24 | ? | 0 | 0004647632 | 20131024.ifs | 2013-10-24 | 2013-10-25 | |||||||
1294602 | 1294602 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07319 | 00 | 2013-09-24 | 2013-09-26 | 2013-09-30 | 2013-09-23 | 0 | 2013-09-23 | ? | 0 | 0004632615 | 20130923.ifs | 2013-09-23 | 2013-09-24 | |||||||
1270533 | 1270533 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05792 | 00 | 2013-08-26 | 2013-08-28 | 2013-08-30 | 2013-08-23 | 0 | 2013-08-23 | ? | 0 | 0004617641 | 20130823.ifs | 2013-08-23 | 2013-08-24 | |||||||
1246052 | 1246052 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05755 | 00 | 2013-07-25 | 2013-07-29 | 2013-07-31 | 2013-07-24 | 0 | 2013-07-24 | ? | 0 | 0004603999 | 20130724.ifs | 2013-07-24 | 2013-07-25 | |||||||
1215174 | 1215174 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0634 | 00 | 2013-06-24 | 2013-06-26 | 2013-06-28 | 2013-06-21 | 0 | 2013-06-21 | ? | 0 | 0004587572 | 20130621.ifs | 2013-06-21 | 2013-06-22 | |||||||
1192107 | 1192107 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0479 | 00 | 2013-05-24 | 2013-05-29 | 2013-05-31 | 2013-05-23 | 0 | 2013-05-23 | ? | 0 | 0004573366 | 20130523.ifs | 2013-05-23 | 2013-05-24 | |||||||
1165538 | 1165538 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05779 | 00 | 2013-04-24 | 2013-04-26 | 2013-04-30 | 2013-04-23 | 0 | 2013-04-23 | ? | 0 | 0004560008 | 20130423.ifs | 2013-04-23 | 2013-04-24 | |||||||
1139166 | 1139166 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05504 | 00 | 2013-03-22 | 2013-03-26 | 2013-03-28 | 2013-03-21 | 0 | 2013-03-21 | ? | 0 | 0004544277 | 20130321.ifs | 2013-03-21 | 2013-03-22 | |||||||
1115876 | 1115876 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05568 | 00 | 2013-02-22 | 2013-02-26 | 2013-02-28 | 2013-02-21 | 0 | 2013-02-21 | ? | 0 | 0004529867 | 20130221.ifs | 2013-02-21 | 2013-02-22 | |||||||
1095270 | 1095270 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .08566 | 00 | 2013-01-25 | 2013-01-29 | 2013-01-31 | 2013-01-24 | 0 | 2013-01-24 | ? | 0 | 0004517317 | 20130124.ifs | 2013-01-24 | 2013-01-25 | |||||||
1058148 | 1058148 | DIVIDEND | ADD | 00768Y834 | 8 | 0 | 1 | 9 | .00355 | 96 | 2012-12-24 | 2012-12-27 | 2012-12-31 | 2012-12-21 | 0 | 2012-12-21 | ? | 1 | 0004492634 | 20121221.ifs | 2012-12-21 | 2012-12-22 | |||||||
1058149 | 1058149 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .08048 | 00 | 2012-12-24 | 2012-12-27 | 2012-12-31 | 2012-12-21 | 0 | 2012-12-21 | ? | 0 | 0004492633 | 20121221.ifs | 2012-12-21 | 2012-12-22 | |||||||
1015098 | 1015098 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05092 | 00 | 2012-11-26 | 2012-11-28 | 2012-11-30 | 2012-11-23 | 0 | 2012-11-23 | ? | 0 | 0004460708 | 20121123.ifs | 2012-11-23 | 2012-11-24 | |||||||
992080 | 992080 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05643 | 00 | 2012-10-25 | 2012-10-29 | 2012-10-31 | 2012-10-24 | 0 | 2012-10-24 | ? | 0 | 0004447763 | 20121024.ifs | 2012-10-24 | 2012-10-25 | |||||||
962205 | 962205 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05398 | 00 | 2012-09-24 | 2012-09-26 | 2012-09-28 | 2012-09-21 | 0 | 2012-09-21 | ? | 0 | 0004432623 | 20120921.ifs | 2012-09-21 | 2012-09-22 | |||||||
920455 | 920455 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05135 | 00 | 2012-07-25 | 2012-07-27 | 2012-07-31 | 2012-07-24 | 0 | 2012-07-24 | ? | 0 | 0004404894 | 20120724.ifs | 2012-07-24 | 2012-07-25 | |||||||
892329 | 892329 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04756 | 00 | 2012-06-25 | 2012-06-27 | 2012-06-29 | 2012-06-22 | 0 | 2012-06-22 | ? | 0 | 0004390587 | 20120622.ifs | 2012-06-22 | 2012-06-23 | |||||||
866738 | 866738 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .04928 | 00 | 2012-05-24 | 2012-05-29 | 2012-05-31 | 2012-05-23 | 0 | 2012-05-23 | ? | 0 | 0004376360 | 20120523.ifs | 2012-05-23 | 2012-05-24 | |||||||
841094 | 841094 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05311 | 00 | 2012-04-24 | 2012-04-26 | 2012-04-30 | 2012-04-23 | 0 | 2012-04-23 | ? | 0 | 0004363538 | 20120423.ifs | 2012-04-23 | 2012-04-24 | |||||||
809891 | 809891 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05363 | 00 | 2012-03-26 | 2012-03-28 | 2012-03-30 | 2012-03-23 | 0 | 2012-03-23 | ? | 0 | 0004349491 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
783367 | 783367 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05202 | 00 | 2012-02-23 | 2012-02-27 | 2012-02-29 | 2012-02-22 | 0 | 2012-02-22 | ? | 0 | 0004334785 | 20120222.ifs | 2012-02-22 | 2012-02-23 | |||||||
761878 | 761878 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .05941 | 00 | 2012-01-25 | 2012-01-27 | 2012-01-31 | 2012-01-24 | 0 | 2012-01-24 | ? | 0 | 0004322720 | 20120124.ifs | 2012-01-24 | 2012-01-25 | |||||||
677274 | 677274 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .0606 | 00 | 2011-10-25 | 2011-10-27 | 2011-10-31 | 2011-10-24 | 0 | 2011-10-24 | ? | 0 | 0004259861 | 20111024.ifs | 2011-10-24 | 2011-10-25 | |||||||
652416 | 652416 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .06263 | 00 | 2011-09-26 | 2011-09-28 | 2011-09-30 | 2011-09-23 | 0 | 2011-09-23 | ? | 0 | 0004246294 | 20110923.ifs | 2011-09-23 | 2011-09-24 | |||||||
625622 | 625622 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 0 | .07369 | 00 | 2011-08-25 | 2011-08-29 | 2011-08-31 | 2011-08-24 | 0 | 2011-08-24 | ? | 0 | 0004231890 | 20110824.ifs | 2011-08-24 | 2011-08-25 | |||||||
592065 | 592065 | DIVIDEND | ADD | 00768Y834 | 0 | 0 | 1 | 4 | .01948 | 00 | 2011-07-25 | 2011-07-27 | 2011-07-29 | 2011-07-22 | 0 | 2011-07-22 | ? | 0 | 0004218947 | 20110722.ifs | 2011-07-22 | 2011-07-23 | |||||||
586588 | 586588 | EQUITY | CHANGE | 00768Y834 | MADRONA FORWARD GLOBAL BD ETF | 0 | A | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | 2011-06-21 | ? | 20110713.ifs | 2011-07-13 | 2011-07-14 | ||||||||||
586589 | 586588 | EQUITY | CHANGE | 00768Y834 | MADRONA GLOBAL BD ETF | 0 | A | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | 2011-07-13 | ? | 20110713.ifs | 2011-07-13 | 2011-07-14 | ||||||||||
586590 | 586590 | CORPACTION | ADD | 00768Y834 | 04 | # | 2011-07-13 | 00768Y834 | 04 | 2011-07-13 | 20110713.ifs | 2011-07-13 | 2011-07-14 | ||||||||||||||||
586591 | 586591 | CORPACTIONAUX | ADD | 00768Y834 | 04 | 2011-07-13 | FWDB | ADVISORSHARES TR | MADRONA FORWARD | FWDB | ADVISORSHARES TR | MADRONA GLOBAL | ? | 2011-07-13 | 20110713.ifs | 2011-07-13 | 2011-07-14 | ||||||||||||
565218 | 565218 | EQUITY | ADD | 00768Y834 | MADRONA FORWARD GLOBAL BD ETF | N | 7 | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | ? | ? | 20110621.ifs | 2011-06-21 | 2011-06-22 | ||||||||||
565219 | 565219 | EXCHANGE | ADD | 00768Y834 | 04 | 2011-06-21 | 2011-06-21 | FWDB | 0 | A | 2011-06-21 | ? | 20110621.ifs | 2011-06-21 | 2011-06-22 | ||||||||||||||
565303 | 565303 | EQUITY | CHANGE | 00768Y834 | MADRONA FORWARD GLOBAL BD ETF | N | 7 | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | ? | ? | 20110621.ifs | 2011-06-21 | 2011-06-22 | ||||||||||
565304 | 565303 | EQUITY | CHANGE | 00768Y834 | MADRONA FORWARD GLOBAL BD ETF | N | A | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | 2011-06-21 | ? | 20110621.ifs | 2011-06-21 | 2011-06-22 | ||||||||||
566328 | 566328 | EQUITY | CHANGE | 00768Y834 | MADRONA FORWARD GLOBAL BD ETF | N | A | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | 2011-06-21 | ? | 20110621.ifs | 2011-06-21 | 2011-06-22 | ||||||||||
566329 | 566328 | EQUITY | CHANGE | 00768Y834 | MADRONA FORWARD GLOBAL BD ETF | 0 | A | 2011-06-21 | ? | 0 | no | no | no | 2011-06-21 | 2011-06-21 | ? | 20110621.ifs | 2011-06-21 | 2011-06-22 |
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 = 159734
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