13F-HR filed by Round Rock Advisors LLC
Round Rock Advisors LLC filed this 13F-HR for the quarter ended 2024-06-30, filed 2024-08-02, with 180 holding rows worth $410,679,825.
- Accession
- 0001951757-24-000626
- Filer
- CIK 1846991
- Filed
- 2024-08-02
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q2 2024
A holdings report, 180 entries on the cover page, a total value of $410,679,825 stated on the cover page (in dollars after the unit check, H1), rows summing to $410,679,825 with VALUE read as dollars as filed, 13F file number 028-21052. 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 |
|---|---|---|---|---|---|---|
| INVESCO QQQ TR | 46090E103 | COM | 69,318 | $33,210,768 | dollars as filed | |
| Vanguard High Dividend Yield ETF | 921946406 | SHS | 264,162 | $31,329,630 | dollars as filed | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 195,290 | $20,829,608 | dollars as filed | |
| VANECK ETF TRUST | 92189F676 | COM | 78,728 | $20,524,454 | dollars as filed | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 84,754 | $20,518,990 | dollars as filed | |
| Apple Inc | 037833100 | COM | 91,161 | $19,200,401 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 36,224 | $16,190,441 | dollars as filed | |
| BERKSHIRE HATHAWAY INC DEL | 084670108 | CL A | 20 | $12,244,820 | dollars as filed | |
| SELECT SECTOR SPDR TR | 81369Y704 | INDL | 95,436 | $11,630,845 | dollars as filed | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 72,652 | $10,588,992 | dollars as filed | |
| ISHARES TR | 464287168 | COM | 85,850 | $10,386,124 | dollars as filed | |
| INVESCO EXCHANGE-TRADED FD TR S&P 500 EQUAL WEIGHT ETF | 46137V357 | COM | 61,660 | $10,129,477 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 43,973 | $8,065,545 | dollars as filed | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 32,970 | $7,458,749 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 36,964 | $7,145,035 | dollars as filed | |
| J P MORGAN EXCHANGE TRADED F | 46641Q837 | ULTRA SHRT ETF | 126,652 | $6,392,108 | dollars as filed | |
| UnitedHealth Group Inc | 91324P102 | COM | 10,657 | $5,427,204 | dollars as filed | |
| SPY | 78462F103 | SHS | 9,628 | $5,239,677 | dollars as filed | |
| iShares MSCI USA Min Vol Factor ETF | 46429B697 | SHS | 52,076 | $4,372,305 | dollars as filed | |
| SPDR SERIES TRUST | 78464A698 | ST STR SP REGBNK | 80,572 | $3,956,084 | dollars as filed | |
| Elevance Health, Inc. | 036752103 | COM | 7,209 | $3,906,470 | dollars as filed | |
| Intercontinental Exchange,Inc. | 45866F104 | COM | 28,412 | $3,889,318 | dollars as filed | |
| AbbVie,Inc. | 00287Y109 | COM | 20,761 | $3,560,926 | dollars as filed | |
| ISHARES TR | 46434VBD1 | IBONDS DEC25 ETF | 132,936 | $3,304,790 | dollars as filed | |
| iShares iBonds Dec 2026 Term Corporate ETF | 46435GAA0 | SHS | 137,658 | $3,279,010 | dollars as filed | |
| AIR PRODS & CHEMS INC | 009158106 | COM | 11,667 | $3,010,670 | dollars as filed | |
| Honeywell Technologies | 438516106 | COM | 14,037 | $2,997,686 | dollars as filed | |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 31,668 | $2,930,570 | dollars as filed | |
| Chevron Corporation | 166764100 | COM | 17,247 | $2,697,776 | dollars as filed | |
| INVESCO EXCH TRADED FD TR II | 46138G649 | COM | 13,334 | $2,628,272 | dollars as filed | |
| ITT INC COM | 45073V108 | Stock | 20,229 | $2,613,160 | dollars as filed | |
| Chubb Limited | H1467J104 | COM | 9,417 | $2,402,088 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C409 | COM | 29,821 | $2,304,382 | dollars as filed | |
| CONSTELLATION BRANDS INC CL A | 21036P108 | Stock | 8,711 | $2,241,166 | dollars as filed | |
| International Business Machines Corporation | 459200101 | COM | 12,944 | $2,238,731 | dollars as filed | |
| JPMORGAN EQUITY PREMIUM INCOME ETF | 46641Q332 | ETF | 38,935 | $2,206,812 | dollars as filed | |
| CAPITAL ONE FINL CORP | 14040H105 | COM | 15,238 | $2,109,702 | dollars as filed | |
| Vanguard Dividend Appreciation ETF | 921908844 | SHS | 11,371 | $2,075,749 | dollars as filed | |
| CVS Health Corporation | 126650100 | COM | 35,012 | $2,067,809 | dollars as filed | |
| NXP SEMICONDUCTORS N V COM | N6596X109 | Stock | 7,500 | $2,018,178 | dollars as filed | |
| WILLIAMS COS INC COM | 969457100 | Stock | 46,259 | $1,966,008 | dollars as filed | |
| iShares iBonds Dec. 2027 Corporate Bond ETF | 46435UAA9 | ETF | 82,741 | $1,963,450 | dollars as filed | |
| Comcast Corp | 20030N101 | COM | 48,155 | $1,885,948 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 15,972 | $1,838,718 | dollars as filed | |
| NVIDIA Corp | 67066G104 | COM | 14,554 | $1,797,942 | dollars as filed | |
| VGT | 92204A702 | SHS | 3,103 | $1,789,159 | dollars as filed | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 34,518 | $1,675,525 | dollars as filed | |
| Home Depot, Inc | 437076102 | COM | 4,809 | $1,655,529 | dollars as filed | |
| PepsiCo,Inc. | 713448108 | COM | 9,626 | $1,587,563 | dollars as filed | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 8,675 | $1,580,224 | dollars as filed | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 2,835 | $1,551,394 | dollars as filed | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 6,048 | $1,509,794 | dollars as filed | |
| ISHARES MSCI EAFE MIN VOL FACTOR ETF | 46429B689 | ETF | 19,391 | $1,344,884 | dollars as filed | |
| ENTERPRISE PRODS PARTNERS L | 293792107 | COM | 44,800 | $1,298,304 | dollars as filed | |
| Raytheon Technologies Corporation | 75513E101 | COM | 12,871 | $1,292,120 | dollars as filed | |
| STATE STR SPDR DOW JONES IND | 78467X109 | UT SER 1 | 3,238 | $1,266,420 | dollars as filed | |
| SPDR SER TR | 78464A862 | S&P SEMICNDCTR | 4,922 | $1,217,998 | dollars as filed | |
| Berkshire Hathaway Inc | 084670702 | COM | 2,987 | $1,215,112 | dollars as filed | |
| IJH | 464287507 | COM | 20,754 | $1,214,524 | dollars as filed | |
| VTI | 922908769 | COM | 4,492 | $1,201,607 | dollars as filed | |
| Vanguard Value ETF | 922908744 | SHS | 7,256 | $1,163,933 | dollars as filed | |
| Citigroup Inc. | 172967424 | COM | 18,110 | $1,149,260 | dollars as filed | |
| AMPHENOL CORP NEW | 032095101 | COM | 17,035 | $1,147,636 | dollars as filed | |
| Merck & Co.,Inc. | 58933Y105 | COM | 9,211 | $1,140,352 | dollars as filed | |
| CAESARS ENTERTAINMENT INC NE | 12769G100 | COM | 26,920 | $1,069,800 | dollars as filed | |
| DELL TECHNOLOGIES INC CL C | 24703L202 | Stock | 7,650 | $1,055,012 | dollars as filed | |
| Tesla Motors, Inc | 88160R101 | COM | 5,245 | $1,037,881 | dollars as filed | |
| Vanguard Small-Cap Growth ETF | 922908595 | SHS | 4,147 | $1,037,282 | dollars as filed | |
| ISHARES TR | 464288802 | ESG OPTIMIZED | 8,772 | $985,712 | dollars as filed | |
| JPMorgan Chase & Co | 46625H100 | COM | 4,822 | $975,389 | dollars as filed | |
| Vanguard International Dividend Appreciation ETF | 921946810 | SHS | 11,976 | $973,417 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 6,629 | $968,895 | dollars as filed | |
| ARISTA NETWORKS INC | 040413106 | COM | 2,620 | $918,258 | dollars as filed | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 4,101 | $894,102 | dollars as filed | |
| INVESCO EXCH TRADED FD TR II | 46138E354 | S&P500 LOW VOL | 13,430 | $872,277 | dollars as filed | |
| WYNDHAM HOTELS & RESORTS INC | 98311A105 | COM | 11,680 | $864,320 | dollars as filed | |
| AMERIPRISE FINL INC COM | 03076C106 | Stock | 2,020 | $862,924 | dollars as filed | |
| Micron Technology,Inc. | 595112103 | COM | 6,528 | $858,628 | dollars as filed | |
| VANGUARD ADMIRAL FDS INC | 921932869 | MIDCP 400 GRTH | 7,810 | $855,474 | dollars as filed | |
| BROOKFIELD CORP CL A LTD VT SH | 11271J107 | Stock | 20,475 | $850,532 | dollars as filed | |
| CAPITAL GROUP INTL FOCUS EQT | 14019W109 | SHS CREAT UNIT | 32,986 | $848,408 | dollars as filed | |
| ISHARES TR | 464289438 | RUS TP200 GR ETF | 3,897 | $835,984 | dollars as filed | |
| Vanguard Intermediate-Term Corporate Bond ETF | 92206C870 | SHS | 10,225 | $817,309 | dollars as filed | |
| iShares 0-5 Year High Yield Corporate Bond ETF | 46434V407 | COM | 18,361 | $774,839 | dollars as filed | |
| AGNICO EAGLE MINES LTD COM | 008474108 | Stock | 11,800 | $771,720 | dollars as filed | |
| Netflix, Inc | 64110L106 | COM | 1,141 | $770,038 | dollars as filed | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 6,766 | $746,576 | dollars as filed | |
| SPDR S&P Midcap 400 ETF Trust | 78467Y107 | SHS | 1,362 | $728,600 | dollars as filed | |
| J P MORGAN EXCHANGE TRADED F | 46654Q203 | NASDAQ EQT PREM | 12,977 | $720,196 | dollars as filed | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 13,809 | $682,430 | dollars as filed | |
| AMEREN CORP COM | 023608102 | Stock | 9,503 | $675,758 | dollars as filed | |
| META PLATFORMS INC CL A | 30303M102 | COM | 1,317 | $664,058 | dollars as filed | |
| MARRIOTT INTL INC NEW CL A | 571903202 | Stock | 2,572 | $621,713 | dollars as filed | |
| XYLEM INC COM | 98419M100 | Stock | 4,513 | $612,066 | dollars as filed | |
| SNOWFLAKE INC COM SHS | 833445109 | Stock | 4,511 | $609,391 | dollars as filed | |
| WISDOMTREE TR | 97717W604 | US SMALLCAP DIVD | 19,546 | $608,858 | dollars as filed | |
| Procter & Gamble Co | 742718109 | COM | 3,588 | $591,733 | dollars as filed | |
| iShares Russell 2000 ETF | 464287655 | SHS | 2,875 | $583,359 | dollars as filed | |
| Pfizer Inc. | 717081103 | COM | 20,833 | $582,901 | dollars as filed | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 13,537 | $576,541 | dollars as filed | |
| iShares ESG Aware MSCI USA Small-Cap ETF | 46435U663 | SHS | 14,797 | $569,692 | dollars as filed | |
| Coca-Cola Company | 191216100 | COM | 8,709 | $554,302 | dollars as filed | |
| Vanguard ESG International Stock ETF | 921910725 | SHS | 9,638 | $551,968 | dollars as filed | |
| MATTHEWS ASIA FDS | 577125818 | EMER MKTS EQUITY | 17,989 | $550,104 | dollars as filed | |
| VOYA GLOBAL ADVANTAGE AND PREM | 92912R104 | COM | 61,326 | $542,735 | dollars as filed | |
| FIDELITY COMWLTH TR | 315912808 | COM | 7,395 | $517,132 | dollars as filed | |
| SCHD | 808524797 | COM | 6,502 | $505,578 | dollars as filed | |
| 3M CO COM | 88579Y101 | Stock | 4,877 | $498,404 | dollars as filed | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 8,582 | $498,013 | dollars as filed | |
| Oracle Corporation | 68389X105 | COM | 3,447 | $486,716 | dollars as filed | |
| BLACKSTONE INC | 09260D107 | COM | 3,870 | $479,162 | dollars as filed | |
| DUPONT DE NEMOURS INC COM | 26614N102 | Stock | 5,904 | $475,213 | dollars as filed | |
| Deere & Company | 244199105 | COM | 1,227 | $458,444 | dollars as filed | |
| SPDR S&P Dividend ETF | 78464A763 | SHS | 3,602 | $458,141 | dollars as filed | |
| General Electric Company | 369604301 | COM | 2,842 | $451,744 | dollars as filed | |
| VANGUARD HEALTH CARE ETF | 92204A504 | ETF | 1,673 | $445,018 | dollars as filed | |
| Vanguard Small-Cap Value ETF | 922908611 | SHS | 2,405 | $438,961 | dollars as filed | |
| PIMCO ETF TR | 72201R643 | ENHANCD SHORT | 4,352 | $429,499 | dollars as filed | |
| ISHARES | 46434VBG4 | EXCHANGE TRADED | 17,074 | $429,070 | dollars as filed | |
| TRAVEL PLUS LEISURE CO COM | 894164102 | Stock | 9,360 | $421,013 | dollars as filed | |
| American Express Company | 025816109 | COM | 1,758 | $407,153 | dollars as filed | |
| Goldman Sachs Group,Inc. | 38141G104 | COM | 899 | $406,636 | dollars as filed | |
| BANK OF NY MELLON CORP COM | 064058100 | Stock | 6,690 | $400,664 | dollars as filed | |
| AT&T Inc | 00206R102 | COM | 20,914 | $399,673 | dollars as filed | |
| Eli Lilly and Company | 532457108 | COM | 422 | $382,235 | dollars as filed | |
| REGENERON PHARMACEUTICALS COM | 75886F107 | Stock | 360 | $378,371 | dollars as filed | |
| YUM BRANDS INC COM | 988498101 | Stock | 2,842 | $376,451 | dollars as filed | |
| NOVARTIS AG SPONSORED ADR | 66987V109 | ADR | 3,500 | $372,610 | dollars as filed | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 5,113 | $371,408 | dollars as filed | |
| PROSHARES TR | 74347B698 | RUSS 2000 DIVD | 5,976 | $371,242 | dollars as filed | |
| Union Pacific Corporation | 907818108 | COM | 1,630 | $368,804 | dollars as filed | |
| GOLDMAN SACHS ETF TR | 381430107 | ACTIVEBETA INT | 10,859 | $365,420 | dollars as filed | |
| iShares Core Dividend Growth ETF | 46434V621 | SHS | 6,329 | $364,589 | dollars as filed | |
| Verizon Communications Inc | 92343V104 | COM | 8,771 | $361,735 | dollars as filed | |
| BlackRock Ultra Short-Term Bond ETF | 46434V878 | SHS | 7,130 | $360,279 | dollars as filed | |
| PARAMOUNT GLOBAL | 92556H206 | CLASS B COM | 34,233 | $355,681 | dollars as filed | |
| DOW HLDGS INC COM | 260557103 | Stock | 6,609 | $350,608 | dollars as filed | |
| VANGUARD TAX-EXEMPT BOND ETF | 922907746 | ETF | 6,907 | $346,110 | dollars as filed | |
| Vanguard Mid-Cap Value ETF | 922908512 | SHS | 2,273 | $341,927 | dollars as filed | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 921 | $335,838 | dollars as filed | |
| PALO ALTO NETWORKS INC | 697435105 | COM | 974 | $330,196 | dollars as filed | |
| PENTAIR PLC SHS | G7S00T104 | Stock | 4,300 | $329,681 | dollars as filed | |
| Southern Company | 842587107 | COM | 4,246 | $329,343 | dollars as filed | |
| Vanguard S&P 500 ETF | 922908363 | COM | 645 | $322,584 | dollars as filed | |
| Walt Disney Co | 254687106 | COM | 3,162 | $313,971 | dollars as filed | |
| CORTEVA INC COM | 22052L104 | Stock | 5,710 | $307,997 | dollars as filed | |
| VANGUARD STAR FDS | 921909768 | COM | 4,963 | $299,269 | dollars as filed | |
| DEVON ENERGY CORP NEW COM | 25179M103 | Stock | 6,295 | $298,383 | dollars as filed | |
| iShares Core S&P U.S. Value ETF | 464287663 | SHS | 3,208 | $282,743 | dollars as filed | |
| ISHARES TR | 464287762 | US HLTHCARE ETF | 4,581 | $280,697 | dollars as filed | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 2,630 | $280,227 | dollars as filed | |
| Boeing Company | 097023105 | COM | 1,522 | $276,954 | dollars as filed | |
| WP CAREY INC COM | 92936U109 | REIT | 5,020 | $276,351 | dollars as filed | |
| Costco Wholesale Corporation | 22160K105 | COM | 310 | $263,442 | dollars as filed | |
| Vanguard Growth | 922908736 | COM | 697 | $260,685 | dollars as filed | |
| VANECK ETF TRUST | 92189F106 | GOLD MINERS ETF | 7,598 | $257,800 | dollars as filed | |
| Walmart Inc. | 931142103 | COM | 3,787 | $256,386 | dollars as filed | |
| SHOPIFY INC | 82509L107 | CL A SUB VTG SHS | 3,880 | $256,274 | dollars as filed | |
| CARRIER GLOBAL CORPORATION COM | 14448C104 | Stock | 4,013 | $253,140 | dollars as filed | |
| BLACKSTONE STRATEGIC CREDIT FU | 09257R101 | COM SHS BEN IN | 20,748 | $246,694 | dollars as filed | |
| PIMCO ETF TR | 72201R833 | ENHAN SHRT MA AC | 2,375 | $239,044 | dollars as filed | |
| PIMCO ETF TR | 72201R775 | ACTIVE BD ETF | 2,512 | $228,793 | dollars as filed | |
| Vanguard ESG U.S. Stock ETF | 921910733 | SHS | 2,355 | $227,540 | dollars as filed | |
| Vanguard Consumer Discretionary ETF | 92204A108 | SHS | 720 | $224,878 | dollars as filed | |
| Financial Select Sector SPDR Fund | 81369Y605 | SHS | 5,434 | $223,404 | dollars as filed | |
| LAM RESEARCH CORP | 512807108 | COM | 201 | $214,035 | dollars as filed | |
| TEMPLETON EMERGING MKTS INCO | 880192109 | COM | 39,750 | $211,867 | dollars as filed | |
| Vanguard ESG U.S. Corporate Bond ETF | 921910691 | SHS | 3,408 | $211,500 | dollars as filed | |
| ISHARES TR | 46435G516 | COM | 2,648 | $208,609 | dollars as filed | |
| ISHARES CORE S&P U.S. GROWTH ETF | 464287671 | ETF | 1,636 | $208,608 | dollars as filed | |
| FIDELITY MERRIMACK STR TR | 316188309 | TOTAL BD ETF | 4,627 | $207,869 | dollars as filed | |
| ZIMMER BIOMET HOLDINGS INC COM | 98956P102 | Stock | 1,900 | $206,207 | dollars as filed | |
| Gilead Sciences,Inc. | 375558103 | COM | 2,950 | $202,400 | dollars as filed | |
| WILLIS TOWERS WATSON PLC LTD SHS | G96629103 | Stock | 769 | $201,528 | dollars as filed | |
| Salesforce.com, Inc | 79466L302 | COM | 780 | $200,538 | dollars as filed | |
| CONSTELLATION ENERGY CORP COM | 21037T109 | Stock | 1,000 | $200,270 | dollars as filed | |
| NEUBERGER BERMAN MUN FD INC | 64124P101 | COM | 17,944 | $191,642 | dollars as filed | |
| VOYA GLBL EQTY DIV & PREM OP | 92912T100 | COM | 36,252 | $186,335 | dollars as filed | |
| MORGAN STANLEY EMER MKTS DEB | 61744H105 | COM | 21,096 | $154,847 | dollars as filed | |
| TEMPLETON EMERGING MARKETS FUN | 880191101 | COM | 12,010 | $148,444 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001951757-24-000626 | this filing | 2024-08-02 | acceptance time not in the bulk data set |