Index Time Series for Vanguard S&P 500 ETF. The frequency of the observation is daily. Moving average series are also typically included. The fund employs an indexing investment approach designed to track the performance of the Standard & Poor's 500 Index, a widely recognized benchmark of U.S. stock market performance that is dominated by the stocks of large U.S. companies. The advisor attempts to replicate the target index by investing all, or substantially all, of its assets in the stocks that make up the index, holding each stock in approximately the same proportion as its weighting in the index. The fund is non-diversified.

As of August 2025, the Vanguard S&P 500 ETF was the largest ETF by assets under management (AUM) listed on a U.S. market, holding assets of roughly ***** million U.S. dollars. The SPDR S&P 500 ETF Trust the second-largest ETF on the list, also tracks the performance of the S&P 500 stock market index. An index fund is an investment fund typically a type of mutual fund or an ETF that tracks a basket of securities, or an index.

As of August 2025, the Vanguard Information Technology Index Fund provided the ******* one-year return rate. The Vanguard S&P 500 Growth Index Fund ranked ****** having a one-year return rate of *****percent. As of August 2025, the Vanguard Total Stock Market Index Fund was the largest fund owned by Vanguard, with net assets under management worth approximately **** trillion U.S. dollars. What is the difference between mutual funds and exchange traded funds? Both mutual funds and exchange traded funds (ETFs) originate from the concept of pooled fund investing, which bundles securities together to offer investors a more diversified portfolio. However, mutual funds and ETFs have some key differences. For instance, ETFs offer more flexible trading as they trade during the day like stocks, while mutual funds only allow transactions at the end of the day. Moreover, ETFs are mostly passively-managed and mirror a designated index. On the other hand, mutual funds are typically actively-managed, as it can be seen by comparing the number of actively and passively-managed mutual funds in the United States. Vanguard Founded by John C. Bogle in 1975, Vanguard is a U.S. asset management company that offers both mutual funds and ETFs. Headquartered in Malvern, Pennsylvania, Vanguard was the ****** largest provider of ETFs in the United States after BlackRock Financial Management, with assets under management worth *** trillion U.S. dollars. Likewise, in 2025, Vanguard ranked among the largest providers of mutual funds worldwide. The total assets under management of Vanguard increased considerably since its foundation in 1975, and peaked at *****trillion U.S. dollars in April 2025.

Description:

• This dataset includes individual ticker data for the following assets:
  • VOO (Vanguard S&P 500 ETF)
  • QQQ (Invesco QQQ ETF)
  • VEA (Vanguard FTSE Developed Markets ETF)
  • VWO (Vanguard FTSE Emerging Markets ETF)
  • VT (Vanguard Total World Stock ETF)
  • FUNO11.MX (Fibra Uno)
  • CETES (28 days, Mexican bonds)
• Each ticker dataset contains the following columns: Open, High, Low, Close, Adj Close, Volume, Ticker, and Date. The CETES dataset is an exception, containing only Date and daily rate information.

Period:

• From 2011 to July 2024.

Combined Dataframe: - A combined dataframe is included, containing information from all the tickers. This combined dataframe is used for the analysis in the provided code.

Portfolio Configurations:

• VOO Configuration:

  • Assets: VOO, VEA, VWO, FUNO11.MX, CETES
  • Code Name: portfolio_voo
  • Description: Combines U.S., developed, and emerging market stocks with Mexican REIT and bonds.

• QQQ Configuration:

  • Assets: QQQ, VEA, VWO, FUNO11.MX, CETES
  • Code Name: portfolio_qqq
  • Description: Includes Nasdaq-100 stocks, developed and emerging market stocks, Mexican REIT, and bonds.

• VT Configuration:

  • Assets: VT, FUNO11.MX, CETES
  • Code Name: portfolio_vt
  • Description: Global stock market exposure with Mexican REIT and bonds.

Purpose:

The purpose of gathering this data is to analyze different configurations for investment portfolios. The analysis explores both dynamic and static investment strategies, following Swensen's model and the 110 rule. This dataset provides a comprehensive basis for studying portfolio performance, risk metrics, and investment returns over an extended period.

For a detailed description of the project, please visit my Medium blog post

The number of exchange-traded funds (ETFs) in the United States has steadily increased. Starting with *** ETFs in 2003, this amount has grown to a total of ***** ETFs as of June 2025. The value of assets under management (AUM) allocated to ETFs in the United States has experienced a sharp increase. What is an ETF? An ETF is a pooled financial product that can be bought and sold on the stock market by retail and institutional investors. ETFs are structured to track the performance of underlying securities. This may range from tracking a singular underlying commodity to a diverse assortment of securities. Some of the largest ETF providers by market share in the United States as of 2025 included BlackRock and Vanguard, each accounting for approximately ********* or more of the U.S. market. Types of ETFs Broad-based domestic equity, global equity, and bond ETFs have the highest issuance rates of ETFs in the United States. A broad-based index sets a benchmark to track the performance of a group of underlying securities. A popular example includes the evaluated performance difference between the S&P 500 ESG and S&P 500 indexes.

The largest exchange-traded fund (ETF) traded in the United States, as of August 16, 2025, was the Vanguard S&P 500 ETF, holding assets under management (AUM) of approximately *** billion U.S. dollars. The Vanguard S&P 500 ETF was one of the largest providers of ETFs in the United States. What are ETFs? An ETF is a basket of shares or other financial assets which generally tracks an underlying index. They are similar to mutual funds, with the fundamental difference that ETFs are listed on stock exchanges, with ETF shares being traded just like regular stock. Are ETFs a good investment? As ETFs hold a basket of stocks and other financial assets, they are diverse and are considered low-risk investments. This makes them popular among risk-averse investors, beginners, or among those who plan to invest more long-term. The popularity of ETFs has increased dramatically in the last decade, which can be seen by the steady increase in the number of ETFs worldwide.

As of the second quarter of 2025, the New York City-based asset management company BlackRock had total assets under management (AUM) of around 12.53 trillion U.S. dollars. The total assets under management of BlackRock Inc. more than doubled between 2016 and 2025, reaching a value which makes them the world’s largest asset management company. Which assets do BlackRock manage? The company manages a wide range of assets: equity, fixed income, multi-assets, and alternatives, but their assets under management are also counted in cash management and advisory. As of 2024, the largest proportion of BlackRock’s AUM was equity, which accounted for more than half of their total AUM that year. Which are their leading funds? BlackRock manages several different types of funds in several asset classes: exchange-traded funds (ETFs), mutual funds, and close-end funds. As of 2024, the ETF iShares Core S&P 500 was the company’s leading fund, which corresponds to the performance of common stocks in the S&P 500 Index.

As of August 2025, Euroclear was the largest fund manager among global fund managers by assets under management (AUM), managing around **** trillion U.S. dollars. BlackRock came in second, with approximately **** trillion US dollars in assets under management. Meanwhile, Schwab ranked third, managing fund assets worth ***** trillion US dollars. Types of investment funds. Investment funds are an important part of financial planning and investing. There are several different types of investment funds offered by fund managers, each with their own purpose and asset types. Mutual funds pool money from many investors and use that money to purchase a portfolio of stocks, bonds, and other securities. Index funds are a type of mutual fund that tracks a market index, like the S&P 500. Exchange-traded funds (ETFs) are a type of mutual fund, that is continuously traded on a stock exchange. ETFs often track market indexes or sectors. Real estate investment trusts (REITs) provide both retail and institutional investors with exposure to income-generating real estate assets such as office buildings, apartments and hotels, without having to fully invest in an individual property. The benefits of investment funds. The main advantage of investment funds is that they provide instant portfolio diversification. Rather than choosing just a few stocks or bonds, funds allow you to invest in a wide variety of different securities in one purchase. This helps reduce risk, as poor performance of one holding has less impact on the overall fund. Funds also provide access to professional management and research. Managers can take advantage of opportunities and insights that an individual investor may not have the ability to leverage. Finally, funds offer convenience. Investors won't be required to constantly rebalance portfolios. While costs and fees are a consideration, investment funds can be an excellent hands-off way for both retail and institutional investors to benefit from the market while spreading risk over many asset classes and securities.

As of February 2025, Vanguard's Total Stock Market ETF was the highest valued exchange-traded fund (ETF) globally, with a market capitalization of over *** trillion U.S. dollars. The Vanguard S&P 500 ETF ranked in second, also having a total market capitalization exceeding ************ U.S. dollars. The iShares Core S&P 500, rounded out the top three, having almost *** billion U.S. dollars in market capitalization.