13F-HR filed by ASPIRIANT, LLC
ASPIRIANT, LLC filed this 13F-HR for the quarter ended 2020-06-30, filed 2020-08-06, with 182 holding rows worth $1,076,874,000.
- Accession
- 0001172661-20-001593
- Filer
- CIK 1433541
- Filed
- 2020-08-06
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2020
A holdings report, 182 entries on the cover page, a total value of $1,076,874,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $1,076,874,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 filed | CUSIP | Class | Amount | Value | Value read as | Type |
|---|---|---|---|---|---|---|
| ISHARES INC | 464286525 | MSCI GBL MIN VOL | 2,589,281 | $226,774,000 | thousands by filing date | |
| iShares Core S&P U.S. Value ETF | 464287663 | SHS | 1,142,891 | $59,694,000 | thousands by filing date | |
| Vanguard Dividend Appreciation ETF | 921908844 | SHS | 499,435 | $58,523,000 | thousands by filing date | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 496,142 | $57,251,000 | thousands by filing date | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 576,762 | $50,958,000 | thousands by filing date | |
| iShares MSCI EAFE Value ETF | 464288877 | SHS | 1,178,268 | $47,092,000 | thousands by filing date | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 987,194 | $46,991,000 | thousands by filing date | |
| Vanguard Small-Cap Value ETF | 922908611 | SHS | 409,271 | $43,746,000 | thousands by filing date | |
| Vanguard S&P 500 ETF | 922908363 | COM | 150,073 | $42,536,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W315 | EMER MKT HIGH FD | 1,100,423 | $39,756,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 88,398 | $32,260,000 | thousands by filing date | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 89,423 | $27,695,000 | thousands by filing date | |
| SPY | 78462F103 | SHS | 67,412 | $20,788,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 ETF | 464287622 | ETF | 88,108 | $15,128,000 | thousands by filing date | |
| NEW YORK LIFE INVESTMENTS ET | 45409B107 | NYLI HEDGE MULTI | 488,390 | $14,806,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 73,126 | $13,054,000 | thousands by filing date | |
| Vanguard FTSE All-World ex-US ETF | 922042775 | SHS | 261,190 | $12,434,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 49,572 | $11,257,000 | thousands by filing date | |
| ISHARES TR | 464287630 | RUS 2000 VAL ETF | 107,879 | $10,513,000 | thousands by filing date | |
| Financial Select Sector SPDR Fund | 81369Y605 | SHS | 421,080 | $9,744,000 | thousands by filing date | |
| iShares MSCI USA Min Vol Factor ETF | 46429B697 | SHS | 145,979 | $8,852,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 43,261 | $8,803,000 | thousands by filing date | |
| ISHARES TR | 464289875 | CORE 40 MODE ETF | 200,913 | $8,010,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 55,100 | $7,886,000 | thousands by filing date | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 65,102 | $7,695,000 | thousands by filing date | |
| VTI | 922908769 | COM | 46,019 | $7,205,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 4,223 | $5,988,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 VALUE ETF | 464287598 | ETF | 48,729 | $5,487,000 | thousands by filing date | |
| ISHARES MSCI EAFE MIN VOL FACTOR ETF | 46429B689 | ETF | 80,266 | $5,301,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 131,025 | $5,189,000 | thousands by filing date | |
| VANGUARD TAX-EXEMPT BOND ETF | 922907746 | ETF | 88,966 | $4,816,000 | thousands by filing date | |
| BILL HOLDINGS INC | 090043100 | COM | 48,809 | $4,403,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 108,419 | $4,339,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 52,702 | $4,133,000 | thousands by filing date | |
| VGT | 92204A702 | SHS | 14,778 | $4,122,000 | thousands by filing date | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 103,163 | $4,002,000 | thousands by filing date | |
| ISHARES TR | 464287689 | RUSSELL 3000 ETF | 21,731 | $3,914,000 | thousands by filing date | |
| Schwab U.S. Large-Cap ETF | 808524201 | SHS | 49,326 | $3,656,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 24,796 | $3,487,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C409 | COM | 41,360 | $3,420,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 2,147 | $3,037,000 | thousands by filing date | |
| ISHARES TR | 464287846 | DOW JONES US ETF | 18,874 | $2,889,000 | thousands by filing date | |
| DOCUSIGN INC COM | 256163106 | Stock | 16,739 | $2,883,000 | thousands by filing date | |
| ISHARES MSCI EAFE SMALL-CAP ETF | 464288273 | ETF | 53,003 | $2,839,000 | thousands by filing date | |
| PepsiCo,Inc. | 713448108 | COM | 20,540 | $2,716,000 | thousands by filing date | |
| VANGUARD INTL EQUITY INDEX F | 922042676 | COM | 57,456 | $2,683,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 22,429 | $2,682,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 40,885 | $2,492,000 | thousands by filing date | |
| ISHARES INC | 464286533 | MSCI EMERG MRKT | 45,893 | $2,382,000 | thousands by filing date | |
| ROYAL BK CDA COM | 780087102 | Stock | 34,467 | $2,337,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 838 | $2,311,000 | thousands by filing date | |
| JPMorgan Chase & Co | 46625H100 | COM | 22,690 | $2,138,000 | thousands by filing date | |
| Salesforce.com, Inc | 79466L302 | COM | 11,279 | $2,112,000 | thousands by filing date | |
| iShares Russell Midcap ETF | 464287499 | SHS | 38,607 | $2,069,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 18,514 | $2,063,000 | thousands by filing date | |
| Vanguard Intermediate-Term Corporate Bond ETF | 92206C870 | SHS | 20,548 | $1,955,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 20,702 | $1,887,000 | thousands by filing date | |
| VanEck High Yield Muni ETF | 92189H409 | SHS | 31,659 | $1,876,000 | thousands by filing date | |
| BERKSHIRE HATHAWAY INC DEL | 084670108 | CL A | 7 | $1,871,000 | thousands by filing date | |
| iShares Short Treasury Bond ETF | 464288679 | SHS | 15,158 | $1,678,000 | thousands by filing date | |
| Vanguard Value ETF | 922908744 | SHS | 16,339 | $1,626,000 | thousands by filing date | |
| TJX Companies Inc | 872540109 | COM | 31,979 | $1,625,000 | thousands by filing date | |
| Union Pacific Corporation | 907818108 | COM | 9,326 | $1,574,000 | thousands by filing date | |
| Danaher Corporation | 235851102 | COM | 8,406 | $1,484,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 9,965 | $1,453,000 | thousands by filing date | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 7,361 | $1,413,000 | thousands by filing date | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 24,096 | $1,376,000 | thousands by filing date | |
| ALIGN TECHNOLOGY INC COM | 016255101 | Stock | 4,906 | $1,346,000 | thousands by filing date | |
| Qualcomm Incorporated | 747525103 | COM | 14,026 | $1,280,000 | thousands by filing date | |
| SPDR SER TR | 78464A359 | BBG CONV SEC ETF | 21,052 | $1,274,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 13,144 | $1,173,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 31,658 | $1,166,000 | thousands by filing date | |
| ELASTIC N V ORD SHS | N14506104 | Stock | 12,251 | $1,131,000 | thousands by filing date | |
| Schwab US Mid-Cap ETF | 808524508 | SHS | 21,375 | $1,125,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 18,621 | $1,115,000 | thousands by filing date | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 7,460 | $1,066,000 | thousands by filing date | |
| Adobe Inc | 00724F101 | COM | 2,443 | $1,063,000 | thousands by filing date | |
| BOX INC CL A | 10316T104 | Stock | 49,358 | $1,024,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 18,526 | $1,020,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524839 | US AGGREGATE B | 18,008 | $1,014,000 | thousands by filing date | |
| Cisco Systems,Inc. | 17275R102 | COM | 21,655 | $1,011,000 | thousands by filing date | |
| 3M CO COM | 88579Y101 | Stock | 6,461 | $1,009,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 12,742 | $983,000 | thousands by filing date | |
| Comcast Corp | 20030N101 | COM | 24,569 | $958,000 | thousands by filing date | |
| Charles Schwab Corp | 808513105 | COM | 28,133 | $952,000 | thousands by filing date | |
| SPDR S&P Midcap 400 ETF Trust | 78467Y107 | SHS | 2,889 | $938,000 | thousands by filing date | |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 11,240 | $936,000 | thousands by filing date | |
| Visa Inc | 92826C839 | COM | 4,710 | $909,000 | thousands by filing date | |
| Raytheon Technologies Corporation | 75513E101 | COM | 14,431 | $890,000 | thousands by filing date | |
| Oracle Corporation | 68389X105 | COM | 15,975 | $885,000 | thousands by filing date | |
| Lowes Companies,Inc. | 548661107 | COM | 6,503 | $879,000 | thousands by filing date | |
| Pfizer Inc. | 717081103 | COM | 26,445 | $864,000 | thousands by filing date | |
| Coca-Cola Company | 191216100 | COM | 19,121 | $854,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 12,478 | $853,000 | thousands by filing date | |
| Home Depot, Inc | 437076102 | COM | 3,371 | $846,000 | thousands by filing date | |
| PAYCHEX INC | 704326107 | COM | 11,054 | $838,000 | thousands by filing date | |
| ISHARES TR | 464288513 | IBOXX HI YD ETF | 10,007 | $816,000 | thousands by filing date | |
| Bank of America Corp | 060505104 | COM | 33,951 | $805,000 | thousands by filing date | |
| iShares MSCI ACWI Low Carbon Target ETF | 46434V464 | SHS | 6,658 | $804,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524409 | US LCAP VA ETF | 16,019 | $803,000 | thousands by filing date | |
| UnitedHealth Group Inc | 91324P102 | COM | 2,697 | $796,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X863 | ST DOW INTL ETF | 27,111 | $782,000 | thousands by filing date | |
| VANECK ETF TRUST | 92189F726 | BIOTECH ETF | 4,657 | $762,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X426 | ST STR MSCI EM | 14,379 | $758,000 | thousands by filing date | |
| SILGAN HLDGS INC | 827048109 | COM | 23,128 | $749,000 | thousands by filing date | |
| Vanguard Short-Term Treasury ETF | 92206C102 | SHS | 12,004 | $747,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 4,241 | $737,000 | thousands by filing date | |
| MasterCard, Inc | 57636Q104 | COM | 2,466 | $730,000 | thousands by filing date | |
| International Business Machines Corporation | 459200101 | COM | 5,943 | $716,000 | thousands by filing date | |
| RESTAURANT BRANDS INTL INC COM | 76131D103 | Stock | 13,072 | $714,000 | thousands by filing date | |
| ISHARES TR | 464287168 | COM | 8,764 | $707,000 | thousands by filing date | |
| iShares Core S&P Total U.S. Stock Market ETF | 464287150 | SHS | 9,285 | $646,000 | thousands by filing date | |
| ILLUMINA INC | 452327109 | COM | 1,739 | $644,000 | thousands by filing date | |
| SPDR S&P Dividend ETF | 78464A763 | SHS | 7,009 | $640,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X871 | ST INTL CAP ETF | 23,245 | $637,000 | thousands by filing date | |
| AbbVie,Inc. | 00287Y109 | COM | 6,481 | $636,000 | thousands by filing date | |
| Wells Fargo & Company | 949746101 | COM | 24,431 | $624,000 | thousands by filing date | |
| ISHARES TR | 464288448 | INTL SEL DIV ETF | 24,725 | $622,000 | thousands by filing date | |
| Vanguard Small-Cap Growth ETF | 922908595 | SHS | 3,090 | $617,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 13,396 | $599,000 | thousands by filing date | |
| ISHARES TR | 464288257 | MSCI ACWI ETF | 7,766 | $572,000 | thousands by filing date | |
| CHARTER COMMUNICATIONS INC N | 16119P108 | COM | 1,111 | $566,000 | thousands by filing date | |
| Vanguard Growth | 922908736 | COM | 2,797 | $565,000 | thousands by filing date | |
| Schwab Fundamental Emerging Markets Equity ETF | 808524730 | SHS | 24,060 | $563,000 | thousands by filing date | |
| Thermo Fisher Scientific Inc. | 883556102 | COM | 1,530 | $554,000 | thousands by filing date | |
| ISHARES MSCI USA QUALITY FACTOR ETF | 46432F339 | ETF | 5,667 | $544,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 2,470 | $511,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524755 | FUNDAMENTAL INTL | 21,161 | $503,000 | thousands by filing date | |
| NIKE,Inc. Class B | 654106103 | COM | 5,126 | $501,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 16,491 | $500,000 | thousands by filing date | |
| Amgen Inc. | 031162100 | COM | 2,006 | $473,000 | thousands by filing date | |
| ISHARES CORE S&P U.S. GROWTH ETF | 464287671 | ETF | 6,339 | $456,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 2,845 | $450,000 | thousands by filing date | |
| Accenture Plc Class A | G1151C101 | COM | 2,064 | $443,000 | thousands by filing date | |
| American Express Company | 025816109 | COM | 4,625 | $441,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 2,386 | $441,000 | thousands by filing date | |
| Walmart Inc. | 931142103 | COM | 3,649 | $439,000 | thousands by filing date | |
| SPDR GOLD TR | 78463V107 | GOLD SHS | 2,629 | $439,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V332 | S&P500 EQL HLT | 1,969 | $437,000 | thousands by filing date | |
| VANGUARD WHITEHALL FDS | 921946885 | COM | 5,447 | $424,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V639 | AI AND NEXT GEN | 3,660 | $420,000 | thousands by filing date | |
| CINCINNATI FINL CORP COM | 172062101 | Stock | 6,532 | $418,000 | thousands by filing date | |
| ISHARES TR | 464287101 | S&P 100 ETF | 2,770 | $395,000 | thousands by filing date | |
| KINDER MORGAN INC DEL COM | 49456B101 | Stock | 25,397 | $386,000 | thousands by filing date | |
| NextEra Energy,Inc. | 65339F101 | COM | 1,573 | $378,000 | thousands by filing date | |
| Bristol-Myers Squibb Company | 110122108 | COM | 6,423 | $377,000 | thousands by filing date | |
| SCHD | 808524797 | COM | 7,285 | $377,000 | thousands by filing date | |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 1,805 | $375,000 | thousands by filing date | |
| iShares U.S. Medical Devices ETF | 464288810 | SHS | 1,355 | $359,000 | thousands by filing date | |
| Vanguard Total World Stock ETF | 922042742 | SHS | 4,781 | $357,000 | thousands by filing date | |
| TRUIST FINL CORP COM | 89832Q109 | Stock | 9,325 | $350,000 | thousands by filing date | |
| Caterpillar Inc. | 149123101 | COM | 2,625 | $333,000 | thousands by filing date | |
| HUNTINGTON BANCSHARES INC COM | 446150104 | Stock | 35,658 | $322,000 | thousands by filing date | |
| NOVARTIS AG SPONSORED ADR | 66987V109 | ADR | 3,684 | $321,000 | thousands by filing date | |
| ECOLAB INC COM | 278865100 | Stock | 1,500 | $298,000 | thousands by filing date | |
| SSGA ACTIVE ETF TR | 78467V848 | ST STR TOTAL ETF | 6,037 | $298,000 | thousands by filing date | |
| RAPT THERAPEUTICS INC | 75382E109 | COM | 10,000 | $290,000 | thousands by filing date | |
| REALTY INCOME CORP COM | 756109104 | REIT | 4,811 | $286,000 | thousands by filing date | |
| iShares MSCI ACWI ex U.S. ETF | 464288240 | SHS | 6,334 | $274,000 | thousands by filing date | |
| Boeing Company | 097023105 | COM | 1,491 | $272,000 | thousands by filing date | |
| CLOROX CO DEL | 189054109 | COM | 1,233 | $271,000 | thousands by filing date | |
| INVESCO QQQ TR | 46090E103 | COM | 1,082 | $268,000 | thousands by filing date | |
| Vanguard Materials ETF | 92204A801 | SHS | 2,235 | $268,000 | thousands by filing date | |
| iShares Emerging Markets Dividend ETF | 464286319 | SHS | 8,160 | $256,000 | thousands by filing date | |
| SEMPRA COM | 816851109 | Stock | 2,170 | $254,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 1,679 | $243,000 | thousands by filing date | |
| iShares TIPS Bond ETF | 464287176 | SHS | 1,977 | $243,000 | thousands by filing date | |
| Costco Wholesale Corporation | 22160K105 | COM | 787 | $238,000 | thousands by filing date | |
| BECTON DICKINSON & CO | 075887109 | COM | 984 | $235,000 | thousands by filing date | |
| CAPITAL ONE FINL CORP | 14040H105 | COM | 3,581 | $225,000 | thousands by filing date | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 2,726 | $221,000 | thousands by filing date | |
| BROOKFIELD RENEWABLE ENERGY | G16258108 | PARTNERSHIP UNIT | 4,424 | $212,000 | thousands by filing date | |
| Starbucks Corporation | 855244109 | COM | 2,844 | $210,000 | thousands by filing date | |
| FEDEX CORP COM | 31428X106 | Stock | 1,453 | $203,000 | thousands by filing date | |
| VANECK ETF TRUST | 92189F387 | SHRT HGH YLD MUN | 8,460 | $202,000 | thousands by filing date | |
| MARATHON PETE CORP COM | 56585A102 | Stock | 5,378 | $200,000 | thousands by filing date | |
| GENERAL ELEC CO | 369604103 | COM | 28,144 | $193,000 | thousands by filing date | |
| iShares Gold Trust | 464285105 | ISHARES | 11,216 | $191,000 | thousands by filing date | |
| UBS AG LONDON BRH | 90267B682 | ETRAC ALER MLP | 11,907 | $163,000 | thousands by filing date | |
| NOKIA CORP | 654902204 | SPONSORED ADR | 23,378 | $103,000 | thousands by filing date | |
| MARATHON OIL CORP | 565849106 | COM | 11,170 | $68,000 | thousands by filing date | |
| PERCEPTRON INC | 71361F100 | COMMON STOCK | 14,067 | $47,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001172661-20-001593 | this filing | 2020-08-06 | acceptance time not in the bulk data set |