Analysts Stocks

      AnaChart Data Marketplace Terms of Use

      Snowflake Marketplace Product Documentation

      AnaChart NASDAQ100 Analyst Price Targets and Ratings

      Product Overview

      AnaChart NASDAQ100 Analyst Price Targets and Ratings is a Snowflake Marketplace dataset containing over 50,000 verified analyst actions across Nasdaq100 constituents over the past 15 years.

      Each record captures both rating changes and price target revisions point-in-time, enabling structured analysis of analyst sentiment, conviction shifts, and group behavior.

      The dataset is designed for quantitative research, financial modeling, sentiment analysis, and backtesting.

      Dataset Coverage

      • Universe: Nasdaq100 constituents

      • Time Coverage: 15 years historical data

      • Records: 50,000+ analyst actions

      • Update Frequency: Regular updates (see listing for current frequency)

      • Delivery Method: Snowflake Secure Share

      • Shared Object: PUBLIC.NASDAQPTRATINGS

      Table Schema and Data Dictionary

      The dataset is delivered as a structured Snowflake table with the following columns:

      Column Description
      Date Date of analyst action
      Company_Name Company name
      Ticker Nasdaq100 ticker symbol
      Broker Research firm issuing the update
      Analyst Analyst name
      Rating_Before Analyst rating prior to update
      Rating_After Analyst rating after update
      Price_Target_Before Previous price target
      Price_Target_After Updated price target
      Link Source reference URL

      All records are structured and formatted for direct analytical use in Snowflake.

      Quick Start Guide

      After installing the listing in Snowflake Marketplace, reference the shared table using:

      PUBLIC.NASDAQPTRATINGS


      Example 2 — Analyst Herd Behavior Over Time

      SELECT
      TO_DATE(Date) AS Day,
      COUNT(*) AS Total_Actions,
      SUM(IFF(Rating_After <> Rating_Before, 1, 0)) AS Rating_Changes,
      SUM(IFF(Price_Target_After > Price_Target_Before, 1, 0)) AS PT_Raises,
      SUM(IFF(Price_Target_After < Price_Target_Before, 1, 0)) AS PT_Cuts
      FROM PUBLIC.NASDAQPTRATINGS
      WHERE TO_DATE(Date) >= DATEADD('day', -90, CURRENT_DATE())
      GROUP BY 1
      ORDER BY 1 DESC;

      Example 3 — Largest Price Target Revisions (Last 12 Months)

      SELECT
      Date,
      Ticker,
      Company_Name,
      Broker,
      Analyst,
      Rating_Before,
      Rating_After,
      Price_Target_Before,
      Price_Target_After,
      (Price_Target_After - Price_Target_Before) AS PT_Change,
      Link
      FROM PUBLIC.NASDAQPTRATINGS
      WHERE TO_DATE(Date) >= DATEADD('year', -1, CURRENT_DATE())
      AND Price_Target_After IS NOT NULL
      AND Price_Target_Before IS NOT NULL
      ORDER BY ABS(Price_Target_After - Price_Target_Before) DESC
      LIMIT 50;

      Intended Use Cases

      • Analyst sentiment factor construction

      • Herd behavior detection

      • Conviction intensity analysis (price target revisions vs rating changes)

      • Event studies and return analysis

      • Quantitative investment research

      Usage Notes

      This dataset is intended for research and analytical purposes.
      It is not investment advice.

      For licensing terms, please refer to the applicable Snowflake Marketplace listing terms.

      Support

      For technical questions or dataset inquiries, contact:

      [email protected]