13F-HR filed by MainStreet Investment Advisors LLC
MainStreet Investment Advisors LLC filed this 13F-HR for the quarter ended 2022-12-31, filed 2023-02-02, with 167 holding rows worth $895,687,734.
- Accession
- 0000950123-23-000669
- Filer
- CIK 1729854
- Filed
- 2023-02-02
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q4 2022
A holdings report, 168 entries on the cover page, a total value of $895,687,734 stated on the cover page (in dollars after the unit check, H1), rows summing to $895,687,737 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 | 294,828 | $71,315,945 | dollars as filed | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 892,489 | $58,582,978 | dollars as filed | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 376,737 | $35,654,390 | dollars as filed | |
| Apple Inc | 037833100 | COM | 256,277 | $33,298,071 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 138,618 | $33,243,369 | dollars as filed | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 85,028 | $32,668,608 | dollars as filed | |
| Vanguard Short-Term Treasury ETF | 92206C102 | SHS | 402,979 | $23,300,246 | dollars as filed | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 29,654 | $21,013,714 | dollars as filed | |
| PepsiCo,Inc. | 713448108 | COM | 109,839 | $19,843,514 | dollars as filed | |
| Procter & Gamble Co | 742718109 | COM | 128,730 | $19,510,319 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 109,711 | $19,380,448 | dollars as filed | |
| AbbVie,Inc. | 00287Y109 | COM | 116,774 | $18,871,846 | dollars as filed | |
| Honeywell Technologies | 438516106 | COM | 83,558 | $17,906,479 | dollars as filed | |
| Chevron Corporation | 166764100 | COM | 90,771 | $16,292,487 | dollars as filed | |
| Starbucks Corporation | 855244109 | COM | 151,891 | $15,067,587 | dollars as filed | |
| Home Depot, Inc | 437076102 | COM | 47,515 | $15,008,087 | dollars as filed | |
| VWO | 922042858 | SHS | 378,338 | $14,747,615 | dollars as filed | |
| JPMorgan Chase & Co | 46625H100 | COM | 109,392 | $14,669,467 | dollars as filed | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 157,425 | $13,889,608 | dollars as filed | |
| McDonalds Corporation | 580135101 | COM | 46,096 | $12,147,679 | dollars as filed | |
| MICROCHIP TECHNOLOGY INC. COM | 595017104 | Stock | 161,321 | $11,332,800 | dollars as filed | |
| Waste Management, Inc. | 94106L109 | COM | 69,587 | $10,916,808 | dollars as filed | |
| Pfizer Inc. | 717081103 | COM | 194,378 | $9,959,929 | dollars as filed | |
| CVS Health Corporation | 126650100 | COM | 103,466 | $9,641,997 | dollars as filed | |
| UnitedHealth Group Inc | 91324P102 | COM | 17,653 | $9,359,268 | dollars as filed | |
| PAYCHEX INC | 704326107 | COM | 77,470 | $8,952,434 | dollars as filed | |
| WW GRAINGER INC COM | 384802104 | Stock | 15,617 | $8,686,956 | dollars as filed | |
| Verizon Communications Inc | 92343V104 | COM | 220,045 | $8,669,773 | dollars as filed | |
| GENUINE PARTS CO COM | 372460105 | Stock | 48,161 | $8,356,415 | dollars as filed | |
| Lockheed Martin Corporation | 539830109 | COM | 17,149 | $8,342,817 | dollars as filed | |
| iShares Gold Trust | 464285204 | COM | 233,861 | $8,089,252 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 92,858 | $7,800,072 | dollars as filed | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 43,521 | $7,565,690 | dollars as filed | |
| Visa Inc | 92826C839 | COM | 35,581 | $7,392,309 | dollars as filed | |
| EMERSON ELEC CO COM | 291011104 | Stock | 74,575 | $7,163,675 | dollars as filed | |
| Accenture Plc Class A | G1151C101 | COM | 27,365 | $7,043,861 | dollars as filed | |
| Texas Instruments Incorporated | 882508104 | COM | 40,738 | $6,730,732 | dollars as filed | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 92,589 | $6,651,594 | dollars as filed | |
| Adobe Inc | 00724F101 | COM | 19,543 | $6,576,806 | dollars as filed | |
| Southern Company | 842587107 | COM | 92,031 | $6,571,933 | dollars as filed | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 104,126 | $6,418,327 | dollars as filed | |
| DOW HLDGS INC COM | 260557103 | Stock | 127,245 | $6,411,875 | dollars as filed | |
| Merck & Co.,Inc. | 58933Y105 | COM | 54,201 | $6,013,601 | dollars as filed | |
| USBANCORPDEL | 902973304 | COM NEW | 134,096 | $5,847,926 | dollars as filed | |
| EOG RES INC COM | 26875P101 | Stock | 44,419 | $5,753,149 | dollars as filed | |
| Cisco Systems,Inc. | 17275R102 | COM | 120,462 | $5,738,809 | dollars as filed | |
| NORTHROP GRUMMAN CORP COM | 666807102 | Stock | 10,156 | $5,541,215 | dollars as filed | |
| PRUDENTIAL FINL INC COM | 744320102 | Stock | 51,386 | $5,110,851 | dollars as filed | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 20,427 | $5,068,143 | dollars as filed | |
| HASBRO INC COM | 418056107 | Stock | 82,028 | $5,004,528 | dollars as filed | |
| Medtronic Plc | G5960L103 | COM | 60,881 | $4,731,672 | dollars as filed | |
| 3M CO COM | 88579Y101 | Stock | 38,208 | $4,581,903 | dollars as filed | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 149,450 | $4,390,841 | dollars as filed | |
| Altria Group Inc | 02209S103 | COM | 94,273 | $4,309,219 | dollars as filed | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 69,884 | $4,285,287 | dollars as filed | |
| INGREDION INC COM | 457187102 | Stock | 43,277 | $4,238,117 | dollars as filed | |
| Intercontinental Exchange,Inc. | 45866F104 | COM | 40,588 | $4,163,923 | dollars as filed | |
| Bank of America Corp | 060505104 | COM | 125,521 | $4,157,256 | dollars as filed | |
| Vanguard Real Estate | 922908553 | SHS | 50,167 | $4,137,774 | dollars as filed | |
| Morgan Stanley | 617446448 | COM | 48,448 | $4,119,049 | dollars as filed | |
| SELECT SECTOR SPDR TR | 81369Y100 | SBI MATERIALS | 49,848 | $3,872,193 | dollars as filed | |
| iShares MSCI EAFE Value ETF | 464288877 | SHS | 82,593 | $3,789,367 | dollars as filed | |
| ENBRIDGE INC COM | 29250N105 | Stock | 95,961 | $3,752,075 | dollars as filed | |
| CROWN CASTLE INC COM | 22822V101 | REIT | 27,561 | $3,738,374 | dollars as filed | |
| CADENCE DESIGN SYSTEM INC COM | 127387108 | Stock | 23,133 | $3,716,085 | dollars as filed | |
| TRUIST FINL CORP COM | 89832Q109 | Stock | 85,608 | $3,683,712 | dollars as filed | |
| Citigroup Inc. | 172967424 | COM | 81,315 | $3,677,877 | dollars as filed | |
| ZOETIS INC CL A | 98978V103 | Stock | 24,779 | $3,631,362 | dollars as filed | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 32,952 | $3,477,095 | dollars as filed | |
| MASCO CORP | 574599106 | COM | 73,977 | $3,452,506 | dollars as filed | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 47,199 | $3,361,513 | dollars as filed | |
| ISHARES TR | 464288257 | MSCI ACWI ETF | 39,060 | $3,315,413 | dollars as filed | |
| ISHARES TR | 464288513 | IBOXX HI YD ETF | 44,983 | $3,312,098 | dollars as filed | |
| JACOBS SOLUTIONS INC COM | 46982L108 | Stock | 25,120 | $3,016,158 | dollars as filed | |
| GENERAL MTRS CO COM | 37045V100 | Stock | 81,926 | $2,755,990 | dollars as filed | |
| Walt Disney Co | 254687106 | COM | 28,872 | $2,508,400 | dollars as filed | |
| Applied Materials,Inc. | 038222105 | COM | 25,719 | $2,504,516 | dollars as filed | |
| ISHARES SHORT-TERM NATIONAL MUNI BOND ETF | 464288158 | ETF | 23,811 | $2,482,773 | dollars as filed | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 51,856 | $2,421,675 | dollars as filed | |
| FREEPORT MCMORAN INC CL B | 35671D857 | Stock | 61,452 | $2,335,176 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C771 | SHS | 49,912 | $2,271,994 | dollars as filed | |
| PRINCIPAL EXCHANGE TRADED FD | 74255Y888 | SPECTRUM PFD | 111,609 | $1,909,630 | dollars as filed | |
| HEALTHPEAK PROPERTIES INC COM | 42250P103 | REIT | 69,669 | $1,746,602 | dollars as filed | |
| iShares Russell 2000 ETF | 464287655 | SHS | 9,686 | $1,688,851 | dollars as filed | |
| CINTAS CORP COM | 172908105 | Stock | 3,688 | $1,665,575 | dollars as filed | |
| WATERS CORP COM | 941848103 | Stock | 4,835 | $1,656,374 | dollars as filed | |
| PIMCO ETF TR | 72201R783 | 0-5 HIGH YIELD | 18,066 | $1,612,571 | dollars as filed | |
| MasterCard, Inc | 57636Q104 | COM | 4,356 | $1,514,712 | dollars as filed | |
| AMERIPRISE FINL INC COM | 03076C106 | Stock | 4,815 | $1,499,247 | dollars as filed | |
| AUTODESK INC COM | 052769106 | Stock | 7,717 | $1,442,076 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 14,853 | $1,317,907 | dollars as filed | |
| American Express Company | 025816109 | COM | 8,905 | $1,315,714 | dollars as filed | |
| Berkshire Hathaway Inc | 084670702 | COM | 4,135 | $1,277,301 | dollars as filed | |
| VanEck High Yield Muni ETF | 92189H409 | SHS | 23,143 | $1,169,879 | dollars as filed | |
| GARTNERINC | 366651107 | STOK | 3,320 | $1,115,985 | dollars as filed | |
| NEW YORK LIFE INVESTMENTS ET | 45409B800 | NYLI MERGER ARBI | 34,132 | $1,083,008 | dollars as filed | |
| AIR PRODS & CHEMS INC | 009158106 | COM | 3,250 | $1,001,845 | dollars as filed | |
| ILLINOIS TOOL WKS INC | 452308109 | COM | 4,370 | $962,711 | dollars as filed | |
| MID AMERICA APARTMENT COMMUNITIES INC. | 59522J103 | Common Stock, par value $0.01 per share | 5,990 | $940,370 | dollars as filed | |
| SILGAN HLDGS INC | 827048109 | COM | 18,012 | $933,742 | dollars as filed | |
| ZIONS BANCORPORATION | 989701107 | COM | 18,286 | $898,940 | dollars as filed | |
| iShares MSCI KLD 400 Social ETF | 464288570 | SHS | 12,313 | $883,950 | dollars as filed | |
| CHURCH & DWIGHT CO INC COM | 171340102 | Stock | 10,363 | $835,361 | dollars as filed | |
| Mondelez International,Inc. Class A | 609207105 | COM | 12,490 | $832,458 | dollars as filed | |
| AGILENT TECHNOLOGIES INC COM | 00846U101 | Stock | 5,541 | $829,211 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 7,511 | $828,463 | dollars as filed | |
| REINSURANCE GROUP AMER INC COM NEW | 759351604 | Stock | 5,503 | $781,921 | dollars as filed | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 15,633 | $730,217 | dollars as filed | |
| NIKE,Inc. Class B | 654106103 | COM | 6,171 | $722,069 | dollars as filed | |
| ISHARES TR | 46429B333 | GNMA BOND ETF | 16,450 | $715,657 | dollars as filed | |
| ESSEX PPTY TR INC COM | 297178105 | REIT | 3,320 | $703,574 | dollars as filed | |
| Amgen Inc. | 031162100 | COM | 2,666 | $700,198 | dollars as filed | |
| Deere & Company | 244199105 | COM | 1,608 | $689,446 | dollars as filed | |
| EXPEDITORS INTL WASH INC COM | 302130109 | Stock | 6,552 | $680,884 | dollars as filed | |
| ZIMMER BIOMET HOLDINGS INC COM | 98956P102 | Stock | 5,199 | $662,872 | dollars as filed | |
| ROCKWELL AUTOMATION INC COM | 773903109 | Stock | 2,534 | $652,682 | dollars as filed | |
| NASDAQ INC COM | 631103108 | Stock | 10,277 | $630,494 | dollars as filed | |
| Schwab U.S. Broad Market ETF | 808524102 | SHS | 13,882 | $622,052 | dollars as filed | |
| MARKELGROUPINC | 570535104 | STOK | 454 | $598,140 | dollars as filed | |
| VERISIGN INC COM | 92343E102 | Stock | 2,756 | $566,192 | dollars as filed | |
| SPY | 78462F103 | SHS | 1,427 | $545,728 | dollars as filed | |
| SCHEIN HENRY INC | 806407102 | COM | 6,600 | $527,142 | dollars as filed | |
| Lowes Companies,Inc. | 548661107 | COM | 2,512 | $500,491 | dollars as filed | |
| NextEra Energy,Inc. | 65339F101 | COM | 5,836 | $487,889 | dollars as filed | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 10,100 | $479,043 | dollars as filed | |
| OSHKOSH CORP COM | 688239201 | Stock | 5,097 | $449,504 | dollars as filed | |
| Coca-Cola Company | 191216100 | COM | 6,772 | $430,767 | dollars as filed | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 2,320 | $425,813 | dollars as filed | |
| COMERICAINC | 200340107 | COM | 6,345 | $424,163 | dollars as filed | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 6,165 | $421,070 | dollars as filed | |
| iShares S&P Mid-Cap 400 Value ETF | 464287705 | SHS | 4,170 | $420,336 | dollars as filed | |
| UMPQUA HOLDINGS | 904214103 | COM | 22,988 | $410,336 | dollars as filed | |
| POLARIS INC COM | 731068102 | Stock | 3,783 | $382,083 | dollars as filed | |
| AMETEK INC COM | 031100100 | Stock | 2,724 | $380,597 | dollars as filed | |
| META PLATFORMS INC CL A | 30303M102 | COM | 3,089 | $371,731 | dollars as filed | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 9,735 | $368,957 | dollars as filed | |
| NVIDIA Corp | 67066G104 | COM | 2,507 | $366,373 | dollars as filed | |
| Abbott Laboratories | 002824100 | COM | 3,294 | $361,648 | dollars as filed | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 7,209 | $352,808 | dollars as filed | |
| INVESCO EXCH TRADED FD TR II | 46138E511 | PFD ETF | 31,475 | $351,891 | dollars as filed | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 2,800 | $348,432 | dollars as filed | |
| OWENS CORNING NEW | 690742101 | COM | 4,072 | $347,342 | dollars as filed | |
| Raytheon Technologies Corporation | 75513E101 | COM | 3,320 | $335,054 | dollars as filed | |
| BORGWARNER INC COM | 099724106 | Stock | 8,318 | $334,800 | dollars as filed | |
| Oracle Corporation | 68389X105 | COM | 4,010 | $327,778 | dollars as filed | |
| MARTIN MARIETTA MATLS INC COM | 573284106 | Stock | 928 | $313,636 | dollars as filed | |
| ALLSTATE CORP COM | 020002101 | Stock | 2,298 | $311,608 | dollars as filed | |
| ISHARES TR | 464287168 | COM | 2,536 | $305,842 | dollars as filed | |
| Tesla Motors, Inc | 88160R101 | COM | 2,482 | $305,733 | dollars as filed | |
| LITTELFUSE INC COM | 537008104 | Stock | 1,388 | $305,638 | dollars as filed | |
| EVERGY INC COM | 30034W106 | Stock | 4,809 | $302,630 | dollars as filed | |
| MANHATTAN ASSOCIATES INC COM | 562750109 | Stock | 2,380 | $288,932 | dollars as filed | |
| Boeing Company | 097023105 | COM | 1,505 | $286,687 | dollars as filed | |
| FLOOR & DECOR HLDGS INC CL A | 339750101 | Stock | 4,066 | $283,116 | dollars as filed | |
| Costco Wholesale Corporation | 22160K105 | COM | 613 | $279,834 | dollars as filed | |
| WILLIAMS SONOMA INC COM | 969904101 | Stock | 2,322 | $266,844 | dollars as filed | |
| PNC FINL SVCS GROUP INC COM | 693475105 | Stock | 1,663 | $262,655 | dollars as filed | |
| International Business Machines Corporation | 459200101 | COM | 1,824 | $256,983 | dollars as filed | |
| INVESCO S&P 500 TOP 50 ETF | 46137V233 | ETF | 910 | $251,142 | dollars as filed | |
| LOEWS CORP COM | 540424108 | Stock | 4,181 | $243,878 | dollars as filed | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 1,395 | $243,009 | dollars as filed | |
| Bristol-Myers Squibb Company | 110122108 | COM | 3,245 | $233,478 | dollars as filed | |
| V F CORP COM | 918204108 | Stock | 8,235 | $227,369 | dollars as filed | |
| LINDE PLC | G5494J103 | SHS | 654 | $213,322 | dollars as filed | |
| Broadcom Inc. | 11135F101 | COM | 374 | $209,115 | dollars as filed | |
| Stryker Corporation | 863667101 | COM | 840 | $205,372 | dollars as filed | |
| ENERPAC TOOL GROUP CORP CL A COM | 292765104 | Stock | 7,971 | $202,862 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0000950123-23-000669 | this filing | 2023-02-02 | acceptance time not in the bulk data set |