{"database":"global_markets","usage":"https://ai.strasmore.com/api/demo/sql?sql=SELECT ... FROM global_markets.<table>","auth":"none — no key, no signup","limits":{"rows":500,"seconds":20,"history_years":1,"history_start":"2025-01-01","tick_data":false,"quote_tape_days":5},"note":"Query every table as global_markets.<table>. requires_paid_plan means this no-signup surface cannot read it at all; preview_days means it is readable but only for that many trailing days, so an older window comes back EMPTY rather than as an error; history_column is the column the history window filters on. Full history and the complete tape are paid: https://www.strasmore.com/#pricing","tables":[{"table":"cache_options_quotes","columns":["ticker","sip_timestamp","sequence_number","ask_price","bid_price","ask_size","bid_size","ask_exchange","bid_exchange","_ingest_time"],"preview_days":5,"history_column":"sip_timestamp"},{"table":"cache_stocks_quotes","columns":["ticker","sip_timestamp","participant_timestamp","trf_timestamp","sequence_number","ask_price","bid_price","ask_size","bid_size","ask_exchange","bid_exchange","tape","conditions","indicators","_ingest_time"],"preview_days":5,"history_column":"sip_timestamp"},{"table":"delayed_stocks_minute_aggs","columns":["ticker","window_start","open","close","high","low","volume","transactions","_ingest_time"],"history_column":"window_start"},{"table":"inflation","columns":["date","cpi","cpi_core","cpi_year_over_year","pce","pce_core","pce_spending","_ingest_time"],"history_column":"date"},{"table":"inflation_expectations","columns":["date","forward_years_5_to_10","market_5_year","market_10_year","model_1_year","model_5_year","model_10_year","model_30_year","_ingest_time"],"history_column":"date"},{"table":"labor_market","columns":["date","avg_hourly_earnings","job_openings","labor_force_participation_rate","unemployment_rate","_ingest_time"],"history_column":"date"},{"table":"options_greeks","columns":["date","ticker","underlying_symbol","option_type","strike_price","expiration_date","volume","option_close","underlying_close","risk_free_rate","days_to_expiry","implied_volatility","iv_converged","delta","gamma","vega","theta","rho"],"requires_paid_plan":true,"history_column":"date"},{"table":"options_minute_aggs","columns":["ticker","window_start","open","close","high","low","volume","transactions","_ingest_time"],"history_column":"window_start"},{"table":"options_trades","columns":["ticker","sip_timestamp","participant_timestamp","price","size","exchange","conditions","correction","underlying_symbol","expiration_date","strike_price","option_type","_ingest_time"],"requires_paid_plan":true,"history_column":"sip_timestamp"},{"table":"stocks_10k_sections","columns":["cik","ticker","filing_date","period_end","filing_url","section","text","_ingest_time"],"history_column":"filing_date"},{"table":"stocks_13f_filings","columns":["accession_number","cusip","file_number","filer_cik","filing_date","filing_url","film_number","form_type","investment_discretion","issuer_name","market_value","other_managers","period","put_call","shares_or_principal_amount","shares_or_principal_type","title_of_class","voting_authority_none","voting_authority_shared","voting_authority_sole","_ingest_time"]},{"table":"stocks_13f_text","columns":["accession_number","filer_cik","filing_date","form_type","filing_url","filing_text","_ingest_time"]},{"table":"stocks_8k_disclosures","columns":["accession_number","cik","filing_date","filing_url","primary_category","secondary_category","tertiary_category","supporting_text","tickers","_ingest_time"]},{"table":"stocks_8k_text","columns":["cik","ticker","form_type","filing_date","accession_number","filing_url","items_text","_ingest_time"],"history_column":"filing_date"},{"table":"stocks_balance_sheets","columns":["period_end","filing_date","cik","tickers","fiscal_year","fiscal_quarter","timeframe","total_assets","total_current_assets","total_liabilities","total_current_liabilities","total_equity","cash_and_equivalents","accounts_payable","accrued_and_other_current_liabilities","accumulated_other_comprehensive_income","additional_paid_in_capital","commitments_and_contingencies","common_stock","debt_current","deferred_revenue_current","goodwill","intangible_assets_net","inventories","long_term_debt_and_capital_lease_obligations","noncontrolling_interest","other_assets","other_current_assets","other_equity","other_noncurrent_liabilities","preferred_stock","property_plant_equipment_net","receivables","retained_earnings_deficit","short_term_investments","total_equity_attributable_to_parent","total_liabilities_and_equity","treasury_stock","_ingest_time"],"history_column":"filing_date"},{"table":"stocks_cash_flow_statements","columns":["period_end","filing_date","cik","tickers","fiscal_year","fiscal_quarter","timeframe","net_income","net_cash_from_operating_activities","net_cash_from_investing_activities","net_cash_from_financing_activities","change_in_cash_and_equivalents","cash_from_operating_activities_continuing_operations","change_in_other_operating_assets_and_liabilities_net","depreciation_depletion_and_amortization","dividends","effect_of_currency_exchange_rate","income_loss_from_discontinued_operations","long_term_debt_issuances_repayments","net_cash_from_financing_activities_continuing_operations","net_cash_from_financing_activities_discontinued_operations","net_cash_from_investing_activities_continuing_operations","net_cash_from_investing_activities_discontinued_operations","net_cash_from_operating_activities_discontinued_operations","noncontrolling_interests","other_cash_adjustments","other_financing_activities","other_investing_activities","other_operating_activities","purchase_of_property_plant_and_equipment","sale_of_property_plant_and_equipment","short_term_debt_issuances_repayments","_ingest_time"],"history_column":"filing_date"},{"table":"stocks_condition_codes","columns":["id","name","abbreviation","type","description","asset_class","data_types","legacy","exchange","sip_mapping","update_rules","_ingest_time"]},{"table":"stocks_daily_aggs","columns":["ticker","date","open","close","high","low","volume","vwap","transactions","otc","_ingest_time"],"history_column":"date"},{"table":"stocks_dividends","columns":["ex_dividend_date","ticker","id","cash_amount","currency","declaration_date","pay_date","record_date","frequency","distribution_type","split_adjusted_cash_amount","historical_adjustment_factor","_ingest_time"],"history_column":"ex_dividend_date"},{"table":"stocks_exchanges","columns":["id","type","asset_class","locale","name","acronym","mic","operating_mic","participant_id","url","_ingest_time"]},{"table":"stocks_form3","columns":["accession_number","aff_10b5_one","date_of_original_submission","direct_or_indirect","exercise_date","exercise_price","filing_date","filing_url","footnotes","form_type","is_director","is_officer","is_other","is_ten_percent_owner","issuer_cik","issuer_name","nature_of_ownership","not_subject_to_section_16","officer_title","owner_cik","owner_name","period_of_report","remarks","security_title","security_type","shares_owned","tickers","underlying_security_shares","underlying_security_title","_ingest_time"]},{"table":"stocks_form4","columns":["accession_number","aff_10b5_one","date_of_original_submission","deemed_execution_date","direct_or_indirect","equity_swap_involved","exercise_date","exercise_price","expiration_date","filing_date","filing_url","footnotes","form_type","is_director","is_officer","is_other","is_ten_percent_owner","issuer_cik","issuer_name","nature_of_ownership","not_subject_to_section_16","officer_title","owner_cik","owner_name","period_of_report","record_type","remarks","security_title","security_type","shares_owned_following_transaction","tickers","transaction_acquired_disposed","transaction_code","transaction_date","transaction_price_per_share","transaction_shares","transaction_timeliness","transaction_value","underlying_security_shares","underlying_security_title","_ingest_time"]},{"table":"stocks_income_statements","columns":["period_end","filing_date","cik","tickers","fiscal_year","fiscal_quarter","timeframe","revenue","cost_of_revenue","gross_profit","operating_income","net_income_loss_attributable_common_shareholders","consolidated_net_income_loss","basic_earnings_per_share","basic_shares_outstanding","diluted_earnings_per_share","diluted_shares_outstanding","ebitda","selling_general_administrative","research_development","total_operating_expenses","income_before_income_taxes","income_taxes","interest_expense","interest_income","depreciation_depletion_amortization","discontinued_operations","equity_in_affiliates","extraordinary_items","noncontrolling_interest","other_income_expense","other_operating_expenses","preferred_stock_dividends_declared","total_other_income_expense","_ingest_time"],"history_column":"filing_date"},{"table":"stocks_ipos","columns":["listing_date","ticker","issuer_name","ipo_status","announced_date","issue_start_date","issue_end_date","final_issue_price","lowest_offer_price","highest_offer_price","total_offer_size","min_shares_offered","max_shares_offered","shares_outstanding","lot_size","currency_code","security_type","security_description","primary_exchange","isin","us_code","last_updated","_ingest_time"],"history_column":"listing_date"},{"table":"stocks_market_holidays","columns":["date","exchange","name","status","open","close","_ingest_time"]},{"table":"stocks_market_status","columns":["afterHours","currencies","earlyHours","exchanges","indicesGroups","market","serverTime","_ingest_time"]},{"table":"stocks_news","columns":["id","published_utc","title","author","article_url","amp_url","image_url","description","tickers","keywords","insights","publisher","_ingest_time"],"history_column":"published_utc"},{"table":"stocks_ratios","columns":["date","ticker","cik","price","market_cap","enterprise_value","average_volume","earnings_per_share","price_to_earnings","price_to_book","price_to_sales","price_to_cash_flow","price_to_free_cash_flow","ev_to_ebitda","ev_to_sales","dividend_yield","return_on_assets","return_on_equity","debt_to_equity","current","quick","cash","free_cash_flow","_ingest_time"],"history_column":"date"},{"table":"stocks_risk_categories","columns":["taxonomy","primary_category","secondary_category","tertiary_category","description","_ingest_time"]},{"table":"stocks_risk_factors","columns":["cik","ticker","filing_date","primary_category","secondary_category","tertiary_category","supporting_text","_ingest_time"],"history_column":"filing_date"},{"table":"stocks_sec_edgar_index","columns":["cik","ticker","issuer_name","form_type","filing_date","accession_number","filing_url","_ingest_time"],"history_column":"filing_date"},{"table":"stocks_short_interest","columns":["settlement_date","ticker","short_interest","avg_daily_volume","days_to_cover","_ingest_time"],"history_column":"settlement_date"},{"table":"stocks_short_volume","columns":["date","ticker","short_volume","short_volume_ratio","total_volume","exempt_volume","non_exempt_volume","adf_short_volume","adf_short_volume_exempt","nasdaq_carteret_short_volume","nasdaq_carteret_short_volume_exempt","nasdaq_chicago_short_volume","nasdaq_chicago_short_volume_exempt","nyse_short_volume","nyse_short_volume_exempt","_ingest_time"],"history_column":"date"},{"table":"stocks_splits","columns":["execution_date","ticker","id","split_from","split_to","adjustment_type","historical_adjustment_factor","_ingest_time"],"history_column":"execution_date"},{"table":"stocks_trades","columns":["ticker","sip_timestamp","participant_timestamp","trf_timestamp","sequence_number","price","size","exchange","tape","conditions","correction","_ingest_time"],"requires_paid_plan":true,"history_column":"sip_timestamp"},{"table":"treasury_yields","columns":["date","yield_1_month","yield_3_month","yield_6_month","yield_1_year","yield_2_year","yield_3_year","yield_5_year","yield_7_year","yield_10_year","yield_20_year","yield_30_year","_ingest_time"],"history_column":"date"}]}