# Turkish stocks, Borsa Istanbul prices and KAP fundamentals since 2016

**Screen every Borsa Istanbul listed company on price trend, risk, valuation, KAP financial statements, dividends, ownership and what it discloses.** The search table joins everything onto one row per share code: the latest price with returns in lira and US dollars, technicals, market capitalization and valuation, the latest KAP income statement, cash flow and balance sheet, growth and payout his…

Turkish stocks, Borsa Istanbul prices and KAP fundamentals since 2016 is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and`
- Canonical page: https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-11-06T09:58:32.455Z
- Tables: 28
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and`
- Topics: turkish stocks, borsa istanbul, kap, xbrl fundamentals, stock screener, stock prices, technical indicators, kap disclosures

## Table directory

Tables follow the publisher's curated order. Display labels do not change table identifiers.

Start here: search_stocks — table id: 37534dc7-95cf-4a0f-9a8a-171572b6c6be

- search_stocks — table id: 37534dc7-95cf-4a0f-9a8a-171572b6c6be; published name: search_stocks; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=search-stocks
- source_fundamentals_facts_2018 — table id: 9541a641-0ec1-4f70-b2da-8db2553fc31e; published name: source_fundamentals_facts_2018; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2018
- source_stock_screener — table id: c9342f43-5ffa-4155-819f-a92b6ee0a22d; published name: source_stock_screener; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-stock-screener
- source_fundamentals_facts_2016 — table id: eef3472e-c207-47ad-b639-0fd6632d96a4; published name: source_fundamentals_facts_2016; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2016
- source_fundamentals_facts_2025 — table id: ab9cd2d7-b6f7-4722-9834-cbb12150ef92; published name: source_fundamentals_facts_2025; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2025
- source_company_profiles — table id: 38647174-353f-4b1f-821e-cbbb30fa6e84; published name: source_company_profiles; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-company-profiles
- source_prices_recent — table id: ad19b9aa-2609-44f1-88f4-c583f75551d0; published name: source_prices_recent; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-prices-recent
- source_prices — table id: 9de9f428-5e34-48e9-9e47-a5059cd9f34f; published name: source_prices; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-prices
- source_fundamentals_facts_2019 — table id: 7ba65c36-6537-41be-abf9-cb18add678f6; published name: source_fundamentals_facts_2019; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2019
- source_annual_report_index — table id: 96008a0e-6830-435c-8d79-8625c97e11c4; published name: source_annual_report_index; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-annual-report-index
- source_fundamentals_latest — table id: f8a0cc88-7074-4a6b-a682-eb2a522793c4; published name: source_fundamentals_latest; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-latest
- series_fx_ecb — table id: 9a74fe31-1589-4e15-b4e3-e0a327f87eab; published name: series_fx_ecb; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=series-fx-ecb
- source_fundamentals_history_stats — table id: 968e562e-1844-4e43-8aaf-3bb8bd291df7; published name: source_fundamentals_history_stats; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-history-stats
- source_fundamentals_facts_2023 — table id: 1b9d8ad1-9ca5-45c0-a8e2-f9d505026c59; published name: source_fundamentals_facts_2023; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2023
- source_corporate_actions — table id: 11de1c46-7566-456b-86a8-82d9a0ab0f83; published name: source_corporate_actions; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-corporate-actions
- source_fundamentals_facts_2021 — table id: a08b23a9-b829-4698-97d3-c1b706427120; published name: source_fundamentals_facts_2021; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2021
- source_securities — table id: 9da1bb04-bd22-4b11-8f41-38a8cc96cec2; published name: source_securities; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-securities
- source_fundamentals_facts_2024 — table id: f2e4bf8f-ca87-422c-a185-2e9a7cd76541; published name: source_fundamentals_facts_2024; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2024
- source_kap_disclosures_history — table id: 96afe32f-bb2b-486a-8530-b6a0d3e14589; published name: source_kap_disclosures_history; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-kap-disclosures-history
- source_filing_activity — table id: 1686962c-79c3-4f41-a7f1-f3e8265cb5af; published name: source_filing_activity; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-filing-activity
- source_fundamentals_facts_2017 — table id: c5521b6c-08d9-4a9d-bba8-2c7e34ffbf42; published name: source_fundamentals_facts_2017; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2017
- series_prices — table id: 70d19070-81c5-4c0e-926e-103a4b9a699a; published name: series_prices; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=series-prices
- series_fundamentals — table id: ad64b322-9bc1-46ad-aa26-2c45d136b385; published name: series_fundamentals; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=series-fundamentals
- source_fundamentals_facts_2020 — table id: bea559f0-316b-448b-abb5-d9bf3168f16b; published name: source_fundamentals_facts_2020; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2020
- kap_disclosures — table id: 163522a6-0717-401e-b89f-b3ff13bdc52f; published name: kap_disclosures; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=kap-disclosures
- source_fundamentals_facts_2022 — table id: c83c3b2b-9225-4f7d-abca-96107fd12e24; published name: source_fundamentals_facts_2022; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2022
- source_company_labels — table id: 27c08954-7763-4b1e-9a84-30a6bf33820d; published name: source_company_labels; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-company-labels
- source_fundamentals_facts_2026 — table id: 929c72ed-d26f-4e55-ab5c-6bcc3cb85e67; published name: source_fundamentals_facts_2026; https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and/tables?table=source-fundamentals-facts-2026

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and nothing else: no filter, sort, search, download or page past row 500.
3. Sign in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: search_stocks

- Table id: `37534dc7-95cf-4a0f-9a8a-171572b6c6be`
- Slug: `search-stocks`
- Immutable version: `92358aaa-7297-5567-9298-8b20706b649b`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/37534dc7-95cf-4a0f-9a8a-171572b6c6be/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/37534dc7-95cf-4a0f-9a8a-171572b6c6be/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/37534dc7-95cf-4a0f-9a8a-171572b6c6be/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/37534dc7-95cf-4a0f-9a8a-171572b6c6be/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (254)

| Column | Type | Description |
| --- | --- | --- |
| `symbol` | string | Borsa Istanbul share code (ticker) as KAP and the exchange write it, such as THYAO, ASELS or KRDMD. |
| `company_name` | string | The company's title on KAP, such as TÜRK HAVA YOLLARI A.O. |
| `share_codes` | string | Every share code of the same company, comma separated, such as KRDMA, KRDMB, KRDMD. |
| `share_code_count` | integer | How many share codes the company has on Borsa Istanbul. |
| `sector` | string | KAP's sector for the company in Turkish, such as İMALAT or MALİ KURULUŞLAR. |
| `sector_en` | string | KAP's sector in English, from a rule over its Turkish name: Manufacturing, Financial institutions, Technology, Electricity gas and water, Wholesale and retail… |
| `industry` | string | KAP's sub-sector for the company in Turkish, such as BANKALAR or GIDA, İÇKİ VE TÜTÜN. |
| `industry_en` | string | KAP's sub-sector in English, from a rule over its Turkish name: Banks, Insurance, Holding and investment companies, Real estate investment trusts, Brokerage ho… |
| `activity` | string | The line of business the company states on KAP, in Turkish, as plain text: what the company does. |
| `market_segment` | string | The Borsa Istanbul equity market the share trades on: Yıldız Pazar (Star Market), Ana Pazar (Main Market), Alt Pazar (Sub-Market), Yakın İzleme Pazarı (Watchli… |
| `index_memberships` | string | The Borsa Istanbul indices the share is in, comma separated, such as BIST 30, BIST 100, BIST TÜM, BIST BANKA, BIST KATILIM. |
| `index_count` | integer | How many Borsa Istanbul indices the share is in. |
| `in_bist30` | boolean | True when the share is in the BIST 30 index of the largest, most liquid shares. |
| `in_bist50` | boolean | True when the share is in the BIST 50 index. |
| `in_bist100` | boolean | True when the share is in the BIST 100 index, the main benchmark. |
| `in_bist_all` | boolean | True when the share is in the BIST TÜM (all shares) index. |
| `in_katilim` | boolean | True when the share is in a BIST Katılım (participation, Sharia-compliant, Islamic finance) index. |
| `city` | string | The city KAP records for the company's head office, in Turkish capitals, such as İSTANBUL, ANKARA or İZMİR. |
| `head_office_address` | string | The company's head office address as KAP records it. |
| `website` | string | The company's website as it gives KAP. |
| `logo_url` | string | Favicon of the company's website at 128 pixels, from Google's favicon service; empty when KAP lists no website. |
| `kap_url` | string | The company's KAP summary page. |
| `kap_company_id` | integer | The number in the company's KAP page address, such as 1107 for Turkish Airlines. |
| `mkk_member_oid` | string | The company's MKK member id, the key every KAP table joins on. |
| `auditor` | string | The company's independent audit firm as KAP records it. |
| `big4_auditor` | boolean | True when the auditor is a Big Four member firm: Deloitte (DRT), PwC, KPMG or EY (Güney). |
| `sector_gics` | string | GICS sector a classification model (Clef) assigned from the KAP line of business: Communication Services, Consumer Discretionary, Consumer Staples, Energy, Fin… |
| `sector_gics_probability` | decimal | The model probability of that sector, 0 to 1. |
| `company_type` | string | Kind of company the model assigned: operating company, holding company, bank or participation bank, insurer or pension company, leasing, factoring or consumer… |
| `company_type_probability` | decimal | The model probability of that company type, 0 to 1. |
| `business_model` | string | Who the company mainly sells to, per the model: businesses, consumers, both businesses and consumers, governments or the public sector, or none fits. |
| `business_model_probability` | decimal | The model probability of that business model, 0 to 1. |
| `revenue_model` | string | How the company mainly earns, per the model: product sales, services or contracts, subscriptions or recurring fees, transaction or usage fees, interest and len… |
| `revenue_model_probability` | decimal | The model probability of that revenue model, 0 to 1. |
| `market_reach` | string | Where the company mainly sells, per the model: mostly in Turkey, Turkey and exports (exporters), mostly outside Turkey, or none fits. |
| `market_reach_probability` | decimal | The model probability of that market reach, 0 to 1. |
| `paid_capital_try` | decimal | Paid-in (issued) capital in Turkish lira; one share is 1 TRY nominal, so this is also the share count. |
| `shares_outstanding` | decimal | Shares outstanding, taken as the paid-in capital at 1 TRY nominal per share. |
| `registered_capital_ceiling_try` | decimal | Registered capital ceiling in Turkish lira, up to which the board may issue shares without a shareholder vote; empty outside the registered capital system. |
| `traded_shares` | decimal | Shares of this code that trade on Borsa Istanbul. |
| `free_float_shares` | decimal | Shares of this code in actual free float, after holdings of 5% or more and other exclusions. |
| `free_float_pct` | decimal | Actual free float as a percentage of this code's shares, such as 49.06. |
| `major_holders` | string | Every holder of 5% or more of the capital, largest first, comma separated. |
| `largest_holder` | string | The largest shareholder KAP reports, such as a holding company, a family or the Turkey Wealth Fund. |
| `largest_holder_pct` | decimal | The largest holder's share of capital, percent. |
| `major_holder_count` | integer | How many holders of 5% or more the company reports. |
| `price_date` | date | Trading day of the latest Borsa Istanbul price. |
| `price` | decimal | Latest closing price in Turkish lira, the stock price. |
| `price_usd` | decimal | Latest closing price in US dollars at that day's ECB rate. |
| `price_change_1d_pct` | decimal | Price change on the latest trading day, percent; daily gain or loss. |
| `volume` | integer | Shares traded on the latest trading day. |
| `is_suspended` | boolean | True when trading was halted on the latest day. |
| `market_cap_try` | decimal | Market capitalization in Turkish lira: latest price times shares outstanding. |
| `market_cap_usd` | decimal | Market capitalization (market value, company size) in US dollars at the latest ECB rate. |
| `market_cap_size` | string | Size bucket by market cap in US dollars: large (5B+), mid (1B to 5B), small (200M to 1B), micro (under 200M). |
| `free_float_market_cap_usd` | decimal | Market value of the free float in US dollars. |
| `price_return_1w_pct` | decimal | Price return over the last week, 5 trading days, percent, on adjusted closes. |
| `price_return_1m_pct` | decimal | Price return over the last month, percent. |
| `price_return_3m_pct` | decimal | Price return over the last 3 months, a quarter, percent. |
| `price_return_6m_pct` | decimal | Price return over the last 6 months, percent. |
| `price_return_ytd_pct` | decimal | Price return year to date (YTD), since the last close of the previous calendar year, percent. |
| `price_return_1y_pct` | decimal | Price return over the last year, 12 months, percent, in lira. |
| `price_return_3y_pct` | decimal | Price return over the last 3 years, percent, in lira. |
| `price_return_5y_pct` | decimal | Price return over the last 5 years, percent, in lira. |
| `price_return_1m_usd_pct` | decimal | Price return over the last month in US dollars, percent. |
| `price_return_1y_usd_pct` | decimal | Price return over the last year in US dollars, percent: what a dollar investor made, net of the lira's fall. |
| `price_return_3y_usd_pct` | decimal | Price return over the last 3 years in US dollars, percent. |
| `price_return_5y_usd_pct` | decimal | Price return over the last 5 years in US dollars, percent. |
| `volatility_30d_pct` | decimal | Annualized volatility of daily returns over the last 30 days, percent. |
| `volatility_90d_pct` | decimal | Annualized volatility of daily returns over the last 90 days, percent. |
| `volatility_1y_pct` | decimal | Annualized volatility of daily returns over the last year, percent; risk. |
| `max_drawdown_1y_pct` | decimal | Maximum drawdown over the last year: the deepest fall from a peak, percent, zero or negative. |
| `max_drawdown_3y_pct` | decimal | Maximum drawdown over the last 3 years, percent. |
| `max_drawdown_all_pct` | decimal | Maximum drawdown since 2016, the worst crash from a peak, percent. |
| `high_52w` | decimal | 52-week high in lira, adjusted. |
| `low_52w` | decimal | 52-week low in lira, adjusted. |
| `pct_from_52w_high` | decimal | Percent below the 52-week high; 0 means at the high. |
| `pct_above_52w_low` | decimal | Percent above the 52-week low; 0 means at the low. |
| `all_time_high` | decimal | All-time high adjusted close since 2016, lira. |
| `all_time_high_date` | date | Date of the all-time high since 2016. |
| `pct_from_all_time_high` | decimal | Percent below the all-time high in lira; 0 means at a record. |
| `pct_from_all_time_high_usd` | decimal | Percent below the all-time high measured in US dollars. |
| `sma_50` | decimal | 50-day simple moving average, lira. |
| `sma_200` | decimal | 200-day simple moving average, lira. |
| `above_sma_50` | boolean | True when the price is above its 50-day moving average. |
| `above_sma_200` | boolean | True when the price is above its 200-day moving average, a long-term uptrend. |
| `pct_vs_sma_200` | decimal | Percent the price sits above or below its 200-day moving average. |
| `ma_cross` | string | golden when the 50-day moving average is above the 200-day, death when below. |
| `rsi_14` | decimal | Relative strength index (RSI), 14 days, 0 to 100; under 30 oversold, over 70 overbought. |
| `macd_histogram` | decimal | MACD line minus its signal line; positive is bullish momentum. |
| `avg_volume_20d` | decimal | Average shares traded per day over the last 20 trading days. |
| `avg_value_traded_20d_try` | decimal | Average lira traded per day over the last 20 trading days; liquidity, turnover. |
| `avg_value_traded_90d_usd` | decimal | Average US dollars traded per day over the last 90 days. |
| `relative_volume` | decimal | Latest day's volume divided by the 20-day average; above 2 is unusual volume. |
| `history_start_date` | date | First trading day in the price series (2016 at the earliest). |
| `trading_days` | integer | Trading days in the price series since 2016. |
| `eps_ttm_try` | decimal | Earnings per share in lira: trailing net income over shares outstanding, else the latest fiscal-year estimate. |
| `pe_ratio` | decimal | Price to earnings: price over earnings per share; empty when earnings are not positive. |
| `ps_ratio` | decimal | Price to sales: market capitalization over revenue. |
| `pb_ratio` | decimal | Price to book: market capitalization over equity; empty when equity is not positive. |
| `ev_to_ebitda` | decimal | Enterprise value over fiscal-year EBITDA; empty when EBITDA is not positive or debt is not reported. |
| `enterprise_value_usd` | decimal | Enterprise value in US dollars: market cap plus debt minus cash and investments. |
| `earnings_yield_pct` | decimal | Net income as a percent of market capitalization. |
| `fcf_yield_pct` | decimal | Latest fiscal-year free cash flow as a percent of market capitalization. |
| `dividend_yield_pct` | decimal | Gross cash dividends per share over the last twelve months as a percent of the latest price. |
| `statement_template` | string | KAP financial statement template: general, bank, insurance or another financial template. |
| `statement_basis` | string | Whether the figures are consolidated (group) or solo. |
| `fiscal_year` | integer | Latest fiscal year with an annual KAP financial report. |
| `fiscal_year_end_date` | date | End of the latest fiscal year. |
| `ias29_restated` | boolean | True when the latest annual report restates for inflation under IAS 29, so its lira figures are in year-end purchasing power. |
| `revenue_try` | decimal | Revenue (sales, turnover) over the trailing twelve months in Turkish lira; the latest fiscal year when no trailing figure exists. |
| `revenue_usd` | decimal | Revenue over the trailing twelve months, or the latest fiscal year, converted to US dollars at the latest ECB USD/TRY rate. |
| `net_income_try` | decimal | Net income (earnings, profit) to the parent over the trailing twelve months in Turkish lira; the latest fiscal year when no trailing figure exists. |
| `net_income_usd` | decimal | Net income over the trailing twelve months, or the latest fiscal year, in US dollars at the latest ECB rate. |
| `fiscal_year_revenue_try` | decimal | Revenue for the latest fiscal year, Turkish lira. |
| `fiscal_year_net_income_try` | decimal | Net income to the parent for the latest fiscal year, Turkish lira. |
| `gross_profit_try` | decimal | Gross profit for the latest fiscal year, Turkish lira. |
| `operating_income_try` | decimal | Operating income (EBIT) for the latest fiscal year, Turkish lira. |
| `ebitda_try` | decimal | EBITDA for the latest fiscal year: operating income plus depreciation and amortisation, Turkish lira. |
| `ebitda_usd` | decimal | EBITDA for the latest fiscal year in US dollars at the latest ECB rate. |
| `depreciation_amortization_try` | decimal | Depreciation and amortisation for the latest fiscal year, Turkish lira. |
| `interest_expense_try` | decimal | Interest expense for the latest fiscal year, Turkish lira. |
| `net_interest_income_try` | decimal | Net interest income for the latest fiscal year, Turkish lira; banks only. |
| `income_tax_try` | decimal | Income tax expense for the latest fiscal year, Turkish lira. |
| `operating_cash_flow_try` | decimal | Net cash from operating activities for the latest fiscal year, Turkish lira. |
| `capex_try` | decimal | Capital expenditure for the latest fiscal year, Turkish lira. |
| `free_cash_flow_try` | decimal | Free cash flow for the latest fiscal year: operating cash flow minus capital expenditure, Turkish lira. |
| `free_cash_flow_usd` | decimal | Free cash flow for the latest fiscal year in US dollars at the latest ECB rate. |
| `dividends_paid_try` | decimal | Cash dividends paid in the latest fiscal year, Turkish lira. |
| `buybacks_try` | decimal | Share buybacks in the latest fiscal year, Turkish lira. |
| `eps_try` | decimal | Estimated earnings per share for the latest fiscal year, Turkish lira: net income over shares at 1 TRY nominal. |
| `revenue_growth_pct` | decimal | Fiscal-year revenue growth over the year before in lira, percent; nominal, so it carries Turkish inflation. |
| `earnings_growth_pct` | decimal | Fiscal-year net income growth over the year before in lira, percent. |
| `gross_margin_pct` | decimal | Gross profit as a percent of fiscal-year revenue. |
| `operating_margin_pct` | decimal | Operating income as a percent of fiscal-year revenue. |
| `ebitda_margin_pct` | decimal | EBITDA as a percent of fiscal-year revenue. |
| `profit_margin_pct` | decimal | Net income as a percent of revenue over the trailing twelve months, or the latest fiscal year. |
| `fcf_margin_pct` | decimal | Free cash flow as a percent of fiscal-year revenue. |
| `is_profitable` | boolean | True when trailing, or latest fiscal-year, net income is positive. |
| `pays_dividend` | boolean | True when the company paid a cash dividend in the latest fiscal year or had a cash dividend ex-date in the last twelve months. |
| `latest_quarter` | string | Latest quarter frame reported, such as CY2026Q2. |
| `quarter_end_date` | date | End of the latest quarter reported. |
| `quarterly_revenue_try` | decimal | Revenue in the latest quarter, Turkish lira. |
| `quarterly_net_income_try` | decimal | Net income in the latest quarter, Turkish lira. |
| `quarterly_revenue_growth_pct` | decimal | Latest-quarter revenue growth on the same quarter a year earlier, percent. |
| `quarterly_earnings_growth_pct` | decimal | Latest-quarter net income growth on the same quarter a year earlier, percent. |
| `revenue_ttm_try` | decimal | Trailing twelve months revenue, Turkish lira; empty when a report in the span restates for inflation. |
| `net_income_ttm_try` | decimal | Trailing twelve months net income, Turkish lira, under the same rule. |
| `latest_report_url` | string | The KAP financial report behind the latest quarter. |
| `balance_sheet_date` | date | Date of the latest balance sheet the cash, debt, assets and equity figures come from. |
| `total_assets_try` | decimal | Total assets on the latest balance sheet, Turkish lira. |
| `total_assets_usd` | decimal | Total assets in US dollars at the latest ECB rate: company size for banks and holdings. |
| `total_liabilities_try` | decimal | Total liabilities on the latest balance sheet, Turkish lira. |
| `book_value_try` | decimal | Equity attributable to owners of the parent (book value, shareholders' funds) on the latest balance sheet, Turkish lira. |
| `book_value_usd` | decimal | Equity attributable to owners of the parent in US dollars at the latest ECB rate. |
| `book_value_per_share_try` | decimal | Book value per share, Turkish lira: equity over shares at 1 TRY nominal. |
| `cash_try` | decimal | Cash and cash equivalents on the latest balance sheet, Turkish lira. |
| `short_term_investments_try` | decimal | Current financial investments on the latest balance sheet, Turkish lira. |
| `long_term_investments_try` | decimal | Non-current financial investments on the latest balance sheet, Turkish lira. |
| `cash_and_investments_try` | decimal | Cash plus short-term investments on the latest balance sheet, Turkish lira: the cash pile. |
| `cash_and_investments_usd` | decimal | Cash plus short-term investments in US dollars at the latest ECB rate. |
| `total_debt_try` | decimal | Financial debt on the latest balance sheet, Turkish lira; for banks funds borrowed, securities issued and subordinated debt, deposits excluded. |
| `total_debt_usd` | decimal | Financial debt in US dollars at the latest ECB rate. |
| `long_term_debt_try` | decimal | Long-term borrowings, lease liabilities included, Turkish lira. |
| `current_debt_try` | decimal | Short-term borrowings plus the current portion of long-term borrowings, Turkish lira. |
| `net_cash_try` | decimal | Cash plus short-term investments minus financial debt, Turkish lira; negative means net debt. |
| `net_cash_usd` | decimal | Net cash in US dollars at the latest ECB rate; negative means net debt. |
| `current_assets_try` | decimal | Current assets on the latest balance sheet, Turkish lira. |
| `current_liabilities_try` | decimal | Current liabilities on the latest balance sheet, Turkish lira. |
| `inventory_try` | decimal | Inventories on the latest balance sheet, Turkish lira. |
| `goodwill_try` | decimal | Goodwill on the latest balance sheet, Turkish lira. |
| `loans_try` | decimal | Loans to customers, Turkish lira; banks only. |
| `deposits_try` | decimal | Customer and bank deposits, Turkish lira; banks only. |
| `debt_to_equity` | decimal | Financial debt divided by equity (leverage); empty when debt is not reported or equity is not positive. |
| `debt_to_assets` | decimal | Financial debt divided by total assets. |
| `current_ratio` | decimal | Current assets divided by current liabilities (liquidity). |
| `roe_pct` | decimal | Return on equity: trailing net income over equity, percent. |
| `roa_pct` | decimal | Return on assets: trailing net income over total assets, percent. |
| `fx_usd_try` | decimal | The ECB USD/TRY rate every US dollar column uses, lira per dollar. |
| `fx_date` | date | The date of that ECB rate. |
| `first_fiscal_year` | integer | First fiscal year with KAP XBRL fundamentals in this dataset (2016 at the earliest). |
| `fiscal_years_reported` | integer | Fiscal years with annual fundamentals in this dataset. |
| `ias29_years` | integer | Fiscal years whose annual report restates for inflation under IAS 29. |
| `revenue_cagr_3y_pct` | decimal | Compound annual revenue growth over the last three fiscal years in lira, percent; nominal, inflation included. |
| `revenue_cagr_5y_pct` | decimal | Compound annual revenue growth over the last five fiscal years in lira, percent; nominal. |
| `revenue_cagr_3y_usd_pct` | decimal | Compound annual revenue growth over the last three fiscal years in US dollars, percent: the inflation-neutral growth measure. |
| `revenue_cagr_5y_usd_pct` | decimal | Compound annual revenue growth over the last five fiscal years in US dollars, percent. |
| `net_income_cagr_5y_pct` | decimal | Compound annual net income growth over the last five fiscal years in lira, percent; only when both years were profitable. |
| `net_income_cagr_3y_usd_pct` | decimal | Compound annual net income growth over the last three fiscal years in US dollars, percent. |
| `net_income_cagr_5y_usd_pct` | decimal | Compound annual net income growth over the last five fiscal years in US dollars, percent. |
| `revenue_5y_ago_usd` | decimal | Revenue five fiscal years before the latest, US dollars at that year's average rate. |
| `revenue_latest_fy_usd` | decimal | Revenue of the latest fiscal year, US dollars at that year's average rate (year-end rate when IAS 29 restated). |
| `consecutive_revenue_growth_years` | integer | Fiscal years in a row, ending with the latest, in which lira revenue grew. |
| `consecutive_revenue_growth_years_usd` | integer | Fiscal years in a row, ending with the latest, in which US dollar revenue grew. |
| `consecutive_profitable_years` | integer | Fiscal years in a row, ending with the latest, with positive net income to the parent. |
| `profitable_years_5y` | integer | Fiscal years with positive net income among the last five reported. |
| `profitable_years_10y` | integer | Fiscal years with positive net income among the last ten reported. |
| `dividend_years_5y` | integer | Fiscal years with cash dividends paid among the last five reported. |
| `dividend_years_10y` | integer | Fiscal years with cash dividends paid among the last ten reported. |
| `buyback_years_10y` | integer | Fiscal years with share buybacks among the last ten reported. |
| `cumulative_fcf_5y_usd` | decimal | Free cash flow summed over the last five fiscal years, US dollars. |
| `cumulative_dividends_5y_usd` | decimal | Dividends paid summed over the last five fiscal years, US dollars. |
| `cumulative_buybacks_5y_usd` | decimal | Share buybacks summed over the last five fiscal years, US dollars. |
| `last_dividend_ex_date` | date | Ex-date of the last cash dividend on Borsa Istanbul. |
| `last_dividend_gross_try` | decimal | Gross cash dividend per share of 1 TRY nominal at that last ex-date, Turkish lira. |
| `last_dividend_net_try` | decimal | Net cash dividend per share after withholding tax at that last ex-date, Turkish lira. |
| `dividends_per_share_12m_try` | decimal | Gross cash dividends per share over the twelve months before the newest ex-date in the corporate actions table, Turkish lira. |
| `dividend_payments_12m` | integer | Cash dividend ex-dates in those twelve months. |
| `dividend_payments_5y` | integer | Cash dividend ex-dates in the last five years. |
| `last_bonus_ex_date` | date | Ex-date of the last bonus share issue (bedelsiz). |
| `last_bonus_pct` | decimal | Bonus shares per 100 held at that last bonus issue, percent. |
| `bonus_issues_5y` | integer | Bonus share issues in the last five years. |
| `last_rights_ex_date` | date | Ex-date of the last rights issue (bedelli). |
| `last_rights_pct` | decimal | New shares per 100 held at that last rights issue, percent. |
| `last_rights_price_try` | decimal | Subscription price per new share at that last rights issue, Turkish lira. |
| `rights_issues_5y` | integer | Rights issues in the last five years. |
| `capital_reductions_5y` | integer | Capital reductions in the last five years. |
| `corporate_actions_total` | integer | Corporate actions on Borsa Istanbul in this dataset. |
| `last_action_url` | string | The Borsa Istanbul notice on KAP behind the company's latest corporate action. |
| `disclosures_total` | integer | KAP disclosures the company published since November 2009. |
| `disclosures_12m` | integer | KAP disclosures in the last twelve months. |
| `material_events_12m` | integer | Material event disclosures (Özel Durum Açıklaması) in the last twelve months. |
| `financial_reports_12m` | integer | Financial reports filed in the last twelve months. |
| `insider_transactions_12m` | integer | Insider, board and major-holder share transaction notices in the last twelve months. |
| `buyback_disclosures_12m` | integer | Share buyback notices in the last twelve months. |
| `dividend_disclosures_12m` | integer | Dividend notices in the last twelve months. |
| `capital_increase_disclosures_12m` | integer | Capital increase or decrease notices in the last twelve months. |
| `contract_disclosures_12m` | integer | New business, tender and contract notices in the last twelve months. |
| `lawsuit_disclosures_12m` | integer | Notices of lawsuits against the company in the last twelve months. |
| `unusual_price_movement_disclosures_12m` | integer | Answers to the exchange on unusual price and volume moves in the last twelve months. |
| `late_disclosures_12m` | integer | Disclosures KAP flags as filed late in the last twelve months. |
| `english_disclosures_12m` | integer | Disclosures also published in English in the last twelve months. |
| `circuit_breaker_halts_12m` | integer | Single-stock circuit breaker notices in the last twelve months. |
| `spk_measures_12m` | integer | Capital Markets Board (SPK) measure decisions about the share, such as trading restrictions, in the last twelve months. |
| `first_disclosure_at` | timestamp_utc | When the company published its first KAP disclosure in this dataset, UTC; a proxy for how long it has been listed. |
| `latest_disclosure_at` | timestamp_utc | When the company published its latest KAP disclosure, UTC. |
| `latest_disclosure_subject` | string | Subject of the latest disclosure, in Turkish. |
| `latest_disclosure_url` | string | Link to the latest disclosure on kap.org.tr. |
| `latest_material_event_at` | timestamp_utc | When it published its latest material event disclosure, UTC. |
| `latest_material_event_subject` | string | Subject of the latest material event disclosure, in Turkish. |
| `latest_financial_report_at` | timestamp_utc | When it published its latest financial report, UTC. |
| `latest_financial_report_period` | string | Year and period of the latest financial report, such as 2026 9 Aylık (nine months). |
| `latest_insider_transaction_at` | timestamp_utc | When it published its latest insider share transaction notice, UTC. |
| `latest_dividend_disclosure_at` | timestamp_utc | When it published its latest dividend notice, UTC. |
| `latest_general_assembly_at` | timestamp_utc | When it published its latest general assembly notice, UTC. |
| `latest_spk_measure_at` | timestamp_utc | When SPK last published a measure decision about the share, UTC. |
| `activity_as_of` | timestamp_utc | The newest disclosure in the dataset; the twelve-month counts end here. |
| `latest_annual_report_year` | integer | Fiscal year of the latest annual activity report (Faaliyet Raporu) on KAP. |
| `latest_annual_report_kind` | string | KAP subject of that report: Faaliyet Raporu (Konsolide), Faaliyet Raporu (Konsolide Olmayan) or Entegre Rapor. |
| `latest_annual_report_at` | timestamp_utc | When KAP published that report, UTC. |
| `latest_annual_report_url` | string | Link to that report's disclosure on kap.org.tr. |
| `latest_annual_report_pdf` | string | KAP download address of that report's PDF attachment. |
| `latest_annual_report_english_pdf` | string | KAP download address of the English version, when the company filed one. |
| `search_text` | string | Share codes, company name, sector and industry in Turkish and English, activity, market, indices, city, auditor and major holders folded into one lowercase col… |

## Table: source_fundamentals_facts_2018

- Table id: `9541a641-0ec1-4f70-b2da-8db2553fc31e`
- Slug: `source-fundamentals-facts-2018`
- Immutable version: `b8d43421-272c-534c-a511-0f8e04f49165`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/9541a641-0ec1-4f70-b2da-8db2553fc31e/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/9541a641-0ec1-4f70-b2da-8db2553fc31e/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/9541a641-0ec1-4f70-b2da-8db2553fc31e/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/9541a641-0ec1-4f70-b2da-8db2553fc31e/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (29)

| Column | Type | Description |
| --- | --- | --- |
| `disclosure_index` | integer | KAP disclosure index of the financial report. |
| `kap_role` | integer | KAP taxonomy role of the statement table, such as 210015 (balance sheet), 310003 (income statement) or 520003 (cash flow). |
| `line_no` | integer | Position of the line inside its statement table, as KAP renders it. |
| `mkk_member_oid` | string | KAP's stable company identifier (MKK member OID). |
| `ticker` | string | First Borsa Istanbul stock code of the filer. |
| `tickers_all` | string | Every stock code of the filer, comma separated, as KAP lists them. |
| `company_name` | string | Filer's name on KAP. |
| `fiscal_year` | integer | Fiscal year the report covers. |
| `fiscal_period` | integer | Fiscal period the report covers: 1 = three months, 2 = six months, 3 = nine months, 4 = full year. |
| `published_at` | timestamp_utc | When KAP published the report, UTC (Istanbul is UTC+3). |
| `statement_basis` | string | consolidated or solo (KAP ftNiteligi CS or NC). |
| `template` | string | KAP statement template: general, banks, finance (leasing, factoring) or insurance. |
| `statement` | string | balance_sheet, income_statement or cash_flow. |
| `concept` | string | XBRL concept of the line, ifrs-full_* or kap-fr_* (KAP's Turkish extension). |
| `label_role` | string | XBRL label role of the line, such as totalLabel or periodEndLabel; tells apart a concept used twice in one table. |
| `period_start` | date | First day of the current period of a flow statement (income statement, cash flow). |
| `period_end` | date | Last day of the current period, the balance sheet date for a balance sheet. |
| `prior_period_end` | date | Last day of the comparative period in the same report. |
| `currency` | string | Presentation currency, TL for nearly every filer. |
| `unit_multiplier` | integer | Presentation unit the report used, 1, 1000 or 1000000; values below are already multiplied out. |
| `value` | decimal | Current-period value in whole currency units: period end for the balance sheet, year to date for flows. Signs as KAP presents them: expenses and outflows are n… |
| `value_prior` | decimal | Comparative-period value in the same report. From fiscal 2023 most non-financial filers restate it into current purchasing power (IAS 29). |
| `value_3m` | decimal | Current three-month value, for interim income statements that carry one. |
| `value_prior_3m` | decimal | Comparative three-month value, for interim income statements that carry one. |
| `audit_type` | string | KAP audit type of the report. |
| `auditor` | string | Audit firm that signed the report, when named. |
| `kap_url` | string | Link to the disclosure on kap.org.tr. |
| `fetched_at` | timestamp_utc | When the report was fetched from KAP. |
| `window_start` | string | KAP listing day the report was listed under in kap_disclosures. |

## Table: source_stock_screener

- Table id: `c9342f43-5ffa-4155-819f-a92b6ee0a22d`
- Slug: `source-stock-screener`
- Immutable version: `86977678-ebfd-5d34-879c-428f467ee1bd`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/c9342f43-5ffa-4155-819f-a92b6ee0a22d/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/c9342f43-5ffa-4155-819f-a92b6ee0a22d/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/c9342f43-5ffa-4155-819f-a92b6ee0a22d/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/c9342f43-5ffa-4155-819f-a92b6ee0a22d/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (73)

| Column | Type | Description |
| --- | --- | --- |
| `symbol` | string | Borsa Istanbul share code (ticker), such as THYAO. |
| `company_name` | string | The company's title on KAP. |
| `security_name` | string | The share's short name in the bulletin. |
| `market_segment` | string | The Borsa Istanbul equity market the share traded on at the latest price. |
| `price_date` | date | Trading day of the latest price. |
| `price` | decimal | Latest closing price in Turkish lira, the stock price. |
| `price_usd` | decimal | Latest closing price in US dollars at that day's ECB rate. |
| `price_change_1d_pct` | decimal | Price change on the latest trading day against the day before, percent; daily gain or loss. |
| `volume` | integer | Shares traded on the latest trading day. |
| `value_traded_try` | decimal | Lira traded on the latest trading day. |
| `is_suspended` | boolean | True when trading was halted on the latest day. |
| `in_bist30` | boolean | True when the share was in the BIST 30 on the latest day. |
| `in_bist100` | boolean | True when the share was in the BIST 100 on the latest day. |
| `shares_outstanding` | decimal | Shares of this share code (its class), at 1 TRY nominal per share; the company's paid-in capital when KAP lists no class count. |
| `market_cap_try` | decimal | Market value of this share code in Turkish lira: latest price times its class's shares; a company with several classes sums them. |
| `market_cap_usd` | decimal | Market capitalization (market value, company size) in US dollars at the latest ECB rate. |
| `market_cap_size` | string | Size bucket by market cap in US dollars: large (5B+), mid (1B to 5B), small (200M to 1B), micro (under 200M). |
| `free_float_market_cap_usd` | decimal | Market value of the free float in US dollars. |
| `free_float_pct` | decimal | Actual free float as a percent of the shares. |
| `price_return_1w_pct` | decimal | Price return over the last 5 trading days, one week, percent, on adjusted closes. |
| `price_return_1m_pct` | decimal | Price return over the last 21 trading days, one month, percent. |
| `price_return_3m_pct` | decimal | Price return over the last 63 trading days, a quarter, percent. |
| `price_return_6m_pct` | decimal | Price return over the last 126 trading days, half a year, percent. |
| `price_return_ytd_pct` | decimal | Price return year to date (YTD), since the last close of the previous calendar year, percent. |
| `price_return_1y_pct` | decimal | Price return over the last 252 trading days, one year, percent, in lira. |
| `price_return_3y_pct` | decimal | Price return over the last 3 years, percent, in lira. |
| `price_return_5y_pct` | decimal | Price return over the last 5 years, percent, in lira. |
| `price_return_1m_usd_pct` | decimal | Price return over the last month in US dollars, percent. |
| `price_return_1y_usd_pct` | decimal | Price return over the last year in US dollars, percent: the return a dollar investor saw, net of the lira's fall. |
| `price_return_3y_usd_pct` | decimal | Price return over the last 3 years in US dollars, percent. |
| `price_return_5y_usd_pct` | decimal | Price return over the last 5 years in US dollars, percent. |
| `volatility_30d_pct` | decimal | Annualized volatility of daily returns over the last 20 trading days, percent. |
| `volatility_90d_pct` | decimal | Annualized volatility of daily returns over the last 63 trading days, percent. |
| `volatility_1y_pct` | decimal | Annualized volatility of daily returns over the last 252 trading days, percent; risk. |
| `max_drawdown_1y_pct` | decimal | Maximum drawdown over the last year: the deepest fall from a trailing peak, percent, zero or negative. |
| `max_drawdown_3y_pct` | decimal | Maximum drawdown over the last 3 years, percent, zero or negative. |
| `max_drawdown_all_pct` | decimal | Maximum drawdown over all history since 2016, the worst crash from a peak, percent. |
| `high_52w` | decimal | 52-week high: highest adjusted price over the last year, lira. |
| `low_52w` | decimal | 52-week low: lowest adjusted price over the last year, lira. |
| `pct_from_52w_high` | decimal | Percent below the 52-week high; 0 means at the high. |
| `pct_above_52w_low` | decimal | Percent above the 52-week low; 0 means at the low. |
| `all_time_high` | decimal | All-time high adjusted close since 2016, lira (ATH). |
| `all_time_high_date` | date | Date of the all-time high since 2016. |
| `pct_from_all_time_high` | decimal | Percent below the all-time high; 0 means at a record. |
| `pct_from_all_time_high_usd` | decimal | Percent below the all-time high measured in US dollars. |
| `sma_20` | decimal | 20-day simple moving average of the adjusted close, lira. |
| `sma_50` | decimal | 50-day simple moving average, lira. |
| `sma_200` | decimal | 200-day simple moving average, lira. |
| `above_sma_20` | boolean | True when the price is above its 20-day moving average. |
| `above_sma_50` | boolean | True when the price is above its 50-day moving average. |
| `above_sma_200` | boolean | True when the price is above its 200-day moving average, a long-term uptrend. |
| `pct_vs_sma_200` | decimal | Percent the price sits above or below its 200-day moving average. |
| `ma_cross` | string | golden when the 50-day moving average is above the 200-day, death when below. |
| `rsi_14` | decimal | Relative strength index (RSI), 14 days, 0 to 100; under 30 oversold, over 70 overbought. |
| `macd_histogram` | decimal | MACD line minus its signal line; positive is bullish momentum. |
| `avg_volume_20d` | decimal | Average shares traded per day over the last 20 trading days. |
| `avg_volume_90d` | decimal | Average shares traded per day over the last 63 trading days. |
| `avg_value_traded_20d_try` | decimal | Average lira traded per day over the last 20 trading days; liquidity, turnover. |
| `avg_value_traded_90d_usd` | decimal | Average US dollars traded per day over the last 63 trading days at the latest rate. |
| `relative_volume` | decimal | Latest day's volume divided by the 20-day average; above 2 is unusual volume. |
| `history_start_date` | date | First trading day in the price series (2016 at the earliest). |
| `trading_days` | integer | Trading days in the price series. |
| `eps_try` | decimal | Earnings per share, lira: trailing net income over shares when available, else the latest fiscal year estimate. |
| `pe_ratio` | decimal | Price to earnings: price over earnings per share; empty when earnings are not positive. |
| `ps_ratio` | decimal | Price to sales: market capitalization over trailing or latest fiscal-year revenue. |
| `pb_ratio` | decimal | Price to book: market capitalization over equity; empty when equity is not positive. |
| `ev_to_ebitda` | decimal | Enterprise value (market cap plus debt minus cash and investments) over fiscal-year EBITDA; empty when EBITDA is not positive or debt is not reported. |
| `enterprise_value_usd` | decimal | Enterprise value in US dollars: market cap plus debt minus cash and investments; empty when debt is not reported. |
| `earnings_yield_pct` | decimal | Trailing or latest fiscal-year net income as a percent of market capitalization. |
| `fcf_yield_pct` | decimal | Latest fiscal-year free cash flow as a percent of market capitalization. |
| `dividend_yield_pct` | decimal | Gross cash dividends per share over the last twelve months as a percent of the latest price. |
| `dividends_per_share_12m_try` | decimal | Gross cash dividends per share of 1 TRY nominal over the last twelve months, lira. |
| `fx_usd_try` | decimal | The ECB USD/TRY rate on the latest price day, lira per dollar. |

## Table: source_fundamentals_facts_2016

- Table id: `eef3472e-c207-47ad-b639-0fd6632d96a4`
- Slug: `source-fundamentals-facts-2016`
- Immutable version: `b1dbe955-b6b8-581c-bec6-61c28147117a`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/eef3472e-c207-47ad-b639-0fd6632d96a4/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/eef3472e-c207-47ad-b639-0fd6632d96a4/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/eef3472e-c207-47ad-b639-0fd6632d96a4/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/eef3472e-c207-47ad-b639-0fd6632d96a4/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (29)

| Column | Type | Description |
| --- | --- | --- |
| `disclosure_index` | integer | KAP disclosure index of the financial report. |
| `kap_role` | integer | KAP taxonomy role of the statement table, such as 210015 (balance sheet), 310003 (income statement) or 520003 (cash flow). |
| `line_no` | integer | Position of the line inside its statement table, as KAP renders it. |
| `mkk_member_oid` | string | KAP's stable company identifier (MKK member OID). |
| `ticker` | string | First Borsa Istanbul stock code of the filer. |
| `tickers_all` | string | Every stock code of the filer, comma separated, as KAP lists them. |
| `company_name` | string | Filer's name on KAP. |
| `fiscal_year` | integer | Fiscal year the report covers. |
| `fiscal_period` | integer | Fiscal period the report covers: 1 = three months, 2 = six months, 3 = nine months, 4 = full year. |
| `published_at` | timestamp_utc | When KAP published the report, UTC (Istanbul is UTC+3). |
| `statement_basis` | string | consolidated or solo (KAP ftNiteligi CS or NC). |
| `template` | string | KAP statement template: general, banks, finance (leasing, factoring) or insurance. |
| `statement` | string | balance_sheet, income_statement or cash_flow. |
| `concept` | string | XBRL concept of the line, ifrs-full_* or kap-fr_* (KAP's Turkish extension). |
| `label_role` | string | XBRL label role of the line, such as totalLabel or periodEndLabel; tells apart a concept used twice in one table. |
| `period_start` | date | First day of the current period of a flow statement (income statement, cash flow). |
| `period_end` | date | Last day of the current period, the balance sheet date for a balance sheet. |
| `prior_period_end` | date | Last day of the comparative period in the same report. |
| `currency` | string | Presentation currency, TL for nearly every filer. |
| `unit_multiplier` | integer | Presentation unit the report used, 1, 1000 or 1000000; values below are already multiplied out. |
| `value` | decimal | Current-period value in whole currency units: period end for the balance sheet, year to date for flows. Signs as KAP presents them: expenses and outflows are n… |
| `value_prior` | decimal | Comparative-period value in the same report. From fiscal 2023 most non-financial filers restate it into current purchasing power (IAS 29). |
| `value_3m` | decimal | Current three-month value, for interim income statements that carry one. |
| `value_prior_3m` | decimal | Comparative three-month value, for interim income statements that carry one. |
| `audit_type` | string | KAP audit type of the report. |
| `auditor` | string | Audit firm that signed the report, when named. |
| `kap_url` | string | Link to the disclosure on kap.org.tr. |
| `fetched_at` | timestamp_utc | When the report was fetched from KAP. |
| `window_start` | string | KAP listing day the report was listed under in kap_disclosures. |

## Table: source_fundamentals_facts_2025

- Table id: `ab9cd2d7-b6f7-4722-9834-cbb12150ef92`
- Slug: `source-fundamentals-facts-2025`
- Immutable version: `a5b4b2ef-cbd8-511a-9e4a-c3599e4d32ee`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/ab9cd2d7-b6f7-4722-9834-cbb12150ef92/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/ab9cd2d7-b6f7-4722-9834-cbb12150ef92/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/ab9cd2d7-b6f7-4722-9834-cbb12150ef92/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/ab9cd2d7-b6f7-4722-9834-cbb12150ef92/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (29)

| Column | Type | Description |
| --- | --- | --- |
| `disclosure_index` | integer | KAP disclosure index of the financial report. |
| `kap_role` | integer | KAP taxonomy role of the statement table, such as 210015 (balance sheet), 310003 (income statement) or 520003 (cash flow). |
| `line_no` | integer | Position of the line inside its statement table, as KAP renders it. |
| `mkk_member_oid` | string | KAP's stable company identifier (MKK member OID). |
| `ticker` | string | First Borsa Istanbul stock code of the filer. |
| `tickers_all` | string | Every stock code of the filer, comma separated, as KAP lists them. |
| `company_name` | string | Filer's name on KAP. |
| `fiscal_year` | integer | Fiscal year the report covers. |
| `fiscal_period` | integer | Fiscal period the report covers: 1 = three months, 2 = six months, 3 = nine months, 4 = full year. |
| `published_at` | timestamp_utc | When KAP published the report, UTC (Istanbul is UTC+3). |
| `statement_basis` | string | consolidated or solo (KAP ftNiteligi CS or NC). |
| `template` | string | KAP statement template: general, banks, finance (leasing, factoring) or insurance. |
| `statement` | string | balance_sheet, income_statement or cash_flow. |
| `concept` | string | XBRL concept of the line, ifrs-full_* or kap-fr_* (KAP's Turkish extension). |
| `label_role` | string | XBRL label role of the line, such as totalLabel or periodEndLabel; tells apart a concept used twice in one table. |
| `period_start` | date | First day of the current period of a flow statement (income statement, cash flow). |
| `period_end` | date | Last day of the current period, the balance sheet date for a balance sheet. |
| `prior_period_end` | date | Last day of the comparative period in the same report. |
| `currency` | string | Presentation currency, TL for nearly every filer. |
| `unit_multiplier` | integer | Presentation unit the report used, 1, 1000 or 1000000; values below are already multiplied out. |
| `value` | decimal | Current-period value in whole currency units: period end for the balance sheet, year to date for flows. Signs as KAP presents them: expenses and outflows are n… |
| `value_prior` | decimal | Comparative-period value in the same report. From fiscal 2023 most non-financial filers restate it into current purchasing power (IAS 29). |
| `value_3m` | decimal | Current three-month value, for interim income statements that carry one. |
| `value_prior_3m` | decimal | Comparative three-month value, for interim income statements that carry one. |
| `audit_type` | string | KAP audit type of the report. |
| `auditor` | string | Audit firm that signed the report, when named. |
| `kap_url` | string | Link to the disclosure on kap.org.tr. |
| `fetched_at` | timestamp_utc | When the report was fetched from KAP. |
| `window_start` | string | KAP listing day the report was listed under in kap_disclosures. |

## Table: source_company_profiles

- Table id: `38647174-353f-4b1f-821e-cbbb30fa6e84`
- Slug: `source-company-profiles`
- Immutable version: `c1872ddf-5932-5e62-a103-2061d199c69a`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/38647174-353f-4b1f-821e-cbbb30fa6e84/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/38647174-353f-4b1f-821e-cbbb30fa6e84/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/38647174-353f-4b1f-821e-cbbb30fa6e84/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/38647174-353f-4b1f-821e-cbbb30fa6e84/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (6)

| Column | Type | Description |
| --- | --- | --- |
| `symbol` | string | Borsa Istanbul share code. |
| `mkk_member_oid` | string | The company's MKK member id. |
| `company_name` | string | The company's title on KAP, as written. |
| `company_name_ascii` | string | The title with Turkish letters folded to ASCII. |
| `industry_ascii` | string | KAP's sub-sector folded to ASCII. |
| `activity_ascii` | string | The stated line of business folded to ASCII, at most 2,000 characters. |

## Table: source_prices_recent

- Table id: `ad19b9aa-2609-44f1-88f4-c583f75551d0`
- Slug: `source-prices-recent`
- Immutable version: `cfce1e14-a319-5108-ae05-4d1019e53185`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/ad19b9aa-2609-44f1-88f4-c583f75551d0/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/ad19b9aa-2609-44f1-88f4-c583f75551d0/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/ad19b9aa-2609-44f1-88f4-c583f75551d0/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/ad19b9aa-2609-44f1-88f4-c583f75551d0/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (24)

| Column | Type | Description |
| --- | --- | --- |
| `date` | date | The trading day of the bulletin, Istanbul time. |
| `symbol` | string | Borsa Istanbul ticker without the .E equity suffix, such as THYAO. |
| `bulletin_code` | string | The instrument series code as the bulletin writes it, such as THYAO.E. |
| `security_name` | string | The instrument name as the bulletin writes it, upper-case ASCII. |
| `market_group` | string | The bulletin's market group: liquidity group A, B, C or D until 2019, then Z1, Z2, N1 or N2 for a while, and empty since. |
| `market_segment_code` | string | The bulletin's market code. In the five-market structure: Z Star, N Main, T Sub-Market, W Watchlist, S Pre-Market; before it G was the Emerging Companies Marke… |
| `market_segment` | string | The market's name for the code, given for the 2019 and current market structures; empty in the A-D group era, whose names are not mapped. |
| `open` | decimal | Opening price in Turkish lira, as traded; empty when the stock did not trade. |
| `high` | decimal | Day's high in Turkish lira, as traded. |
| `low` | decimal | Day's low in Turkish lira, as traded. |

This document was cut at 60 KiB. The complete version is at https://mostlyright.md/datasets/turkish-stocks-borsa-istanbul-listings-and-kap-fundamentals-and.