Skip to content

13F-HR filed by ASPIRIANT, LLC

ASPIRIANT, LLC filed this 13F-HR for the quarter ended 2017-06-30, filed 2017-08-03, with 210 holding rows worth $1,149,756,000.

Accession
0001172661-17-001468
Filed
2017-08-03
Accepted by EDGAR
acceptance time not in the bulk data set
Ingested
Source
SEC quarterly data set

Original filing

13F report for Q2 2017

A holdings report, 210 entries on the cover page, a total value of $1,149,756,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $1,149,756,000 with VALUE read as thousands by filing date, 13F file number 028-13064. The quarter's positions are built on this report. The resolved quarter.

The information table after summing rows of one CUSIP and put or call (H4), with the CUSIP and issuer name as filed. Values in dollars after the unit check (method).

Issuer as filedCUSIPClassAmountValueValue read asType
ISHARES INC464286525MSCI GBL MIN VOL1,350,406$106,817,000thousands by filing date
UBS Alerian MLP/ MLPI902641646TR UNIT3,990,571$106,389,000thousands by filing date
iShares Core S&P U.S. Value ETF464287663SHS1,387,911$70,700,000thousands by filing date
Vanguard S&P 500 ETF922908363COM192,570$42,762,000thousands by filing date
Vanguard Dividend Appreciation ETF921908844SHS432,155$40,048,000thousands by filing date
Vanguard Real Estate922908553SHS470,845$39,188,000thousands by filing date
ISHARES TR464287739U.S. REAL ES ETF469,490$37,451,000thousands by filing date
ISHARES TR CORE S&P 500 ETF464287200SHS152,680$37,164,000thousands by filing date
VANGUARD INTL EQUITY INDEX F922042676COM628,503$35,353,000thousands by filing date
Vanguard FTSE Developed Markets ETF921943858SHS819,161$33,848,000thousands by filing date
SPY78462F103SHS119,271$28,840,000thousands by filing date
iShares Core MSCI Emerging Markets ETF46434G103SHS474,175$23,728,000thousands by filing date
Vanguard Total Bond Market ETF921937835SHS287,999$23,567,000thousands by filing date
ISHARES TR464288257MSCI ACWI ETF330,059$21,616,000thousands by filing date
Vanguard FTSE All-World ex-US ETF922042775SHS418,771$20,951,000thousands by filing date
Berkshire Hathaway Inc084670702COM123,413$20,902,000thousands by filing date
Apple Inc037833100COM140,441$20,226,000thousands by filing date
SPDR INDEX SHS FDS78463X863ST DOW INTL ETF511,433$19,486,000thousands by filing date
ISHARES RUSSELL 1000 ETF464287622ETF135,942$18,389,000thousands by filing date
VANGUARD SCOTTSDALE FDS92206C409COM229,359$18,358,000thousands by filing date
Financial Select Sector SPDR Fund81369Y605SHS690,324$17,030,000thousands by filing date
ISHARES INC464286533MSCI EMERG MRKT236,240$13,088,000thousands by filing date
iShares Russell 2000 ETF464287655SHS86,432$12,180,000thousands by filing date
Schwab U.S. Large-Cap ETF808524201SHS197,194$11,392,000thousands by filing date
META PLATFORMS INC CL A30303M102COM66,948$10,108,000thousands by filing date
Schwab US Mid-Cap ETF808524508SHS204,869$9,866,000thousands by filing date
Schwab US TIPS ETF808524870SHS176,415$9,713,000thousands by filing date
CINCINNATI FINL CORP COM172062101Stock123,217$8,927,000thousands by filing date
ISHARES RUSSELL 1000 VALUE ETF464287598ETF76,446$8,901,000thousands by filing date
iShares Core MSCI EAFE ETF46432F842SHS145,869$8,882,000thousands by filing date
ISHARES TR464287234MSCI EMG MKT ETF209,671$8,678,000thousands by filing date
VWO922042858SHS207,961$8,491,000thousands by filing date
ISHARES TR464287465MSCI EAFE ETF125,508$8,183,000thousands by filing date
Procter & Gamble Co742718109COM78,707$6,859,000thousands by filing date
Johnson & Johnson478160104COM51,035$6,751,000thousands by filing date
ROYAL BK CDA COM780087102Stock80,500$5,838,000thousands by filing date
Vanguard Intermediate-Term Corporate Bond ETF92206C870SHS64,933$5,684,000thousands by filing date
Alphabet Inc. Reg. Shares A02079K305COM5,914$5,498,000thousands by filing date
USBANCORPDEL902973304COM NEW105,628$5,484,000thousands by filing date
JPMorgan Chase & Co46625H100COM56,423$5,157,000thousands by filing date
SCHWAB STRATEGIC TR808524839US AGGREGATE B95,848$5,008,000thousands by filing date
Vanguard Short-Term Bond ETF921937827SHS57,893$4,623,000thousands by filing date
PepsiCo,Inc.713448108COM39,942$4,613,000thousands by filing date
Wells Fargo & Company949746101COM78,224$4,334,000thousands by filing date
iShares Russell Midcap ETF464287499SHS22,503$4,323,000thousands by filing date
Chevron Corporation166764100COM41,210$4,299,000thousands by filing date
UBS AG LONDON BRH90267B682ETRAC ALER MLP216,026$4,048,000thousands by filing date
ISHARES TR464287689RUSSELL 3000 ETF27,278$3,929,000thousands by filing date
ISHARES TR464288489INTL DEV RE ETF135,954$3,872,000thousands by filing date
Walt Disney Co254687106COM33,960$3,608,000thousands by filing date
Union Pacific Corporation907818108COM31,861$3,470,000thousands by filing date
RAYTHEON CO755111507COM NEW21,267$3,434,000thousands by filing date
VANGUARD MALVERN FDS922020805SHS68,440$3,369,000thousands by filing date
SSGA ACTIVE ETF TR78467V848ST STR TOTAL ETF67,926$3,343,000thousands by filing date
Comcast Corp20030N101COM83,018$3,231,000thousands by filing date
Microsoft Corp594918104COM46,355$3,195,000thousands by filing date
3M CO COM88579Y101Stock15,097$3,143,000thousands by filing date
VGT92204A702SHS22,026$3,102,000thousands by filing date
Verizon Communications Inc92343V104COM68,573$3,062,000thousands by filing date
Home Depot, Inc437076102COM19,485$2,989,000thousands by filing date
SCHWAB STRATEGIC TR808524706EMRG MKTEQ ETF114,784$2,852,000thousands by filing date
iShares MSCI USA Min Vol Factor ETF46429B697SHS55,858$2,733,000thousands by filing date
TJX Companies Inc872540109COM37,623$2,715,000thousands by filing date
Charles Schwab Corp808513105COM63,083$2,710,000thousands by filing date
GENERAL ELEC CO369604103COM97,773$2,627,000thousands by filing date
ISHARES MSCI EAFE MIN VOL FACTOR ETF46429B689ETF37,289$2,582,000thousands by filing date
Qualcomm Incorporated747525103COM44,478$2,456,000thousands by filing date
VANECK ETF TRUST92189F726BIOTECH ETF19,508$2,451,000thousands by filing date
ISHARES TR464288414NATIONAL MUN ETF22,047$2,428,000thousands by filing date
CVS Health Corporation126650100COM29,445$2,369,000thousands by filing date
Vanguard Materials ETF92204A801SHS19,342$2,352,000thousands by filing date
Danaher Corporation235851102COM27,597$2,329,000thousands by filing date
ISHARES TR464287630RUS 2000 VAL ETF18,748$2,229,000thousands by filing date
Abbott Laboratories002824100COM45,689$2,221,000thousands by filing date
TWILIO INC CL A90138F102Stock73,769$2,147,000thousands by filing date
VTI922908769COM17,012$2,117,000thousands by filing date
EXXON MOBIL CORP30231G102COM25,665$2,072,000thousands by filing date
JP MORGAN CHASE & CO46625H365EXCHANGE TRADED69,321$2,059,000thousands by filing date
BERKSHIRE HATHAWAY INC DEL084670108CL A9$2,038,000thousands by filing date
ISHARESRUSSELL1000GROWTHETF464287614STOK16,534$1,968,000thousands by filing date
NextEra Energy,Inc.65339F101COM13,902$1,948,000thousands by filing date
ENBRIDGE INC COM29250N105Stock43,255$1,722,000thousands by filing date
AT&T Inc00206R102COM45,075$1,701,000thousands by filing date
Cisco Systems,Inc.17275R102COM53,270$1,667,000thousands by filing date
iShares MSCI EAFE Value ETF464288877SHS31,724$1,640,000thousands by filing date
Costco Wholesale Corporation22160K105COM9,708$1,553,000thousands by filing date
Intel Corp458140100COM46,012$1,552,000thousands by filing date
SPDR INDEX SHS FDS78463X871ST INTL CAP ETF46,137$1,539,000thousands by filing date
SCHWAB STRATEGIC TR808524888INTL SCEQT ETF44,668$1,502,000thousands by filing date
International Business Machines Corporation459200101COM9,672$1,488,000thousands by filing date
ALLERGAN PLCG0177J108SHS5,885$1,431,000thousands by filing date
EOG RES INC COM26875P101Stock15,492$1,402,000thousands by filing date
Merck & Co.,Inc.58933Y105COM21,636$1,387,000thousands by filing date
SPDR INDEX SHS FDS78463X426ST STR MSCI EM23,638$1,376,000thousands by filing date
VANGUARD INDEX FDS922908637LARGE CAP ETF12,315$1,367,000thousands by filing date
CELGENE CORP151020104COM10,504$1,364,000thousands by filing date
Coca-Cola Company191216100COM29,799$1,336,000thousands by filing date
Pfizer Inc.717081103COM38,427$1,291,000thousands by filing date
Alphabet Inc. Reg. Shares C02079K107COM1,417$1,288,000thousands by filing date
RYDEX GUGGENHEIM78355W833GUG S&P500 EQ WT11,733$1,268,000thousands by filing date
WELLS FARGO & CO949746804PERP PFD CNV A925$1,213,000thousands by filing date
Schlumberger Limited806857108COM18,377$1,210,000thousands by filing date
Vanguard Mega Cap Growth ETF921910816SHS11,575$1,158,000thousands by filing date
iShares S&P 500 Value ETF464287408SHS10,827$1,136,000thousands by filing date
Philip Morris International Inc.718172109COM9,263$1,088,000thousands by filing date
NIKE,Inc. Class B654106103COM18,425$1,087,000thousands by filing date
PAYPALHLDGSINC70450Y103STOK19,755$1,060,000thousands by filing date
TORONTO DOMINION BK ONT COM NEW891160509Stock20,962$1,056,000thousands by filing date
Energy Select Sector SPDR Fund81369Y506SHS15,706$1,020,000thousands by filing date
REALTY INCOME CORP COM756109104REIT18,387$1,015,000thousands by filing date
MONSANTO CO NEW61166W101COM8,532$1,010,000thousands by filing date
WENDYS CO COM95058W100Stock64,196$996,000thousands by filing date
United Parcel Service,Inc. Class B911312106COM8,900$984,000thousands by filing date
Duke Energy Corporation26441C204COM11,592$969,000thousands by filing date
EMERSON ELEC CO COM291011104Stock16,251$969,000thousands by filing date
Bristol-Myers Squibb Company110122108COM17,308$964,000thousands by filing date
Oracle Corporation68389X105COM18,172$911,000thousands by filing date
iShares Core US Aggregate Bond ETF464287226SHS8,306$910,000thousands by filing date
NOVARTIS AG SPONSORED ADR66987V109ADR10,391$867,000thousands by filing date
EXPRESS SCRIPTS HLDG CO30219G108COM13,002$830,000thousands by filing date
AMERICAN ELEC PWR CO INC COM025537101Stock11,912$828,000thousands by filing date
Vanguard Value ETF922908744SHS8,298$801,000thousands by filing date
Amgen Inc.031162100COM4,602$793,000thousands by filing date
AARONS INC002535300COM PAR $0.5020,393$793,000thousands by filing date
TABLEAU SOFTWARE INC87336U105CL A12,913$791,000thousands by filing date
SCANA CORP NEW80589M102COM11,703$784,000thousands by filing date
iShares Core S&P Small-Cap ETF464287804SHS10,170$713,000thousands by filing date
PRAXAIR INC74005P104COM5,310$704,000thousands by filing date
ISHARES TR464287374NORTH AMERN NAT21,982$696,000thousands by filing date
SPDR GOLD TR78463V107GOLD SHS5,863$692,000thousands by filing date
HD SUPPLY HLDGS INC40416M105COM22,000$674,000thousands by filing date
Amazon.com, Inc023135106COM695$673,000thousands by filing date
BOX INC CL A10316T104Stock35,356$645,000thousands by filing date
GENUINE PARTS CO COM372460105Stock6,627$615,000thousands by filing date
PRICE T ROWE GROUP INC COM74144T108Stock8,095$601,000thousands by filing date
Southern Company842587107COM12,381$593,000thousands by filing date
MasterCard, Inc57636Q104COM4,620$561,000thousands by filing date
BED BATH & BEYOND INC075896100COM18,250$555,000thousands by filing date
V F CORP COM918204108Stock9,547$550,000thousands by filing date
POLARIS INC COM731068102Stock5,940$548,000thousands by filing date
MARATHON PETE CORP COM56585A102Stock10,300$539,000thousands by filing date
CURRENCYSHS BRIT POUND STER23129S106BRIT POUND STE4,089$519,000thousands by filing date
DBX ETF TR233051853XTRACK MSCI EURP18,740$513,000thousands by filing date
EVERPURE INC CL A74624M102Stock38,748$496,000thousands by filing date
Vanguard Small-Cap ETF922908751SHS3,628$492,000thousands by filing date
Bank of America Corp060505104COM19,922$483,000thousands by filing date
Altria Group Inc02209S103COM6,002$447,000thousands by filing date
Vanguard Small-Cap Growth ETF922908595SHS3,036$442,000thousands by filing date
POWERSHARES ETF TR II S&P500 L73937B779COM9,636$431,000thousands by filing date
ISHARES RUSSELL MID-CAP GROWTH ETF464287481ETF3,925$424,000thousands by filing date
BANK OF NY MELLON CORP COM064058100Stock8,290$423,000thousands by filing date
PAYCHEX INC704326107COM7,338$418,000thousands by filing date
Boeing Company097023105COM2,100$415,000thousands by filing date
SPDR SERIES TRUST78464A284NUVEEN ICE HIGH7,167$407,000thousands by filing date
UnitedHealth Group Inc91324P102COM2,180$404,000thousands by filing date
ISHARES TR464288513IBOXX HI YD ETF4,513$399,000thousands by filing date
Starbucks Corporation855244109COM6,652$388,000thousands by filing date
PowerShares QQQ Trust Unit Ser73935A104COM2,694$371,000thousands by filing date
iShares Emerging Markets Dividend ETF464286319SHS9,191$369,000thousands by filing date
Adobe Inc00724F101COM2,554$361,000thousands by filing date
SCHWAB STRATEGIC TR808524409US LCAP VA ETF7,168$360,000thousands by filing date
McDonalds Corporation580135101COM2,347$359,000thousands by filing date
CLOROX CO DEL189054109COM2,675$356,000thousands by filing date
WISDOMTREE EUROPE HEDGED EQUITY FUND97717X701ETF5,451$340,000thousands by filing date
Vanguard Consumer Staples ETF92204A207SHS2,348$331,000thousands by filing date
CARDINAL HEALTH INC14149Y108COM4,223$329,000thousands by filing date
VAREX IMAGING CORP92214X106COMMON STOCK9,610$325,000thousands by filing date
RYDEX ETF TRUST HEALTH CARE78355W841COM1,859$323,000thousands by filing date
AbbVie,Inc.00287Y109COM4,446$322,000thousands by filing date
ISHARES TR464287168COM3,280$302,000thousands by filing date
ISHARES TR464287564SELECT US REIT2,967$300,000thousands by filing date
Vanguard FTSE Pacific ETF922042866SHS4,500$296,000thousands by filing date
NEW YORK LIFE INVESTMENTS ET45409B107NYLI HEDGE MULTI9,827$289,000thousands by filing date
Visa Inc92826C839COM3,059$287,000thousands by filing date
BECTON DICKINSON & CO075887109COM1,470$287,000thousands by filing date
American Tower Corporation03027X100COM2,163$286,000thousands by filing date
Gilead Sciences,Inc.375558103COM3,894$276,000thousands by filing date
ILLUMINA INC452327109COM1,585$275,000thousands by filing date
DTE ENERGY CO233331883UNIT 99/99/99995,000$274,000thousands by filing date
SPDR S&P Dividend ETF78464A763SHS3,019$268,000thousands by filing date
NUVEEN CA DIVI ADV MUN67066Y105COM17,556$264,000thousands by filing date
SEMPRA COM816851109Stock2,321$262,000thousands by filing date
EVERSOURCE ENERGY COM30040W108Stock4,291$261,000thousands by filing date
STERICYCLE INC858912207DEP PFD A 1/103,900$261,000thousands by filing date
Accenture Plc Class AG1151C101COM2,083$258,000thousands by filing date
NVIDIA Corp67066G104COM1,773$256,000thousands by filing date
ISHARES MSCI EAFE GROWTH ETF464288885ETF3,300$244,000thousands by filing date
MARATHON OIL CORP565849106COM20,083$238,000thousands by filing date
ISHARES TR464288687COM5,955$233,000thousands by filing date
OCCIDENTAL PETE CORP674599105COM3,750$225,000thousands by filing date
American Express Company025816109COM2,637$222,000thousands by filing date
iShares S&P 500 Growth ETF464287309SHS1,620$222,000thousands by filing date
WALGREENS BOOTS ALLIANCE INC931427108COM2,811$220,000thousands by filing date
TOYOTA MOTOR CORP ADS892331307ADR2,040$214,000thousands by filing date
PUBLIC STORAGE COM74460D109REIT1,014$211,000thousands by filing date
CONSOLIDATED EDISON INC209115104COM2,601$210,000thousands by filing date
Invesco S&P 500 Pure Growth78355W403GUG S&P500 PU GR2,198$207,000thousands by filing date
CAPITAL ONE FINL CORP14040H105COM2,479$205,000thousands by filing date
iShares iBoxx Inv Grade Corporate Bond ETF464287242SHS1,701$205,000thousands by filing date
WORKDAY INC CL A98138H101Stock2,101$204,000thousands by filing date
KRAFT HEINZ CO COM500754106Stock2,363$202,000thousands by filing date
Vanguard Utilities ETF92204A876SHS1,756$201,000thousands by filing date
FULL HSE RESORTS INC359678109COM77,600$192,000thousands by filing date
GLOBAL X FDS37950E226GLB X MLP ENRG I13,025$180,000thousands by filing date
HUNTINGTON BANCSHARES INC COM446150104Stock11,425$154,000thousands by filing date
FORD MTR CO COM345370860Stock11,131$125,000thousands by filing date
UNITED SEC BANCSHARES CALIF911460103COM12,480$115,000thousands by filing date
GOLDMAN SACHS MLP INC OPP FD38147W103COM SHS10,590$102,000thousands by filing date
INTERMOLECULAR INC45882D109COM67,246$61,000thousands by filing date
SUPPORT COM INC86858W200COM NEW20,649$48,000thousands by filing date

Amendment chain

FilingRoleFiledAcceptedIngested
13F-HR 0001172661-17-001468this filing2017-08-03acceptance time not in the bulk data set