$140 Million is the total value of AURORA FINANCIAL ADVISORS, LLC's 187 reported holdings in Q4 2017. The portfolio turnover from Q3 2017 to Q4 2017 was - .
Value | Shares | ↓ Weighting | ||||||
---|---|---|---|---|---|---|---|---|
SPHD | New | POWERSHARES ETF TR II | $5,997,000 | – | 141,342 | +100.0% | 4.30% | – |
USMV | New | ISHARES TRmin vol usa etf | $5,551,000 | – | 105,190 | +100.0% | 3.98% | – |
AAPL | New | APPLE INC | $3,146,000 | – | 18,592 | +100.0% | 2.25% | – |
JNJ | New | JOHNSON &JOHNSON | $2,725,000 | – | 19,508 | +100.0% | 1.95% | – |
JPM | New | JPMORGAN CHASE &CO | $2,605,000 | – | 24,363 | +100.0% | 1.87% | – |
VIG | New | VANGUARD SPECIALIZED FUNDSdiv app etf | $2,443,000 | – | 23,951 | +100.0% | 1.75% | – |
SPY | New | SPDR S&P 500 ETF TRtr unit | $2,287,000 | – | 8,572 | +100.0% | 1.64% | – |
XOM | New | EXXON MOBIL CORP | $2,056,000 | – | 24,581 | +100.0% | 1.47% | – |
PFE | New | PFIZER INC | $1,999,000 | – | 55,208 | +100.0% | 1.43% | – |
ADI | New | ANALOG DEVICES INC | $1,931,000 | – | 21,690 | +100.0% | 1.38% | – |
T | New | AT&T INC | $1,926,000 | – | 49,562 | +100.0% | 1.38% | – |
VEA | New | VANGUARD TAX MANAGED INTL FDftse dev mkt etf | $1,914,000 | – | 42,671 | +100.0% | 1.37% | – |
VZ | New | VERIZON COMMUNICATIONS INC | $1,860,000 | – | 35,144 | +100.0% | 1.33% | – |
PG | New | PROCTER AND GAMBLE CO | $1,772,000 | – | 19,295 | +100.0% | 1.27% | – |
UTX | New | UNITED TECHNOLOGIES CORP | $1,492,000 | – | 11,696 | +100.0% | 1.07% | – |
SDY | New | SPDR SERIES TRUSTs&p divid etf | $1,484,000 | – | 15,707 | +100.0% | 1.06% | – |
MSFT | New | MICROSOFT CORP | $1,441,000 | – | 16,847 | +100.0% | 1.03% | – |
V | New | VISA INC | $1,414,000 | – | 12,407 | +100.0% | 1.01% | – |
C | New | CITIGROUP INC | $1,401,000 | – | 18,830 | +100.0% | 1.00% | – |
KKR | New | KKR &CO L P DEL | $1,358,000 | – | 64,516 | +100.0% | 0.97% | – |
ABBV | New | ABBVIE INC | $1,353,000 | – | 13,991 | +100.0% | 0.97% | – |
KO | New | COCA COLA CO | $1,284,000 | – | 28,003 | +100.0% | 0.92% | – |
SBUX | New | STARBUCKS CORP | $1,263,000 | – | 22,007 | +100.0% | 0.90% | – |
PGF | New | POWERSHARES ETF TRUSTfinl pfd ptfl | $1,261,000 | – | 66,874 | +100.0% | 0.90% | – |
BX | New | BLACKSTONE GROUP L P | $1,249,000 | – | 39,034 | +100.0% | 0.89% | – |
GOOG | New | ALPHABET INCcap stk cl c | $1,216,000 | – | 1,163 | +100.0% | 0.87% | – |
ABT | New | ABBOTT LABS | $1,216,000 | – | 21,319 | +100.0% | 0.87% | – |
IJH | New | ISHARES TRcore s&p mcp etf | $1,214,000 | – | 6,402 | +100.0% | 0.87% | – |
SPYG | New | SPDR SERIES TRUSTprtflo s&p500 gw | $1,203,000 | – | 36,471 | +100.0% | 0.86% | – |
MDLZ | New | MONDELEZ INTL INCcl a | $1,139,000 | – | 26,622 | +100.0% | 0.82% | – |
INTC | New | INTEL CORP | $1,099,000 | – | 23,817 | +100.0% | 0.79% | – |
RTN | New | RAYTHEON CO | $1,092,000 | – | 5,817 | +100.0% | 0.78% | – |
UNH | New | UNITEDHEALTH GROUP INC | $1,076,000 | – | 4,882 | +100.0% | 0.77% | – |
VAW | New | VANGUARD WORLD FDSmaterials etf | $1,047,000 | – | 7,663 | +100.0% | 0.75% | – |
CSCO | New | CISCO SYS INC | $1,043,000 | – | 27,250 | +100.0% | 0.75% | – |
CVX | New | CHEVRON CORP NEW | $1,039,000 | – | 8,304 | +100.0% | 0.74% | – |
GILD | New | GILEAD SCIENCES INC | $1,035,000 | – | 14,457 | +100.0% | 0.74% | – |
PCLN | New | PRICELINE GRP INC | $1,028,000 | – | 592 | +100.0% | 0.74% | – |
EPD | New | ENTERPRISE PRODS PARTNERS L | $1,028,000 | – | 38,815 | +100.0% | 0.74% | – |
COF | New | CAPITAL ONE FINL CORP | $1,007,000 | – | 10,115 | +100.0% | 0.72% | – |
WFC | New | WELLS FARGO CO NEW | $1,004,000 | – | 16,557 | +100.0% | 0.72% | – |
MDT | New | MEDTRONIC PLC | $1,002,000 | – | 12,413 | +100.0% | 0.72% | – |
MLPX | New | GLOBAL X FDSglb x mlp enrg i | $999,000 | – | 73,560 | +100.0% | 0.72% | – |
PYPL | New | PAYPAL HLDGS INC | $976,000 | – | 13,264 | +100.0% | 0.70% | – |
DUK | New | DUKE ENERGY CORP NEW | $962,000 | – | 11,447 | +100.0% | 0.69% | – |
SHY | New | ISHARES TR1 3 yr treas bd | $939,000 | – | 11,206 | +100.0% | 0.67% | – |
SCZ | New | ISHARES TReafe sml cp etf | $935,000 | – | 14,510 | +100.0% | 0.67% | – |
BOND | New | PIMCO ETF TRactive bd etf | $901,000 | – | 8,504 | +100.0% | 0.64% | – |
CNA | New | CNA FINL CORP | $873,000 | – | 16,466 | +100.0% | 0.62% | – |
DBEF | New | DBX ETF TRxtrack msci eafe | $869,000 | – | 27,355 | +100.0% | 0.62% | – |
BRKB | New | BERKSHIRE HATHAWAY INC DELcl b new | $856,000 | – | 4,321 | +100.0% | 0.61% | – |
CNP | New | CENTERPOINT ENERGY INC | $844,000 | – | 29,795 | +100.0% | 0.60% | – |
IGSB | New | ISHARES TR1 3 yr cr bd etf | $840,000 | – | 8,037 | +100.0% | 0.60% | – |
SIX | New | SIX FLAGS ENTMT CORP NEW | $798,000 | – | 11,999 | +100.0% | 0.57% | – |
IEMG | New | ISHARES INCcore msci emkt | $792,000 | – | 13,920 | +100.0% | 0.57% | – |
PEP | New | PEPSICO INC | $774,000 | – | 6,461 | +100.0% | 0.55% | – |
D | New | DOMINION ENERGY INC | $766,000 | – | 9,456 | +100.0% | 0.55% | – |
STWD | New | STARWOOD PPTY TR INC | $766,000 | – | 35,919 | +100.0% | 0.55% | – |
CG | New | CARLYLE GROUP L P | $762,000 | – | 33,281 | +100.0% | 0.55% | – |
LMT | New | LOCKHEED MARTIN CORP | $756,000 | – | 2,357 | +100.0% | 0.54% | – |
VCSH | New | VANGUARD SCOTTSDALE FDSshrt trm corp bd | $751,000 | – | 9,474 | +100.0% | 0.54% | – |
GOOGL | New | ALPHABET INCcap stk cl a | $744,000 | – | 707 | +100.0% | 0.53% | – |
VGR | New | VECTOR GROUP LTD | $742,000 | – | 33,158 | +100.0% | 0.53% | – |
WRI | New | WEINGARTEN RLTY INVSsh ben int | $738,000 | – | 22,479 | +100.0% | 0.53% | – |
MCD | New | MCDONALDS CORP | $736,000 | – | 4,278 | +100.0% | 0.53% | – |
CTSH | New | COGNIZANT TECHNOLOGY SOLUTIOcl a | $723,000 | – | 10,189 | +100.0% | 0.52% | – |
MNST | New | MONSTER BEVERAGE CORP NEW | $720,000 | – | 11,390 | +100.0% | 0.52% | – |
MMP | New | MAGELLAN MIDSTREAM PRTNRS LP | $718,000 | – | 10,124 | +100.0% | 0.51% | – |
EEM | New | ISHARES TRmsci emg mkt etf | $713,000 | – | 15,145 | +100.0% | 0.51% | – |
DLR | New | DIGITAL RLTY TR INC | $709,000 | – | 6,226 | +100.0% | 0.51% | – |
CVS | New | CVS HEALTH CORP | $697,000 | – | 9,620 | +100.0% | 0.50% | – |
BLK | New | BLACKROCK INC | $692,000 | – | 1,348 | +100.0% | 0.50% | – |
ACN | New | ACCENTURE PLC IRELAND | $689,000 | – | 4,506 | +100.0% | 0.49% | – |
F | New | FORD MTR CO DEL | $687,000 | – | 55,009 | +100.0% | 0.49% | – |
EFAV | New | ISHARES TRmin vol eafe etf | $646,000 | – | 8,856 | +100.0% | 0.46% | – |
AVGO | New | BROADCOM LTD | $642,000 | – | 2,499 | +100.0% | 0.46% | – |
SCHE | New | SCHWAB STRATEGIC TRemrg mkteq etf | $633,000 | – | 22,679 | +100.0% | 0.45% | – |
MCK | New | MCKESSON CORP | $632,000 | – | 4,056 | +100.0% | 0.45% | – |
ADP | New | AUTOMATIC DATA PROCESSING IN | $631,000 | – | 5,387 | +100.0% | 0.45% | – |
LUMN | New | CENTURYLINK INC | $631,000 | – | 37,889 | +100.0% | 0.45% | – |
BIIB | New | BIOGEN INC | $621,000 | – | 1,952 | +100.0% | 0.44% | – |
YUM | New | YUM BRANDS INC | $612,000 | – | 7,505 | +100.0% | 0.44% | – |
AMGN | New | AMGEN INC | $609,000 | – | 3,506 | +100.0% | 0.44% | – |
UNP | New | UNION PAC CORP | $603,000 | – | 4,502 | +100.0% | 0.43% | – |
MRK | New | MERCK &CO INC | $602,000 | – | 10,706 | +100.0% | 0.43% | – |
TWX | New | TIME WARNER INC | $598,000 | – | 6,541 | +100.0% | 0.43% | – |
PPC | New | PILGRIMS PRIDE CORP NEW | $584,000 | – | 18,819 | +100.0% | 0.42% | – |
MON | New | MONSANTO CO NEW | $577,000 | – | 4,946 | +100.0% | 0.41% | – |
IWD | New | ISHARES TRrus 1000 val etf | $576,000 | – | 4,639 | +100.0% | 0.41% | – |
WPZ | New | WILLIAMS PARTNERS L P NEW | $573,000 | – | 14,792 | +100.0% | 0.41% | – |
PSX | New | PHILLIPS 66 | $564,000 | – | 5,576 | +100.0% | 0.40% | – |
IWF | New | ISHARES TRrus 1000 grw etf | $561,000 | – | 4,171 | +100.0% | 0.40% | – |
WAT | New | WATERS CORP | $549,000 | – | 2,842 | +100.0% | 0.39% | – |
APO | New | APOLLO GLOBAL MGMT LLC | $546,000 | – | 16,325 | +100.0% | 0.39% | – |
VGSH | New | VANGUARD SCOTTSDALE FDSshort term treas | $535,000 | – | 8,886 | +100.0% | 0.38% | – |
IJR | New | ISHARES TRcore s&p scp etf | $534,000 | – | 6,956 | +100.0% | 0.38% | – |
HYG | New | ISHARES TRiboxx hi yd etf | $534,000 | – | 6,129 | +100.0% | 0.38% | – |
FUN | New | CEDAR FAIR L Pdepositry unit | $525,000 | – | 8,092 | +100.0% | 0.38% | – |
IEFA | New | ISHARES TRcore msci eafe | $525,000 | – | 7,950 | +100.0% | 0.38% | – |
AEP | New | AMERICAN ELEC PWR INC | $506,000 | – | 6,883 | +100.0% | 0.36% | – |
EFA | New | ISHARES TRmsci eafe etf | $500,000 | – | 7,119 | +100.0% | 0.36% | – |
SYY | New | SYSCO CORP | $494,000 | – | 8,141 | +100.0% | 0.35% | – |
TRV | New | TRAVELERS COMPANIES INC | $483,000 | – | 3,568 | +100.0% | 0.35% | – |
FB | New | FACEBOOK INCcl a | $482,000 | – | 2,732 | +100.0% | 0.34% | – |
DHR | New | DANAHER CORP DEL | $471,000 | – | 5,081 | +100.0% | 0.34% | – |
QQQ | New | POWERSHARES QQQ TRUSTunit ser 1 | $471,000 | – | 3,028 | +100.0% | 0.34% | – |
SO | New | SOUTHERN CO | $463,000 | – | 9,638 | +100.0% | 0.33% | – |
MIC | New | MACQUARIE INFRASTRUCTURE COR | $449,000 | – | 6,998 | +100.0% | 0.32% | – |
IJT | New | ISHARES TRs&p sml 600 gwt | $444,000 | – | 2,612 | +100.0% | 0.32% | – |
SEP | New | SPECTRA ENERGY PARTNERS LP | $439,000 | – | 11,103 | +100.0% | 0.31% | – |
TUP | New | TUPPERWARE BRANDS CORP | $434,000 | – | 6,935 | +100.0% | 0.31% | – |
HYS | New | PIMCO ETF TR0-5 high yield | $434,000 | – | 4,328 | +100.0% | 0.31% | – |
AIG | New | AMERICAN INTL GROUP INC | $422,000 | – | 7,096 | +100.0% | 0.30% | – |
AZN | New | ASTRAZENECA PLCsponsored adr | $420,000 | – | 12,114 | +100.0% | 0.30% | – |
CMBS | New | ISHARES TRcmbs etf | $414,000 | – | 8,082 | +100.0% | 0.30% | – |
IJS | New | ISHARES TRsp smcp600vl etf | $408,000 | – | 2,661 | +100.0% | 0.29% | – |
SYK | New | STRYKER CORP | $403,000 | – | 2,609 | +100.0% | 0.29% | – |
IMCV | New | ISHARES TRmrgstr md cp val | $402,000 | – | 2,522 | +100.0% | 0.29% | – |
IYW | New | ISHARES TRu.s. tech etf | $401,000 | – | 2,466 | +100.0% | 0.29% | – |
CMCSA | New | COMCAST CORP NEWcl a | $399,000 | – | 9,969 | +100.0% | 0.29% | – |
WMT | New | WAL-MART STORES INC | $400,000 | – | 4,053 | +100.0% | 0.29% | – |
AMAT | New | APPLIED MATLS INC | $389,000 | – | 7,626 | +100.0% | 0.28% | – |
NUS | New | NU SKIN ENTERPRISES INCcl a | $387,000 | – | 5,674 | +100.0% | 0.28% | – |
ECL | New | ECOLAB INC | $387,000 | – | 2,890 | +100.0% | 0.28% | – |
IYC | New | ISHARES TRu.s. cnsm sv etf | $382,000 | – | 2,136 | +100.0% | 0.27% | – |
CRM | New | SALESFORCE COM INC | $379,000 | – | 3,709 | +100.0% | 0.27% | – |
VNQ | New | VANGUARD INDEX FDSreit etf | $375,000 | – | 4,526 | +100.0% | 0.27% | – |
IJK | New | ISHARES TRs&p mc 400gr etf | $376,000 | – | 1,745 | +100.0% | 0.27% | – |
DGS | New | WISDOMTREE TRemg mkts smcap | $370,000 | – | 7,098 | +100.0% | 0.26% | – |
TPR | New | TAPESTRY INC | $368,000 | – | 8,326 | +100.0% | 0.26% | – |
IYF | New | ISHARES TRu.s. finls etf | $369,000 | – | 3,097 | +100.0% | 0.26% | – |
IYH | New | ISHARES TRus hlthcare etf | $361,000 | – | 2,073 | +100.0% | 0.26% | – |
VLO | New | VALERO ENERGY CORP NEW | $360,000 | – | 3,924 | +100.0% | 0.26% | – |
BA | New | BOEING CO | $356,000 | – | 1,208 | +100.0% | 0.26% | – |
IWM | New | ISHARES TRrussell 2000 etf | $348,000 | – | 2,286 | +100.0% | 0.25% | – |
CLX | New | CLOROX CO DEL | $347,000 | – | 2,334 | +100.0% | 0.25% | – |
IVV | New | ISHARES TRcore s&p500 etf | $344,000 | – | 1,281 | +100.0% | 0.25% | – |
TWO | New | TWO HBRS INVT CORP | $340,000 | – | 20,951 | +100.0% | 0.24% | – |
SCHV | New | SCHWAB STRATEGIC TRus lcap va etf | $334,000 | – | 6,115 | +100.0% | 0.24% | – |
DIS | New | DISNEY WALT CO | $332,000 | – | 3,090 | +100.0% | 0.24% | – |
BKLN | New | POWERSHARES ETF TRUST IIsenior ln port | $331,000 | – | 14,409 | +100.0% | 0.24% | – |
BNDX | New | VANGUARD CHARLOTTE FDSintl bd idx etf | $330,000 | – | 6,086 | +100.0% | 0.24% | – |
GE | New | GENERAL ELECTRIC CO | $325,000 | – | 18,677 | +100.0% | 0.23% | – |
IYK | New | ISHARES TRu.s. cnsm gd etf | $320,000 | – | 2,530 | +100.0% | 0.23% | – |
ORI | New | OLD REP INTL CORP | $317,000 | – | 14,845 | +100.0% | 0.23% | – |
MLM | New | MARTIN MARIETTA MATLS INC | $307,000 | – | 1,389 | +100.0% | 0.22% | – |
ORCL | New | ORACLE CORP | $292,000 | – | 6,177 | +100.0% | 0.21% | – |
MDY | New | SPDR S&P MIDCAP 400 ETF TRutser1 s&pdcrp | $291,000 | – | 845 | +100.0% | 0.21% | – |
NEE | New | NEXTERA ENERGY INC | $289,000 | – | 1,853 | +100.0% | 0.21% | – |
QCOM | New | QUALCOMM INC | $289,000 | – | 4,516 | +100.0% | 0.21% | – |
CL | New | COLGATE PALMOLIVE CO | $280,000 | – | 3,715 | +100.0% | 0.20% | – |
MMM | New | 3M CO | $279,000 | – | 1,189 | +100.0% | 0.20% | – |
BTI | New | BRITISH AMERN TOB PLCsponsored adr | $278,000 | – | 4,155 | +100.0% | 0.20% | – |
MCHP | New | MICROCHIP TECHNOLOGY INC | $275,000 | – | 3,133 | +100.0% | 0.20% | – |
GSK | New | GLAXOSMITHKLINE PLCsponsored adr | $267,000 | – | 7,536 | +100.0% | 0.19% | – |
APU | New | AMERIGAS PARTNERS L Punit l p int | $264,000 | – | 5,720 | +100.0% | 0.19% | – |
AMJ | New | JPMORGAN CHASE &COalerian ml etn | $263,000 | – | 9,581 | +100.0% | 0.19% | – |
XEL | New | XCEL ENERGY INC | $258,000 | – | 5,364 | +100.0% | 0.18% | – |
FNDC | New | SCHWAB STRATEGIC TRschwb fdt int sc | $258,000 | – | 7,191 | +100.0% | 0.18% | – |
GIS | New | GENERAL MLS INC | $257,000 | – | 4,350 | +100.0% | 0.18% | – |
COP | New | CONOCOPHILLIPS | $255,000 | – | 4,650 | +100.0% | 0.18% | – |
DIM | New | WISDOMTREE TRintl midcap dv | $254,000 | – | 3,685 | +100.0% | 0.18% | – |
WOOD | New | ISHARES TRgl timb fore etf | $249,000 | – | 3,510 | +100.0% | 0.18% | – |
AGG | New | ISHARES TRcore us aggbd et | $249,000 | – | 2,286 | +100.0% | 0.18% | – |
GLW | New | CORNING INC | $247,000 | – | 7,725 | +100.0% | 0.18% | – |
BBL | New | BHP BILLITON PLCsponsored adr | $246,000 | – | 6,117 | +100.0% | 0.18% | – |
IYE | New | ISHARES TRu.s. energy etf | $238,000 | – | 6,007 | +100.0% | 0.17% | – |
IBM | New | INTERNATIONAL BUSINESS MACHS | $234,000 | – | 1,529 | +100.0% | 0.17% | – |
BMY | New | BRISTOL MYERS SQUIBB CO | $235,000 | – | 3,837 | +100.0% | 0.17% | – |
NKE | New | NIKE INCcl b | $231,000 | – | 3,702 | +100.0% | 0.16% | – |
EA | New | ELECTRONIC ARTS INC | $224,000 | – | 2,141 | +100.0% | 0.16% | – |
MO | New | ALTRIA GROUP INC | $218,000 | – | 3,065 | +100.0% | 0.16% | – |
UL | New | UNILEVER PLCspon adr new | $218,000 | – | 3,950 | +100.0% | 0.16% | – |
ESRX | New | EXPRESS SCRIPTS HLDG CO | $216,000 | – | 2,896 | +100.0% | 0.16% | – |
TROW | New | PRICE T ROWE GROUP INC | $207,000 | – | 1,982 | +100.0% | 0.15% | – |
BCE | New | BCE INC | $206,000 | – | 4,296 | +100.0% | 0.15% | – |
AXP | New | AMERICAN EXPRESS CO | $204,000 | – | 2,057 | +100.0% | 0.15% | – |
PPL | New | PPL CORP | $203,000 | – | 6,580 | +100.0% | 0.14% | – |
BKR | New | BAKER HUGHES A GE COcl a | $200,000 | – | 6,321 | +100.0% | 0.14% | – |
MUI | New | BLACKROCK MUNI INTER DR FD I | $187,000 | – | 13,500 | +100.0% | 0.13% | – |
MAT | New | MATTEL INC | $185,000 | – | 12,047 | +100.0% | 0.13% | – |
AES | New | AES CORP | $179,000 | – | 16,615 | +100.0% | 0.13% | – |
NLY | New | ANNALY CAP MGMT INC | $158,000 | – | 13,363 | +100.0% | 0.11% | – |
FMN | New | FEDERATED PREM MUN INC FD | $150,000 | – | 10,688 | +100.0% | 0.11% | – |
CYS | New | CYS INVTS INC | $117,000 | – | 14,661 | +100.0% | 0.08% | – |
NHA | New | NUVEEN MUN 2021 TARGET TERM | $94,000 | – | 10,000 | +100.0% | 0.07% | – |
NAVB | New | NAVIDEA BIOPHARMACEUTICALS I | $11,000 | – | 32,500 | +100.0% | 0.01% | – |
Original filings
The following EDGAR filing(s) were analyzed to create this report:
- View 13F-HR filed 2018-03-16
Top long-term holdings
Name | Quarters owned | Latest quarter owned | Max weighting |
---|---|---|---|
POWERSHARES ETF TR II | 1 | Q4 2017 | 4.3% |
ISHARES TR | 1 | Q4 2017 | 4.0% |
APPLE INC | 1 | Q4 2017 | 2.3% |
JOHNSON &JOHNSON | 1 | Q4 2017 | 2.0% |
JPMORGAN CHASE &CO | 1 | Q4 2017 | 1.9% |
VANGUARD SPECIALIZED FUNDS | 1 | Q4 2017 | 1.8% |
SPDR S&P 500 ETF TR | 1 | Q4 2017 | 1.6% |
EXXON MOBIL CORP | 1 | Q4 2017 | 1.5% |
PFIZER INC | 1 | Q4 2017 | 1.4% |
ANALOG DEVICES INC | 1 | Q4 2017 | 1.4% |
View AURORA FINANCIAL ADVISORS, LLC's complete holdings history.
Latest filings
Type | Filed |
---|---|
13F-HR | 2018-03-16 |
View AURORA FINANCIAL ADVISORS, LLC's complete filings history.
All filings
- Holdings (13F-HR)
- Significant ownership (13-D/G)
- Insider transactions (4, 5, 6)
- Events (8-K)
- Shareholder votes (proxy)
View complete filings history.