13F-HR/A filed by MainStreet Investment Advisors LLC
MainStreet Investment Advisors LLC filed this 13F-HR/A for the quarter ended 2023-06-30, filed 2024-02-16, with 177 holding rows worth $921,432,168.
- Accession
- 0000950123-24-002692
- Filer
- CIK 1729854
- Filed
- 2024-02-16
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2023
A holdings report, amendment of type restatement, 178 entries on the cover page, a total value of $921,432,168 stated on the cover page (in dollars after the unit check, H1), rows summing to $921,432,168 with VALUE read as dollars as filed, 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 | 271,651 | $71,031,400 | dollars as filed | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 853,318 | $61,865,555 | dollars as filed | |
| Apple Inc | 037833100 | COM | 248,201 | $48,143,642 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 134,551 | $45,819,998 | dollars as filed | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 369,640 | $36,834,583 | dollars as filed | |
| Vanguard Short-Term Treasury ETF | 92206C102 | SHS | 523,058 | $30,196,138 | dollars as filed | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 57,098 | $25,449,254 | dollars as filed | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 29,322 | $20,265,607 | dollars as filed | |
| PepsiCo,Inc. | 713448108 | COM | 109,368 | $20,257,141 | dollars as filed | |
| Procter & Gamble Co | 742718109 | COM | 127,452 | $19,339,566 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 110,071 | $18,218,952 | dollars as filed | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 150,018 | $17,957,155 | dollars as filed | |
| Honeywell Technologies | 438516106 | COM | 81,022 | $16,812,065 | dollars as filed | |
| AbbVie,Inc. | 00287Y109 | COM | 117,060 | $15,771,494 | dollars as filed | |
| JPMorgan Chase & Co | 46625H100 | COM | 106,855 | $15,540,991 | dollars as filed | |
| VWO | 922042858 | SHS | 363,576 | $14,790,256 | dollars as filed | |
| Home Depot, Inc | 437076102 | COM | 47,527 | $14,763,787 | dollars as filed | |
| Starbucks Corporation | 855244109 | COM | 146,513 | $14,513,578 | dollars as filed | |
| Chevron Corporation | 166764100 | COM | 91,563 | $14,407,438 | dollars as filed | |
| MICROCHIP TECHNOLOGY INC. COM | 595017104 | Stock | 159,238 | $14,266,132 | dollars as filed | |
| McDonalds Corporation | 580135101 | COM | 45,866 | $13,686,873 | dollars as filed | |
| Waste Management, Inc. | 94106L109 | COM | 67,929 | $11,780,248 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 89,349 | $11,647,535 | dollars as filed | |
| Caterpillar Inc. | 149123101 | COM | 39,943 | $9,827,975 | dollars as filed | |
| Adobe Inc | 00724F101 | COM | 18,862 | $9,223,330 | dollars as filed | |
| Accenture Plc Class A | G1151C101 | COM | 63,671 | $9,142,514 | dollars as filed | |
| PAYCHEX INC | 704326107 | COM | 76,898 | $8,602,579 | dollars as filed | |
| Verizon Communications Inc | 92343V104 | COM | 227,962 | $8,477,907 | dollars as filed | |
| UnitedHealth Group Inc | 91324P102 | COM | 17,325 | $8,327,088 | dollars as filed | |
| Visa Inc | 92826C839 | COM | 34,879 | $8,283,065 | dollars as filed | |
| GENUINE PARTS CO COM | 372460105 | Stock | 48,777 | $8,254,531 | dollars as filed | |
| Lockheed Martin Corporation | 539830109 | COM | 16,874 | $7,768,452 | dollars as filed | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 42,596 | $7,635,333 | dollars as filed | |
| CVS Health Corporation | 126650100 | COM | 107,990 | $7,465,349 | dollars as filed | |
| Merck & Co.,Inc. | 58933Y105 | COM | 63,401 | $7,315,841 | dollars as filed | |
| Pfizer Inc. | 717081103 | COM | 192,750 | $7,070,070 | dollars as filed | |
| Texas Instruments Incorporated | 882508104 | COM | 39,137 | $7,045,443 | dollars as filed | |
| EMERSON ELEC CO COM | 291011104 | Stock | 77,799 | $7,032,252 | dollars as filed | |
| DOW HLDGS INC COM | 260557103 | Stock | 130,685 | $6,960,283 | dollars as filed | |
| Southern Company | 842587107 | COM | 92,684 | $6,511,051 | dollars as filed | |
| Cisco Systems,Inc. | 17275R102 | COM | 121,115 | $6,266,490 | dollars as filed | |
| iShares Gold Trust | 464285204 | COM | 155,845 | $5,671,200 | dollars as filed | |
| CADENCE DESIGN SYSTEM INC COM | 127387108 | Stock | 23,895 | $5,603,855 | dollars as filed | |
| Medtronic Plc | G5960L103 | COM | 62,580 | $5,513,298 | dollars as filed | |
| EOG RES INC COM | 26875P101 | Stock | 45,752 | $5,235,859 | dollars as filed | |
| MARRIOTT INTL INC NEW CL A | 571903202 | Stock | 26,466 | $4,861,540 | dollars as filed | |
| PRUDENTIAL FINL INC COM | 744320102 | Stock | 53,918 | $4,756,646 | dollars as filed | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 69,736 | $4,707,180 | dollars as filed | |
| INGREDION INC COM | 457187102 | Stock | 44,401 | $4,704,286 | dollars as filed | |
| Intercontinental Exchange,Inc. | 45866F104 | COM | 39,728 | $4,492,442 | dollars as filed | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 61,536 | $4,473,052 | dollars as filed | |
| USBANCORPDEL | 902973304 | COM NEW | 131,525 | $4,345,586 | dollars as filed | |
| Altria Group Inc | 02209S103 | COM | 94,751 | $4,292,220 | dollars as filed | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 19,383 | $4,170,252 | dollars as filed | |
| Applied Materials,Inc. | 038222105 | COM | 28,701 | $4,148,442 | dollars as filed | |
| ZOETIS INC CL A | 98978V103 | Stock | 23,764 | $4,092,398 | dollars as filed | |
| PUBLIC STORAGE COM | 74460D109 | REIT | 13,964 | $4,075,813 | dollars as filed | |
| SELECT SECTOR SPDR TR | 81369Y100 | SBI MATERIALS | 47,445 | $3,931,767 | dollars as filed | |
| AMERICAN ELEC PWR CO INC COM | 025537101 | Stock | 45,502 | $3,831,268 | dollars as filed | |
| Deere & Company | 244199105 | COM | 9,404 | $3,810,407 | dollars as filed | |
| 3M CO COM | 88579Y101 | Stock | 37,440 | $3,747,370 | dollars as filed | |
| ENBRIDGE INC COM | 29250N105 | Stock | 99,922 | $3,712,102 | dollars as filed | Value about 1,000 times the price other filers imply, kept as filed and left out of ratios. |
| Citigroup Inc. | 172967424 | COM | 77,899 | $3,586,470 | dollars as filed | Value about 1,000 times the price other filers imply, kept as filed and left out of ratios. |
| Bank of America Corp | 060505104 | COM | 121,936 | $3,498,344 | dollars as filed | |
| ISHARES TR | 464288257 | MSCI ACWI ETF | 36,132 | $3,466,504 | dollars as filed | |
| CROWN CASTLE INC COM | 22822V101 | REIT | 29,373 | $3,346,759 | dollars as filed | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 45,236 | $3,018,599 | dollars as filed | |
| JACOBS SOLUTIONS INC COM | 46982L108 | Stock | 25,235 | $3,000,189 | dollars as filed | |
| Walt Disney Co | 254687106 | COM | 33,552 | $2,995,522 | dollars as filed | |
| GENERAL MTRS CO COM | 37045V100 | Stock | 76,088 | $2,933,953 | dollars as filed | |
| TRUIST FINL CORP COM | 89832Q109 | Stock | 96,422 | $2,926,408 | dollars as filed | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 98,697 | $2,905,640 | dollars as filed | |
| NextEra Energy,Inc. | 65339F101 | COM | 37,524 | $2,784,281 | dollars as filed | |
| CUMMINS INC COM | 231021106 | Stock | 11,196 | $2,744,812 | dollars as filed | |
| FREEPORT MCMORAN INC CL B | 35671D857 | Stock | 65,478 | $2,619,120 | dollars as filed | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 23,916 | $2,552,555 | dollars as filed | |
| Vanguard Real Estate | 922908553 | SHS | 28,029 | $2,342,103 | dollars as filed | |
| ISHARES TR | 464288513 | IBOXX HI YD ETF | 27,575 | $2,070,055 | dollars as filed | |
| ISHARES SHORT-TERM NATIONAL MUNI BOND ETF | 464288158 | ETF | 19,106 | $1,987,788 | dollars as filed | |
| American Express Company | 025816109 | COM | 10,895 | $1,897,909 | dollars as filed | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 35,243 | $1,737,127 | dollars as filed | |
| CINTAS CORP COM | 172908105 | Stock | 3,467 | $1,723,376 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 13,662 | $1,652,692 | dollars as filed | |
| AMERIPRISE FINL INC COM | 03076C106 | Stock | 4,766 | $1,583,074 | dollars as filed | |
| AUTODESK INC COM | 052769106 | Stock | 7,425 | $1,519,229 | dollars as filed | |
| MasterCard, Inc | 57636Q104 | COM | 3,699 | $1,454,816 | dollars as filed | |
| iShares Russell 2000 ETF | 464287655 | SHS | 7,540 | $1,412,016 | dollars as filed | Value about 1,000 times the price other filers imply, kept as filed and left out of ratios. |
| WATERS CORP COM | 941848103 | Stock | 4,784 | $1,275,127 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C771 | SHS | 27,540 | $1,266,565 | dollars as filed | |
| iShares MSCI KLD 400 Social ETF | 464288570 | SHS | 14,075 | $1,184,693 | dollars as filed | |
| VanEck High Yield Muni ETF | 92189H409 | SHS | 21,278 | $1,092,413 | dollars as filed | |
| Berkshire Hathaway Inc | 084670702 | COM | 3,144 | $1,072,104 | dollars as filed | |
| PRINCIPAL EXCHANGE TRADED FD | 74255Y888 | SPECTRUM PFD | 62,840 | $1,065,138 | dollars as filed | |
| GARTNERINC | 366651107 | STOK | 3,024 | $1,059,337 | dollars as filed | |
| NVIDIA Corp | 67066G104 | COM | 2,459 | $1,040,206 | dollars as filed | |
| ILLINOIS TOOL WKS INC | 452308109 | COM | 4,144 | $1,036,663 | dollars as filed | |
| CHURCH & DWIGHT CO INC COM | 171340102 | Stock | 10,145 | $1,016,833 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 9,176 | $984,126 | dollars as filed | |
| MID AMERICA APARTMENT COMMUNITIES INC. | 59522J103 | Common Stock, par value $0.01 per share | 6,462 | $981,319 | dollars as filed | |
| AIR PRODS & CHEMS INC | 009158106 | COM | 3,194 | $956,699 | dollars as filed | |
| META PLATFORMS INC CL A | 30303M102 | COM | 3,024 | $867,828 | dollars as filed | |
| SILGAN HLDGS INC | 827048109 | COM | 17,755 | $832,532 | dollars as filed | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 10,776 | $808,200 | dollars as filed | |
| iShares S&P Mid-Cap 400 Value ETF | 464287705 | SHS | 7,403 | $793,083 | dollars as filed | |
| Mondelez International,Inc. Class A | 609207105 | COM | 10,791 | $787,096 | dollars as filed | |
| EXPEDITORS INTL WASH INC COM | 302130109 | Stock | 6,450 | $781,288 | dollars as filed | |
| ESSEX PPTY TR INC COM | 297178105 | REIT | 3,273 | $766,864 | dollars as filed | |
| REINSURANCE GROUP AMER INC COM NEW | 759351604 | Stock | 5,488 | $761,131 | dollars as filed | |
| ROCKWELL AUTOMATION INC COM | 773903109 | Stock | 2,287 | $753,452 | dollars as filed | |
| ISHARES MSCI EAFE GROWTH ETF | 464288885 | ETF | 7,702 | $734,848 | dollars as filed | |
| ZIMMER BIOMET HOLDINGS INC COM | 98956P102 | Stock | 4,949 | $720,574 | dollars as filed | |
| Schwab U.S. Broad Market ETF | 808524102 | SHS | 13,882 | $717,699 | dollars as filed | |
| PIMCO ETF TR | 72201R783 | 0-5 HIGH YIELD | 7,800 | $711,279 | dollars as filed | |
| Amgen Inc. | 031162100 | COM | 3,086 | $685,154 | dollars as filed | |
| Automatic Data Processing,Inc. | 053015103 | COM | 3,081 | $677,173 | dollars as filed | |
| NIKE,Inc. Class B | 654106103 | COM | 6,090 | $672,154 | dollars as filed | |
| AGILENT TECHNOLOGIES INC COM | 00846U101 | Stock | 5,576 | $670,514 | dollars as filed | |
| Tesla Motors, Inc | 88160R101 | COM | 2,535 | $663,587 | dollars as filed | |
| Coca-Cola Company | 191216100 | COM | 10,661 | $642,005 | dollars as filed | |
| Eli Lilly and Company | 532457108 | COM | 1,322 | $619,992 | dollars as filed | |
| MARKELGROUPINC | 570535104 | STOK | 439 | $607,216 | dollars as filed | |
| ConocoPhillips | 20825C104 | COM | 5,577 | $577,833 | dollars as filed | |
| ISHARES TR | 46429B333 | GNMA BOND ETF | 13,099 | $574,260 | dollars as filed | |
| SHERWIN WILLIAMS CO | 824348106 | COM | 2,114 | $561,310 | dollars as filed | |
| OWENS CORNING NEW | 690742101 | COM | 4,163 | $543,272 | dollars as filed | |
| S&P Global,Inc. | 78409V104 | COM | 1,342 | $537,994 | dollars as filed | |
| SCHEIN HENRY INC | 806407102 | COM | 6,488 | $526,177 | dollars as filed | |
| MANHATTAN ASSOCIATES INC COM | 562750109 | Stock | 2,509 | $501,499 | dollars as filed | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 10,100 | $493,688 | dollars as filed | |
| MASCO CORP | 574599106 | COM | 8,540 | $490,025 | dollars as filed | |
| VERISIGN INC COM | 92343E102 | Stock | 2,147 | $485,158 | dollars as filed | |
| HERSHEY CO COM | 427866108 | Stock | 1,896 | $473,431 | dollars as filed | |
| Raytheon Technologies Corporation | 75513E101 | COM | 4,734 | $463,743 | dollars as filed | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 2,664 | $463,163 | dollars as filed | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 2,320 | $461,425 | dollars as filed | |
| FLOOR & DECOR HLDGS INC CL A | 339750101 | Stock | 4,333 | $450,459 | dollars as filed | |
| MARTIN MARIETTA MATLS INC COM | 573284106 | Stock | 974 | $449,686 | dollars as filed | |
| POLARIS INC COM | 731068102 | Stock | 3,718 | $449,618 | dollars as filed | |
| Lowes Companies,Inc. | 548661107 | COM | 1,983 | $447,563 | dollars as filed | |
| OSHKOSH CORP COM | 688239201 | Stock | 5,130 | $444,207 | dollars as filed | |
| WW GRAINGER INC COM | 384802104 | Stock | 557 | $439,245 | dollars as filed | |
| LITTELFUSE INC COM | 537008104 | Stock | 1,497 | $436,091 | dollars as filed | |
| iShares MSCI EAFE Value ETF | 464288877 | SHS | 8,716 | $426,561 | dollars as filed | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 10,483 | $414,707 | dollars as filed | |
| Oracle Corporation | 68389X105 | COM | 3,465 | $412,647 | dollars as filed | |
| ZIONS BANCORPORATION | 989701107 | COM | 15,276 | $410,313 | dollars as filed | |
| BORGWARNER INC COM | 099724106 | Stock | 9,030 | $389,727 | dollars as filed | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 7,409 | $389,047 | dollars as filed | |
| SMUCKER J M CO | 832696405 | COM NEW | 2,599 | $383,794 | dollars as filed | |
| INVESCO EXCH TRADED FD TR II | 46138E511 | PFD ETF | 33,410 | $379,872 | dollars as filed | |
| MCCORMICK & CO INC COM NON VTG | 579780206 | Stock | 4,314 | $376,310 | dollars as filed | |
| AMETEK INC COM | 031100100 | Stock | 2,281 | $369,248 | dollars as filed | |
| Intel Corp | 458140100 | COM | 10,995 | $367,673 | dollars as filed | |
| Walmart Inc. | 931142103 | COM | 2,309 | $362,929 | dollars as filed | |
| Bristol-Myers Squibb Company | 110122108 | COM | 5,624 | $359,655 | dollars as filed | |
| BECTON DICKINSON & CO | 075887109 | COM | 1,339 | $353,509 | dollars as filed | |
| NASDAQ INC COM | 631103108 | Stock | 7,061 | $351,991 | dollars as filed | |
| Abbott Laboratories | 002824100 | COM | 3,115 | $339,597 | dollars as filed | |
| COLGATE PALMOLIVE CO COM | 194162103 | Stock | 4,316 | $332,504 | dollars as filed | |
| ISHARES TR | 464287168 | COM | 2,930 | $331,969 | dollars as filed | |
| Broadcom Inc. | 11135F101 | COM | 380 | $329,623 | dollars as filed | |
| HASBRO INC COM | 418056107 | Stock | 5,035 | $326,117 | dollars as filed | |
| INVESCO S&P 500 TOP 50 ETF | 46137V233 | ETF | 910 | $318,254 | dollars as filed | |
| Costco Wholesale Corporation | 22160K105 | COM | 576 | $310,107 | dollars as filed | |
| International Business Machines Corporation | 459200101 | COM | 2,289 | $306,291 | dollars as filed | |
| WILLIAMS SONOMA INC COM | 969904101 | Stock | 2,424 | $303,339 | dollars as filed | |
| SPY | 78462F103 | SHS | 678 | $300,544 | dollars as filed | Value about 1,000 times the price other filers imply, kept as filed and left out of ratios. |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 4,060 | $286,149 | dollars as filed | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 1,395 | $282,794 | dollars as filed | |
| EVERGY INC COM | 30034W106 | Stock | 4,751 | $277,553 | dollars as filed | |
| COMERICAINC | 200340107 | COM | 6,135 | $259,878 | dollars as filed | |
| HEALTHPEAK PROPERTIES INC COM | 42250P103 | REIT | 11,427 | $229,683 | dollars as filed | |
| Goldman Sachs Group,Inc. | 38141G104 | COM | 680 | $219,328 | dollars as filed | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 2,260 | $218,384 | dollars as filed | |
| ENERPAC TOOL GROUP CORP CL A COM | 292765104 | Stock | 7,945 | $214,515 | dollars as filed | |
| AT&T Inc | 00206R102 | COM | 13,346 | $212,869 | dollars as filed | |
| LOEWS CORP COM | 540424108 | Stock | 3,447 | $204,683 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0000950123-23-006224 | superseded | 2023-07-21 | acceptance time not in the bulk data set | |
| 13F-HR/A 0000950123-24-002692 | this filing | 2024-02-16 | acceptance time not in the bulk data set |