13F-HR filed by Alesco Advisors, LLC, An ESL Co
Alesco Advisors, LLC, An ESL Co filed this 13F-HR for the quarter ended 2023-06-30, filed 2023-08-09, with 164 holding rows worth $2,784,139,084.
- Accession
- 0001140361-23-038830
- Filer
- CIK 1269978
- Filed
- 2023-08-09
- 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, 164 entries on the cover page, a total value of $2,784,139,084 stated on the cover page (in dollars after the unit check, H1), rows summing to $2,784,139,084 with VALUE read as dollars as filed, 13F file number 028-10620. 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 |
|---|---|---|---|---|---|---|
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 1,437,066 | $640,514,608 | dollars as filed | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 4,412,879 | $297,869,343 | dollars as filed | |
| IJH | 464287507 | COM | 967,652 | $253,021,529 | dollars as filed | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 2,471,589 | $246,293,826 | dollars as filed | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 2,797,152 | $137,871,625 | dollars as filed | |
| Schwab US TIPS ETF | 808524870 | SHS | 2,336,690 | $122,512,636 | dollars as filed | |
| SPDR SER TR | 78464A508 | PRTFLO S&P500 VL | 2,793,456 | $120,677,312 | dollars as filed | |
| SPY | 78462F103 | SHS | 243,996 | $108,158,762 | dollars as filed | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 1,390,408 | $101,068,765 | dollars as filed | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 1,732,187 | $82,140,302 | dollars as filed | |
| iShares MSCI EAFE Value ETF | 464288877 | SHS | 1,437,960 | $70,373,748 | dollars as filed | |
| iShares U.S. Treasury Bond ETF | 46429B267 | SHS | 2,573,193 | $58,926,125 | dollars as filed | |
| SPDR SERIES TRUST | 78464A839 | ST STR SP400VAL | 690,917 | $47,521,260 | dollars as filed | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 1,004,805 | $46,401,877 | dollars as filed | |
| ISHARES TR | 46435G425 | COM | 365,092 | $35,581,866 | dollars as filed | |
| iShares ESG Aware US Aggregate Bond ETF | 46435U549 | SHS | 591,412 | $27,896,904 | dollars as filed | |
| iShares S&P Mid-Cap 400 Value ETF | 464287705 | SHS | 233,621 | $25,027,784 | dollars as filed | |
| VWO | 922042858 | SHS | 614,182 | $24,984,909 | dollars as filed | |
| ISHARES MICRO-CAP ETF | 464288869 | ETF | 176,595 | $19,301,781 | dollars as filed | |
| iShares S&P 500 Value ETF | 464287408 | SHS | 114,481 | $18,453,151 | dollars as filed | |
| ISHARES TR | 464288323 | NEW YORK MUN ETF | 293,967 | $15,656,682 | dollars as filed | |
| ISHARES SHORT-TERM NATIONAL MUNI BOND ETF | 464288158 | ETF | 128,657 | $13,385,473 | dollars as filed | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 122,929 | $13,120,212 | dollars as filed | |
| ISHARES MSCI EAFE SMALL-CAP ETF | 464288273 | ETF | 192,774 | $11,369,809 | dollars as filed | |
| Schwab Short Term US Treasury ETF | 808524862 | SHS | 235,026 | $11,295,358 | dollars as filed | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 55,356 | $11,221,693 | dollars as filed | |
| SPDR SERIES TRUST | 78468R861 | STATE STRET SPDR | 605,377 | $11,175,254 | dollars as filed | |
| ISHARES TR | 46435G516 | COM | 133,939 | $9,768,171 | dollars as filed | |
| iShares 0-5 Year TIPS Bond ETF | 46429B747 | SHS | 97,016 | $9,468,777 | dollars as filed | |
| Vanguard Mid-Cap Value ETF | 922908512 | SHS | 62,633 | $8,667,124 | dollars as filed | |
| PAYCHEX INC | 704326107 | COM | 77,280 | $8,645,355 | dollars as filed | |
| SPDR Bloomberg Investment Grade Floating Rate ETF | 78468R200 | SHS | 257,470 | $7,901,754 | dollars as filed | |
| ISHARES TR | 46435G243 | COM | 329,800 | $7,885,518 | dollars as filed | |
| iShares ESG Aware MSCI USA Small-Cap ETF | 46435U663 | SHS | 189,014 | $6,713,777 | dollars as filed | |
| ISHARES INC | 46434G863 | COM | 167,196 | $5,288,409 | dollars as filed | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 18,664 | $5,135,960 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C409 | COM | 67,357 | $5,096,239 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524755 | FUNDAMENTAL INTL | 149,565 | $4,829,454 | dollars as filed | |
| Apple Inc | 037833100 | COM | 21,685 | $4,206,260 | dollars as filed | |
| VANGUARD TAX-EXEMPT BOND ETF | 922907746 | ETF | 82,632 | $4,149,779 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C730 | COM | 20,355 | $4,102,754 | dollars as filed | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 17,894 | $3,939,608 | dollars as filed | |
| Microsoft Corp | 594918104 | COM | 10,747 | $3,659,688 | dollars as filed | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 50,070 | $3,630,075 | dollars as filed | |
| BROADSTONE NET LEASE INC COM | 11135E203 | REIT | 229,954 | $3,550,490 | dollars as filed | |
| Schwab U.S. Large-Cap ETF | 808524201 | SHS | 61,972 | $3,245,485 | dollars as filed | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 32,882 | $3,220,830 | dollars as filed | |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 40,070 | $3,028,090 | dollars as filed | |
| DIMENSIONAL ETF TRUST | 25434v740 | EMERGING MKTS VA | 115,621 | $2,817,684 | dollars as filed | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 13,767 | $2,738,166 | dollars as filed | |
| iShares TIPS Bond ETF | 464287176 | SHS | 25,097 | $2,700,960 | dollars as filed | |
| Berkshire Hathaway Inc | 084670702 | COM | 7,912 | $2,697,992 | dollars as filed | |
| ISHARES 1-5 YEAR INVESTMENT GRADE CORPORATE BOND ETF | 464288646 | ETF | 49,515 | $2,484,168 | dollars as filed | |
| iShares 0-5 Year High Yield Corporate Bond ETF | 46434V407 | COM | 58,605 | $2,429,177 | dollars as filed | |
| ISHARES TR | 464287689 | RUSSELL 3000 ETF | 9,495 | $2,416,183 | dollars as filed | |
| ISHARES TR | 464287432 | 20 YR TR BD ETF | 21,660 | $2,229,680 | dollars as filed | |
| DIMENSIONAL ETF TRUST | 25434V773 | INTL SMALL CAP E | 91,671 | $2,091,932 | dollars as filed | |
| SPDR SER TR STATE STR SPDR PORT S&P 500 ETF | 78464A854 | SHS | 36,930 | $1,924,422 | dollars as filed | |
| SPDR Portfolio Mortgage Backed Bond ETF | 78464A383 | SHS | 85,550 | $1,874,401 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524839 | US AGGREGATE B | 39,026 | $1,801,440 | dollars as filed | |
| iShares 0-3 Month Treasury Bond ETF | 46436E718 | SHS | 16,930 | $1,703,666 | dollars as filed | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 22,352 | $1,676,400 | dollars as filed | |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 22,722 | $1,601,447 | dollars as filed | |
| EXXON MOBIL CORP | 30231G102 | COM | 14,344 | $1,538,394 | dollars as filed | |
| iShares Russell 2000 ETF | 464287655 | SHS | 8,185 | $1,532,805 | dollars as filed | |
| Lowes Companies,Inc. | 548661107 | COM | 6,220 | $1,403,854 | dollars as filed | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 14,300 | $1,381,809 | dollars as filed | |
| iShares Short Treasury Bond ETF | 464288679 | SHS | 11,710 | $1,293,370 | dollars as filed | |
| iShares S&P Small-Cap 600 Value ETF | 464287879 | SHS | 13,555 | $1,288,909 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524805 | INTL EQTY ETF | 35,665 | $1,271,457 | dollars as filed | |
| ISHARES TR | 464287887 | S&P SML 600 GWT | 11,015 | $1,265,954 | dollars as filed | |
| Vanguard Intermediate-Term Corporate Bond ETF | 92206C870 | SHS | 15,440 | $1,220,223 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524409 | US LCAP VA ETF | 18,080 | $1,212,968 | dollars as filed | |
| GLOBAL X FDS | 37954Y889 | S&P 500 CATHOLIC | 21,138 | $1,150,753 | dollars as filed | |
| iShares Floating Rate Bond ETF | 46429B655 | SHS | 22,495 | $1,143,196 | dollars as filed | |
| JPMorgan Chase & Co | 46625H100 | COM | 7,810 | $1,135,887 | dollars as filed | |
| Schwab US REIT ETF | 808524847 | SHS | 55,385 | $1,081,669 | dollars as filed | |
| Vanguard Small-Cap Value ETF | 922908611 | SHS | 6,465 | $1,069,311 | dollars as filed | |
| SPDR INDEX SHS FDS | 78463X871 | ST INTL CAP ETF | 33,957 | $1,036,028 | dollars as filed | |
| XYLEM INC COM | 98419M100 | Stock | 9,124 | $1,027,545 | dollars as filed | |
| Vanguard High Dividend Yield ETF | 921946406 | SHS | 9,685 | $1,027,288 | dollars as filed | |
| ISHARES INC | 464286525 | MSCI GBL MIN VOL | 10,441 | $1,023,792 | dollars as filed | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 19,100 | $1,002,941 | dollars as filed | |
| ISHARES TR | 464287457 | COM | 12,310 | $998,095 | dollars as filed | |
| iShares Gold Trust | 464285204 | COM | 27,242 | $991,336 | dollars as filed | |
| SPDR S&P 500 Fossil Fuel Reserves Free ETF | 78468R796 | SHS | 27,390 | $990,696 | dollars as filed | |
| Vanguard Intermediate-Term Bond ETF | 921937819 | SHS | 12,220 | $919,311 | dollars as filed | |
| SPDR SER TR | 78468R721 | NUVEEN BLMBRG MU | 19,836 | $915,630 | dollars as filed | |
| Johnson & Johnson | 478160104 | COM | 5,468 | $905,063 | dollars as filed | |
| Schwab US Mid-Cap ETF | 808524508 | SHS | 12,188 | $865,714 | dollars as filed | |
| PIMCO ETF TR | 72201R205 | 1-5 US TIP IDX | 16,461 | $827,988 | dollars as filed | |
| Vanguard Value ETF | 922908744 | SHS | 5,588 | $794,055 | dollars as filed | |
| SPDR S&P Midcap 400 ETF Trust | 78467Y107 | SHS | 1,648 | $789,244 | dollars as filed | |
| Vanguard S&P 500 ETF | 922908363 | COM | 1,893 | $770,877 | dollars as filed | |
| iShares Global 100 ETF | 464287572 | SHS | 10,115 | $769,347 | dollars as filed | |
| ISHARES | 46434VAX8 | EXCHANGE TRADED | 29,610 | $748,837 | dollars as filed | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 3,000 | $727,980 | dollars as filed | |
| VANECK ETF TRUST | 92189H201 | INTRMDT MUNI ETF | 15,650 | $720,996 | dollars as filed | |
| iShares MBS ETF | 464288588 | SHS | 7,645 | $713,011 | dollars as filed | |
| Schwab Intermediate-Term US Treasury ETF | 808524854 | SHS | 14,370 | $708,154 | dollars as filed | |
| ISHARES TR | 464288281 | JPMORGAN USD EMG | 7,780 | $673,281 | dollars as filed | |
| Vanguard Short-Term Treasury ETF | 92206C102 | SHS | 11,520 | $665,050 | dollars as filed | |
| Oracle Corporation | 68389X105 | COM | 5,579 | $664,403 | dollars as filed | |
| VANGUARD SCOTTSDALE FDS | 92206C680 | COM | 9,300 | $658,068 | dollars as filed | |
| ISHARES TR | 464288661 | 3 7 YR TREAS BD | 5,646 | $650,758 | dollars as filed | |
| WISDOMTREE TR | 97717Y527 | FLOATNG RAT TREA | 12,850 | $646,612 | dollars as filed | |
| Amazon.com, Inc | 023135106 | COM | 4,938 | $643,718 | dollars as filed | |
| VTI | 922908769 | COM | 2,749 | $605,550 | dollars as filed | |
| INVESCO EXCHANGE TRADED FD T | 46137V258 | S&P500 PUR VAL | 7,695 | $596,747 | dollars as filed | |
| iShares iBoxx Inv Grade Corporate Bond ETF | 464287242 | SHS | 5,300 | $573,142 | dollars as filed | |
| ISHARES RUSSELL MID-CAP VALUE ETF | 464287473 | ETF | 5,040 | $553,594 | dollars as filed | |
| PepsiCo,Inc. | 713448108 | COM | 2,925 | $541,769 | dollars as filed | |
| ISHARES | 46434VBG4 | EXCHANGE TRADED | 21,590 | $531,546 | dollars as filed | |
| Dimensional International Value ETF | 25434V807 | SHS | 15,860 | $521,001 | dollars as filed | |
| CHEMUNG FINANCIAL CORP | 164024101 | COMMON STOCK | 13,214 | $507,550 | dollars as filed | |
| ISHARES TR | 46435G326 | CORE MSCI INTL | 8,105 | $495,378 | dollars as filed | |
| ALLSTATE CORP COM | 020002101 | Stock | 4,402 | $479,994 | dollars as filed | |
| Visa Inc | 92826C839 | COM | 2,013 | $478,047 | dollars as filed | |
| ISHARES TR | 464287630 | RUS 2000 VAL ETF | 3,350 | $471,680 | dollars as filed | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 3,888 | $465,394 | dollars as filed | |
| iShares Russell Midcap ETF | 464287499 | SHS | 6,260 | $457,168 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524706 | EMRG MKTEQ ETF | 18,446 | $454,328 | dollars as filed | |
| MICROCHIP TECHNOLOGY INC. COM | 595017104 | Stock | 4,835 | $433,129 | dollars as filed | |
| ISHARES TR | 46434V456 | MSCI INTL QUALTY | 11,800 | $420,080 | dollars as filed | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 2,379 | $413,613 | dollars as filed | |
| Procter & Gamble Co | 742718109 | COM | 2,684 | $407,270 | dollars as filed | |
| CONSTELLATION BRANDS INC CL A | 21036P108 | Stock | 1,616 | $397,674 | dollars as filed | |
| SPDR SERIES TRUST | 78468R523 | ST STR BL 12 ETF | 3,930 | $390,878 | dollars as filed | |
| SPDR GOLD TR | 78463V107 | GOLD SHS | 2,185 | $389,520 | dollars as filed | |
| VANGUARD INTL EQUITY INDEX F | 922042676 | COM | 9,474 | $380,760 | dollars as filed | |
| GLOBAL X FDS | 37954Y368 | CMN | 12,320 | $351,954 | dollars as filed | |
| McDonalds Corporation | 580135101 | COM | 1,149 | $342,873 | dollars as filed | |
| TRANE TECHNOLOGIES PLC SHS | G8994E103 | Stock | 1,725 | $329,924 | dollars as filed | |
| Schwab U.S. Small-Cap ETF | 808524607 | SHS | 7,455 | $326,529 | dollars as filed | |
| SCHWAB STRATEGIC TR | 808524888 | INTL SCEQT ETF | 9,516 | $321,367 | dollars as filed | |
| J P MORGAN EXCHANGE TRADED F | 46641Q753 | US VALUE FACTR | 8,985 | $320,585 | dollars as filed | |
| SHERWIN WILLIAMS CO | 824348106 | COM | 1,200 | $318,624 | dollars as filed | |
| STATE STR SPDR DOW JONES IND | 78467X109 | UT SER 1 | 895 | $307,746 | dollars as filed | |
| Vanguard Real Estate | 922908553 | SHS | 3,674 | $306,999 | dollars as filed | |
| Alphabet Inc. Reg. Shares C | 02079K107 | COM | 2,456 | $297,102 | dollars as filed | |
| Walt Disney Co | 254687106 | COM | 3,323 | $296,671 | dollars as filed | |
| Deere & Company | 244199105 | COM | 714 | $289,306 | dollars as filed | |
| SPDR Bloomberg 1-3 Month T-Bill ETF | 78468R663 | SHS | 3,110 | $285,560 | dollars as filed | |
| Automatic Data Processing,Inc. | 053015103 | COM | 1,295 | $284,628 | dollars as filed | |
| Home Depot, Inc | 437076102 | COM | 893 | $277,402 | dollars as filed | |
| Boeing Company | 097023105 | COM | 1,305 | $275,564 | dollars as filed | |
| ISHARES RUSSELL 1000 ETF | 464287622 | ETF | 1,115 | $271,770 | dollars as filed | |
| ISHARES MSCI EAFE MIN VOL FACTOR ETF | 46429B689 | ETF | 3,950 | $266,625 | dollars as filed | |
| ISHARES TR | 46436E767 | COM | 7,350 | $264,233 | dollars as filed | |
| Abbott Laboratories | 002824100 | COM | 2,423 | $264,195 | dollars as filed | |
| ISHARES TR | 464288620 | SHS | 5,240 | $262,472 | dollars as filed | |
| Caterpillar Inc. | 149123101 | COM | 1,050 | $258,353 | dollars as filed | |
| Intel Corp | 458140100 | COM | 7,500 | $250,803 | dollars as filed | |
| Thermo Fisher Scientific Inc. | 883556102 | COM | 466 | $243,136 | dollars as filed | |
| UnitedHealth Group Inc | 91324P102 | COM | 490 | $235,514 | dollars as filed | |
| ISHARES CORE S&P U.S. GROWTH ETF | 464287671 | ETF | 2,400 | $234,336 | dollars as filed | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 7,740 | $227,866 | dollars as filed | |
| Vanguard Total World Stock ETF | 922042742 | SHS | 2,200 | $213,356 | dollars as filed | |
| TOMPKINS FINL CORP COM | 890110109 | Stock | 3,796 | $211,437 | dollars as filed | |
| iShares MSCI Intl Momentum Factor ETF | 46434V449 | SHS | 6,325 | $209,990 | dollars as filed | |
| Pfizer Inc. | 717081103 | COM | 5,617 | $206,038 | dollars as filed | |
| Cigna Corporation | 125523100 | COM | 729 | $204,557 | dollars as filed | |
| Merck & Co.,Inc. | 58933Y105 | COM | 1,762 | $203,325 | dollars as filed | |
| ISHARES TR | 46436E551 | ESG SELECT SCRE | 5,675 | $202,146 | dollars as filed |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001140361-23-038830 | this filing | 2023-08-09 | acceptance time not in the bulk data set |