The Query Tool enables you to run a custom query on the database of securities, using any set of fields from a list hundreds of variables. Enter an SQL SELECT query below, using the data columns shown in the list. Clicking on a variable in the list will insert the column name at the cursor position in the text area. Press Ctrl + Space for completion of column names and SQL keywords.
10
1
SELECT2
ticker, name, close_price, consecutive_down_price_day3
FROM4
data5
WHERE6
consecutive_down_price_day > 07
ORDER BY8
consecutive_down_price_day DESC, market_cap DESC9
LIMIT10
100
Variables
| Name | Data Column |
|---|
Name | Data Column |
|---|---|
Profile | |
Ticker |
ticker
|
Security Name |
name
|
Exchange |
exchange
|
Sector |
sector
|
Industry |
industry
|
Free Float |
free_float
|
Market Capitalization |
market_cap
|
Average Volume (Last 20 Days) |
average_volume
|
Beta (Past 60 Months) |
beta
|
Percentage Held By Insiders (Latest Annual Proxy Report) |
held_by_insiders_pct
|
Percentage Held By Institutions (Latest 13F Reports) |
held_by_institutions_pct
|
Recent Price/Volume | |
Closing Price |
close_price
|
Opening Price |
open_price
|
High Price |
high_price
|
Low Price |
low_price
|
Volume |
volume
|
Previous Closing Price |
previous_close_price
|
Previous Opening Price |
previous_open_price
|
Previous High Price |
previous_high_price
|
Previous Low Price |
previous_low_price
|
Previous Volume |
previous_volume
|
High/Low Price | |
52-Week High Price |
high_price_52_week
|
26-Week High Price |
high_price_26_week
|
13-Week High Price |
high_price_13_week
|
4-Week High Price |
high_price_4_week
|
2-Week High Price |
high_price_2_week
|
1-Week High Price |
high_price_1_week
|
52-Week Low Price |
low_price_52_week
|
26-Week Low Price |
low_price_26_week
|
13-Week Low Price |
low_price_13_week
|
4-Week Low Price |
low_price_4_week
|
2-Week Low Price |
low_price_2_week
|
1-Week Low Price |
low_price_1_week
|
High/Low Volume | |
52-Week High Volume |
high_volume_52_week
|
26-Week High Volume |
high_volume_26_week
|
13-Week High Volume |
high_volume_13_week
|
4-Week High Volume |
high_volume_4_week
|
2-Week High Volume |
high_volume_2_week
|
1-Week High Volume |
high_volume_1_week
|
52-Week Low Volume |
low_volume_52_week
|
26-Week Low Volume |
low_volume_26_week
|
13-Week Low Volume |
low_volume_13_week
|
4-Week Low Volume |
low_volume_4_week
|
2-Week Low Volume |
low_volume_2_week
|
1-Week Low Volume |
low_volume_1_week
|
Money Flow | |
Total Money Flow, Past 52 Weeks |
money_flow_52_week
|
Total Money Flow, Past 26 Weeks |
money_flow_26_week
|
Total Money Flow, Past 13 Weeks |
money_flow_13_week
|
Total Money Flow, Past 4 Weeks |
money_flow_4_week
|
Total Money Flow, Past 2 Weeks |
money_flow_2_week
|
Total Money Flow, Past Week |
money_flow_1_week
|
Total Money Flow, 1 Day |
money_flow_1_day
|
Total Volume | |
Total Volume, Past 52 Weeks |
total_volume_52_week
|
Total Volume, Past 26 Weeks |
total_volume_26_week
|
Total Volume, Past 13 Weeks |
total_volume_13_week
|
Total Volume, Past 4 Weeks |
total_volume_4_week
|
Total Volume, Past 2 Weeks |
total_volume_2_week
|
Total Volume, Past Week |
total_volume_1_week
|
Percent Change in Price | |
Percent Change in Price, Past 52 Weeks |
percent_change_price_52_week
|
Percent Change in Price, Past 26 Weeks |
percent_change_price_26_week
|
Percent Change in Price, Past 13 Weeks |
percent_change_price_13_week
|
Percent Change in Price, Past 4 Weeks |
percent_change_price_4_week
|
Percent Change in Price, Past 2 Weeks |
percent_change_price_2_week
|
Percent Change in Price, Past Week |
percent_change_price_1_week
|
Percent Change in Price, 1 Day |
percent_change_price_1_day
|
New High/Low in Price | |
Reached New 52-Week High Price |
new_high_price_52_week
|
Reached New 26-Week High Price |
new_high_price_26_week
|
Reached New 13-Week High Price |
new_high_price_13_week
|
Reached New 4-Week High Price |
new_high_price_4_week
|
Reached New 2-Week High Price |
new_high_price_2_week
|
Reached New 1-Week High Price |
new_high_price_1_week
|
Reached New 52-Week Low Price |
new_low_price_52_week
|
Reached New 26-Week Low Price |
new_low_price_26_week
|
Reached New 13-Week Low Price |
new_low_price_13_week
|
Reached New 4-Week Low Price |
new_low_price_4_week
|
Reached New 2-Week Low Price |
new_low_price_2_week
|
Reached New 1-Week Low Price |
new_low_price_1_week
|
Consecutive Days/Weeks of Increasing/Decreasing Price | |
Consecutive Days of Increasing Price |
consecutive_up_price_day
|
Consecutive Weeks of Increasing Price |
consecutive_up_price_week
|
Consecutive Days of Decreasing Price |
consecutive_down_price_day
|
Consecutive Weeks of Decreasing Price |
consecutive_down_price_week
|
Consecutive Days/Weeks of Increasing/Decreasing Volume | |
Consecutive Days of Increasing Volume |
consecutive_up_volume_day
|
Consecutive Weeks of Increasing Volume |
consecutive_up_volume_week
|
Consecutive Days of Decreasing Volume |
consecutive_down_volume_day
|
Consecutive Weeks of Decreasing Volume |
consecutive_down_volume_week
|
New High/Low in Volume | |
Had New 52-Week High Volume |
new_high_volume_52_week
|
Had New 26-Week High Volume |
new_high_volume_26_week
|
Had New 13-Week High Volume |
new_high_volume_13_week
|
Had New 4-Week High Volume |
new_high_volume_4_week
|
Had New 2-Week High Volume |
new_high_volume_2_week
|
Had New 1-Week High Volume |
new_high_volume_1_week
|
Had New 52-Week Low Volume |
new_low_volume_52_week
|
Had New 26-Week Low Volume |
new_low_volume_26_week
|
Had New 13-Week Low Volume |
new_low_volume_13_week
|
Had New 4-Week Low Volume |
new_low_volume_4_week
|
Had New 2-Week Low Volume |
new_low_volume_2_week
|
Had New 1-Week Low Volume |
new_low_volume_1_week
|
Moving Averages | |
Simple Moving Average (5-Day) |
sma_5
|
Simple Moving Average (10-Day) |
sma_10
|
Simple Moving Average (20-Day) |
sma_20
|
Simple Moving Average (50-Day) |
sma_50
|
Simple Moving Average (100-Day) |
sma_100
|
Simple Moving Average (200-Day) |
sma_200
|
Previous Simple Moving Average (5-Day) |
previous_sma_5
|
Previous Simple Moving Average (10-Day) |
previous_sma_10
|
Previous Simple Moving Average (20-Day) |
previous_sma_20
|
Previous Simple Moving Average (50-Day) |
previous_sma_50
|
Previous Simple Moving Average (100-Day) |
previous_sma_100
|
Previous Simple Moving Average (200-Day) |
previous_sma_200
|
Technical Indicators | |
MACD (12, 26, 9) |
macd_12_26
|
MACD (12, 26, 9) Signal |
macd_signal_12_26_9
|
Previous MACD (12, 26, 9) |
previous_macd_12_26
|
Previous MACD (12, 26, 9) Signal |
previous_macd_signal_12_26_9
|
RSI (14-Day) |
rsi_14
|
Previous RSI (14-Day) |
previous_rsi_14
|
Stochastic (14, 3, 3) %K |
stochastic_14_3_3_k
|
Stochastic (14, 3, 3) %D |
stochastic_14_3_3_d
|
Previous Stochastic (14, 3, 3) %K |
previous_stochastic_14_3_3_k
|
Previous Stochastic (14, 3, 3) %D |
previous_stochastic_14_3_3_d
|
Upper Bollinger Band (20, 2) |
bollinger_upper_20_2
|
Lower Bollinger Band (20, 2) |
bollinger_lower_20_2
|
Previous Upper Bollinger Band (20, 2) |
previous_bollinger_upper_20_2
|
Previous Lower Bollinger Band (20, 2) |
previous_bollinger_lower_20_2
|
Income Statement Financials | |
Quarterly Revenue (MRQ) |
quarterly_revenue
|
Quarterly Net Income (MRQ) |
quarterly_net_income
|
Previous Quarterly Revenue (QoQ) |
previous_quarterly_revenue_qoq
|
Previous Quarterly Revenue (YoY) |
previous_quarterly_revenue_yoy
|
Previous Quarterly Net Income (QoQ) |
previous_quarterly_net_income_qoq
|
Previous Quarterly Net Income (YoY) |
previous_quarterly_net_income_yoy
|
Revenue (MRY) |
revenue
|
Net Income (MRY) |
net_income
|
Previous Annual Revenue |
previous_revenue
|
Previous Net Income |
previous_net_income
|
Cost of Goods Sold (MRY) |
cost_goods_sold
|
Gross Profit (MRY) |
gross_profit
|
Operating Expenses (MRY) |
operating_expenses
|
Operating Income (MRY) |
operating_income
|
Non-Operating Income/Expense (MRY) |
non_operating_income
|
Pre-Tax Income (MRY) |
pre_tax_income
|
Normalized Pre-Tax Income (MRY) |
normalized_pre_tax_income
|
Income after Taxes (MRY) |
income_after_taxes
|
Income from Continuous Operations (MRY) |
income_continuous_operations
|
Consolidated Net Income/Loss (MRY) |
consolidated_net_income
|
Normalized Income after Taxes (MRY) |
normalized_income_after_taxes
|
EBIT (MRY) |
ebit
|
EBITDA (MRY) |
ebitda
|
Balance Sheet Financials | |
Current Assets (MRQ) |
current_assets
|
Property, Plant, and Equipment (MRQ) |
property_plant_equipment
|
Long-Term Assets (MRQ) |
long_term_assets
|
Total Assets (MRQ) |
total_assets
|
Current Liabilities (MRQ) |
current_liabilities
|
Long-Term Debt (MRQ) |
long_term_debt
|
Long-Term Liabilities (MRQ) |
long_term_liabilities
|
Total Liabilities (MRQ) |
total_liabilities
|
Common Equity (MRQ) |
common_equity
|
Tangible Shareholders Equity (MRQ) |
tangible_stockholders_equity
|
Shareholders Equity (MRQ) |
shareholders_equity
|
Common Shares Outstanding (MRQ) |
common_shares_outstanding
|
Cash Flow Statement Financials | |
Cash Flow from Operating Activities (MRY) |
cash_flow_operating_activity
|
Cash Flow from Investing Activities (MRY) |
cash_flow_investing_activity
|
Cash Flow from Financial Activities (MRY) |
cash_flow_financial_activity
|
Beginning Cash (MRY) |
beginning_cash
|
End Cash (MRY) |
ending_cash
|
Increase/Decrease in Cash (MRY) |
net_change_cash
|
Fundamental Ratios | |
PE Ratio (Current Year Earnings Estimate) |
pe_ratio
|
PE Ratio (Trailing 12 Months) |
pe_ratio_ttm
|
PEG Ratio (Long Term Growth Estimate) |
peg_ratio
|
Price to Sales Ratio (Trailing 12 Months) |
price_sales_ratio
|
Price to Book Ratio (Most Recent Quarterly Book Value per Share) |
price_book_ratio
|
Price to Cash Ratio (Most Recent Annual Cash Flow per Share) |
price_cash_ratio
|
Pre-Tax Margin (Trailing 12 Months) |
pre_tax_margin
|
Net Margin (Trailing 12 Months) |
net_margin
|
Return on Equity (Trailing 12 Months) |
return_on_equity
|
Return on Assets (Trailing 12 Months) |
return_on_assets
|
Current Ratio (Most Recent Fiscal Quarter) |
current_ratio
|
Quick Ratio (Most Recent Fiscal Quarter) |
quick_ratio
|
Debt to Common Equity (Most Recent Fiscal Quarter) |
debt_equity_ratio
|
Inventory Turnover (Trailing 12 Months) |
inventory_turnover
|
Book Value per Share (Most Recent Fiscal Quarter) |
book_value_per_share
|
Earnings | |
Fiscal Period End, Next Quarterly Earnings Report |
fiscal_period_end_qr1
|
Quarterly Earnings per Share Estimate |
earnings_estimate_qr1
|
Next Expected Quarterly Earnings Report Date |
expected_report_date_qr1
|
Days Until Next Expected Quarterly Earnings Report |
days_from_expected_report_date_qr1
|
Fiscal Period End, Last Quarterly Earnings Report |
fiscal_period_end_qr0
|
Last Quarterly Earnings per Share Estimate |
earnings_estimate_qr0
|
Last Quarterly Earnings per Share |
earnings_actual_qr0
|
Last Quarterly Earnings Report Date |
report_date_qr0
|
Days Since Last Quarterly Earnings Report |
days_since_report_date_qr0
|
Earnings per Share (Most Recent Fiscal Year) |
eps_year
|
Diluted Earnings per Share (Trailing 12 Months) |
eps_ttm
|
Dividends | |
Last Dividend Date |
last_dividend_date
|
Last Dividend Amount |
last_dividend_amount
|
Days Since Last Dividend |
days_since_last_dividend
|
Annual Dividend (Based on Last Quarter) |
annual_dividend
|
Dividend Yield (Based on Last Quarter) |
dividend_yield
|
Percent Growth in Revenue/Net Income | |
Percent Growth in Quarterly Revenue (QoQ) |
percent_growth_quarterly_revenue_qoq
|
Percent Growth in Quarterly Revenue (YoY) |
percent_growth_quarterly_revenue_yoy
|
Percent Growth in Annual Revenue |
percent_growth_annual_revenue
|
Percent Growth in Quarterly Net Income (QoQ) |
percent_growth_quarterly_net_income_qoq
|
Percent Growth in Quarterly Net Income (YoY) |
percent_growth_quarterly_net_income_yoy
|
Percent Growth in Annual Net Income |
percent_growth_annual_net_income
|
New High/Low in Revenue/Net Income | |
New 5-Year High Annual Revenue |
new_high_annual_revenue_5_year
|
New 5-Year Low Annual Revenue |
new_low_annual_revenue_5_year
|
New 5-Year High Quarterly Revenue (QoQ) |
new_high_quarterly_revenue_qoq_5_year
|
New 5-Year Low Quarterly Revenue (QoQ) |
new_low_quarterly_revenue_qoq_5_year
|
New 5-Year High Quarterly Revenue (YoY) |
new_high_quarterly_revenue_yoy_5_year
|
New 5-Year Low Quarterly Revenue (YoY) |
new_low_quarterly_revenue_yoy_5_year
|
New 5-Year High Annual Net Income |
new_high_annual_net_income_5_year
|
New 5-Year Low Annual Net Income |
new_low_annual_net_income_5_year
|
New 5-Year High Quarterly Net Income (QoQ) |
new_high_quarterly_net_income_qoq_5_year
|
New 5-Year Low Quarterly Net Income (QoQ) |
new_low_quarterly_net_income_qoq_5_year
|
New 5-Year High Quarterly Net Income (YoY) |
new_high_quarterly_net_income_yoy_5_year
|
New 5-Year Low Quarterly Net Income (YoY) |
new_low_quarterly_net_income_yoy_5_year
|
Consecutive Quarters/Years of Increasing/Decreasing Revenue/Net Income | |
Consecutive Quarters of Increasing Revenue (QoQ) |
consecutive_up_quarterly_revenue_qoq
|
Consecutive Quarters of Decreasing Revenue (QoQ) |
consecutive_down_quarterly_revenue_qoq
|
Consecutive Quarters of Increasing Revenue (YoY) |
consecutive_up_quarterly_revenue_yoy
|
Consecutive Quarters of Decreasing Revenue (YoY) |
consecutive_down_quarterly_revenue_yoy
|
Consecutive Years of Increasing Revenue |
consecutive_up_annual_revenue
|
Consecutive Years of Decreasing Revenue |
consecutive_down_annual_revenue
|
Consecutive Quarters of Increasing Net Income (QoQ) |
consecutive_up_quarterly_net_income_qoq
|
Consecutive Quarters of Decreasing Net Income (QoQ) |
consecutive_down_quarterly_net_income_qoq
|
Consecutive Quarters of Increasing Net Income (YoY) |
consecutive_up_quarterly_net_income_yoy
|
Consecutive Quarters of Decreasing Net Income (YoY) |
consecutive_down_quarterly_net_income_yoy
|
Consecutive Years of Increasing Net Income |
consecutive_up_annual_net_income
|
Consecutive Years of Decreasing Net Income |
consecutive_down_annual_net_income
|
Splits | |
Last Split Date (if within past year) |
last_split_date
|
Last Split Ratio (if within past year) |
last_split_ratio
|
Days Since Last Split (if within past year) |
days_since_last_split
|
Volatility Metrics | |
Historical Volatility (Close-to-Close) (10-Day) |
historical_volatility_10
|
Historical Volatility (Close-to-Close) (20-Day) |
historical_volatility_20
|
Historical Volatility (Close-to-Close) (30-Day) |
historical_volatility_30
|
Historical Volatility (Close-to-Close) (60-Day) |
historical_volatility_60
|
Historical Volatility (Close-to-Close) (90-Day) |
historical_volatility_90
|
Historical Volatility (Close-to-Close) (120-Day) |
historical_volatility_120
|
Historical Volatility (Close-to-Close) (150-Day) |
historical_volatility_150
|
Historical Volatility (Close-to-Close) (180-Day) |
historical_volatility_180
|
Historical Volatility (Parkinson) (10-Day) |
parkinson_historical_volatility_10
|
Historical Volatility (Parkinson) (20-Day) |
parkinson_historical_volatility_20
|
Historical Volatility (Parkinson) (30-Day) |
parkinson_historical_volatility_30
|
Historical Volatility (Parkinson) (60-Day) |
parkinson_historical_volatility_60
|
Historical Volatility (Parkinson) (90-Day) |
parkinson_historical_volatility_90
|
Historical Volatility (Parkinson) (120-Day) |
parkinson_historical_volatility_120
|
Historical Volatility (Parkinson) (150-Day) |
parkinson_historical_volatility_150
|
Historical Volatility (Parkinson) (180-Day) |
parkinson_historical_volatility_180
|
Implied Volatility (Calls) (10-Day) |
iv_call_10
|
Implied Volatility (Calls) (20-Day) |
iv_call_20
|
Implied Volatility (Calls) (30-Day) |
iv_call_30
|
Implied Volatility (Calls) (60-Day) |
iv_call_60
|
Implied Volatility (Calls) (90-Day) |
iv_call_90
|
Implied Volatility (Calls) (120-Day) |
iv_call_120
|
Implied Volatility (Calls) (150-Day) |
iv_call_150
|
Implied Volatility (Calls) (180-Day) |
iv_call_180
|
Implied Volatility (Puts) (10-Day) |
iv_put_10
|
Implied Volatility (Puts) (20-Day) |
iv_put_20
|
Implied Volatility (Puts) (30-Day) |
iv_put_30
|
Implied Volatility (Puts) (60-Day) |
iv_put_60
|
Implied Volatility (Puts) (90-Day) |
iv_put_90
|
Implied Volatility (Puts) (120-Day) |
iv_put_120
|
Implied Volatility (Puts) (150-Day) |
iv_put_150
|
Implied Volatility (Puts) (180-Day) |
iv_put_180
|
Implied Volatility (Mean) (10-Day) |
iv_mean_10
|
Implied Volatility (Mean) (20-Day) |
iv_mean_20
|
Implied Volatility (Mean) (30-Day) |
iv_mean_30
|
Implied Volatility (Mean) (60-Day) |
iv_mean_60
|
Implied Volatility (Mean) (90-Day) |
iv_mean_90
|
Implied Volatility (Mean) (120-Day) |
iv_mean_120
|
Implied Volatility (Mean) (150-Day) |
iv_mean_150
|
Implied Volatility (Mean) (180-Day) |
iv_mean_180
|
Put-Call Implied Volatility Ratio (10-Day) |
put_call_iv_ratio_10
|
Put-Call Implied Volatility Ratio (20-Day) |
put_call_iv_ratio_20
|
Put-Call Implied Volatility Ratio (30-Day) |
put_call_iv_ratio_30
|
Put-Call Implied Volatility Ratio (60-Day) |
put_call_iv_ratio_60
|
Put-Call Implied Volatility Ratio (90-Day) |
put_call_iv_ratio_90
|
Put-Call Implied Volatility Ratio (120-Day) |
put_call_iv_ratio_120
|
Put-Call Implied Volatility Ratio (150-Day) |
put_call_iv_ratio_150
|
Put-Call Implied Volatility Ratio (180-Day) |
put_call_iv_ratio_180
|
Implied Volatility Skew (10-Day) |
iv_mean_skew_10
|
Implied Volatility Skew (20-Day) |
iv_mean_skew_20
|
Implied Volatility Skew (30-Day) |
iv_mean_skew_30
|
Implied Volatility Skew (60-Day) |
iv_mean_skew_60
|
Implied Volatility Skew (90-Day) |
iv_mean_skew_90
|
Implied Volatility Skew (120-Day) |
iv_mean_skew_120
|
Implied Volatility Skew (150-Day) |
iv_mean_skew_150
|
Implied Volatility Skew (180-Day) |
iv_mean_skew_180
|
Option Statistics | |
Put-Call Ratio (Volume) (10-Day) |
put_call_ratio_volume_10
|
Put-Call Ratio (Volume) (20-Day) |
put_call_ratio_volume_20
|
Put-Call Ratio (Volume) (30-Day) |
put_call_ratio_volume_30
|
Put-Call Ratio (Volume) (60-Day) |
put_call_ratio_volume_60
|
Put-Call Ratio (Volume) (90-Day) |
put_call_ratio_volume_90
|
Put-Call Ratio (Volume) (120-Day) |
put_call_ratio_volume_120
|
Put-Call Ratio (Volume) (150-Day) |
put_call_ratio_volume_150
|
Put-Call Ratio (Volume) (180-Day) |
put_call_ratio_volume_180
|
Put-Call Ratio (Open Interest) (10-Day) |
put_call_ratio_oi_10
|
Put-Call Ratio (Open Interest) (20-Day) |
put_call_ratio_oi_20
|
Put-Call Ratio (Open Interest) (30-Day) |
put_call_ratio_oi_30
|
Put-Call Ratio (Open Interest) (60-Day) |
put_call_ratio_oi_60
|
Put-Call Ratio (Open Interest) (90-Day) |
put_call_ratio_oi_90
|
Put-Call Ratio (Open Interest) (120-Day) |
put_call_ratio_oi_120
|
Put-Call Ratio (Open Interest) (150-Day) |
put_call_ratio_oi_150
|
Put-Call Ratio (Open Interest) (180-Day) |
put_call_ratio_oi_180
|
Percentiles Within Industry of Price Performance | |
Percentile Within Industry, Percent Change in Price, Past 52 Weeks |
percentile_industry_percent_change_price_52_week
|
Percentile Within Industry, Percent Change in Price, Past 26 Weeks |
percentile_industry_percent_change_price_26_week
|
Percentile Within Industry, Percent Change in Price, Past 13 Weeks |
percentile_industry_percent_change_price_13_week
|
Percentile Within Industry, Percent Change in Price, Past 4 Weeks |
percentile_industry_percent_change_price_4_week
|
Percentile Within Industry, Percent Change in Price, Past 2 Weeks |
percentile_industry_percent_change_price_2_week
|
Percentile Within Industry, Percent Change in Price, Past Week |
percentile_industry_percent_change_price_1_week
|
Percentile Within Industry, Percent Change in Price, 1 Day |
percentile_industry_percent_change_price_1_day
|
Percentiles Within Industry of Revenue/Net Income Growth | |
Percentile Within Industry, Percent Growth in Quarterly Revenue (QoQ) |
percentile_industry_percent_growth_quarterly_revenue_qoq
|
Percentile Within Industry, Percent Growth in Quarterly Revenue (YoY) |
percentile_industry_percent_growth_quarterly_revenue_yoy
|
Percentile Within Industry, Percent Growth in Annual Revenue |
percentile_industry_percent_growth_annual_revenue
|
Percentile Within Industry, Percent Growth in Quarterly Net Income (QoQ) |
percentile_industry_percent_growth_quarterly_net_income_qoq
|
Percentile Within Industry, Percent Growth in Quarterly Net Income (YoY) |
percentile_industry_percent_growth_quarterly_net_income_yoy
|
Percentile Within Industry, Percent Growth in Annual Net Income |
percentile_industry_percent_growth_annual_net_income
|
Percentiles Within Industry of Fundamental Ratios and Percentages | |
Percentile Within Industry, PE Ratio (Current Year Earnings Estimate) |
percentile_industry_pe_ratio
|
Percentile Within Industry, PE Ratio (Trailing 12 Months) |
percentile_industry_pe_ratio_ttm
|
Percentile Within Industry, PEG Ratio (Long Term Growth Estimate) |
percentile_industry_peg_ratio
|
Percentile Within Industry, Price to Sales Ratio (Trailing 12 Months) |
percentile_industry_price_sales_ratio
|
Percentile Within Industry, Price to Book Ratio (Most Recent Quarterly Book Value per Share) |
percentile_industry_price_book_ratio
|
Percentile Within Industry, Price to Cash Ratio (Most Recent Annual Cash Flow per Share) |
percentile_industry_price_cash_ratio
|
Percentile Within Industry, Pre-Tax Margin (Trailing 12 Months) |
percentile_industry_pre_tax_margin
|
Percentile Within Industry, Net Margin (Trailing 12 Months) |
percentile_industry_net_margin
|
Percentile Within Industry, Return on Equity (Trailing 12 Months) |
percentile_industry_return_on_equity
|
Percentile Within Industry, Return on Assets (Trailing 12 Months) |
percentile_industry_return_on_assets
|
Percentile Within Industry, Current Ratio (Most Recent Fiscal Quarter) |
percentile_industry_current_ratio
|
Percentile Within Industry, Quick Ratio (Most Recent Fiscal Quarter) |
percentile_industry_quick_ratio
|
Percentile Within Industry, Debt to Common Equity (Most Recent Fiscal Quarter) |
percentile_industry_debt_equity_ratio
|
Percentile Within Industry, Inventory Turnover (Trailing 12 Months) |
percentile_industry_inventory_turnover
|
Percentile Within Industry, Dividend Yield (Based on Last Quarter) |
percentile_industry_dividend_yield
|
Percentile Within Industry, Percentage Held By Insiders (Latest Annual Proxy Report) |
percentile_industry_held_by_insiders_pct
|
Percentile Within Industry, Percentage Held By Institutions (Latest 13F Reports) |
percentile_industry_held_by_institutions_pct
|
Percentiles Within Sector of Price Performance | |
Percentile Within Sector, Percent Change in Price, Past 52 Weeks |
percentile_sector_percent_change_price_52_week
|
Percentile Within Sector, Percent Change in Price, Past 26 Weeks |
percentile_sector_percent_change_price_26_week
|
Percentile Within Sector, Percent Change in Price, Past 13 Weeks |
percentile_sector_percent_change_price_13_week
|
Percentile Within Sector, Percent Change in Price, Past 4 Weeks |
percentile_sector_percent_change_price_4_week
|
Percentile Within Sector, Percent Change in Price, Past 2 Weeks |
percentile_sector_percent_change_price_2_week
|
Percentile Within Sector, Percent Change in Price, Past Week |
percentile_sector_percent_change_price_1_week
|
Percentile Within Sector, Percent Change in Price, 1 Day |
percentile_sector_percent_change_price_1_day
|
Percentiles Within Sector of Revenue/Net Income Growth | |
Percentile Within Sector, Percent Growth in Quarterly Revenue (QoQ) |
percentile_sector_percent_growth_quarterly_revenue_qoq
|
Percentile Within Sector, Percent Growth in Quarterly Revenue (YoY) |
percentile_sector_percent_growth_quarterly_revenue_yoy
|
Percentile Within Sector, Percent Growth in Annual Revenue |
percentile_sector_percent_growth_annual_revenue
|
Percentile Within Sector, Percent Growth in Quarterly Net Income (QoQ) |
percentile_sector_percent_growth_quarterly_net_income_qoq
|
Percentile Within Sector, Percent Growth in Quarterly Net Income (YoY) |
percentile_sector_percent_growth_quarterly_net_income_yoy
|
Percentile Within Sector, Percent Growth in Annual Net Income |
percentile_sector_percent_growth_annual_net_income
|
Percentiles Within Sector of Fundamental Ratios and Percentages | |
Percentile Within Sector, PE Ratio (Current Year Earnings Estimate) |
percentile_sector_pe_ratio
|
Percentile Within Sector, PE Ratio (Trailing 12 Months) |
percentile_sector_pe_ratio_ttm
|
Percentile Within Sector, PEG Ratio (Long Term Growth Estimate) |
percentile_sector_peg_ratio
|
Percentile Within Sector, Price to Sales Ratio (Trailing 12 Months) |
percentile_sector_price_sales_ratio
|
Percentile Within Sector, Price to Book Ratio (Most Recent Quarterly Book Value per Share) |
percentile_sector_price_book_ratio
|
Percentile Within Sector, Price to Cash Ratio (Most Recent Annual Cash Flow per Share) |
percentile_sector_price_cash_ratio
|
Percentile Within Sector, Pre-Tax Margin (Trailing 12 Months) |
percentile_sector_pre_tax_margin
|
Percentile Within Sector, Net Margin (Trailing 12 Months) |
percentile_sector_net_margin
|
Percentile Within Sector, Return on Equity (Trailing 12 Months) |
percentile_sector_return_on_equity
|
Percentile Within Sector, Return on Assets (Trailing 12 Months) |
percentile_sector_return_on_assets
|
Percentile Within Sector, Current Ratio (Most Recent Fiscal Quarter) |
percentile_sector_current_ratio
|
Percentile Within Sector, Quick Ratio (Most Recent Fiscal Quarter) |
percentile_sector_quick_ratio
|
Percentile Within Sector, Debt to Common Equity (Most Recent Fiscal Quarter) |
percentile_sector_debt_equity_ratio
|
Percentile Within Sector, Inventory Turnover (Trailing 12 Months) |
percentile_sector_inventory_turnover
|
Percentile Within Sector, Dividend Yield (Based on Last Quarter) |
percentile_sector_dividend_yield
|
Percentile Within Sector, Percentage Held By Insiders (Latest Annual Proxy Report) |
percentile_sector_held_by_insiders_pct
|
Percentile Within Sector, Percentage Held By Institutions (Latest 13F Reports) |
percentile_sector_held_by_institutions_pct
|
Percentiles Within Market of Price Performance | |
Percentile Within Market, Percent Change in Price, Past 52 Weeks |
percentile_market_percent_change_price_52_week
|
Percentile Within Market, Percent Change in Price, Past 26 Weeks |
percentile_market_percent_change_price_26_week
|
Percentile Within Market, Percent Change in Price, Past 13 Weeks |
percentile_market_percent_change_price_13_week
|
Percentile Within Market, Percent Change in Price, Past 4 Weeks |
percentile_market_percent_change_price_4_week
|
Percentile Within Market, Percent Change in Price, Past 2 Weeks |
percentile_market_percent_change_price_2_week
|
Percentile Within Market, Percent Change in Price, Past Week |
percentile_market_percent_change_price_1_week
|
Percentile Within Market, Percent Change in Price, 1 Day |
percentile_market_percent_change_price_1_day
|
Percentiles Within Market of Revenue/Net Income Growth | |
Percentile Within Market, Percent Growth in Quarterly Revenue (QoQ) |
percentile_market_percent_growth_quarterly_revenue_qoq
|
Percentile Within Market, Percent Growth in Quarterly Revenue (YoY) |
percentile_market_percent_growth_quarterly_revenue_yoy
|
Percentile Within Market, Percent Growth in Annual Revenue |
percentile_market_percent_growth_annual_revenue
|
Percentile Within Market, Percent Growth in Quarterly Net Income (QoQ) |
percentile_market_percent_growth_quarterly_net_income_qoq
|
Percentile Within Market, Percent Growth in Quarterly Net Income (YoY) |
percentile_market_percent_growth_quarterly_net_income_yoy
|
Percentile Within Market, Percent Growth in Annual Net Income |
percentile_market_percent_growth_annual_net_income
|
Percentiles Within Market of Fundamental Ratios and Percentages | |
Percentile Within Market, PE Ratio (Current Year Earnings Estimate) |
percentile_market_pe_ratio
|
Percentile Within Market, PE Ratio (Trailing 12 Months) |
percentile_market_pe_ratio_ttm
|
Percentile Within Market, PEG Ratio (Long Term Growth Estimate) |
percentile_market_peg_ratio
|
Percentile Within Market, Price to Sales Ratio (Trailing 12 Months) |
percentile_market_price_sales_ratio
|
Percentile Within Market, Price to Book Ratio (Most Recent Quarterly Book Value per Share) |
percentile_market_price_book_ratio
|
Percentile Within Market, Price to Cash Ratio (Most Recent Annual Cash Flow per Share) |
percentile_market_price_cash_ratio
|
Percentile Within Market, Pre-Tax Margin (Trailing 12 Months) |
percentile_market_pre_tax_margin
|
Percentile Within Market, Net Margin (Trailing 12 Months) |
percentile_market_net_margin
|
Percentile Within Market, Return on Equity (Trailing 12 Months) |
percentile_market_return_on_equity
|
Percentile Within Market, Return on Assets (Trailing 12 Months) |
percentile_market_return_on_assets
|
Percentile Within Market, Current Ratio (Most Recent Fiscal Quarter) |
percentile_market_current_ratio
|
Percentile Within Market, Quick Ratio (Most Recent Fiscal Quarter) |
percentile_market_quick_ratio
|
Percentile Within Market, Debt to Common Equity (Most Recent Fiscal Quarter) |
percentile_market_debt_equity_ratio
|
Percentile Within Market, Inventory Turnover (Trailing 12 Months) |
percentile_market_inventory_turnover
|
Percentile Within Market, Dividend Yield (Based on Last Quarter) |
percentile_market_dividend_yield
|
Percentile Within Market, Percentage Held By Insiders (Latest Annual Proxy Report) |
percentile_market_held_by_insiders_pct
|
Percentile Within Market, Percentage Held By Institutions (Latest 13F Reports) |
percentile_market_held_by_institutions_pct
|