Predefined Queries

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.

Most Active
Most Active Securities by Money Flow, 1 Day

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 Week

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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 Day

This query returns the most actively traded stocks and ETFs by volume on the last trading day.

Most Active Securities by Volume, Past Week

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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.

Corporate Events
Upcoming Earnings Announcements

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 Announcements

This 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 Dividends

This query returns securities that had an ex-dividend date within the past 30 days.

Recent Stock Splits

This query returns securities that have had a stock split within the past 30 days.

New Highs/Lows in Price
Stocks Reaching a New 4-Week High Price

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 Price

This 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 Price

This 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 Price

This 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 Price

This 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 Price

This 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 Price

This 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 Price

This 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.

New Highs/Lows in Volume
Stocks with a New 4-Week High Volume

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 Volume

This 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 Volume

This 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 Volume

This 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 Volume

This 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 Volume

This 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 Volume

This 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 Volume

This 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.

Largest Percent Increase/Decrease in Price
Largest Percent Increase in Price, 1 Day

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 Day

This 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 Week

This 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 Week

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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 Weeks

This 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.

Most Consecutive Days/Weeks with Increasing/Decreasing Price
Most Consecutive Days with Increasing Price

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 Price

This 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 Price

This 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 Price

This query returns the securities having the most consecutive weeks with a close-to-close decrease in price, as of the last trading day.

Most Consecutive Days/Weeks with Increasing/Decreasing Volume
Most Consecutive Days with Increasing Volume

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 Volume

This 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 Volume

This 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 Volume

This query returns the securities having the most consecutive weeks with a decrease in weekly volume, as of the last trading day.

Moving Average Crossovers
Price Crossed Above 5-Day Moving Average

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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This 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 Average

This query returns securities which had the 100-day simple moving average cross below the 200-day simple moving average on the last trading day.

Technical Indicator Signals
MACD(12, 26, 9) Crossed Above 0

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 0

This 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 Line

This 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 Line

This 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 70

This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross above 70.

RSI(14) Crossed Below 70

This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross below 70.

RSI(14) Crossed Above 30

This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross above 30.

RSI(14) Crossed Below 30

This query returns securities which had the 14-day Relative Strength Index (RSI) indicator cross below 30.

Stochastic(14, 3, 3) Crossed Above 80

This 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 80

This 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 20

This 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 20

This 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 Line

This 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 Line

This 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 Band

This 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 Band

This 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 Band

This 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 Band

This query returns securities for which the closing price crossed below the 20-day, 2-standard-deviation lower Bollinger Band.

New High/Low Revenue
New 5-Year High Quarterly Revenue (QoQ)

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 Revenue

This query returns companies that had their highest annual revenue in 5 years, in the most recent fiscal year.

New 5-Year Low Annual Revenue

This query returns companies that had their lowest annual revenue in 5 years, in the most recent fiscal year.

New High/Low Net Income
New 5-Year High Quarterly Net Income (QoQ)

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 Income

This 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 Income

This query returns companies that had their lowest annual net income in 5 years, in the most recent fiscal year.