Universal Query

Introduction

Instead of maintaining separate endpoints for each data type, use /api/v1/universal-query to access all our financial data from one place.

Query parameters give you direct control over the response payload. You can select the dataset, request specific fields, and apply multiple filters – keeping payload sizes small and your integration clean.

Core Capabilities

  • Unified Access: Query any financial dataset via one endpoint.
  • Tailored Payloads: Request only the fields you need to save bandwidth.
  • Complex Filtering: Combine multiple operators (eq, gt, in) per query.

Endpoint URL

GET
https://financialdata.net/api/v1/universal-query

Query Parameters

NameTypeRequiredDescription
datasetstringYesThe dataset name to query (e.g., company_information, key_metrics).
fieldsstringYesComma-separated list of fields to include in response (e.g., trading_symbol, revenue).
field[operator]string / numberOptionalField-level filters, up to 5 per request (e.g., market_cap[gt]=1000000000).
offsetintegerOptionalNumber of records to skip for pagination. Default is 0.
formatstringOptionalThe format of the returned data (json or csv). Default is json.
keystringYesYour API key.

Filters & Operators

OperatorConditionExample
eqEqual totrading_symbol[eq]=MSFT
neNot equal toaddress_country_code[ne]=US
gtGreater thanmarket_cap[gt]=1000000000
gteGreater than or equal toprice_to_earnings_ratio[gte]=20
ltLess thanemployee_count[lt]=1000
lteLess than or equal tofiscal_year[lte]=2020
inMatches any in comma-separated listisin_number[in]=US0378331005,US67066G1040
ninExcludes all in comma-separated listindustry[nin]=Mining,Metals

Dynamic Record Limits

To maintain optimal performance, the maximum number of records returned per request is calculated dynamically based on query complexity, target dataset, and requested fields.

Client applications must inspect the X-Record-Limit HTTP response header for the applied limit and use it with the offset parameter to paginate through the remaining data.

Datasets & Fields

Dataset
stock_symbols
Symbol Lists
Available Fields
trading_symbolregistrant_name
Dataset
international_stock_symbols
Symbol Lists
Available Fields
trading_symbolregistrant_name
Dataset
etf_symbols
Symbol Lists
Available Fields
trading_symboldescription
Dataset
commodity_symbols
Symbol Lists
Available Fields
trading_symboldescription
Dataset
otc_symbols
Symbol Lists
Available Fields
trading_symboltitle_of_security
Dataset
stock_quotes
Market Data
Available Fields
trading_symbolregistrant_nametimepricechangepercentage_change
Dataset
stock_prices
Market Data
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
international_stock_prices
Market Data
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
minute_prices
Market Data
Available Fields
trading_symboltimeopenhighlowclosevolume
Dataset
latest_prices
Market Data
Available Fields
trading_symboltimeopenhighlowclosevolume
Dataset
commodity_prices
Market Data
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
otc_prices
Market Data
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
otc_volume
Market Data
Available Fields
trading_symboltitle_of_securitymonth_start_datemonthly_volumeprevious_monthly_volumevolume_year_to_date
Dataset
index_symbols
Market Indexes
Available Fields
trading_symbolindex_name
Dataset
index_quotes
Market Indexes
Available Fields
trading_symbolindex_nametimepricechangepercentage_change
Dataset
index_prices
Market Indexes
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
index_constituents
Market Indexes
Available Fields
trading_symbolindex_nameconstituent_symbolconstituent_namesectorindustrydate_added
Dataset
option_chain
Derivatives Data
Available Fields
trading_symbolcentral_index_keyregistrant_namecontract_nameexpiration_dateput_or_callstrike_price
Dataset
option_prices
Derivatives Data
Available Fields
contract_namedateopenhighlowclosevolume
Dataset
option_greeks
Derivatives Data
Available Fields
contract_namedatedeltagammathetavegarho
Dataset
futures_symbols
Derivatives Data
Available Fields
trading_symboldescriptiontype
Dataset
futures_prices
Derivatives Data
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
crypto_symbols
Crypto Currencies
Available Fields
trading_symbolbase_assetquote_asset
Dataset
crypto_information
Crypto Currencies
Available Fields
trading_symbolcrypto_namemarket_capfully_diluted_valuationtotal_supplymax_supplycirculating_supplyhighest_pricehighest_price_datelowest_pricelowest_price_datehash_functionblock_timeledger_start_datewebsitedescription
Dataset
crypto_quotes
Crypto Currencies
Available Fields
trading_symbolbase_assetquote_assettimepricechangepercentage_change
Dataset
crypto_prices
Crypto Currencies
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
crypto_minute_prices
Crypto Currencies
Available Fields
trading_symboltimeopenhighlowclosevolume
Dataset
forex_symbols
Forex Data
Available Fields
trading_symbolbase_assetquote_asset
Dataset
forex_quotes
Forex Data
Available Fields
trading_symbolbase_assetquote_assettimepricechangepercentage_change
Dataset
forex_prices
Forex Data
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
forex_minute_prices
Forex Data
Available Fields
trading_symboltimeopenhighlowclosevolume
Dataset
company_information
Basic Information
Available Fields
trading_symbolcentral_index_keyregistrant_nameisin_numberlei_numberein_numberexchangesic_codesic_descriptionfiscal_year_endstate_of_incorporationaddress_streetaddress_cityaddress_stateaddress_zip_codeaddress_countryaddress_country_codephone_numbermailing_addressbusiness_addressformer_nameindustryfounding_datechief_executive_officernumber_of_employeeswebsitemarket_capshares_issuedshares_outstandingdescription
Dataset
international_company_information
Basic Information
Available Fields
trading_symbolregistrant_nameexchangeisin_numberindustryfounding_datechief_executive_officernumber_of_employeeswebsitedescription
Dataset
key_metrics
Basic Information
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearperiod_end_dateearnings_per_shareearnings_per_share_forecastprice_to_earnings_ratioforward_price_to_earnings_ratioearnings_growth_rateprice_earnings_to_growth_ratiobook_value_per_shareprice_to_book_ratioebitdaenterprise_valuedividend_yielddividend_payout_ratiodebt_to_equity_ratiocapital_expendituresfree_cash_flowreturn_on_equityone_year_betathree_year_betafive_year_beta
Dataset
international_key_metrics
Basic Information
Available Fields
trading_symbolregistrant_namefiscal_periodperiod_end_datecurrency_codeearnings_per_shareprice_to_earnings_ratioearnings_growth_rateprice_earnings_to_growth_ratiobook_value_per_shareprice_to_book_ratioebitdaenterprise_valuedividend_yielddividend_payout_ratiodebt_to_equity_ratiocapital_expendituresfree_cash_flowreturn_on_equityone_year_betathree_year_betafive_year_beta
Dataset
market_cap
Basic Information
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearmarket_capchange_in_market_cappercentage_change_in_market_capshares_outstandingchange_in_shares_outstandingpercentage_change_in_shares_outstanding
Dataset
employee_count
Basic Information
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearemployee_count
Dataset
executive_compensation
Basic Information
Available Fields
trading_symbolcentral_index_keyregistrant_nameexecutive_nameexecutive_positionfiscal_yearsalarybonusstock_awardsincentive_plan_compensationother_compensationtotal_compensation
Dataset
securities_information
Basic Information
Available Fields
trading_symbolissuer_namecusip_numberisin_numberfigi_identifiersecurity_type
Dataset
income_statements
Financial Statements
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_daterevenuecost_of_revenuegross_profitresearch_and_development_expensesgeneral_and_administrative_expensesoperating_expensesoperating_incomeinterest_expenseinterest_incomenet_incomeearnings_per_share_basicearnings_per_share_dilutedweighted_average_shares_outstanding_basicweighted_average_shares_outstanding_diluted
Dataset
balance_sheet_statements
Financial Statements
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_datecash_and_cash_equivalentsmarketable_securities_currentaccounts_receivableinventoriesnon_trade_receivablesother_assets_currenttotal_assets_currentmarketable_securities_non_currentproperty_plant_and_equipmentother_assets_non_currenttotal_assets_non_currenttotal_assetsaccounts_payabledeferred_revenueshort_term_debtother_liabilities_currenttotal_liabilities_currentlong_term_debtother_liabilities_non_currenttotal_liabilities_non_currenttotal_liabilitiescommon_stockretained_earningsaccumulated_other_comprehensive_incometotal_shareholders_equity
Dataset
cash_flow_statements
Financial Statements
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_datedepreciation_and_amortizationshare_based_compensation_expensedeferred_income_tax_expenseother_non_cash_income_expensechange_in_accounts_receivablechange_in_inventorieschange_in_non_trade_receivableschange_in_other_assetschange_in_accounts_payablechange_in_deferred_revenuechange_in_other_liabilitiescash_from_operating_activitiespurchases_of_marketable_securitiessales_of_marketable_securitiesacquisition_of_property_plant_and_equipmentacquisition_of_businessother_investing_activitiescash_from_investing_activitiestax_withholding_for_share_based_compensationpayments_of_dividendsissuance_of_common_stockrepurchase_of_common_stockissuance_of_long_term_debtrepayment_of_long_term_debtother_financing_activitiescash_from_financing_activitieschange_in_cashcash_at_end_of_periodincome_taxes_paidinterest_paid
Dataset
international_income_statements
Financial Statements
Available Fields
trading_symbolregistrant_namefiscal_periodperiod_end_datecurrency_coderevenuecost_of_revenuegross_profitresearch_and_development_expensesgeneral_and_administrative_expensesoperating_expensesoperating_incomeinterest_expenseinterest_incomenet_incomeearnings_per_share_basicearnings_per_share_dilutedweighted_average_shares_outstanding_basicweighted_average_shares_outstanding_diluted
Dataset
international_balance_sheet_statements
Financial Statements
Available Fields
trading_symbolregistrant_namefiscal_periodperiod_end_datecurrency_codecash_and_cash_equivalentsaccounts_receivableinventoriesother_assets_currenttotal_assets_currentproperty_plant_and_equipmentother_assets_non_currenttotal_assets_non_currenttotal_assetsaccounts_payableshort_term_debtother_liabilities_currenttotal_liabilities_currentlong_term_debtother_liabilities_non_currenttotal_liabilities_non_currenttotal_liabilitiescommon_stockretained_earningstotal_shareholders_equity
Dataset
international_cash_flow_statements
Financial Statements
Available Fields
trading_symbolregistrant_namefiscal_periodperiod_end_datecurrency_codedepreciation_and_amortizationshare_based_compensation_expensechange_in_accounts_receivablechange_in_inventorieschange_in_other_assetschange_in_accounts_payablechange_in_other_liabilitiescash_from_operating_activitiesacquisition_of_property_plant_and_equipmentacquisition_of_businesscash_from_investing_activitiespayments_of_dividendsissuance_of_common_stockrepurchase_of_common_stockissuance_of_long_term_debtrepayment_of_long_term_debtcash_from_financing_activitieschange_in_cashcash_at_end_of_period
Dataset
liquidity_ratios
Financial Ratios
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_dateworking_capitalcurrent_ratiocash_ratioquick_ratiodays_of_inventory_outstandingdays_sales_outstandingdays_payables_outstandingcash_conversion_cyclesales_to_working_capital_ratiocash_to_current_liabilities_ratioworking_capital_to_debt_ratiocash_flow_adequacy_ratiosales_to_current_assets_ratiocash_to_current_assets_ratiocash_to_working_capital_ratioinventory_to_working_capital_rationet_debt
Dataset
solvency_ratios
Financial Ratios
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_dateequity_ratiodebt_coverage_ratioasset_coverage_ratiointerest_coverage_ratiodebt_to_equity_ratiodebt_to_assets_ratiodebt_to_capital_ratiodebt_to_income_ratiocash_flow_to_debt_ratio
Dataset
efficiency_ratios
Financial Ratios
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_dateasset_turnover_ratioinventory_turnover_ratioaccounts_receivable_turnover_ratioaccounts_payable_turnover_ratioequity_multiplierdays_sales_in_inventoryfixed_asset_turnover_ratiodays_working_capitalworking_capital_turnover_ratiodays_cash_on_handcapital_intensity_ratiosales_to_equity_ratioinventory_to_sales_ratioinvestment_turnover_ratiosales_to_operating_income_ratio
Dataset
profitability_ratios
Financial Ratios
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_dateebitebitdaprofit_margingross_marginoperating_marginoperating_cash_flow_marginreturn_on_equityreturn_on_assetsreturn_on_debtcash_return_on_assetscash_turnover_ratio
Dataset
valuation_ratios
Financial Ratios
Available Fields
trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_datedividends_per_sharedividend_payout_ratiobook_value_per_shareretention_rationet_fixed_assets
Dataset
latest_news
Market News
Available Fields
trading_symbolspublication_timearticle_headlinearticle_text
Dataset
press_releases
Market News
Available Fields
trading_symbolcentral_index_keyregistrant_namepublication_timerelease_headlinerelease_text
Dataset
sec_press_releases
Market News
Available Fields
publication_timerelease_headlinerelease_text
Dataset
fed_press_releases
Market News
Available Fields
publication_timerelease_typerelease_headlinerelease_text
Dataset
earnings_calendar
Event Calendars
Available Fields
trading_symbolregistrant_namefiscal_quarter_end_datereport_dateconference_call_timeearnings_per_share_forecast
Dataset
ipo_calendar
Event Calendars
Available Fields
trading_symbolregistrant_nameexchangepricing_dateshare_priceshares_offeredoffering_value
Dataset
splits_calendar
Event Calendars
Available Fields
trading_symbolregistrant_nameexecution_datemultiplier
Dataset
dividends_calendar
Event Calendars
Available Fields
trading_symbolregistrant_nameamountdeclaration_dateex_daterecord_datepayment_date
Dataset
economic_calendar
Event Calendars
Available Fields
event_namecountrycountry_codetimeprevious_valueactual_value
Dataset
economic_indicators
Economic Data
Available Fields
indicator_idindicator_namecategoryfrequencyunits
Dataset
economic_indicator_values
Economic Data
Available Fields
indicator_iddatevalue
Dataset
insider_transactions
Insider Trading
Available Fields
trading_symbolcentral_index_keyregistrant_nameinsider_nameinsider_central_index_keyrelationship_to_issueris_derivatives_transactiontitle_of_securitytransaction_datetransaction_codetransaction_descriptionamount_of_securitiesprice_per_securityacquired_or_disposedtitle_of_underlying_securityamount_of_underlying_securitiessecurities_owned_following_transactionownership_formnature_of_indirect_ownership
Dataset
proposed_sales
Insider Trading
Available Fields
trading_symbolcentral_index_keyregistrant_nameseller_namerelationship_to_issuertitle_of_securitybroker_nameamount_of_securities_to_be_soldmarket_valueamount_of_securities_outstandingapproximate_date_of_saleexchangeacquisition_period_startacquisition_period_endnature_of_acquisition_transactionnames_of_persons_from_whom_acquired
Dataset
senate_trading
Insider Trading
Available Fields
name_of_reporting_persontype_of_reporting_personreport_datetransaction_numbertransaction_typetransaction_dateowner_typetrading_symbolasset_nameasset_typeamountcomment
Dataset
house_trading
Insider Trading
Available Fields
name_of_reporting_personreport_datestatetransaction_numbertransaction_typetransaction_dateowner_typetrading_symbolasset_nameasset_typeamountnotification_date
Dataset
institutional_investors
Institutional Trading
Available Fields
central_index_keyregistrant_name
Dataset
institutional_holdings
Institutional Trading
Available Fields
investor_namecentral_index_keyperiod_of_reportissuer_nametrading_symbolcusip_numbertitle_of_securitymarket_valueamount_of_securitiesprice_per_securityshares_or_principalput_or_callinvestment_discretionportfolio_weight
Dataset
institutional_portfolio_statistics
Institutional Trading
Available Fields
investor_namecentral_index_keyperiod_of_reportportfolio_sizeadded_securitiesremoved_securitiesportfolio_valuesales_valuepurchases_valuechange_in_portfolio_valuepercentage_change_in_portfolio_valueportfolio_turnoverperiod_returnperiod_rate_of_returnannual_returnannual_rate_of_returnreturn_since_inceptionrate_of_return_since_inception
Dataset
etf_quotes
Etf Data
Available Fields
trading_symboldescriptiontimepricechangepercentage_change
Dataset
etf_prices
Etf Data
Available Fields
trading_symboldateopenhighlowclosevolume
Dataset
etf_minute_prices
Etf Data
Available Fields
trading_symboltimeopenhighlowclosevolume
Dataset
etf_holdings
Etf Data
Available Fields
central_index_keyregistrant_nameperiod_of_reportetf_nameetf_symbolseries_idclass_idissuer_namelei_numbertitle_of_securitytrading_symbolcusip_numberisin_numberamount_of_unitsdescription_of_unitsdenomination_currencyvalue_in_usdpercentage_value_compared_to_assetspayoff_profileasset_typeissuer_typecountry_of_issuer_or_investmentis_restricted_securityfair_value_levelis_cash_collateralis_non_cash_collateralis_loan_by_fund
Dataset
mutual_fund_symbols
Mutual Funds
Available Fields
trading_symbolfund_name
Dataset
mutual_fund_holdings
Mutual Funds
Available Fields
central_index_keyregistrant_nameperiod_of_reportfund_namefund_symbolseries_idclass_idissuer_namelei_numbertitle_of_securitytrading_symbolcusip_numberisin_numberamount_of_unitsdescription_of_unitsdenomination_currencyvalue_in_usdpercentage_value_compared_to_assetspayoff_profileasset_typeissuer_typecountry_of_issuer_or_investmentis_restricted_securityfair_value_levelis_cash_collateralis_non_cash_collateralis_loan_by_fund
Dataset
mutual_fund_statistics
Mutual Funds
Available Fields
central_index_keyregistrant_nameperiod_of_reportfund_namefund_symbolseries_idclass_idtotal_assetstotal_liabilitiesnet_assetsreturn_preceding_month1return_preceding_month2return_preceding_month3realized_gain_preceding_month1change_in_unrealized_appreciation_preceding_month1realized_gain_preceding_month2change_in_unrealized_appreciation_preceding_month2realized_gain_preceding_month3change_in_unrealized_appreciation_preceding_month3share_sale_preceding_month1share_redemption_preceding_month1share_sale_preceding_month2share_redemption_preceding_month2share_sale_preceding_month3share_redemption_preceding_month3
Dataset
esg_scores
Esg Data
Available Fields
trading_symbolcentral_index_keyregistrant_nameindustrydateenvironmental_risk_scoresocial_risk_scoregovernance_risk_scoreesg_risk_score
Dataset
esg_ratings
Esg Data
Available Fields
trading_symbolcentral_index_keyregistrant_nameindustrydateesg_corporate_ratingesg_industry_rank
Dataset
industry_esg_scores
Esg Data
Available Fields
industrydateenvironmental_risk_scoresocial_risk_scoregovernance_risk_scoreesg_risk_score
Dataset
investment_adviser_names
Investment Advisers
Available Fields
legal_name
Dataset
investment_adviser_information
Investment Advisers
Available Fields
legal_nameprimary_business_namecentral_index_keylei_numberform_of_businessfiscal_year_endstate_of_incorporationcountry_of_incorporationoffice_addressoffice_phone_numberwebsitenumber_of_employeesassets_under_managementnumber_of_accounts
Dataset
analyst_consensus
Miscellaneous Data
Available Fields
trading_symbolcentral_index_keyregistrant_nameaverage_price_targethighest_price_targetlowest_price_targetbuy_recommendationssell_recommendationshold_recommendations
Dataset
earnings_releases
Miscellaneous Data
Available Fields
trading_symbolcentral_index_keyregistrant_namemarket_capfiscal_quarter_end_dateearnings_per_shareearnings_per_share_forecastpercentage_surprisenumber_of_forecastsconference_call_time
Dataset
initial_public_offerings
Miscellaneous Data
Available Fields
trading_symbolregistrant_nameexchangepricing_dateshare_priceshares_offeredoffering_value
Dataset
stock_splits
Miscellaneous Data
Available Fields
trading_symbolcentral_index_keyregistrant_nameexecution_datemultiplier
Dataset
dividends
Miscellaneous Data
Available Fields
trading_symbolregistrant_nametypeamountdeclaration_dateex_daterecord_datepayment_date
Dataset
short_interest
Miscellaneous Data
Available Fields
trading_symboltitle_of_securitymarket_codesettlement_dateshorted_securitiesprevious_shorted_securitieschange_in_shorted_securitiespercentage_change_in_shorted_securitiesaverage_daily_volumedays_to_coveris_stock_split