> ## Documentation Index > Fetch the complete documentation index at: https://docs.arrays.org/llms.txt > Use this file to discover all available pages before exploring further. # Get Financial Metrics Screener > [OpenAPI JSON Spec](/docs/output/v1_stocks_screener_financial-metrics_get.json) Retrieve stocks filtered by financial metrics at a specific snapshot time. Returns stocks matching the specified metric type and value ranges. Includes companies with a market cap exceeding $5B at the time of the data snapshot. Please note that current market caps may fluctuate below this threshold due to recent price changes. **Overview:** This endpoint filters stocks based on financial metrics from the `stock_financial_metrics` table. The snapshot parameter is a Unix timestamp (seconds) that will be used directly for querying data. **Financial Metrics from stock_financial_metrics table (28 metrics):** **PIT (Point-in-Time) Balance Sheet Ratios (5 metrics):** - `CURRENT_RATIO_MRQ`: Current Ratio (Most Recent Quarter) - Current assets divided by current liabilities - `DEBT_TO_ASSETS_MRQ`: Debt-to-Assets Ratio (MRQ) - Total debt divided by total assets - `DEBT_TO_EQUITY_MRQ`: Debt-to-Equity Ratio (MRQ) - Total debt divided by total equity - `NET_WORKING_CAPITAL_MRQ`: Net Working Capital (MRQ) - Current assets minus current liabilities - `QUICK_RATIO_MRQ`: Quick Ratio (MRQ) - (Current assets - Inventory) divided by current liabilities **TTM (Trailing Twelve Months) Base Metrics (3 metrics):** - `REVENUE_TTM`: Revenue TTM - Total revenue over trailing twelve months - `NET_INCOME_TTM`: Net Income TTM - Net income over trailing twelve months - `EPS_TTM`: Earnings Per Share TTM - Earnings per share over trailing twelve months **TTM Profitability Ratios (3 metrics):** - `ROA_TTM`: Return on Assets TTM - Net income divided by average total assets - `ROE_TTM`: Return on Equity TTM - Net income divided by average shareholder equity - `ROIC_TTM`: Return on Invested Capital TTM - Net operating profit after tax divided by invested capital **MRQ Margin Ratios (4 metrics):** - `GROSS_MARGIN_MRQ`: Gross Margin (MRQ) - (Revenue - Cost of Goods Sold) / Revenue - `OPERATING_MARGIN_MRQ`: Operating Margin (MRQ) - Operating income / Revenue - `NET_MARGIN_MRQ`: Net Margin (MRQ) - Net income / Revenue - `FCF_MARGIN_MRQ`: Free Cash Flow Margin (MRQ) - Free cash flow / Revenue **Other MRQ Ratios (1 metric):** - `RD_TO_SALES_TTM`: Research & Development to Sales (TTM) - R&D expenses / Revenue **Revenue Growth Metrics (4 metrics):** - `REVENUE_GROWTH_QOQ`: Revenue Growth Quarter-over-Quarter - `REVENUE_GROWTH_YOY_QUARTERLY`: Revenue Growth Year-over-Year (Quarterly) - `REVENUE_GROWTH_YOY_TTM`: Revenue Growth Year-over-Year (TTM) - `REVENUE_GROWTH_YOY_ANNUAL`: Revenue Growth Year-over-Year (Annual) **EPS Growth Metrics (4 metrics):** - `EPS_GROWTH_QOQ`: EPS Growth Quarter-over-Quarter - `EPS_GROWTH_YOY_QUARTERLY`: EPS Growth Year-over-Year (Quarterly) - `EPS_GROWTH_YOY_TTM`: EPS Growth Year-over-Year (TTM) - `EPS_GROWTH_YOY_ANNUAL`: EPS Growth Year-over-Year (Annual) **FCF Growth Metrics (4 metrics):** - `FCF_GROWTH_QOQ`: Free Cash Flow Growth Quarter-over-Quarter - `FCF_GROWTH_YOY_QUARTERLY`: FCF Growth Year-over-Year (Quarterly) - `FCF_GROWTH_YOY_TTM`: FCF Growth Year-over-Year (TTM) - `FCF_GROWTH_YOY_ANNUAL`: FCF Growth Year-over-Year (Annual) **Price-Related Metrics (7 metrics):** - `MARKET_CAP`: Market Capitalization - Total market value of a company's outstanding shares - `PE_RATIO`: Price-to-Earnings Ratio - Market price per share divided by earnings per share - `PS_RATIO`: Price-to-Sales Ratio - Market capitalization divided by revenue - `PB_RATIO`: Price-to-Book Ratio - Market price per share divided by book value per share - `DIVIDEND_YIELD`: Dividend Yield - Annual dividend per share divided by market price per share - `ENTERPRISE_VALUE`: Enterprise Value - Market capitalization + Total debt - Cash and cash equivalents - `EV_EBITDA_RATIO`: EV/EBITDA Ratio - Enterprise value divided by EBITDA **Filtering:** - Use `range_min` to filter for stocks where the metric value is greater than or equal to the minimum - Use `range_max` to filter for stocks where the metric value is less than or equal to the maximum - Both filters can be used together to create a range - If neither filter is provided, all stocks matching the metric type will be returned **Response Format:** Returns an array of stocks with their symbol, snapshot time (Unix timestamp seconds, UTC), metric type, and metric value. **ETF behavior**: financial-metrics returns NO ETFs. The 7 valuation metrics (MARKET_CAP, PE_RATIO, PS_RATIO, PB_RATIO, DIVIDEND_YIELD, ENTERPRISE_VALUE, EV_EBITDA_RATIO) are skipped for ETFs — they require shares-outstanding / SEC fundamentals an ETF does not have (ETF MARKET_CAP via AUM is a follow-up). The 28 fundamental metrics (REVENUE_TTM, ROE_TTM, etc.) likewise return no ETFs. Query ETFs via the technical-metrics endpoint. ## OpenAPI ````yaml /api-reference/openapi.json get /v1/stocks/screener/financial-metrics openapi: 3.0.0 info: contact: {} description: >- Welcome to Arrays! Arrays is a unified financial data layer for both financial institutions and retail users, delivering comprehensive market data across crypto and equity markets. Our datasets cover fundamentals, ETFs, options, crypto, and more. Visit [arrays.org](https://arrays.org) to request an API key and start your free trial. You can explore our full API offerings in the documentation below. For any questions regarding APIs or pricing, please contact support@arrays.org. title: Arrays API version: '1.0' servers: - url: https://data-tools.prd.arrays.org/api security: [] paths: /v1/stocks/screener/financial-metrics: get: tags: - Stock summary: Get Financial Metrics Screener description: >- [OpenAPI JSON Spec](/docs/output/v1_stocks_screener_financial-metrics_get.json) Retrieve stocks filtered by financial metrics at a specific snapshot time. Returns stocks matching the specified metric type and value ranges. Includes companies with a market cap exceeding $5B at the time of the data snapshot. Please note that current market caps may fluctuate below this threshold due to recent price changes. **Overview:** This endpoint filters stocks based on financial metrics from the `stock_financial_metrics` table. The snapshot parameter is a Unix timestamp (seconds) that will be used directly for querying data. **Financial Metrics from stock_financial_metrics table (28 metrics):** **PIT (Point-in-Time) Balance Sheet Ratios (5 metrics):** - `CURRENT_RATIO_MRQ`: Current Ratio (Most Recent Quarter) - Current assets divided by current liabilities - `DEBT_TO_ASSETS_MRQ`: Debt-to-Assets Ratio (MRQ) - Total debt divided by total assets - `DEBT_TO_EQUITY_MRQ`: Debt-to-Equity Ratio (MRQ) - Total debt divided by total equity - `NET_WORKING_CAPITAL_MRQ`: Net Working Capital (MRQ) - Current assets minus current liabilities - `QUICK_RATIO_MRQ`: Quick Ratio (MRQ) - (Current assets - Inventory) divided by current liabilities **TTM (Trailing Twelve Months) Base Metrics (3 metrics):** - `REVENUE_TTM`: Revenue TTM - Total revenue over trailing twelve months - `NET_INCOME_TTM`: Net Income TTM - Net income over trailing twelve months - `EPS_TTM`: Earnings Per Share TTM - Earnings per share over trailing twelve months **TTM Profitability Ratios (3 metrics):** - `ROA_TTM`: Return on Assets TTM - Net income divided by average total assets - `ROE_TTM`: Return on Equity TTM - Net income divided by average shareholder equity - `ROIC_TTM`: Return on Invested Capital TTM - Net operating profit after tax divided by invested capital **MRQ Margin Ratios (4 metrics):** - `GROSS_MARGIN_MRQ`: Gross Margin (MRQ) - (Revenue - Cost of Goods Sold) / Revenue - `OPERATING_MARGIN_MRQ`: Operating Margin (MRQ) - Operating income / Revenue - `NET_MARGIN_MRQ`: Net Margin (MRQ) - Net income / Revenue - `FCF_MARGIN_MRQ`: Free Cash Flow Margin (MRQ) - Free cash flow / Revenue **Other MRQ Ratios (1 metric):** - `RD_TO_SALES_TTM`: Research & Development to Sales (TTM) - R&D expenses / Revenue **Revenue Growth Metrics (4 metrics):** - `REVENUE_GROWTH_QOQ`: Revenue Growth Quarter-over-Quarter - `REVENUE_GROWTH_YOY_QUARTERLY`: Revenue Growth Year-over-Year (Quarterly) - `REVENUE_GROWTH_YOY_TTM`: Revenue Growth Year-over-Year (TTM) - `REVENUE_GROWTH_YOY_ANNUAL`: Revenue Growth Year-over-Year (Annual) **EPS Growth Metrics (4 metrics):** - `EPS_GROWTH_QOQ`: EPS Growth Quarter-over-Quarter - `EPS_GROWTH_YOY_QUARTERLY`: EPS Growth Year-over-Year (Quarterly) - `EPS_GROWTH_YOY_TTM`: EPS Growth Year-over-Year (TTM) - `EPS_GROWTH_YOY_ANNUAL`: EPS Growth Year-over-Year (Annual) **FCF Growth Metrics (4 metrics):** - `FCF_GROWTH_QOQ`: Free Cash Flow Growth Quarter-over-Quarter - `FCF_GROWTH_YOY_QUARTERLY`: FCF Growth Year-over-Year (Quarterly) - `FCF_GROWTH_YOY_TTM`: FCF Growth Year-over-Year (TTM) - `FCF_GROWTH_YOY_ANNUAL`: FCF Growth Year-over-Year (Annual) **Price-Related Metrics (7 metrics):** - `MARKET_CAP`: Market Capitalization - Total market value of a company's outstanding shares - `PE_RATIO`: Price-to-Earnings Ratio - Market price per share divided by earnings per share - `PS_RATIO`: Price-to-Sales Ratio - Market capitalization divided by revenue - `PB_RATIO`: Price-to-Book Ratio - Market price per share divided by book value per share - `DIVIDEND_YIELD`: Dividend Yield - Annual dividend per share divided by market price per share - `ENTERPRISE_VALUE`: Enterprise Value - Market capitalization + Total debt - Cash and cash equivalents - `EV_EBITDA_RATIO`: EV/EBITDA Ratio - Enterprise value divided by EBITDA **Filtering:** - Use `range_min` to filter for stocks where the metric value is greater than or equal to the minimum - Use `range_max` to filter for stocks where the metric value is less than or equal to the maximum - Both filters can be used together to create a range - If neither filter is provided, all stocks matching the metric type will be returned **Response Format:** Returns an array of stocks with their symbol, snapshot time (Unix timestamp seconds, UTC), metric type, and metric value. **ETF behavior**: financial-metrics returns NO ETFs. The 7 valuation metrics (MARKET_CAP, PE_RATIO, PS_RATIO, PB_RATIO, DIVIDEND_YIELD, ENTERPRISE_VALUE, EV_EBITDA_RATIO) are skipped for ETFs — they require shares-outstanding / SEC fundamentals an ETF does not have (ETF MARKET_CAP via AUM is a follow-up). The 28 fundamental metrics (REVENUE_TTM, ROE_TTM, etc.) likewise return no ETFs. Query ETFs via the technical-metrics endpoint. parameters: - description: >- Snapshot time (Unix timestamp in seconds, used directly for querying) in: query name: snapshot required: true schema: type: integer - description: >- Metric type. Valid values: CURRENT_RATIO_MRQ, DEBT_TO_ASSETS_MRQ, DEBT_TO_EQUITY_MRQ, EPS_GROWTH_QOQ, EPS_GROWTH_YOY_ANNUAL, EPS_GROWTH_YOY_QUARTERLY, EPS_GROWTH_YOY_TTM, EPS_TTM, FCF_GROWTH_QOQ, FCF_GROWTH_YOY_ANNUAL, FCF_GROWTH_YOY_QUARTERLY, FCF_GROWTH_YOY_TTM, FCF_MARGIN_MRQ, GROSS_MARGIN_MRQ, NET_INCOME_TTM, NET_MARGIN_MRQ, NET_WORKING_CAPITAL_MRQ, OPERATING_MARGIN_MRQ, QUICK_RATIO_MRQ, RD_TO_SALES_TTM, REVENUE_GROWTH_QOQ, REVENUE_GROWTH_YOY_ANNUAL, REVENUE_GROWTH_YOY_QUARTERLY, REVENUE_GROWTH_YOY_TTM, REVENUE_TTM, ROA_TTM, ROE_TTM, ROIC_TTM, MARKET_CAP, PE_RATIO, PS_RATIO, PB_RATIO, DIVIDEND_YIELD, ENTERPRISE_VALUE, EV_EBITDA_RATIO in: query name: metric_type required: true schema: type: string - description: >- Minimum value filter (optional). Returns only stocks where metric value >= range_min in: query name: range_min schema: type: number format: float64 - description: >- Maximum value filter (optional). Returns only stocks where metric value <= range_max in: query name: range_max schema: type: number format: float64 - description: >- Sort order (optional). Valid values: ASC (ascending), DESC (descending). Defaults to DESC in: query name: order_by schema: type: string responses: '200': description: Successfully retrieved financial metrics screener data content: application/json: schema: allOf: - $ref: '#/components/schemas/model.APIResponse' - properties: data: items: $ref: '#/components/schemas/model.MetricScreenerData' type: array type: object '400': description: Invalid parameters (missing snapshot, invalid metric_type, etc.) content: application/json: schema: allOf: - $ref: '#/components/schemas/model.APIResponse' - properties: error: $ref: '#/components/schemas/model.APIError' type: object '500': description: Internal server error content: application/json: schema: allOf: - $ref: '#/components/schemas/model.APIResponse' - properties: error: $ref: '#/components/schemas/model.APIError' type: object security: - ApiKeyAuth: [] components: schemas: model.APIResponse: properties: data: {} error: $ref: '#/components/schemas/model.APIError' metadata: {} pagination: {} request_id: type: string success: type: boolean type: object model.MetricScreenerData: properties: date: description: Date string (YYYY-MM-DD) example: '2024-01-15' type: string metric: description: Metric type example: PE_RATIO type: string snapshot_time: description: Snapshot time (Unix timestamp seconds, UTC) example: 1705276800 type: integer symbol: description: Stock symbol example: AAPL type: string value: description: Metric value example: 28.5 type: number type: object model.APIError: properties: code: example: RESOURCE_NOT_FOUND type: string details: items: $ref: '#/components/schemas/model.APIErrorDetail' type: array docs_url: type: string examples: items: type: string type: array hint: type: string message: example: The requested resource was not found. type: string suggestions: items: type: string type: array type: object model.APIErrorDetail: properties: field: type: string got: type: string reason: type: string type: object securitySchemes: ApiKeyAuth: description: 'API Key authentication. Example: "your-api-key-here"' in: header name: X-API-Key type: apiKey ````