13F-HR filed by MainStreet Investment Advisors LLC
MainStreet Investment Advisors LLC filed this 13F-HR for the quarter ended 2021-09-30, filed 2021-11-08, with 179 holding rows worth $1,039,084,000.
- Accession
- 0000950123-21-014152
- Filer
- CIK 1729854
- Filed
- 2021-11-08
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q3 2021
A holdings report, 179 entries on the cover page, a total value of $1,039,084,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $1,039,084,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 |
|---|---|---|---|---|---|---|
| IJH | 464287507 | COM | 344,297 | $90,574,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 937,571 | $73,140,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 349,670 | $49,478,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 422,909 | $46,177,000 | thousands by filing date | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 102,368 | $44,102,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 153,106 | $43,164,000 | thousands by filing date | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 33,109 | $27,767,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 9,012 | $24,094,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 144,085 | $20,143,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 401,510 | $20,080,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 123,204 | $19,897,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 93,138 | $19,771,000 | thousands by filing date | |
| JPMorgan Chase & Co | 46625H100 | COM | 111,439 | $18,242,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 5,539 | $18,195,000 | thousands by filing date | |
| PepsiCo,Inc. | 713448108 | COM | 120,504 | $18,125,000 | thousands by filing date | |
| Starbucks Corporation | 855244109 | COM | 161,721 | $17,839,000 | thousands by filing date | |
| Home Depot, Inc | 437076102 | COM | 51,179 | $16,800,000 | thousands by filing date | |
| AbbVie,Inc. | 00287Y109 | COM | 143,458 | $15,475,000 | thousands by filing date | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 148,992 | $12,731,000 | thousands by filing date | |
| Adobe Inc | 00724F101 | COM | 22,076 | $12,710,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 48,154 | $12,530,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 226,259 | $12,220,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 49,720 | $11,988,000 | thousands by filing date | |
| Waste Management, Inc. | 94106L109 | COM | 75,834 | $11,327,000 | thousands by filing date | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 138,245 | $10,265,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 95,914 | $9,730,000 | thousands by filing date | |
| PAYCHEX INC | 704326107 | COM | 82,889 | $9,321,000 | thousands by filing date | |
| Pfizer Inc. | 717081103 | COM | 210,000 | $9,032,000 | thousands by filing date | |
| Texas Instruments Incorporated | 882508104 | COM | 46,167 | $8,873,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 68,630 | $8,603,000 | thousands by filing date | |
| HASBRO INC COM | 418056107 | Stock | 93,893 | $8,377,000 | thousands by filing date | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 45,850 | $8,349,000 | thousands by filing date | |
| Visa Inc | 92826C839 | COM | 36,388 | $8,105,000 | thousands by filing date | |
| 3M CO COM | 88579Y101 | Stock | 45,553 | $7,991,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 132,759 | $7,891,000 | thousands by filing date | |
| UnitedHealth Group Inc | 91324P102 | COM | 19,960 | $7,799,000 | thousands by filing date | |
| EMERSON ELEC CO COM | 291011104 | Stock | 77,867 | $7,335,000 | thousands by filing date | |
| DOW HLDGS INC COM | 260557103 | Stock | 125,879 | $7,245,000 | thousands by filing date | |
| CVS Health Corporation | 126650100 | COM | 83,358 | $7,073,000 | thousands by filing date | |
| Citigroup Inc. | 172967424 | COM | 99,837 | $7,006,000 | thousands by filing date | |
| Lockheed Martin Corporation | 539830109 | COM | 19,552 | $6,747,000 | thousands by filing date | |
| MICROCHIP TECHNOLOGY INC. COM | 595017104 | Stock | 86,111 | $6,631,000 | thousands by filing date | |
| WW GRAINGER INC COM | 384802104 | Stock | 16,725 | $6,573,000 | thousands by filing date | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 33,064 | $6,482,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 204,971 | $6,405,000 | thousands by filing date | |
| Southern Company | 842587107 | COM | 100,396 | $6,221,000 | thousands by filing date | |
| Accenture Plc Class A | G1151C101 | COM | 18,935 | $6,058,000 | thousands by filing date | |
| Bank of America Corp | 060505104 | COM | 140,893 | $5,981,000 | thousands by filing date | |
| GENUINE PARTS CO COM | 372460105 | Stock | 49,331 | $5,980,000 | thousands by filing date | |
| Cisco Systems,Inc. | 17275R102 | COM | 105,335 | $5,734,000 | thousands by filing date | |
| ISHARES TR | 464288513 | IBOXX HI YD ETF | 64,997 | $5,687,000 | thousands by filing date | |
| ZOETIS INC CL A | 98978V103 | Stock | 28,960 | $5,622,000 | thousands by filing date | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 76,714 | $5,601,000 | thousands by filing date | |
| Morgan Stanley | 617446448 | COM | 56,616 | $5,509,000 | thousands by filing date | |
| ISHARES TR | 464288257 | MSCI ACWI ETF | 54,215 | $5,417,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 30,709 | $5,195,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y100 | SBI MATERIALS | 61,523 | $4,867,000 | thousands by filing date | |
| Intercontinental Exchange,Inc. | 45866F104 | COM | 42,338 | $4,861,000 | thousands by filing date | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 40,558 | $4,712,000 | thousands by filing date | |
| NORTHROP GRUMMAN CORP COM | 666807102 | Stock | 13,035 | $4,695,000 | thousands by filing date | |
| MASCO CORP | 574599106 | COM | 83,780 | $4,654,000 | thousands by filing date | |
| CERNER CORP | 156782104 | COM | 64,954 | $4,580,000 | thousands by filing date | |
| Altria Group Inc | 02209S103 | COM | 100,454 | $4,573,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 16,149 | $4,407,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 163,128 | $4,406,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 57,731 | $4,336,000 | thousands by filing date | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 68,317 | $4,219,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C771 | SHS | 75,375 | $4,017,000 | thousands by filing date | |
| ENBRIDGE INC COM | 29250N105 | Stock | 92,940 | $3,699,000 | thousands by filing date | |
| EOG RES INC COM | 26875P101 | Stock | 46,058 | $3,697,000 | thousands by filing date | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 69,434 | $3,651,000 | thousands by filing date | |
| INGREDION INC COM | 457187102 | Stock | 38,884 | $3,461,000 | thousands by filing date | |
| Stryker Corporation | 863667101 | COM | 12,008 | $3,167,000 | thousands by filing date | |
| JACOBS ENGINEERING GROUP INC | 469814107 | COM | 21,524 | $2,853,000 | thousands by filing date | |
| ACTVISION BLIZZARD INC | 00507V109 | COM | 34,409 | $2,663,000 | thousands by filing date | |
| CADENCE DESIGN SYSTEM INC COM | 127387108 | Stock | 15,519 | $2,350,000 | thousands by filing date | |
| PRINCIPAL EXCHANGE TRADED FD | 74255Y888 | SPECTRUM PFD | 112,956 | $2,343,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 876 | $2,335,000 | thousands by filing date | |
| AUTODESK INC COM | 052769106 | Stock | 8,022 | $2,288,000 | thousands by filing date | |
| ISHARES SHORT-TERM NATIONAL MUNI BOND ETF | 464288158 | ETF | 19,410 | $2,088,000 | thousands by filing date | |
| VanEck High Yield Muni ETF | 92189H409 | SHS | 33,097 | $2,068,000 | thousands by filing date | |
| American Express Company | 025816109 | COM | 11,112 | $1,862,000 | thousands by filing date | |
| MasterCard, Inc | 57636Q104 | COM | 5,293 | $1,841,000 | thousands by filing date | |
| CINTAS CORP COM | 172908105 | Stock | 4,683 | $1,783,000 | thousands by filing date | |
| VIATRIS INC COM | 92556V106 | Stock | 129,860 | $1,760,000 | thousands by filing date | |
| WATERS CORP COM | 941848103 | Stock | 4,663 | $1,666,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 7,452 | $1,630,000 | thousands by filing date | |
| AMERIPRISE FINL INC COM | 03076C106 | Stock | 6,026 | $1,592,000 | thousands by filing date | |
| PRUDENTIAL FINL INC COM | 744320102 | Stock | 14,066 | $1,480,000 | thousands by filing date | |
| ZIONS BANCORPORATION | 989701107 | COM | 21,382 | $1,324,000 | thousands by filing date | |
| Oracle Corporation | 68389X105 | COM | 14,827 | $1,292,000 | thousands by filing date | |
| GARTNERINC | 366651107 | STOK | 4,099 | $1,246,000 | thousands by filing date | |
| CHURCH & DWIGHT CO INC COM | 171340102 | Stock | 14,484 | $1,196,000 | thousands by filing date | |
| ESSEX PPTY TR INC COM | 297178105 | REIT | 3,547 | $1,134,000 | thousands by filing date | |
| VERISIGN INC COM | 92343E102 | Stock | 5,143 | $1,054,000 | thousands by filing date | |
| AMETEK INC COM | 031100100 | Stock | 8,420 | $1,045,000 | thousands by filing date | |
| NASDAQ INC COM | 631103108 | Stock | 5,391 | $1,041,000 | thousands by filing date | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 18,000 | $1,025,000 | thousands by filing date | |
| ROCKWELL AUTOMATION INC COM | 773903109 | Stock | 3,011 | $885,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R783 | 0-5 HIGH YIELD | 8,853 | $879,000 | thousands by filing date | |
| iShares MSCI KLD 400 Social ETF | 464288570 | SHS | 10,470 | $871,000 | thousands by filing date | |
| FIFTH THIRD BANCORP COM | 316773100 | Stock | 19,756 | $839,000 | thousands by filing date | |
| ISHARES TR | 46429B333 | GNMA BOND ETF | 16,610 | $830,000 | thousands by filing date | |
| NIKE,Inc. Class B | 654106103 | COM | 5,679 | $825,000 | thousands by filing date | |
| ILLINOIS TOOL WKS INC | 452308109 | COM | 3,756 | $776,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 6,496 | $767,000 | thousands by filing date | |
| Deere & Company | 244199105 | COM | 2,181 | $731,000 | thousands by filing date | |
| Mondelez International,Inc. Class A | 609207105 | COM | 12,401 | $722,000 | thousands by filing date | |
| Schwab U.S. Broad Market ETF | 808524102 | SHS | 6,941 | $721,000 | thousands by filing date | |
| SILGAN HLDGS INC | 827048109 | COM | 18,713 | $718,000 | thousands by filing date | |
| AGILENT TECHNOLOGIES INC COM | 00846U101 | Stock | 4,525 | $713,000 | thousands by filing date | |
| ZIMMER BIOMET HOLDINGS INC COM | 98956P102 | Stock | 4,836 | $707,000 | thousands by filing date | |
| AIR PRODS & CHEMS INC | 009158106 | COM | 2,740 | $702,000 | thousands by filing date | |
| MARKELGROUPINC | 570535104 | STOK | 575 | $687,000 | thousands by filing date | |
| Coca-Cola Company | 191216100 | COM | 12,965 | $680,000 | thousands by filing date | |
| iShares S&P Mid-Cap 400 Value ETF | 464287705 | SHS | 6,585 | $679,000 | thousands by filing date | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 8,525 | $675,000 | thousands by filing date | |
| Tesla Motors, Inc | 88160R101 | COM | 858 | $665,000 | thousands by filing date | |
| EXPEDITORS INTL WASH INC COM | 302130109 | Stock | 5,503 | $656,000 | thousands by filing date | |
| NVIDIA Corp | 67066G104 | COM | 3,123 | $647,000 | thousands by filing date | |
| Lowes Companies,Inc. | 548661107 | COM | 3,181 | $646,000 | thousands by filing date | |
| Applied Materials,Inc. | 038222105 | COM | 5,007 | $644,000 | thousands by filing date | |
| REINSURANCE GROUP AMER INC COM NEW | 759351604 | Stock | 5,687 | $633,000 | thousands by filing date | |
| Costco Wholesale Corporation | 22160K105 | COM | 1,400 | $629,000 | thousands by filing date | |
| F5 INC COM | 315616102 | Stock | 3,009 | $598,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 2,695 | $589,000 | thousands by filing date | |
| UMPQUA HOLDINGS | 904214103 | COM | 28,999 | $587,000 | thousands by filing date | |
| V F CORP COM | 918204108 | Stock | 8,366 | $560,000 | thousands by filing date | |
| FLOWERS FOODS INC COM | 343498101 | Stock | 23,488 | $555,000 | thousands by filing date | |
| SCHEIN HENRY INC | 806407102 | COM | 7,201 | $548,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 8,935 | $525,000 | thousands by filing date | |
| NextEra Energy,Inc. | 65339F101 | COM | 6,673 | $524,000 | thousands by filing date | |
| OSHKOSH CORP COM | 688239201 | Stock | 4,718 | $483,000 | thousands by filing date | |
| Amgen Inc. | 031162100 | COM | 2,244 | $477,000 | thousands by filing date | |
| CONAGRA FOODS INC | 205887102 | COM | 13,871 | $470,000 | thousands by filing date | |
| COMERICAINC | 200340107 | COM | 5,729 | $462,000 | thousands by filing date | |
| POLARIS INC COM | 731068102 | Stock | 3,796 | $454,000 | thousands by filing date | |
| International Business Machines Corporation | 459200101 | COM | 3,259 | $453,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 8,520 | $429,000 | thousands by filing date | |
| MARTIN MARIETTA MATLS INC COM | 573284106 | Stock | 1,253 | $428,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 7,230 | $424,000 | thousands by filing date | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 2,834 | $423,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 3,730 | $418,000 | thousands by filing date | |
| SPY | 78462F103 | SHS | 963 | $413,000 | thousands by filing date | |
| BERKSHIRE HATHAWAY INC DEL | 084670108 | CL A | 1 | $411,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 1,204 | $409,000 | thousands by filing date | |
| PNC FINL SVCS GROUP INC COM | 693475105 | Stock | 2,079 | $407,000 | thousands by filing date | |
| ALLSTATE CORP COM | 020002101 | Stock | 3,056 | $389,000 | thousands by filing date | |
| ISHARES TR | 464287168 | COM | 3,260 | $374,000 | thousands by filing date | |
| Comcast Corp | 20030N101 | COM | 6,498 | $364,000 | thousands by filing date | |
| OWENS CORNING NEW | 690742101 | COM | 4,243 | $363,000 | thousands by filing date | |
| Raytheon Technologies Corporation | 75513E101 | COM | 4,146 | $356,000 | thousands by filing date | |
| TRUIST FINL CORP COM | 89832Q109 | Stock | 5,959 | $350,000 | thousands by filing date | |
| Boeing Company | 097023105 | COM | 1,467 | $323,000 | thousands by filing date | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 1,535 | $308,000 | thousands by filing date | |
| EVERGY INC COM | 30034W106 | Stock | 4,834 | $301,000 | thousands by filing date | |
| INVESCO S&P 500 TOP 50 ETF | 46137V233 | ETF | 910 | $300,000 | thousands by filing date | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 1,210 | $286,000 | thousands by filing date | |
| Netflix, Inc | 64110L106 | COM | 467 | $285,000 | thousands by filing date | |
| LINDE PLC | G5494J103 | SHS | 971 | $285,000 | thousands by filing date | |
| Salesforce.com, Inc | 79466L302 | COM | 1,026 | $278,000 | thousands by filing date | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 979 | $268,000 | thousands by filing date | |
| ENERGIZER HLDGS INC COM | 29272W109 | Stock | 6,830 | $267,000 | thousands by filing date | |
| Duke Energy Corporation | 26441C204 | COM | 2,680 | $261,000 | thousands by filing date | |
| TARGET CORP COM | 87612E106 | Stock | 1,129 | $259,000 | thousands by filing date | |
| INVESCO EXCH TRADED FD TR II | 46138E511 | PFD ETF | 16,890 | $254,000 | thousands by filing date | |
| CME Group Inc. Class A | 12572Q105 | COM | 1,271 | $245,000 | thousands by filing date | |
| DTE ENERGY CO COM | 233331107 | Stock | 2,180 | $244,000 | thousands by filing date | |
| Philip Morris International Inc. | 718172109 | COM | 2,519 | $238,000 | thousands by filing date | |
| LOEWS CORP COM | 540424108 | Stock | 4,216 | $228,000 | thousands by filing date | |
| Bristol-Myers Squibb Company | 110122108 | COM | 3,745 | $222,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 4,093 | $218,000 | thousands by filing date | |
| iShares Russell Midcap ETF | 464287499 | SHS | 2,761 | $216,000 | thousands by filing date | |
| EDGEWELL PERSONAL CARE CO | 28035Q102 | COM | 5,964 | $216,000 | thousands by filing date | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 1,665 | $212,000 | thousands by filing date | |
| Broadcom Inc. | 11135F101 | COM | 435 | $211,000 | thousands by filing date | |
| Intuit Inc. | 461202103 | COM | 390 | $210,000 | thousands by filing date | |
| SHERWIN WILLIAMS CO | 824348106 | COM | 752 | $210,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 685 | $201,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0000950123-21-014152 | this filing | 2021-11-08 | acceptance time not in the bulk data set |