Shared conversation on NexusTrade
AI Stocks Average Return Analysis
An analysis of the average returns of AI stocks over the past year, including insights on market-cap-weighted returns and the impact of excluding outliers.
Aurora: Hello. Would you like to use GPT Stock Reports to find the best Ecommerce stocks?
User: what is the average return of all AI stocks in the past year?
Aurora: Here’s the available data, presented in a Markdown table: | avg_percent_return | |--------------------| | 49.28 | ## Observations • This single-row result indicates that, on average, the stocks classified under AI (artificialIntelligence = TRUE) yielded a one-year return of about 49.28%. • We do not have individual stock-level returns in the final output—only this aggregate. If stock-level details were provided, we would list each one in a table with its corresponding return. ## What the Query Does The query identifies all stocks labeled as AI in the “stockindustries.current” table, finds their adjusted closing prices one year prior and at the most recent date available, calculates each stock’s one-year return, and then reports the average of those returns as a percentage. It’s designed to answer how AI-related stocks have performed, on average, over the last year. ## Important Disclaimers • As an AI, I might make mistakes. The information above should be double-checked against reliable sources before you make any financial decisions. • Past performance does not guarantee future results, and market conditions can shift rapidly. • Always consult multiple data points and, if needed,…
User: exclude the stocks in the top 10 percentile and bottom 90 percentile of returns
Aurora: ## Query Results Below is a Markdown table showing the final result returned by the query. It does not include stock-level data; instead, it contains an aggregated number reflecting the average 1-year return for AI stocks (excluding the top 10% and bottom 10% outliers): | avg_return_excluding_outliers | |-------------------------------| | 8.08 | --- ## Observations 1. The query only produced a single aggregated value, indicating the average 1-year return for AI-designated stocks after outliers in the top and bottom 10% were excluded. 2. No individual stock symbols appear in these results because the query was designed to compute only an aggregate measure. 3. If you were expecting a list of every AI stock and its respective return, be aware that this particular query does not include that breakdown (it calculates an overall average only). --- ## What the Query Is Designed to Do • This SQL statement identifies stocks marked as AI (artificialIntelligence = TRUE), finds each stock’s adjusted price from a year ago and the latest price on record, calculates each stock’s one-year return, filters out the top 10% and bottom 10% of returns as outliers, and finally returns the average one-ye…
User: what about these two groups: * all AI stocks * all AI stocks excluding the stocks in the top 10 percentile and bottom 90 percentile of returns This time, I want to weight it by market cap, so higher market caps as of last year are weighted more than lower market caps
Aurora: ### 1. Final Results in a Markdown Table Below is a table containing all rows from the final results: | group_label | weighted_return | |---------------------|-------------------------| | ALL_AI | 0.45448345337060037 | | EXCLUDING_OUTLIERS | 0.33683707650540035 | There is no ticker-level breakdown provided in this particular output (i.e., no individual stock entries). The final result only shows these two aggregated rows. --- ### 2. Notable Observations • The first row (“ALL_AI”) shows the market-cap-weighted average return for every AI-designated stock over the past year. • The second row (“EXCLUDING_OUTLIERS”) reveals the weighted return after removing stocks in the top and bottom decile of returns (the top 10% and bottom 10%). These two values help compare how outlier stocks (extremely high or low returns) can skew the overall average return. --- ### 3. What the Query Does (in Simple Terms) This query finds stocks labeled as AI, calculates each one’s one-year price return, and then computes a market-cap-weighted average return across all of them. It also splits the results into: 1. A group that includes all AI stocks. 2. A group that excludes the highest 10% and lowest 10% of r…