13F-HR filed by MainStreet Investment Advisors LLC
MainStreet Investment Advisors LLC filed this 13F-HR for the quarter ended 2017-12-31, filed 2018-02-15, with 161 holding rows worth $653,014,000.
- Accession
- 0001398344-18-002449
- Filer
- CIK 1729854
- Filed
- 2018-02-15
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q4 2017
A holdings report, 161 entries on the cover page, a total value of $653,014,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $653,012,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 | 366,660 | $69,585,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 865,602 | $60,860,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 447,782 | $34,394,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 354,034 | $29,378,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 626,275 | $28,752,000 | thousands by filing date | |
| DBX ETF TR | 233051200 | XTRACK MSCI EAFE | 728,009 | $23,136,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 88,204 | $14,927,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 94,692 | $13,230,000 | thousands by filing date | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 25,648 | $13,176,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 133,511 | $11,421,000 | thousands by filing date | |
| 3M CO COM | 88579Y101 | Stock | 44,488 | $10,471,000 | thousands by filing date | |
| Home Depot, Inc | 437076102 | COM | 54,184 | $10,269,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 111,510 | $10,246,000 | thousands by filing date | |
| JPMorgan Chase & Co | 46625H100 | COM | 86,920 | $9,295,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 8,765 | $9,233,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 72,630 | $9,093,000 | thousands by filing date | |
| PepsiCo,Inc. | 713448108 | COM | 74,757 | $8,965,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 56,086 | $8,601,000 | thousands by filing date | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 31,784 | $8,545,000 | thousands by filing date | |
| MICROCHIP TECHNOLOGY INC. COM | 595017104 | Stock | 92,442 | $8,124,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 40,826 | $8,093,000 | thousands by filing date | |
| AbbVie,Inc. | 00287Y109 | COM | 83,076 | $8,034,000 | thousands by filing date | |
| Pfizer Inc. | 717081103 | COM | 215,717 | $7,813,000 | thousands by filing date | |
| HASBRO INC COM | 418056107 | Stock | 80,079 | $7,278,000 | thousands by filing date | |
| Lowes Companies,Inc. | 548661107 | COM | 71,941 | $6,686,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 38,152 | $6,567,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 5,477 | $6,405,000 | thousands by filing date | |
| PRICELINE GRP INC | 741503403 | COM NEW | 3,680 | $6,395,000 | thousands by filing date | |
| Altria Group Inc | 02209S103 | COM | 84,041 | $6,001,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 104,058 | $5,575,000 | thousands by filing date | |
| DOWDUPONT INC | 26078J100 | COM | 74,899 | $5,334,000 | thousands by filing date | |
| Union Pacific Corporation | 907818108 | COM | 39,666 | $5,319,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 63,350 | $5,299,000 | thousands by filing date | |
| Waste Management, Inc. | 94106L109 | COM | 61,323 | $5,292,000 | thousands by filing date | |
| PAYCHEX INC | 704326107 | COM | 76,630 | $5,217,000 | thousands by filing date | |
| KRAFT HEINZ CO COM | 500754106 | Stock | 66,005 | $5,133,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 108,021 | $4,986,000 | thousands by filing date | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 39,562 | $4,714,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 87,972 | $4,656,000 | thousands by filing date | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 56,905 | $4,613,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 54,650 | $4,413,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 57,980 | $4,268,000 | thousands by filing date | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 20,164 | $4,102,000 | thousands by filing date | |
| Citigroup Inc. | 172967424 | COM | 55,076 | $4,098,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 102,322 | $3,978,000 | thousands by filing date | |
| BIOGEN INC COM | 09062X103 | Stock | 11,539 | $3,676,000 | thousands by filing date | |
| Oracle Corporation | 68389X105 | COM | 77,626 | $3,670,000 | thousands by filing date | |
| Philip Morris International Inc. | 718172109 | COM | 34,612 | $3,657,000 | thousands by filing date | |
| Starbucks Corporation | 855244109 | COM | 62,169 | $3,570,000 | thousands by filing date | |
| American Express Company | 025816109 | COM | 33,814 | $3,358,000 | thousands by filing date | |
| GENUINE PARTS CO COM | 372460105 | Stock | 34,414 | $3,270,000 | thousands by filing date | |
| ConocoPhillips | 20825C104 | COM | 58,395 | $3,205,000 | thousands by filing date | |
| CERNER CORP | 156782104 | COM | 46,919 | $3,162,000 | thousands by filing date | |
| Adobe Inc | 00724F101 | COM | 17,898 | $3,136,000 | thousands by filing date | |
| EXPRESS SCRIPTS HLDG CO | 30219G108 | COM | 40,327 | $3,010,000 | thousands by filing date | |
| MCKESSON CORP COM | 58155Q103 | Stock | 19,272 | $3,005,000 | thousands by filing date | |
| Southern Company | 842587107 | COM | 58,560 | $2,816,000 | thousands by filing date | |
| GENERAL ELEC CO | 369604103 | COM | 160,746 | $2,805,000 | thousands by filing date | |
| HALLIBURTON CO COM | 406216101 | Stock | 57,156 | $2,793,000 | thousands by filing date | |
| WW GRAINGER INC COM | 384802104 | Stock | 11,088 | $2,620,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 45,532 | $2,599,000 | thousands by filing date | |
| ENBRIDGE INC COM | 29250N105 | Stock | 65,256 | $2,552,000 | thousands by filing date | |
| CME Group Inc. Class A | 12572Q105 | COM | 16,959 | $2,477,000 | thousands by filing date | |
| MasterCard, Inc | 57636Q104 | COM | 15,672 | $2,372,000 | thousands by filing date | |
| Visa Inc | 92826C839 | COM | 20,625 | $2,352,000 | thousands by filing date | |
| Utilities Select Sector SPDR Fund | 81369Y886 | SHS | 43,778 | $2,306,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y100 | SBI MATERIALS | 36,630 | $2,217,000 | thousands by filing date | |
| COMPASS MINERALS INTL INC | 20451N101 | COM | 29,040 | $2,098,000 | thousands by filing date | |
| POWERSHARES | 73936Q769 | EXCHANGE TRADED | 81,420 | $1,876,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 49,950 | $1,519,000 | thousands by filing date | |
| Lockheed Martin Corporation | 539830109 | COM | 4,430 | $1,422,000 | thousands by filing date | |
| BJS RESTAURANTS INC | 09180C106 | COM | 38,608 | $1,405,000 | thousands by filing date | |
| CINTAS CORP COM | 172908105 | Stock | 8,325 | $1,297,000 | thousands by filing date | |
| AMERIPRISE FINL INC COM | 03076C106 | Stock | 7,347 | $1,245,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 1,165 | $1,219,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 6,354 | $1,121,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 7,211 | $1,099,000 | thousands by filing date | |
| ZIONS BANCORPORATION | 989701107 | COM | 21,481 | $1,092,000 | thousands by filing date | |
| CONAGRA FOODS INC | 205887102 | COM | 28,507 | $1,074,000 | thousands by filing date | |
| REINSURANCE GROUP AMER INC COM NEW | 759351604 | Stock | 6,755 | $1,053,000 | thousands by filing date | |
| MARKELGROUPINC | 570535104 | STOK | 829 | $944,000 | thousands by filing date | |
| VERISIGN INC COM | 92343E102 | Stock | 8,146 | $932,000 | thousands by filing date | |
| ISHARES TR | 464288372 | COM | 20,570 | $930,000 | thousands by filing date | |
| Cisco Systems,Inc. | 17275R102 | COM | 24,161 | $925,000 | thousands by filing date | |
| ESSEX PPTY TR INC COM | 297178105 | REIT | 3,716 | $897,000 | thousands by filing date | |
| ROCKWELL COLLINS INC | 774341101 | COM | 6,473 | $878,000 | thousands by filing date | |
| AMETEK INC COM | 031100100 | Stock | 12,071 | $875,000 | thousands by filing date | |
| NextEra Energy,Inc. | 65339F101 | COM | 5,569 | $870,000 | thousands by filing date | |
| MARTIN MARIETTA MATLS INC COM | 573284106 | Stock | 3,921 | $867,000 | thousands by filing date | |
| WATERS CORP COM | 941848103 | Stock | 4,317 | $834,000 | thousands by filing date | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 10,185 | $831,000 | thousands by filing date | |
| CHURCH & DWIGHT CO INC COM | 171340102 | Stock | 16,461 | $826,000 | thousands by filing date | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 15,000 | $816,000 | thousands by filing date | |
| NASDAQ INC COM | 631103108 | Stock | 10,328 | $794,000 | thousands by filing date | |
| V F CORP COM | 918204108 | Stock | 10,690 | $791,000 | thousands by filing date | |
| OSHKOSH CORP COM | 688239201 | Stock | 8,708 | $791,000 | thousands by filing date | |
| Boeing Company | 097023105 | COM | 2,580 | $761,000 | thousands by filing date | |
| UMPQUA HOLDINGS | 904214103 | COM | 34,619 | $720,000 | thousands by filing date | |
| ISHARES TR | 46429B333 | GNMA BOND ETF | 14,205 | $703,000 | thousands by filing date | |
| GARTNERINC | 366651107 | STOK | 5,643 | $695,000 | thousands by filing date | |
| AUTODESK INC COM | 052769106 | Stock | 6,594 | $691,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 13,087 | $681,000 | thousands by filing date | |
| F5 INC COM | 315616102 | Stock | 5,141 | $675,000 | thousands by filing date | |
| CIMAREX ENERGY CO COM | 171798101 | Stock | 5,325 | $650,000 | thousands by filing date | |
| POLARIS INC COM | 731068102 | Stock | 5,174 | $642,000 | thousands by filing date | |
| SCHEIN HENRY INC | 806407102 | COM | 8,256 | $577,000 | thousands by filing date | |
| OWENS CORNING NEW | 690742101 | COM | 6,247 | $574,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 10,145 | $571,000 | thousands by filing date | |
| ZIMMER BIOMET HOLDINGS INC COM | 98956P102 | Stock | 4,635 | $559,000 | thousands by filing date | |
| JACOBS ENGINEERING GROUP INC | 469814107 | COM | 8,117 | $535,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 11,260 | $531,000 | thousands by filing date | |
| ANDEAVOR | 03349M105 | COM | 4,620 | $528,000 | thousands by filing date | |
| EXACT SCIENCES CORP COM | 30063P105 | Stock | 10,000 | $525,000 | thousands by filing date | |
| Schwab U.S. Broad Market ETF | 808524102 | SHS | 7,916 | $511,000 | thousands by filing date | |
| UNITED TECHNOLOGIES CORP | 913017109 | COM | 3,730 | $476,000 | thousands by filing date | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 9,538 | $466,000 | thousands by filing date | |
| SILGAN HLDGS INC | 827048109 | COM | 15,858 | $466,000 | thousands by filing date | |
| CA INC COM | 12673P105 | COM | 13,166 | $438,000 | thousands by filing date | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 2,826 | $437,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 2,897 | $428,000 | thousands by filing date | |
| Deere & Company | 244199105 | COM | 2,440 | $382,000 | thousands by filing date | |
| WESTAR ENERGY INC | 95709T100 | COMMON STOCK | 7,109 | $375,000 | thousands by filing date | |
| LABORATORY CORP OF AMERICA | 50540R409 | COM NEW | 2,254 | $360,000 | thousands by filing date | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 7,605 | $341,000 | thousands by filing date | |
| PHILLIPS 66 COM | 718546104 | Stock | 3,317 | $336,000 | thousands by filing date | |
| ROCKWELL AUTOMATION INC COM | 773903109 | Stock | 1,652 | $324,000 | thousands by filing date | |
| PNC FINL SVCS GROUP INC COM | 693475105 | Stock | 2,240 | $323,000 | thousands by filing date | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 4,997 | $320,000 | thousands by filing date | |
| NORTHROP GRUMMAN CORP COM | 666807102 | Stock | 1,024 | $314,000 | thousands by filing date | |
| ACTUANT CORP | 00508X203 | CL A NEW | 12,385 | $313,000 | thousands by filing date | |
| ISHARES TR | 464287713 | US TELECOM ETF | 10,250 | $301,000 | thousands by filing date | |
| CARPENTER TECHNOLOGY CORP | 144285103 | COM | 5,888 | $300,000 | thousands by filing date | |
| ENERGIZER HLDGS INC COM | 29272W109 | Stock | 6,223 | $299,000 | thousands by filing date | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 2,188 | $295,000 | thousands by filing date | |
| RYDEX ETF TRUST TOP 50 ETF | 78355W205 | COM | 1,530 | $291,000 | thousands by filing date | |
| Amgen Inc. | 031162100 | COM | 1,662 | $289,000 | thousands by filing date | |
| POWERSHARES ETF TR II S&P500 L | 73937B779 | COM | 6,046 | $289,000 | thousands by filing date | |
| EDGEWELL PERSONAL CARE CO | 28035Q102 | COM | 4,825 | $287,000 | thousands by filing date | |
| Bristol-Myers Squibb Company | 110122108 | COM | 4,466 | $274,000 | thousands by filing date | |
| BB & T CORP | 054937107 | COM | 5,345 | $266,000 | thousands by filing date | |
| UNITED RENTALS INC COM | 911363109 | Stock | 1,530 | $263,000 | thousands by filing date | |
| PRAXAIR INC | 74005P104 | COM | 1,700 | $263,000 | thousands by filing date | |
| SUNTRUST BANKS INC | 867914103 | COM | 4,063 | $262,000 | thousands by filing date | |
| Coca-Cola Company | 191216100 | COM | 5,636 | $259,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y407 | SBI CONS DISCR | 2,614 | $258,000 | thousands by filing date | |
| CORNING INC | 219350105 | COM | 7,992 | $256,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y308 | STATE STREET CON | 4,489 | $255,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 2,358 | $254,000 | thousands by filing date | |
| JOHN HANCOCK EXCHANGE TRADED | 47804J107 | MLTFCTR LRG CAP | 7,280 | $253,000 | thousands by filing date | |
| International Business Machines Corporation | 459200101 | COM | 1,642 | $252,000 | thousands by filing date | |
| NEW YORK LIFE INVESTMENTS ET | 45409B107 | NYLI HEDGE MULTI | 8,040 | $245,000 | thousands by filing date | |
| CRAY INC | 225223304 | COM NEW | 10,000 | $242,000 | thousands by filing date | |
| NEW YORK LIFE INVESTMENTS ET | 45409B800 | NYLI MERGER ARBI | 7,739 | $240,000 | thousands by filing date | |
| Bank of America Corp | 060505104 | COM | 7,830 | $231,000 | thousands by filing date | |
| UnitedHealth Group Inc | 91324P102 | COM | 1,047 | $231,000 | thousands by filing date | |
| Walmart Inc. | 931142103 | COM | 2,335 | $231,000 | thousands by filing date | |
| LOEWS CORP COM | 540424108 | Stock | 4,495 | $225,000 | thousands by filing date | |
| Caterpillar Inc. | 149123101 | COM | 1,344 | $212,000 | thousands by filing date | |
| Mondelez International,Inc. Class A | 609207105 | COM | 4,818 | $206,000 | thousands by filing date | |
| VONAGE HLDGS CORP | 92886T201 | COM | 20,000 | $203,000 | thousands by filing date | |
| FORD MTR CO COM | 345370860 | Stock | 10,638 | $133,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001398344-18-002449 | this filing | 2018-02-15 | acceptance time not in the bulk data set |