13F-HR filed by Koesten, Hirschmann & Crabtree, INC.
Koesten, Hirschmann & Crabtree, INC. filed this 13F-HR for the quarter ended 2023-06-30, filed 2023-07-26, with 167 holding rows worth $132,151,669.
- Accession
- 0001963421-23-000003
- Filer
- CIK 1963421
- Filed
- 2023-07-26
- 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, 183 entries on the cover page, a total value of $132,151,669 stated on the cover page (in dollars after the unit check, H1), rows summing to $132,151,669 with VALUE read as dollars as filed, 13F file number 028-22885. 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 |
|---|---|---|---|---|---|---|
| SCHWAB STRATEGIC TR | 808524771 | FUNDAMENTAL US L | 611,449 | $35,201,082 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524805 | INTL EQTY ETF | 492,769 | $17,567,221 | dollars as filed | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 84,933 | $17,217,676 | dollars as filed | |
| Schwab U.S. Large-Cap ETF | 808524201 | SHS | 313,701 | $16,428,555 | dollars as filed | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 50,453 | $10,034,551 | dollars as filed | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 119,854 | $8,090,199 | dollars as filed | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 6,220 | $2,772,342 | dollars as filed | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 27,424 | $2,732,759 | dollars as filed | |
| Schwab U.S. Small-Cap ETF | 808524607 | SHS | 60,714 | $2,659,294 | dollars as filed | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 53,678 | $2,645,777 | dollars as filed | |
| Apple Inc | 037833100 | COM | 11,043 | $2,142,033 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524706 | EMRG MKTEQ ETF | 86,074 | $2,120,014 | dollars as filed | |
| Schwab US Mid-Cap ETF | 808524508 | SHS | 19,648 | $1,395,598 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524409 | US LCAP VA ETF | 18,120 | $1,215,698 | dollars as filed | |
| IJH | 464287507 | COM | 4,371 | $1,142,930 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 2,395 | $815,594 | dollars as filed | |
| iShares Core S&P U.S. Value ETF | 464287663 | SHS | 7,287 | $570,281 | dollars as filed | |
| ADTRAN HOLDINGS INC | 00486H105 | COM | 47,512 | $500,302 | dollars as filed | |
| COLGATE PALMOLIVE CO COM | 194162103 | Stock | 6,329 | $487,587 | dollars as filed | |
| Netflix, Inc | 64110L106 | COM | 842 | $370,893 | dollars as filed | |
| INVESCO CURRENCYSHARES BRITISH | 46138m109 | INDX FD | 3,020 | $369,135 | dollars as filed | |
| Procter & Gamble Co | 742718109 | COM | 1,933 | $293,314 | dollars as filed | |
| PepsiCo,Inc. | 713448108 | COM | 1,218 | $225,587 | dollars as filed | |
| HENRY JACK & ASSOC INC | 426281101 | COM | 1,303 | $218,031 | dollars as filed | |
| UMB FINL CORP | 902788108 | COM | 3,387 | $206,269 | dollars as filed | |
| INVESCO EXCHANGE TRADED FD T | 46137V100 | AEROSPACE DEFN | 2,145 | $181,189 | dollars as filed | |
| SPDR S&P 500 Fossil Fuel Reserves Free ETF | 78468R796 | SHS | 4,860 | $175,787 | dollars as filed | |
| SPY | 78462F103 | SHS | 388 | $171,773 | dollars as filed | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 3,626 | $167,439 | dollars as filed | |
| Tesla Motors, Inc | 88160R101 | COM | 615 | $160,989 | dollars as filed | |
| META PLATFORMS INC CL A | 30303M102 | COM | 548 | $157,266 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524789 | FUNDAMENTAL US B | 2,510 | $142,419 | dollars as filed | |
| Costco Wholesale Corporation | 22160K105 | COM | 243 | $130,561 | dollars as filed | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 1,060 | $126,882 | dollars as filed | |
| CYBERARK SOFTWARE LTD SHS | M2682V108 | Stock | 784 | $122,563 | dollars as filed | |
| ISHARES TR | 46435G516 | COM | 1,480 | $107,937 | dollars as filed | |
| Vanguard Growth | 922908736 | COM | 373 | $105,463 | dollars as filed | |
| VANGUARD WORLD FD | 92204A603 | INDUSTRIAL ETF | 510 | $104,821 | dollars as filed | |
| INVESCO QQQ TR | 46090E103 | COM | 283 | $104,546 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 840 | $101,615 | dollars as filed | |
| iShares Russell 2000 ETF | 464287655 | SHS | 500 | $93,635 | dollars as filed | |
| VANGUARD WORLD FD | 92204A405 | FINANCIALS ETF | 1,150 | $93,426 | dollars as filed | |
| Bristol-Myers Squibb Company | 110122108 | COM | 1,380 | $88,251 | dollars as filed | |
| MANAGED PORTFOLIO SERIES | 56167N720 | TORTOISE NRAM PI | 3,425 | $84,437 | dollars as filed | |
| GARMIN LTD SHS | H2906T109 | Stock | 792 | $82,598 | dollars as filed | |
| iShares Russell Midcap ETF | 464287499 | SHS | 1,050 | $76,682 | dollars as filed | |
| Walmart Inc. | 931142103 | COM | 483 | $75,918 | dollars as filed | |
| iShares ESG Aware MSCI USA Small-Cap ETF | 46435U663 | SHS | 2,080 | $73,882 | dollars as filed | |
| ARES MANAGEMENT CORPORATION CL A COM STK | 03990B101 | Stock | 704 | $67,831 | dollars as filed | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 242 | $66,594 | dollars as filed | |
| VMWARE, INC. | 928563402 | CL A COM | 443 | $63,655 | dollars as filed | |
| ISHARES TR | 464287168 | COM | 534 | $60,462 | dollars as filed | |
| Amgen Inc. | 031162100 | COM | 251 | $55,794 | dollars as filed | |
| DNP SELECT INCOME FD INC | 23325P104 | COM | 5,300 | $55,544 | dollars as filed | |
| Mondelez International,Inc. Class A | 609207105 | COM | 761 | $55,508 | dollars as filed | |
| PHILLIPS 66 COM | 718546104 | Stock | 574 | $54,749 | dollars as filed | |
| DELL TECHNOLOGIES INC CL C | 24703L202 | Stock | 1,006 | $54,435 | dollars as filed | |
| ISHARES TR | 46436E668 | ESG AWARE 80/20 | 1,660 | $51,102 | dollars as filed | |
| Walt Disney Co | 254687106 | COM | 531 | $47,408 | dollars as filed | |
| Pfizer Inc. | 717081103 | COM | 1,283 | $47,066 | dollars as filed | |
| Charles Schwab Corp | 808513105 | COM | 765 | $43,361 | dollars as filed | |
| ISHARES RUSSELL 1000 ETF | 464287622 | ETF | 177 | $43,142 | dollars as filed | |
| U.S. GLOBAL JETS ETF | 26922A842 | ETF | 1,900 | $40,698 | dollars as filed | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 306 | $40,616 | dollars as filed | |
| Vanguard ESG International Stock ETF | 921910725 | SHS | 750 | $39,833 | dollars as filed | |
| CLOROX CO DEL | 189054109 | COM | 250 | $39,765 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C599 | VNG RUS3000IDX | 201 | $39,606 | dollars as filed | |
| BP PLC SPONSORED ADR | 055622104 | ADR | 1,095 | $38,643 | dollars as filed | |
| NUSHARES ETF TR | 67092P607 | NUVEEN ESG SMLCP | 1,030 | $38,100 | dollars as filed | |
| UNITED AIRLS HLDGS INC COM | 910047109 | Stock | 682 | $37,422 | dollars as filed | |
| ENTERPRISE PRODS PARTNERS L | 293792107 | COM | 1,400 | $36,890 | dollars as filed | |
| SCHD | 808524797 | COM | 500 | $36,310 | dollars as filed | |
| TEXTRON INC COM | 883203101 | Stock | 535 | $36,171 | dollars as filed | |
| NUSHARES ETF TR | 67092P888 | NUVEEN ESG EMRGN | 1,270 | $34,684 | dollars as filed | |
| TRACTOR SUPPLY CO COM | 892356106 | Stock | 154 | $34,050 | dollars as filed | |
| 3M CO COM | 88579Y101 | Stock | 330 | $33,030 | dollars as filed | |
| ISHARES INC | 46434G863 | COM | 1,025 | $32,421 | dollars as filed | |
| Chevron Corporation | 166764100 | COM | 200 | $31,470 | dollars as filed | |
| Vanguard Value ETF | 922908744 | SHS | 216 | $30,652 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 284 | $30,459 | dollars as filed | |
| CROWDSTRIKE HLDGS INC | 22788C105 | COM | 200 | $29,374 | dollars as filed | |
| T-Mobile US,Inc. | 872590104 | COM | 208 | $28,892 | dollars as filed | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 289 | $28,288 | dollars as filed | |
| EPR PPTYS COM SH BEN INT | 26884U109 | REIT | 603 | $28,228 | dollars as filed | |
| AT&T Inc | 00206R102 | COM | 1,756 | $28,012 | dollars as filed | |
| CAPITOL FED FINL INC COM | 14057J101 | Stock | 4,300 | $26,531 | dollars as filed | |
| Cigna Corporation | 125523100 | COM | 94 | $26,377 | dollars as filed | |
| Union Pacific Corporation | 907818108 | COM | 123 | $25,169 | dollars as filed | |
| AMEREN CORP COM | 023608102 | Stock | 275 | $22,460 | dollars as filed | |
| Schwab U.S. Large-Cap Growth ETF | 808524300 | SHS | 276 | $20,666 | dollars as filed | |
| PG&E CORP COM | 69331C108 | Stock | 856 | $14,792 | dollars as filed | |
| CGI INC CL A SUB VTG | 12532H104 | Stock | 140 | $14,761 | dollars as filed | |
| XCELENERGY INC | 98389B100 | COM | 192 | $11,937 | dollars as filed | |
| CANADIAN PACIFIC KANSAS CITY COM | 13646K108 | Stock | 144 | $11,631 | dollars as filed | |
| HARTFORD INSURANCE GROUP INC COM | 416515104 | Stock | 159 | $11,452 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 67 | $11,090 | dollars as filed | |
| Fidelity MSCI Real Estate Index ETF | 316092857 | SHS | 436 | $10,940 | dollars as filed | |
| DILLARDS INC CL A | 254067101 | Stock | 32 | $10,441 | dollars as filed | |
| ARES CAPITAL CORP | 04010L103 | COM | 500 | $9,395 | dollars as filed | |
| KINDER MORGAN INC DEL COM | 49456B101 | Stock | 537 | $9,248 | dollars as filed | |
| ISHARES TR | 464287556 | ISHARES BIOTECH | 72 | $9,142 | dollars as filed | |
| EVERGY INC COM | 30034W106 | Stock | 151 | $8,822 | dollars as filed | |
| ISHARES TR | 46436E767 | COM | 236 | $8,483 | dollars as filed | |
| ACTVISION BLIZZARD INC | 00507V109 | COM | 100 | $8,430 | dollars as filed | |
| ROBLOX CORP CL A | 771049103 | Stock | 200 | $8,060 | dollars as filed | |
| FS CREDIT OPPORTUNITIES CORP | 30290Y101 | COMMON STOCK | 1,655 | $7,862 | dollars as filed | |
| PRINCIPAL FINANCIAL GROUP INC COM | 74251V102 | Stock | 103 | $7,812 | dollars as filed | |
| Vanguard Energy ETF | 92204A306 | SHS | 68 | $7,677 | dollars as filed | |
| iShares Silver Trust | 46428Q109 | COM | 365 | $7,625 | dollars as filed | |
| Altria Group Inc | 02209S103 | COM | 160 | $7,248 | dollars as filed | |
| COINBASE GLOBAL INC COM CL A | 19260Q107 | Stock | 100 | $7,155 | dollars as filed | |
| ROKU INC COM CL A | 77543R102 | Stock | 100 | $6,396 | dollars as filed | |
| Micron Technology,Inc. | 595112103 | COM | 100 | $6,311 | dollars as filed | |
| ZIONS BANCORPORATION | 989701107 | COM | 221 | $5,929 | dollars as filed | |
| HANESBRANDS INC | 410345102 | COM | 1,216 | $5,521 | dollars as filed | |
| WARNER BROS DISCOVERY INC COM SER A | 934423104 | Stock | 423 | $5,305 | dollars as filed | |
| OCCIDENTAL PETE CORP | 674599105 | COM | 88 | $5,175 | dollars as filed | |
| ZILLOW GROUP INC CL C CAP STK | 98954M200 | Stock | 101 | $5,077 | dollars as filed | |
| DICKS SPORTING GOODS INC COM | 253393102 | Stock | 37 | $4,892 | dollars as filed | |
| iShares Core S&P Total U.S. Stock Market ETF | 464287150 | SHS | 48 | $4,697 | dollars as filed | |
| Verizon Communications Inc | 92343V104 | COM | 125 | $4,649 | dollars as filed | |
| CVS Health Corporation | 126650100 | COM | 60 | $4,148 | dollars as filed | |
| FIDELITY MERRIMACK STR TR | 316188309 | TOTAL BD ETF | 90 | $4,088 | dollars as filed | |
| AbbVie,Inc. | 00287Y109 | COM | 30 | $3,978 | dollars as filed | |
| 23ANDME HOLDING CO | 90138Q108 | CLASS A COM | 2,000 | $3,500 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524839 | US AGGREGATE B | 75 | $3,468 | dollars as filed | |
| AFFIRM HLDGS INC COM CL A | 00827B106 | Stock | 200 | $3,066 | dollars as filed | |
| FORD MTR CO COM | 345370860 | Stock | 200 | $3,026 | dollars as filed | |
| PINTEREST INC CL A | 72352L106 | Stock | 100 | $2,734 | dollars as filed | |
| CHARGEPOINT HLDGS INC | 15961R105 | COM CL A | 311 | $2,734 | dollars as filed | |
| FLAHERTY & CRUMRIN PFD & INM | 338478100 | COM | 186 | $2,556 | dollars as filed | |
| ISHARES RUSSELL 1000 VALUE ETF | 464287598 | ETF | 14 | $2,143 | dollars as filed | |
| ISHARES TR | 46432F834 | COM | 33 | $2,067 | dollars as filed | |
| SOUTHWESTAIRLSCO | 844741108 | STOK | 51 | $1,830 | dollars as filed | |
| SONOS INC | 83570H108 | COM | 100 | $1,633 | dollars as filed | |
| VIATRIS INC COM | 92556V106 | Stock | 157 | $1,570 | dollars as filed | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 32 | $1,541 | dollars as filed | |
| INVESCO ACTIVELY MANAGED EXC | 46090A804 | TOTAL RETURN | 29 | $1,348 | dollars as filed | |
| LUMEN TECHNOLOGIES INC | 550241103 | COM | 581 | $1,314 | dollars as filed | |
| PRUDENTIAL FINL INC COM | 744320102 | Stock | 14 | $1,236 | dollars as filed | |
| Coca-Cola Company | 191216100 | COM | 17 | $1,024 | dollars as filed | |
| KYNDRYL HLDGS INC | 50155Q100 | COMMON STOCK | 76 | $1,010 | dollars as filed | |
| NIO INC SPON ADS | 62914V106 | ADR | 100 | $969 | dollars as filed | |
| OPENDOOR TECHNOLOGIES INC | 683712103 | COM | 200 | $804 | dollars as filed | |
| Starbucks Corporation | 855244109 | COM | 8 | $793 | dollars as filed | |
| USBANCORPDEL | 902973304 | COM NEW | 23 | $760 | dollars as filed | |
| MOLSON COORS BEVERAGE CO CL B | 60871R209 | Stock | 11 | $725 | dollars as filed | |
| BLOCK H & R INC COM | 093671105 | Stock | 20 | $638 | dollars as filed | |
| Vanguard Small-Cap Value ETF | 922908611 | SHS | 4 | $609 | dollars as filed | |
| SNAP INC | 83304A106 | CL A | 50 | $592 | dollars as filed | |
| FISKER INC | 33813J106 | CL A COM STK | 100 | $564 | dollars as filed | |
| OCCIDENTAL PETE CORP WT EXP 080327 | 674599162 | Stock | 11 | $411 | dollars as filed | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 2 | $409 | dollars as filed | |
| Schwab US REIT ETF | 808524847 | SHS | 20 | $397 | dollars as filed | |
| VWO | 922042858 | SHS | 7 | $301 | dollars as filed | |
| YUM BRANDS INC COM | 988498101 | Stock | 2 | $278 | dollars as filed | |
| Salesforce.com, Inc | 79466L302 | COM | 1 | $212 | dollars as filed | |
| FUBOTV INC | 35953D104 | COM | 100 | $208 | dollars as filed | |
| CLEAN ENERGY FUELS CORP | 184499101 | COMMON STOCK | 40 | $199 | dollars as filed | |
| DEXCOM INC COM | 252131107 | Stock | 1 | $190 | dollars as filed | |
| Medtronic Plc | G5960L103 | COM | 1 | $124 | dollars as filed | |
| ALIGNMENT HEALTHCARE INC COM | 01625V104 | Stock | 15 | $87 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 0 | $52 | dollars as filed | Amount filed as zero, left out of ratios. |
| DELTA AIR LINES INC COM NEW | 247361702 | Stock | 1 | $47 | dollars as filed | |
| UNITI GROUP INC | 91325V108 | COM | 7 | $33 | dollars as filed | |
| DRAFTKINGS INC NEW | 26142V105 | COM CL A | 1 | $27 | dollars as filed | |
| AGENUS INC | 00847G705 | COM NEW | 1 | $2 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001963421-23-000003 | this filing | 2023-07-26 | acceptance time not in the bulk data set |