We have assembled a large collection of predefined queries to demonstrate the range of information that can be obtained from our market data, and to serve as a starting point for creating new queries. All of these predefined queries use the same set of variables as the Query Tool, and the queries can be viewed and modified as needed to restrict or broaden the results, include additional columns, etc.
This query returns the most actively traded stocks and ETFs by money flow on the last trading day. Money flow of a security for a given day is defined to be the average of the high, low, and closing prices multiplied by volume.
Most Active Securities by Money Flow, Past WeekThis query returns the most actively traded stocks and ETFs by money flow over the past week. Money flow of a security for a given day is defined to be the average of the high, low, and closing prices multiplied by volume.
Most Active Securities by Money Flow, Past 2 WeeksThis query returns the most actively traded stocks and ETFs by money flow over the past 2 weeks. Money flow of a security for a given day is defined to be the average of the high, low, and closing prices multiplied by volume.
Most Active Securities by Money Flow, Past 4 WeeksThis query returns the most actively traded stocks and ETFs by money flow over the past 4 weeks. Money flow of a security for a given day is defined to be the average of the high, low, and closing prices multiplied by volume.
Most Active Securities by Money Flow, Past 13 WeeksThis query returns the most actively traded stocks and ETFs by money flow over the past 13 weeks. Money flow of a security for a given day is defined to be the average of the high, low, and closing prices multiplied by volume.
Most Active Securities by Money Flow, Past 26 WeeksThis query returns the most actively traded stocks and ETFs by money flow over the past 26 weeks. Money flow of a security for a given day is defined to be the average of the high, low, and closing prices multiplied by volume.
Most Active Securities by Money Flow, Past 52 WeeksThis query returns the most actively traded stocks and ETFs by money flow over the past 52 weeks. Money flow of a security for a given day is defined to be the average of the high, low, and closing prices multiplied by volume.
Most Active Securities by Volume, 1 DayThis query returns the most actively traded stocks and ETFs by volume on the last trading day.
Most Active Securities by Volume, Past WeekThis query returns the most actively traded stocks and ETFs by total number of shares traded over the past week. Volume on past days is adjusted for splits when calculating total volume over a period of time.
Most Active Securities by Volume, Past 2 WeeksThis query returns the most actively traded stocks and ETFs by total number of shares traded over the past 2 weeks. Volume on past days is adjusted for splits when calculating total volume over a period of time.
Most Active Securities by Volume, Past 4 WeeksThis query returns the most actively traded stocks and ETFs by total number of shares traded over the past 4 weeks. Volume on past days is adjusted for splits when calculating total volume over a period of time.
Most Active Securities by Volume, Past 13 WeeksThis query returns the most actively traded stocks and ETFs by total number of shares traded over the past 13 weeks. Volume on past days is adjusted for splits when calculating total volume over a period of time.
Most Active Securities by Volume, Past 26 WeeksThis query returns the most actively traded stocks and ETFs by total number of shares traded over the past 26 weeks. Volume on past days is adjusted for splits when calculating total volume over a period of time.
Most Active Securities by Volume, Past 52 WeeksThis query returns the most actively traded stocks and ETFs by total number of shares traded over the past 52 weeks. Volume on past days is adjusted for splits when calculating total volume over a period of time.
This query returns companies that are expected to announce quarterly earnings within the next 30 days. Earnings estimates are calculated as diluted earnings per share before non-recurring items and including employee stock options expenses.
Recent Earnings AnnouncementsThis query returns companies that had an earnings announcement within the past 30 days. Earnings figures are calculated as diluted earnings per share before non-recurring items and including employee stock options expenses.
Recent DividendsThis query returns securities that had an ex-dividend date within the past 30 days.
Recent Stock SplitsThis query returns securities that have had a stock split within the past 30 days.
This query returns securities that traded at a new 4-week high price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new high price has been reached.
Stocks Reaching a New 4-Week Low PriceThis query returns securities that traded at a new 4-week low price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new low price has been reached.
Stocks Reaching a New 13-Week High PriceThis query returns securities that traded at a new 13-week high price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new high price has been reached.
Stocks Reaching a New 13-Week Low PriceThis query returns securities that traded at a new 13-week low price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new low price has been reached.
Stocks Reaching a New 26-Week High PriceThis query returns securities that traded at a new 26-week high price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new high price has been reached.
Stocks Reaching a New 26-Week Low PriceThis query returns securities that traded at a new 26-week low price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new low price has been reached.
Stocks Reaching a New 52-Week High PriceThis query returns securities that traded at a new 52-week high price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new high price has been reached.
Stocks Reaching a New 52-Week Low PriceThis query returns securities that traded at a new 52-week low price on the last trading day. Past prices are adjusted for splits and dividends when determining if a new low price has been reached.
This query returns securities that had a new 4-week high volume on the last trading day. Past volumes are adjusted for splits when determining if a new high volume has been reached.
Stocks with a New 4-Week Low VolumeThis query returns securities that had a new 4-week low volume on the last trading day. Past volumes are adjusted for splits when determining if a new low volume has been reached.
Stocks with a New 13-Week High VolumeThis query returns securities that had a new 13-week high volume on the last trading day. Past volumes are adjusted for splits when determining if a new high volume has been reached.
Stocks with a New 13-Week Low VolumeThis query returns securities that had a new 13-week low volume on the last trading day. Past volumes are adjusted for splits when determining if a new low volume has been reached.
Stocks with a New 26-Week High VolumeThis query returns securities that had a new 26-week high volume on the last trading day. Past volumes are adjusted for splits when determining if a new high volume has been reached.
Stocks with a New 26-Week Low VolumeThis query returns securities that had a new 26-week low volume on the last trading day. Past volumes are adjusted for splits when determining if a new low volume has been reached.
Stocks with a New 52-Week High VolumeThis query returns securities that had a new 52-week high volume on the last trading day. Past volumes are adjusted for splits when determining if a new high volume has been reached.
Stocks with a New 52-Week Low VolumeThis query returns securities that had a new 52-week low volume on the last trading day. Past volumes are adjusted for splits when determining if a new low volume has been reached.
This query returns the securities that had the largest close-to-close percent increase in price on the last trading day.
Largest Percent Decrease in Price, 1 DayThis query returns the securities that had the largest close-to-close percent decrease in price on the last trading day.
Largest Percent Increase in Price, Past WeekThis query returns the securities that had the largest close-to-close percent increase in price over the past week. Past prices are adjusted for splits and dividends when calculating the percentage price increase over a period of time.
Largest Percent Decrease in Price, Past WeekThis query returns the securities that had the largest close-to-close percent decrease in price over the past week. Past prices are adjusted for splits and dividends when calculating the percentage price decrease over a period of time.
Largest Percent Increase in Price, Past 4 WeeksThis query returns the securities that had the largest close-to-close percent increase in price over the past 4 weeks. Past prices are adjusted for splits and dividends when calculating the percentage price increase over a period of time.
Largest Percent Decrease in Price, Past 4 WeeksThis query returns the securities that had the largest close-to-close percent decrease in price over the past 4 weeks. Past prices are adjusted for splits and dividends when calculating the percentage price decrease over a period of time.
Largest Percent Increase in Price, Past 13 WeeksThis query returns the securities that had the largest close-to-close percent increase in price over the past 13 weeks. Past prices are adjusted for splits and dividends when calculating the percentage price increase over a period of time.
Largest Percent Decrease in Price, Past 13 WeeksThis query returns the securities that had the largest close-to-close percent decrease in price over the past 13 weeks. Past prices are adjusted for splits and dividends when calculating the percentage price decrease over a period of time.
This query returns the securities having the most consecutive trading days with a close-to-close increase in price, as of the last trading day.
Most Consecutive Days with Decreasing PriceThis query returns the securities having the most consecutive trading days with a close-to-close decrease in price, as of the last trading day.
Most Consecutive Weeks with Increasing PriceThis query returns the securities having the most consecutive weeks with a close-to-close increase in price, as of the last trading day.
Most Consecutive Weeks with Decreasing PriceThis query returns the securities having the most consecutive weeks with a close-to-close decrease in price, as of the last trading day.
This query returns the securities having the most consecutive trading days with an increase in volume, as of the last trading day.
Most Consecutive Days with Decreasing VolumeThis query returns the securities having the most consecutive trading days with a decrease in volume, as of the last trading day.
Most Consecutive Weeks with Increasing VolumeThis query returns the securities having the most consecutive weeks with an increase in weekly volume, as of the last trading day.
Most Consecutive Weeks with Decreasing VolumeThis query returns the securities having the most consecutive weeks with a decrease in weekly volume, as of the last trading day.
This query returns securities which had the closing price cross above the 5-day simple moving average on the last trading day.
Price Crossed Below 5-Day Moving AverageThis query returns securities which had the closing price cross below the 5-day simple moving average on the last trading day.
Price Crossed Above 10-Day Moving AverageThis query returns securities which had the closing price cross above the 10-day simple moving average on the last trading day.
Price Crossed Below 10-Day Moving AverageThis query returns securities which had the closing price cross below the 10-day simple moving average on the last trading day.
Price Crossed Above 20-Day Moving AverageThis query returns securities which had the closing price cross above the 20-day simple moving average on the last trading day.
Price Crossed Below 20-Day Moving AverageThis query returns securities which had the closing price cross below the 20-day simple moving average on the last trading day.
Price Crossed Above 50-Day Moving AverageThis query returns securities which had the closing price cross above the 50-day simple moving average on the last trading day.
Price Crossed Below 50-Day Moving AverageThis query returns securities which had the closing price cross below the 50-day simple moving average on the last trading day.
Price Crossed Above 100-Day Moving AverageThis query returns securities which had the closing price cross above the 100-day simple moving average on the last trading day.
Price Crossed Below 100-Day Moving AverageThis query returns securities which had the closing price cross below the 100-day simple moving average on the last trading day.
Price Crossed Above 200-Day Moving AverageThis query returns securities which had the closing price cross above the 200-day simple moving average on the last trading day.
Price Crossed Below 200-Day Moving AverageThis query returns securities which had the closing price cross below the 200-day simple moving average on the last trading day.
5-Day Moving Average Crossed Above 10-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross above the 10-day simple moving average on the last trading day.
5-Day Moving Average Crossed Below 10-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross below the 10-day simple moving average on the last trading day.
5-Day Moving Average Crossed Above 20-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross above the 20-day simple moving average on the last trading day.
5-Day Moving Average Crossed Below 20-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross below the 20-day simple moving average on the last trading day.
5-Day Moving Average Crossed Above 50-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross above the 50-day simple moving average on the last trading day.
5-Day Moving Average Crossed Below 50-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross below the 50-day simple moving average on the last trading day.
5-Day Moving Average Crossed Above 100-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross above the 100-day simple moving average on the last trading day.
5-Day Moving Average Crossed Below 100-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross below the 100-day simple moving average on the last trading day.
5-Day Moving Average Crossed Above 200-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross above the 200-day simple moving average on the last trading day.
5-Day Moving Average Crossed Below 200-Day Moving AverageThis query returns securities which had the 5-day simple moving average cross below the 200-day simple moving average on the last trading day.
10-Day Moving Average Crossed Above 20-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross above the 20-day simple moving average on the last trading day.
10-Day Moving Average Crossed Below 20-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross below the 20-day simple moving average on the last trading day.
10-Day Moving Average Crossed Above 50-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross above the 50-day simple moving average on the last trading day.
10-Day Moving Average Crossed Below 50-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross below the 50-day simple moving average on the last trading day.
10-Day Moving Average Crossed Above 100-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross above the 100-day simple moving average on the last trading day.
10-Day Moving Average Crossed Below 100-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross below the 100-day simple moving average on the last trading day.
10-Day Moving Average Crossed Above 200-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross above the 200-day simple moving average on the last trading day.
10-Day Moving Average Crossed Below 200-Day Moving AverageThis query returns securities which had the 10-day simple moving average cross below the 200-day simple moving average on the last trading day.
20-Day Moving Average Crossed Above 50-Day Moving AverageThis query returns securities which had the 20-day simple moving average cross above the 50-day simple moving average on the last trading day.
20-Day Moving Average Crossed Below 50-Day Moving AverageThis query returns securities which had the 20-day simple moving average cross below the 50-day simple moving average on the last trading day.
20-Day Moving Average Crossed Above 100-Day Moving AverageThis query returns securities which had the 20-day simple moving average cross above the 100-day simple moving average on the last trading day.
20-Day Moving Average Crossed Below 100-Day Moving AverageThis query returns securities which had the 20-day simple moving average cross below the 100-day simple moving average on the last trading day.
20-Day Moving Average Crossed Above 200-Day Moving AverageThis query returns securities which had the 20-day simple moving average cross above the 200-day simple moving average on the last trading day.
20-Day Moving Average Crossed Below 200-Day Moving AverageThis query returns securities which had the 20-day simple moving average cross below the 200-day simple moving average on the last trading day.
50-Day Moving Average Crossed Above 100-Day Moving AverageThis query returns securities which had the 50-day simple moving average cross above the 100-day simple moving average on the last trading day.
50-Day Moving Average Crossed Below 100-Day Moving AverageThis query returns securities which had the 50-day simple moving average cross below the 100-day simple moving average on the last trading day.
50-Day Moving Average Crossed Above 200-Day Moving AverageThis query returns securities which had the 50-day simple moving average cross above the 200-day simple moving average on the last trading day.
50-Day Moving Average Crossed Below 200-Day Moving AverageThis query returns securities which had the 50-day simple moving average cross below the 200-day simple moving average on the last trading day.
100-Day Moving Average Crossed Above 200-Day Moving AverageThis query returns securities which had the 100-day simple moving average cross above the 200-day simple moving average on the last trading day.
100-Day Moving Average Crossed Below 200-Day Moving AverageThis query returns securities which had the 100-day simple moving average cross below the 200-day simple moving average on the last trading day.
This query returns securities which had the 12-day fast period, 26-day slow period Moving Average Convergence Divergence (MACD) indicator cross above 0.
MACD(12, 26, 9) Crossed Below 0This query returns securities which had the 12-day fast period, 26-day slow period Moving Average Convergence Divergence (MACD) indicator cross below 0.
MACD(12, 26, 9) Crossed Above Signal LineThis query returns securities which had the 12-day fast period, 26-day slow period Moving Average Convergence Divergence (MACD) indicator cross above the 9-day EMA signal line.
MACD(12, 26, 9) Crossed Below Signal LineThis query returns securities which had the 12-day fast period, 26-day slow period Moving Average Convergence Divergence (MACD) indicator cross below the 9-day EMA signal line.
RSI(14) Crossed Above 70This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross above 70.
RSI(14) Crossed Below 70This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross below 70.
RSI(14) Crossed Above 30This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross above 30.
RSI(14) Crossed Below 30This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross below 30.
Stochastic(14, 3, 3) Crossed Above 80This query returns securities which had the 14-day Slow Stochastic Oscillator with a 3-day %K smoothing period cross above 80.
Stochastic(14, 3, 3) Crossed Below 80This query returns securities which had the 14-day Slow Stochastic Oscillator with a 3-day %K smoothing period cross below 80.
Stochastic(14, 3, 3) Crossed Above 20This query returns securities which had the 14-day Slow Stochastic Oscillator with a 3-day %K smoothing period cross above 20.
Stochastic(14, 3, 3) Crossed Below 20This query returns securities which had the 14-day Slow Stochastic Oscillator with a 3-day %K smoothing period cross below 20.
Stochastic(14, 3, 3) %K Line Crossed Above %D LineThis query returns securities which had the 14-day Slow Stochastic Oscillator with a 3-day %K smoothing period cross above the 3-day %D line.
Stochastic(14, 3, 3) %K Line Crossed Below %D LineThis query returns securities which had the 14-day Slow Stochastic Oscillator with a 3-day %K smoothing period cross below the 3-day %D line.
Price Crossed Above Bollinger(20, 2) Upper BandThis query returns securities for which the closing price crossed above the 20-day, 2-standard-deviation upper Bollinger Band.
Price Crossed Below Bollinger(20, 2) Upper BandThis query returns securities for which the closing price crossed below the 20-day, 2-standard-deviation upper Bollinger Band.
Price Crossed Above Bollinger(20, 2) Lower BandThis query returns securities for which the closing price crossed above the 20-day, 2-standard-deviation lower Bollinger Band.
Price Crossed Below Bollinger(20, 2) Lower BandThis query returns securities for which the closing price crossed below the 20-day, 2-standard-deviation lower Bollinger Band.
This query returns companies that had their highest quarterly revenue in 5 years, in the most recent fiscal quarter.
New 5-Year Low Quarterly Revenue (QoQ)This query returns companies that had their lowest quarterly revenue in 5 years, in the most recent fiscal quarter.
New 5-Year High Quarterly Revenue (YoY)This query returns companies that had their highest quarterly revenue in 5 years, in the most recent fiscal quarter, on a year-over-year basis.
New 5-Year Low Quarterly Revenue (YoY)This query returns companies that had their lowest quarterly revenue in 5 years, in the most recent fiscal quarter, on a year-over-year basis.
New 5-Year High Annual RevenueThis query returns companies that had their highest annual revenue in 5 years, in the most recent fiscal year.
New 5-Year Low Annual RevenueThis query returns companies that had their lowest annual revenue in 5 years, in the most recent fiscal year.
This query returns companies that had their highest quarterly net income in 5 years, in the most recent fiscal quarter.
New 5-Year Low Quarterly Net Income (QoQ)This query returns companies that had their lowest quarterly net income in 5 years, in the most recent fiscal quarter.
New 5-Year High Quarterly Net Income (YoY)This query returns companies that had their highest quarterly net income in 5 years, in the most recent fiscal quarter, on a year-over-year basis.
New 5-Year Low Quarterly Net Income (YoY)This query returns companies that had their lowest quarterly net income in 5 years, in the most recent fiscal quarter, on a year-over-year basis.
New 5-Year High Annual Net IncomeThis query returns companies that had their highest annual net income in 5 years, in the most recent fiscal year.
New 5-Year Low Annual Net IncomeThis query returns companies that had their lowest annual net income in 5 years, in the most recent fiscal year.