13F-HR filed by Alesco Advisors, LLC, An ESL Co
Alesco Advisors, LLC, An ESL Co filed this 13F-HR for the quarter ended 2019-12-31, filed 2020-02-14, with 167 holding rows worth $1,930,062,000.
- Accession
- 0001567619-20-003493
- Filer
- CIK 1269978
- Filed
- 2020-02-14
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q4 2019
A holdings report, 167 entries on the cover page, a total value of $1,930,062,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $1,930,062,000 with VALUE read as thousands by filing date, 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,261,350 | $407,719,000 | thousands by filing date | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 4,390,706 | $286,450,000 | thousands by filing date | |
| IJH | 464287507 | COM | 1,037,958 | $213,633,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 2,280,724 | $191,239,000 | thousands by filing date | |
| SPY | 78462F103 | SHS | 289,981 | $93,333,000 | thousands by filing date | |
| iShares Core MSCI Emerging Markets ETF | 46434G103 | SHS | 1,685,765 | $90,627,000 | thousands by filing date | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 1,133,672 | $55,867,000 | thousands by filing date | |
| iShares S&P Mid-Cap 400 Value ETF | 464287705 | SHS | 324,363 | $55,379,000 | thousands by filing date | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 552,551 | $46,337,000 | thousands by filing date | |
| SPDR Bloomberg Investment Grade Floating Rate ETF | 78468R200 | SHS | 1,262,101 | $38,784,000 | thousands by filing date | |
| Schwab US REIT ETF | 808524847 | SHS | 789,615 | $36,291,000 | thousands by filing date | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 779,770 | $34,357,000 | thousands by filing date | |
| Schwab Short Term US Treasury ETF | 808524862 | SHS | 549,828 | $27,755,000 | thousands by filing date | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 232,161 | $26,088,000 | thousands by filing date | |
| VANGUARD INTL EQUITY INDEX F | 922042676 | COM | 398,358 | $23,539,000 | thousands by filing date | |
| iShares TIPS Bond ETF | 464287176 | SHS | 185,126 | $21,580,000 | thousands by filing date | |
| iShares S&P 500 Value ETF | 464287408 | SHS | 125,760 | $16,360,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524839 | US AGGREGATE B | 252,589 | $13,496,000 | thousands by filing date | |
| ISHARES MICRO-CAP ETF | 464288869 | ETF | 134,537 | $13,385,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 247,696 | $11,015,000 | thousands by filing date | |
| ISHARES MSCI EAFE SMALL-CAP ETF | 464288273 | ETF | 159,965 | $9,963,000 | thousands by filing date | |
| iShares Floating Rate Bond ETF | 46429B655 | SHS | 189,275 | $9,638,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524805 | INTL EQTY ETF | 285,150 | $9,590,000 | thousands by filing date | |
| iShares 0-5 Year TIPS Bond ETF | 46429B747 | SHS | 83,599 | $8,419,000 | thousands by filing date | |
| INVESCO ACTVELY MNGD ETC FD | 46090F100 | OPTIMUM YIELD | 507,394 | $8,402,000 | thousands by filing date | |
| iShares MSCI EAFE Value ETF | 464288877 | SHS | 145,159 | $7,248,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R205 | 1-5 US TIP IDX | 137,656 | $7,209,000 | thousands by filing date | |
| PAYCHEX INC | 704326107 | COM | 78,634 | $6,689,000 | thousands by filing date | |
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 44,610 | $6,595,000 | thousands by filing date | |
| Schwab U.S. Large-Cap ETF | 808524201 | SHS | 82,017 | $6,300,000 | thousands by filing date | |
| SPDR SER TR | 78468R101 | PORTFOLIO SH TSR | 207,974 | $6,231,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 84,196 | $5,847,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A607 | ST STR DOW REIT | 53,320 | $5,440,000 | thousands by filing date | |
| ISHARES TR | 464288323 | NEW YORK MUN ETF | 67,414 | $3,846,000 | thousands by filing date | |
| ISHARES TR | 464288661 | 3 7 YR TREAS BD | 26,180 | $3,292,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 70,435 | $3,244,000 | thousands by filing date | |
| Schwab US TIPS ETF | 808524870 | SHS | 56,715 | $3,212,000 | thousands by filing date | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 17,948 | $3,157,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 32,584 | $3,024,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A649 | ST STR AGGRE ETF | 97,654 | $2,869,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 16,925 | $2,669,000 | thousands by filing date | |
| Vanguard Mid-Cap ETF | 922908629 | SHS | 13,876 | $2,472,000 | thousands by filing date | |
| Schwab US Mid-Cap ETF | 808524508 | SHS | 36,997 | $2,225,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 9,600 | $2,174,000 | thousands by filing date | |
| ISHARES TR | 464287457 | COM | 24,376 | $2,063,000 | thousands by filing date | |
| Schwab U.S. Small-Cap ETF | 808524607 | SHS | 26,340 | $1,992,000 | thousands by filing date | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 17,280 | $1,968,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 12,746 | $1,859,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X863 | ST DOW INTL ETF | 47,787 | $1,854,000 | thousands by filing date | |
| iShares Gold Trust | 464285105 | ISHARES | 123,510 | $1,791,000 | thousands by filing date | |
| SPDR PORTFOLIO TIPS ETF | 78464A656 | PORTFLI TIPS ETF | 62,605 | $1,787,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524706 | EMRG MKTEQ ETF | 63,965 | $1,751,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 5,757 | $1,691,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X871 | ST INTL CAP ETF | 53,045 | $1,690,000 | thousands by filing date | |
| ISHARES SHORT-TERM NATIONAL MUNI BOND ETF | 464288158 | ETF | 15,633 | $1,669,000 | thousands by filing date | |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 20,650 | $1,665,000 | thousands by filing date | |
| ISHARES TR | 464287887 | S&P SML 600 GWT | 8,599 | $1,662,000 | thousands by filing date | |
| ISHARES TR | 464287606 | S&P MC 400GR ETF | 6,905 | $1,644,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 ETF | 464287622 | ETF | 9,116 | $1,626,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524888 | INTL SCEQT ETF | 45,420 | $1,574,000 | thousands by filing date | |
| iShares S&P Small-Cap 600 Value ETF | 464287879 | SHS | 9,665 | $1,554,000 | thousands by filing date | |
| Vanguard S&P 500 ETF | 922908363 | COM | 5,179 | $1,532,000 | thousands by filing date | |
| META PLATFORMS INC CL A | 30303M102 | COM | 7,288 | $1,496,000 | thousands by filing date | |
| ISHARES TR | 464288612 | INTRM GOV CR ETF | 12,975 | $1,462,000 | thousands by filing date | |
| ISHARESAGENCYBONDETF | 464288166 | STOK | 12,400 | $1,433,000 | thousands by filing date | |
| Vanguard Mid-Cap Value ETF | 922908512 | SHS | 11,781 | $1,404,000 | thousands by filing date | |
| Visa Inc | 92826C839 | COM | 7,316 | $1,375,000 | thousands by filing date | |
| iShares Short Treasury Bond ETF | 464288679 | SHS | 12,185 | $1,346,000 | thousands by filing date | |
| MasterCard, Inc | 57636Q104 | COM | 4,497 | $1,343,000 | thousands by filing date | |
| iShares S&P 500 Growth ETF | 464287309 | SHS | 6,597 | $1,277,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 11,000 | $1,248,000 | thousands by filing date | |
| PepsiCo,Inc. | 713448108 | COM | 8,832 | $1,207,000 | thousands by filing date | |
| Micron Technology,Inc. | 595112103 | COM | 22,425 | $1,206,000 | thousands by filing date | |
| NOVARTIS AG SPONSORED ADR | 66987V109 | ADR | 12,560 | $1,189,000 | thousands by filing date | |
| SPDR SER TR STATE STR SPDR PORT S&P 500 ETF | 78464A854 | SHS | 30,729 | $1,162,000 | thousands by filing date | |
| JPMorgan Chase & Co | 46625H100 | COM | 8,225 | $1,147,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A839 | ST STR SP400VAL | 20,406 | $1,118,000 | thousands by filing date | |
| iShares MBS ETF | 464288588 | SHS | 10,200 | $1,102,000 | thousands by filing date | |
| LULULEMON ATHLETICA INC | 550021109 | COM | 4,750 | $1,100,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 7,150 | $1,091,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 6,506 | $1,078,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 15,265 | $1,065,000 | thousands by filing date | |
| ISHARES 1-5 YEAR INVESTMENT GRADE CORPORATE BOND ETF | 464288646 | ETF | 19,540 | $1,048,000 | thousands by filing date | |
| Vanguard Small-Cap ETF | 922908751 | SHS | 6,145 | $1,018,000 | thousands by filing date | |
| Amazon.com, Inc | 023135106 | COM | 547 | $1,011,000 | thousands by filing date | |
| SPDR SER TR | 78468R721 | NUVEEN BLMBRG MU | 19,572 | $990,000 | thousands by filing date | |
| SPDR S&P Midcap 400 ETF Trust | 78467Y107 | SHS | 2,426 | $911,000 | thousands by filing date | |
| VANGUARD TAX-EXEMPT BOND ETF | 922907746 | ETF | 16,520 | $884,000 | thousands by filing date | |
| VANECK ETF TRUST | 92189H201 | INTRMDT MUNI ETF | 17,200 | $864,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP VALUE ETF | 464287473 | ETF | 9,006 | $853,000 | thousands by filing date | |
| Mondelez International,Inc. Class A | 609207105 | COM | 15,320 | $844,000 | thousands by filing date | |
| SONY GROUP CORP SPONSORED ADR | 835699307 | ADR | 12,260 | $834,000 | thousands by filing date | |
| Lowes Companies,Inc. | 548661107 | COM | 6,947 | $832,000 | thousands by filing date | |
| NVIDIA Corp | 67066G104 | COM | 3,445 | $811,000 | thousands by filing date | |
| SPDR S&P 500 Fossil Fuel Reserves Free ETF | 78468R796 | SHS | 9,945 | $784,000 | thousands by filing date | |
| Schwab Intermediate-Term US Treasury ETF | 808524854 | SHS | 14,000 | $769,000 | thousands by filing date | |
| ACTVISION BLIZZARD INC | 00507V109 | COM | 12,655 | $752,000 | thousands by filing date | |
| SCHWAB STRATEGIC TR | 808524409 | US LCAP VA ETF | 12,491 | $751,000 | thousands by filing date | |
| Alphabet Inc. Reg. Shares A | 02079K305 | COM | 539 | $722,000 | thousands by filing date | |
| Coca-Cola Company | 191216100 | COM | 12,895 | $714,000 | thousands by filing date | |
| ServiceNow,Inc. | 81762P102 | COM | 2,475 | $699,000 | thousands by filing date | |
| iShares iBoxx Inv Grade Corporate Bond ETF | 464287242 | SHS | 5,300 | $678,000 | thousands by filing date | |
| UNILEVER PLC | 904767704 | SPON ADR NEW | 11,770 | $673,000 | thousands by filing date | |
| VTI | 922908769 | COM | 4,037 | $661,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 3,050 | $653,000 | thousands by filing date | |
| EQUINIX INC COM | 29444U700 | REIT | 1,065 | $622,000 | thousands by filing date | |
| INVESCO EXCHANGE TRADED FD T | 46137V258 | S&P500 PUR VAL | 8,346 | $578,000 | thousands by filing date | |
| SBA COMMUNICATIONS CORP CL A | 78410G104 | REIT | 2,327 | $561,000 | thousands by filing date | |
| ALLSTATE CORP COM | 020002101 | Stock | 4,902 | $551,000 | thousands by filing date | |
| ISHARES TR | 464288281 | JPMORGAN USD EMG | 4,770 | $546,000 | thousands by filing date | |
| BARCLAYS BANK PLC | 06738C778 | DJUBS CMDT ETN36 | 22,615 | $517,000 | thousands by filing date | |
| American Tower Corporation | 03027X100 | COM | 2,240 | $515,000 | thousands by filing date | |
| BIOMARIN PHARMACEUTICAL INC | 09061G101 | COM | 6,020 | $509,000 | thousands by filing date | |
| ELECTRONIC ARTS INC COM | 285512109 | Stock | 4,590 | $493,000 | thousands by filing date | |
| iShares ESG Aware US Aggregate Bond ETF | 46435U549 | SHS | 8,925 | $479,000 | thousands by filing date | |
| ISHARES TR | 464287630 | RUS 2000 VAL ETF | 3,515 | $452,000 | thousands by filing date | |
| Schlumberger Limited | 806857108 | COM | 11,096 | $446,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 4,005 | $433,000 | thousands by filing date | |
| S&P Global,Inc. | 78409V104 | COM | 1,575 | $430,000 | thousands by filing date | |
| MOODYS CORP COM | 615369105 | Stock | 1,810 | $430,000 | thousands by filing date | |
| ISHARES TR | 464288521 | CRE U S REIT ETF | 7,849 | $428,000 | thousands by filing date | |
| DB COMMODITY INDEX TRACKING | 46138B103 | ETF | 26,585 | $424,000 | thousands by filing date | |
| SPDW | 78463X889 | COM | 13,465 | $422,000 | thousands by filing date | |
| ISHARES TR | 464287440 | 7-10 YR TRSY BD | 3,800 | $419,000 | thousands by filing date | |
| ISHARES TR | 464288208 | MRGSTR MD CP ETF | 1,895 | $397,000 | thousands by filing date | |
| Booking Holdings Inc. | 09857L108 | COM | 191 | $392,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 4,285 | $390,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 6,473 | $387,000 | thousands by filing date | |
| Intercontinental Exchange,Inc. | 45866F104 | COM | 4,130 | $382,000 | thousands by filing date | |
| ALIBABA GROUP HLDG LTD | 01609W102 | SPONSORED ADS | 1,755 | $372,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 8,270 | $371,000 | thousands by filing date | |
| RYANAIR HOLDINGS PLC SPONSORED ADR | 783513203 | ADR | 4,225 | $370,000 | thousands by filing date | |
| SPDR Portfolio S&P 400 Mid Cap ETF | 78464A847 | SHS | 10,039 | $364,000 | thousands by filing date | |
| CME Group Inc. Class A | 12572Q105 | COM | 1,795 | $360,000 | thousands by filing date | |
| CBOE GLOBAL MKTS INC COM | 12503M108 | Stock | 2,980 | $358,000 | thousands by filing date | |
| GRAPHIC PACKAGING HLDG CO COM | 388689101 | Stock | 21,295 | $355,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 2,407 | $348,000 | thousands by filing date | |
| TOMPKINS FINL CORP COM | 890110109 | Stock | 3,796 | $347,000 | thousands by filing date | |
| CONSTELLATION BRANDS INC CL A | 21036P108 | Stock | 1,791 | $340,000 | thousands by filing date | |
| BERKSHIRE HATHAWAY INC DEL | 084670108 | CL A | 1 | $340,000 | thousands by filing date | |
| ALCON AG ORD SHS | H01301128 | Stock | 5,882 | $333,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C771 | SHS | 6,200 | $330,000 | thousands by filing date | |
| SEATTLE GENETICS INC | 812578102 | COM | 2,875 | $328,000 | thousands by filing date | |
| HALLIBURTON CO COM | 406216101 | Stock | 12,805 | $313,000 | thousands by filing date | |
| SPDR Portfolio S&P 600 Small Cap ETF | 78468R853 | SHS | 9,343 | $305,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 3,467 | $301,000 | thousands by filing date | |
| Oracle Corporation | 68389X105 | COM | 5,657 | $300,000 | thousands by filing date | |
| STATE STR SPDR DOW JONES IND | 78467X109 | UT SER 1 | 1,045 | $298,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R739 | ST NUVE TERM ETF | 6,059 | $298,000 | thousands by filing date | |
| SPDR GOLD TR | 78463V107 | GOLD SHS | 1,919 | $274,000 | thousands by filing date | |
| Automatic Data Processing,Inc. | 053015103 | COM | 1,585 | $270,000 | thousands by filing date | |
| ISHARES INC | 464286475 | EM MKT SM-CP ETF | 5,974 | $270,000 | thousands by filing date | |
| Vertex Pharmaceuticals Incorporated | 92532F100 | COM | 1,220 | $267,000 | thousands by filing date | |
| Boeing Company | 097023105 | COM | 814 | $265,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R408 | ST TERM HIGH ETF | 9,445 | $254,000 | thousands by filing date | |
| MICROCHIP TECHNOLOGY INC. COM | 595017104 | Stock | 2,405 | $252,000 | thousands by filing date | |
| ISHARES TR | 46432F834 | COM | 3,881 | $240,000 | thousands by filing date | |
| INGERSOLL-RAND PLC | G47791101 | SHS | 1,775 | $236,000 | thousands by filing date | |
| INCYTE CORP COM | 45337C102 | Stock | 2,680 | $234,000 | thousands by filing date | |
| SHERWIN WILLIAMS CO | 824348106 | COM | 400 | $233,000 | thousands by filing date | |
| SPDR SER TR | 78464A508 | PRTFLO S&P500 VL | 6,643 | $232,000 | thousands by filing date | |
| Union Pacific Corporation | 907818108 | COM | 1,240 | $224,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 1,706 | $213,000 | thousands by filing date | |
| COGNEX CORP | 192422103 | COM | 3,795 | $213,000 | thousands by filing date | |
| BLACKROCK INC CL A COM | 09247X101 | COM | 421 | $212,000 | thousands by filing date | |
| AMBEV SA SPONSORED ADR | 02319V103 | ADR | 34,700 | $162,000 | thousands by filing date | |
| TRANSOCEAN LTD REGISTERED SHS | H8817H100 | Stock | 16,175 | $111,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001567619-20-003493 | this filing | 2020-02-14 | acceptance time not in the bulk data set |