13F-HR filed by MainStreet Investment Advisors LLC
MainStreet Investment Advisors LLC filed this 13F-HR for the quarter ended 2020-09-30, filed 2020-11-09, with 180 holding rows worth $1,279,472,000.
- Accession
- 0000950123-20-011049
- Filer
- CIK 1729854
- Filed
- 2020-11-09
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q3 2020
A holdings report, 181 entries on the cover page, a total value of $1,279,472,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $1,279,471,000 with VALUE read as thousands by filing date, 13F file number 028-18622. 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 TR CORE S&P 500 ETF | 464287200 | SHS | 309,123 | $103,884,000 | thousands by filing date | |
| IJH | 464287507 | COM | 467,429 | $86,619,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 1,059,767 | $67,454,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 457,513 | $52,984,000 | thousands by filing date | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 595,770 | $52,559,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 205,960 | $43,320,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 529,593 | $37,193,000 | thousands by filing date | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 506,153 | $30,511,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 360,978 | $28,503,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 182,992 | $25,434,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 7,786 | $24,516,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 159,956 | $23,814,000 | thousands by filing date | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 41,657 | $23,476,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 481,400 | $20,816,000 | thousands by filing date | |
| PepsiCo,Inc. | 713448108 | COM | 147,220 | $20,405,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 624,789 | $19,600,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 118,723 | $19,543,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 12,876 | $18,872,000 | thousands by filing date | |
| ISHARES TR | 464288513 | IBOXX HI YD ETF | 221,579 | $18,590,000 | thousands by filing date | |
| Starbucks Corporation | 855244109 | COM | 203,049 | $17,446,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C771 | SHS | 318,870 | $17,305,000 | thousands by filing date | |
| Home Depot, Inc | 437076102 | COM | 58,063 | $16,125,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 264,528 | $15,737,000 | thousands by filing date | |
| Adobe Inc | 00724F101 | COM | 30,202 | $14,812,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 67,813 | $14,440,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 71,455 | $14,079,000 | thousands by filing date | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 117,146 | $13,581,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 56,496 | $12,400,000 | thousands by filing date | |
| JPMorgan Chase & Co | 46625H100 | COM | 122,670 | $11,810,000 | thousands by filing date | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 220,544 | $11,645,000 | thousands by filing date | |
| AbbVie,Inc. | 00287Y109 | COM | 122,878 | $10,763,000 | thousands by filing date | |
| Visa Inc | 92826C839 | COM | 52,817 | $10,562,000 | thousands by filing date | |
| MICROCHIP TECHNOLOGY INC. COM | 595017104 | Stock | 99,255 | $10,199,000 | thousands by filing date | |
| HASBRO INC COM | 418056107 | Stock | 118,027 | $9,763,000 | thousands by filing date | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 188,327 | $9,608,000 | thousands by filing date | |
| Waste Management, Inc. | 94106L109 | COM | 82,666 | $9,355,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 126,876 | $9,135,000 | thousands by filing date | |
| UnitedHealth Group Inc | 91324P102 | COM | 28,447 | $8,869,000 | thousands by filing date | |
| Pfizer Inc. | 717081103 | COM | 236,660 | $8,685,000 | thousands by filing date | |
| ISHARES TR | 464288372 | COM | 223,815 | $8,635,000 | thousands by filing date | |
| Texas Instruments Incorporated | 882508104 | COM | 59,363 | $8,476,000 | thousands by filing date | |
| NEW YORK LIFE INVESTMENTS ET | 45409B800 | NYLI MERGER ARBI | 247,028 | $8,310,000 | thousands by filing date | |
| 3M CO COM | 88579Y101 | Stock | 51,273 | $8,213,000 | thousands by filing date | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 48,958 | $8,158,000 | thousands by filing date | |
| Utilities Select Sector SPDR Fund | 81369Y886 | SHS | 131,064 | $7,783,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 74,588 | $7,751,000 | thousands by filing date | |
| Lockheed Martin Corporation | 539830109 | COM | 20,142 | $7,720,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 147,527 | $7,639,000 | thousands by filing date | |
| PAYCHEX INC | 704326107 | COM | 93,515 | $7,460,000 | thousands by filing date | |
| Citigroup Inc. | 172967424 | COM | 158,433 | $6,830,000 | thousands by filing date | |
| ZOETIS INC CL A | 98978V103 | Stock | 39,604 | $6,550,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y100 | SBI MATERIALS | 102,553 | $6,526,000 | thousands by filing date | |
| NORTHROP GRUMMAN CORP COM | 666807102 | Stock | 20,587 | $6,495,000 | thousands by filing date | |
| DOW HLDGS INC COM | 260557103 | Stock | 136,191 | $6,408,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 77,158 | $6,400,000 | thousands by filing date | |
| MASCO CORP | 574599106 | COM | 115,447 | $6,365,000 | thousands by filing date | |
| WW GRAINGER INC COM | 384802104 | Stock | 17,613 | $6,284,000 | thousands by filing date | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 44,614 | $6,176,000 | thousands by filing date | |
| CERNER CORP | 156782104 | COM | 83,218 | $6,016,000 | thousands by filing date | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 74,276 | $5,863,000 | thousands by filing date | |
| Stryker Corporation | 863667101 | COM | 27,643 | $5,760,000 | thousands by filing date | |
| Southern Company | 842587107 | COM | 106,044 | $5,750,000 | thousands by filing date | |
| EMERSON ELEC CO COM | 291011104 | Stock | 85,666 | $5,617,000 | thousands by filing date | |
| BIOGEN INC COM | 09062X103 | Stock | 19,698 | $5,588,000 | thousands by filing date | |
| VanEck High Yield Muni ETF | 92189H409 | SHS | 89,808 | $5,371,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 42,704 | $5,299,000 | thousands by filing date | |
| CVS Health Corporation | 126650100 | COM | 89,800 | $5,245,000 | thousands by filing date | |
| GENUINE PARTS CO COM | 372460105 | Stock | 54,637 | $5,200,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 142,070 | $5,094,000 | thousands by filing date | |
| Bank of America Corp | 060505104 | COM | 211,346 | $5,091,000 | thousands by filing date | |
| ISHARES SHORT-TERM NATIONAL MUNI BOND ETF | 464288158 | ETF | 46,136 | $4,987,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 171,795 | $4,898,000 | thousands by filing date | |
| ISHARES TR | 464288257 | MSCI ACWI ETF | 55,450 | $4,432,000 | thousands by filing date | |
| Altria Group Inc | 02209S103 | COM | 111,220 | $4,297,000 | thousands by filing date | |
| Accenture Plc Class A | G1151C101 | COM | 18,156 | $4,103,000 | thousands by filing date | |
| Cisco Systems,Inc. | 17275R102 | COM | 91,701 | $3,612,000 | thousands by filing date | |
| ALLSTATE CORP COM | 020002101 | Stock | 35,962 | $3,385,000 | thousands by filing date | |
| ACTVISION BLIZZARD INC | 00507V109 | COM | 41,171 | $3,333,000 | thousands by filing date | |
| ENBRIDGE INC COM | 29250N105 | Stock | 106,072 | $3,097,000 | thousands by filing date | |
| iShares Global REIT ETF | 46434V647 | SHS | 129,587 | $2,725,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A375 | ST INTER BD ETF | 69,537 | $2,556,000 | thousands by filing date | |
| EOG RES INC COM | 26875P101 | Stock | 68,607 | $2,466,000 | thousands by filing date | |
| MasterCard, Inc | 57636Q104 | COM | 6,689 | $2,262,000 | thousands by filing date | |
| INGREDION INC COM | 457187102 | Stock | 28,824 | $2,181,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 1,344 | $1,976,000 | thousands by filing date | |
| AUTODESK INC COM | 052769106 | Stock | 8,411 | $1,943,000 | thousands by filing date | |
| CINTAS CORP COM | 172908105 | Stock | 5,691 | $1,894,000 | thousands by filing date | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 15,734 | $1,858,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 14,036 | $1,528,000 | thousands by filing date | |
| CHURCH & DWIGHT CO INC COM | 171340102 | Stock | 15,985 | $1,498,000 | thousands by filing date | |
| American Express Company | 025816109 | COM | 13,192 | $1,322,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 8,561 | $1,282,000 | thousands by filing date | |
| BERKSHIRE HATHAWAY INC DEL | 084670108 | CL A | 4 | $1,280,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R783 | 0-5 HIGH YIELD | 13,255 | $1,243,000 | thousands by filing date | |
| VERISIGN INC COM | 92343E102 | Stock | 5,989 | $1,227,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 4,679 | $1,226,000 | thousands by filing date | |
| Oracle Corporation | 68389X105 | COM | 19,383 | $1,157,000 | thousands by filing date | |
| ISHARES TR | 46429B333 | GNMA BOND ETF | 22,602 | $1,155,000 | thousands by filing date | |
| NASDAQ INC COM | 631103108 | Stock | 8,723 | $1,071,000 | thousands by filing date | |
| AMERIPRISE FINL INC COM | 03076C106 | Stock | 6,926 | $1,067,000 | thousands by filing date | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 18,000 | $1,047,000 | thousands by filing date | |
| INVESCO EXCH TRADED FD TR II | 46138G508 | SR LN ETF | 47,427 | $1,031,000 | thousands by filing date | |
| Lowes Companies,Inc. | 548661107 | COM | 5,937 | $984,000 | thousands by filing date | |
| AMETEK INC COM | 031100100 | Stock | 9,781 | $972,000 | thousands by filing date | |
| WATERS CORP COM | 941848103 | Stock | 4,771 | $933,000 | thousands by filing date | |
| Coca-Cola Company | 191216100 | COM | 17,017 | $841,000 | thousands by filing date | |
| EXACT SCIENCES CORP COM | 30063P105 | Stock | 8,062 | $822,000 | thousands by filing date | |
| ESSEX PPTY TR INC COM | 297178105 | REIT | 3,754 | $753,000 | thousands by filing date | |
| SILGAN HLDGS INC | 827048109 | COM | 20,172 | $742,000 | thousands by filing date | |
| NIKE,Inc. Class B | 654106103 | COM | 5,677 | $712,000 | thousands by filing date | |
| Mondelez International,Inc. Class A | 609207105 | COM | 12,303 | $707,000 | thousands by filing date | |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 8,409 | $698,000 | thousands by filing date | |
| AIR PRODS & CHEMS INC | 009158106 | COM | 2,324 | $692,000 | thousands by filing date | |
| Duke Energy Corporation | 26441C204 | COM | 7,704 | $682,000 | thousands by filing date | |
| ZIMMER BIOMET HOLDINGS INC COM | 98956P102 | Stock | 4,987 | $679,000 | thousands by filing date | |
| ZIONS BANCORPORATION | 989701107 | COM | 22,997 | $672,000 | thousands by filing date | |
| MARKELGROUPINC | 570535104 | STOK | 683 | $665,000 | thousands by filing date | |
| Vanguard Total World Stock ETF | 922042742 | SHS | 8,239 | $664,000 | thousands by filing date | |
| iShares MSCI KLD 400 Social ETF | 464288570 | SHS | 5,070 | $649,000 | thousands by filing date | |
| ILLINOIS TOOL WKS INC | 452308109 | COM | 3,335 | $644,000 | thousands by filing date | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 5,516 | $644,000 | thousands by filing date | |
| V F CORP COM | 918204108 | Stock | 9,072 | $637,000 | thousands by filing date | |
| Costco Wholesale Corporation | 22160K105 | COM | 1,763 | $625,000 | thousands by filing date | |
| FLOWERS FOODS INC COM | 343498101 | Stock | 25,695 | $625,000 | thousands by filing date | |
| GARTNERINC | 366651107 | STOK | 4,899 | $612,000 | thousands by filing date | |
| NVIDIA Corp | 67066G104 | COM | 1,126 | $610,000 | thousands by filing date | |
| ROCKWELL AUTOMATION INC COM | 773903109 | Stock | 2,746 | $606,000 | thousands by filing date | |
| REINSURANCE GROUP AMER INC COM NEW | 759351604 | Stock | 6,304 | $600,000 | thousands by filing date | |
| Deere & Company | 244199105 | COM | 2,644 | $586,000 | thousands by filing date | |
| Amgen Inc. | 031162100 | COM | 2,267 | $576,000 | thousands by filing date | |
| CONAGRA FOODS INC | 205887102 | COM | 15,636 | $558,000 | thousands by filing date | |
| Schwab U.S. Broad Market ETF | 808524102 | SHS | 6,941 | $553,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 16,048 | $551,000 | thousands by filing date | |
| FIFTH THIRD BANCORP COM | 316773100 | Stock | 24,797 | $528,000 | thousands by filing date | |
| F5 INC COM | 315616102 | Stock | 4,270 | $524,000 | thousands by filing date | |
| JACOBS ENGINEERING GROUP INC | 469814107 | COM | 5,545 | $514,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 3,099 | $477,000 | thousands by filing date | |
| CSX Corporation | 126408103 | COM | 6,070 | $471,000 | thousands by filing date | |
| ISHARES TR | 464288281 | JPMORGAN USD EMG | 4,237 | $470,000 | thousands by filing date | |
| SCHEIN HENRY INC | 806407102 | COM | 7,988 | $470,000 | thousands by filing date | |
| iShares Floating Rate Bond ETF | 46429B655 | SHS | 9,251 | $469,000 | thousands by filing date | |
| NextEra Energy,Inc. | 65339F101 | COM | 4,654 | $466,000 | thousands by filing date | |
| Raytheon Technologies Corporation | 75513E101 | COM | 8,056 | $464,000 | thousands by filing date | |
| EXPEDITORS INTL WASH INC COM | 302130109 | Stock | 5,013 | $454,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 10,210 | $450,000 | thousands by filing date | |
| Comcast Corp | 20030N101 | COM | 9,437 | $437,000 | thousands by filing date | |
| OSHKOSH CORP COM | 688239201 | Stock | 5,952 | $437,000 | thousands by filing date | |
| CME Group Inc. Class A | 12572Q105 | COM | 2,453 | $411,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R739 | ST NUVE TERM ETF | 8,205 | $409,000 | thousands by filing date | |
| POLARIS INC COM | 731068102 | Stock | 4,293 | $405,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 9,100 | $404,000 | thousands by filing date | |
| AGILENT TECHNOLOGIES INC COM | 00846U101 | Stock | 3,981 | $402,000 | thousands by filing date | |
| UMPQUA HOLDINGS | 904214103 | COM | 34,331 | $365,000 | thousands by filing date | |
| International Business Machines Corporation | 459200101 | COM | 2,878 | $350,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 2,015 | $348,000 | thousands by filing date | |
| NORTHERN TR CORP COM | 665859104 | Stock | 4,374 | $342,000 | thousands by filing date | |
| OWENS CORNING NEW | 690742101 | COM | 4,863 | $335,000 | thousands by filing date | |
| Netflix, Inc | 64110L106 | COM | 660 | $331,000 | thousands by filing date | |
| SPY | 78462F103 | SHS | 963 | $322,000 | thousands by filing date | |
| MARTIN MARIETTA MATLS INC COM | 573284106 | Stock | 1,367 | $322,000 | thousands by filing date | |
| Salesforce.com, Inc | 79466L302 | COM | 1,272 | $320,000 | thousands by filing date | |
| SCHWEITZER-MAUDUIT INTL INC | 808541106 | COM | 10,406 | $316,000 | thousands by filing date | |
| ENERGIZER HLDGS INC COM | 29272W109 | Stock | 7,636 | $299,000 | thousands by filing date | |
| Caterpillar Inc. | 149123101 | COM | 1,958 | $292,000 | thousands by filing date | |
| DTE ENERGY CO COM | 233331107 | Stock | 2,495 | $287,000 | thousands by filing date | |
| iShares Core S&P U.S. Value ETF | 464287663 | SHS | 5,270 | $286,000 | thousands by filing date | |
| Union Pacific Corporation | 907818108 | COM | 1,447 | $285,000 | thousands by filing date | |
| LINDE PLC | G5494J103 | SHS | 1,185 | $282,000 | thousands by filing date | |
| EVERGY INC COM | 30034W106 | Stock | 5,490 | $279,000 | thousands by filing date | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 1,517 | $267,000 | thousands by filing date | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 1,659 | $260,000 | thousands by filing date | |
| Bristol-Myers Squibb Company | 110122108 | COM | 4,301 | $259,000 | thousands by filing date | |
| TARGET CORP COM | 87612E106 | Stock | 1,619 | $255,000 | thousands by filing date | |
| Boeing Company | 097023105 | COM | 1,507 | $249,000 | thousands by filing date | |
| PNC FINL SVCS GROUP INC COM | 693475105 | Stock | 2,222 | $244,000 | thousands by filing date | |
| INVESCO S&P 500 TOP 50 ETF | 46137V233 | ETF | 910 | $238,000 | thousands by filing date | |
| Broadcom Inc. | 11135F101 | COM | 645 | $235,000 | thousands by filing date | |
| American Tower Corporation | 03027X100 | COM | 899 | $217,000 | thousands by filing date | |
| Philip Morris International Inc. | 718172109 | COM | 2,699 | $202,000 | thousands by filing date | |
| FORD MTR CO COM | 345370860 | Stock | 15,723 | $104,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0000950123-20-011049 | this filing | 2020-11-09 | acceptance time not in the bulk data set |