* Drop Python 3.10 support
Python 3.10 reached end of life on 2026-10-01, and the patched releases of
Pillow (13.0.0) and filelock (>=4.2.1) require Python >=3.11, so the 3.10
resolution fork kept vulnerable versions in every lockfile.
- requires-python = ">=3.11,<4" in all pyproject.toml files, the
cookiecutter template, and the CLI codegen project template
- CI: drop the ubuntu 3.10 matrix rows, move the macOS/Windows minimum
rows and the lint jobs to 3.11, drop 3.10 from the nox sessions
- READMEs: state 3.11 as the minimum supported version
* Relock with patched certifi, filelock, virtualenv, Pillow, and fastmcp
Regenerate all 38 uv.lock files against requires-python >=3.11 and upgrade
only the packages with open Dependabot advisories:
- certifi 2026.7.22 -> 2026.10.23 (GHSA-6q48-6c7w-9gw2, compromised emSign CAs)
- virtualenv 21.14.7 -> 21.14.13
- filelock 4.1.0/4.2.0 -> 4.2.4
- Pillow 12.3.0 -> 13.0.0
- fastmcp / fastmcp-slim 4.1.0 -> 4.1.3
All other changes are removed Python 3.10-only resolution forks; no other
package changes version for Python 3.11+.
* desktop: bump zod, @hookform/resolvers, and vitest
- zod ^3.25.76 -> ^4.6.7 (GHSA-mrhx-c7xc-m3w5; no patched 3.x exists)
- @hookform/resolvers ^3.10.0 -> ^5.9.2 for zod 4 support
- vitest ^4.1.11 -> ^4.1.12 (@vitest/mocker GHSA-qxg6-89mg-rqv8,
GHSA-xp26-3454-mjgp)
- override zod to the root version so @openbb/ui-pro, which declares
zod ^3 but never imports it, does not pull in a second, vulnerable copy
* desktop: remove Python 3.10 from environment pickers
- version pickers in InstallComponents and AddExtensionSelector start at 3.11
- create_environment_from_requirements accepts 3.11 through 3.14 and falls
back to 3.12 otherwise (previously 3.10 through 3.13)
- component tests select 3.11 instead of 3.10
* Remove Python 3.10 tomli fallbacks
With requires-python >=3.11, tomllib is always available, so the
version-conditional tomli imports are dead code.
- import tomllib directly in the cli and core config loaders, the
mcp_server and platform_api config validators, dev_install.py, and
the cli and cookiecutter tests; dev_install.py no longer pip-installs
tomli on the fly
- drop the tomli>=2.0; python_version<'3.11' dependency from cli, core,
mcp_server, and platform_api, plus platform_api's backport comment
- raise the fake-extension fixtures in cli/conftest.py,
core/integration/conftest.py, and the charting test metadata to
>=3.11
- relock cli, core, mcp_server, and platform_api; only the tomli
requires-dist entry is removed and resolution markers are reordered,
no package versions change
* Target Python 3.11 in ruff and ty for cli, core, mcp_server, platform_api, cookiecutter
With ruff target-version py310 and ty python-version 3.10, both tools
reject an unconditional `import tomllib`: ty reports it as unresolved
(exit 1) and ruff's isort classifies it as third-party. Raise the targets
in the projects that now import tomllib directly, and in the root
ruff.toml that governs dev_install.py.
- ruff target-version = "py311" and ty python-version = "3.11" in cli,
core, mcp_server, platform_api, and cookiecutter; root ruff.toml
target-version = "py311"
- UP042: OutputMode, ChartLifecycle, MCPType, and HTTPMethod become
StrEnum; every consumer uses .value or == comparisons, so only str()
and format() output change
- UP017: datetime.timezone.utc -> datetime.UTC (ruff autofix) in the cli
dispatchers, the cli test generator, and a core test
* Fix ruff and ty failures in packages this PR touches
CI installs unpinned dependencies, so the lint jobs ran against
pandas 3.1.0, ruff 0.17.2, and ty 0.0.91.
- cli/conftest.py: guard the find_spec("openbb") lookup so ty no longer
reports an Optional ModuleSpec/origin (failing Lint openbb-cli)
- quantitative: pandas 3.1 types Index.max() as object; cast max_date to
Timestamp before period_start in attribution, factors, and
risk_decomposition (failing ty)
- federal_reserve: use Series(...).dt.date instead of
DatetimeIndex.date so neither pandas 3.0 nor 3.1 needs a ty: ignore
(pandas 3.1 made the existing ignores unused, failing ty)
- core tests: type the filter_by_dates doubles as Data subclasses and
cast the deliberate bad arguments in test_helpers.py; apply ruff format
to test_docstring_generator_helpers.py
- platform_api README: apply ruff format to the Python code blocks
* Fix pandas 3.1 deprecations failing fred, sec, and eia tests
These suites turn warnings into errors, and pandas 3.1.0 adds
Pandas4Warning deprecations for several patterns they use. Every change
also passes with the locked pandas 3.0.6.
- fred, sec: replace inplace=True sort_values/reset_index/rename/
set_index/drop with reassignment
- fred balance_of_payments, sec as_filed_widget: replace fillna with a
string on float columns by astype(object).where(notna, ...)
- sec: build quarter start dates from ISO strings instead of parsing
"2024Q2"-style strings; use the DataFrame constructor instead of
DataFrame.from_records for column dicts; pad CIK lookup rows to two
fields instead of constructing a ragged DataFrame
- eia: read EIA workbooks with the calamine engine (xlrd is deprecated);
replace the xlrd dependency with python-calamine and relock; calamine
workbooks are not safe for concurrent reads, so the petroleum status
report serializes its sheet reads with a lock
* imf: fall back to the published catalog when the IMF API is unreachable
imf_cache.json.xz is generated at build time and is not committed, so
every CI build of openbb-imf needed a live api.imf.org. The only fallback
was actions/cache, and caches saved by pull_request runs are scoped to
that PR, so a new PR never had one. With api.imf.org returning
"503 no healthy upstream" during IMF's data portal maintenance window,
the build failed.
When live generation fails on a non-forced build, the hook now copies
imf_cache.json.xz from the latest openbb-imf wheel on PyPI, after
checking the wheel's sha256 against the digest PyPI publishes. Builds
with OPENBB_IMF_FORCE_CACHE_REBUILD=1, which the publish workflow sets,
still fail hard, so a release never ships a stale catalog.
---------
Co-authored-by: dlee-bq <325002271+dlee-bq@users.noreply.github.com>
OpenBB OECD Provider Extension
This package adds the openbb-oecd provider extension to the Open Data Platform by OpenBB.
It provides everything you need — endpoints, tools, and metadata — to access and explore the entirety of https://data-explorer.oecd.org, without any previous experience working with it.
Installation
Install from PyPI with:
pip install openbb-oecd
Then build the Python static assets by running:
openbb-build
Quick Start
The fastest way to get started is by connecting to the OpenBB Workspace as a custom backend.
Start Server
openbb-api
This starts the FastAPI server over localhost on port 6900.
Add to Workspace
See the documentation here for more details.
Click to Open App
Once added, click on the app to open the dashboard.
The dashboard contains widgets with metadata and information, as well as ones for exploring and retrieving the data.
Implementation Details
OECD publishes data through a SDMX v2 REST API, and organizes everything into "dataflows". You can think of these as databases, each with its own dimension definitions, codelists, and observation attributes. Some definitions are shared across dataflows, others are domain-specific.
The extension ships with a bundled metadata cache that covers all OECD dataflows. It contains dimension definitions, codelist mappings, content constraints, and the full topic taxonomy. When anything is missing from the bundled cache, it is fetched on first use and added to a user-writable cache file that persists across sessions.
Input is validated against the dataflow's content constraints. Codes are resolved to human-readable labels in the output, and dataset and series metadata are returned alongside the observations.
Indicators
In this library, we use the term "indicator" to refer to indicator-like dimensions within individual dataflows.
These are dimensions that represent what is being measured, such as MEASURE, SUBJECT, TRANSACTION, or
ACTIVITY. The specific dimension varies by dataflow.
The OECD codes for these values — B1GQ, CPI, LI, etc. — are used to construct ticker-like symbols.
Symbology
The Open Data Platform refers to all time series IDs as a symbol.
Requesting data requires a symbol constructed from the dataflow's short ID and an identifier, joined with ::.
The identifier can be either:
- An indicator-like code, such as
CPI,LI, orB1GQ - A presentation table identifier, such as
T0101
DF_PRICES_ALL::CPI — Consumer Price Index, all items
DF_QNA::B1GQ — GDP, expenditure approach (Quarterly National Accounts)
DF_CLI::LI — Composite Leading Indicator
DF_EO::GDPV_USD — GDP forecast, volume (Economic Outlook)
DF_BOP::B6_USD — Current account balance
DF_QNA::T0101 — Quarterly National Accounts presentation table
Multiple indicators from the same dataflow can be comma-separated:
DF_PRICES_ALL::CPI,DF_PRICES_ALL::HICP
Use obb.economy.available_indicators(provider="oecd") to search for or list indicator symbols.
Use obb.oecd_utils.list_tables() and obb.oecd_utils.get_table_detail() to discover presentation tables and inspect their dimensions.
Use obb.oecd_utils.get_dataflow_parameters() to see all dimensions and valid codes for any dataflow.
Metadata Cache
The library ships with a bundled base cache (oecd_cache.msgpack.xz) containing:
- All dataflow IDs, names, and version metadata
- DSD dimension definitions and codelist references for every dataflow
- All codelist code-to-label mappings
- Content constraints (valid value sets per dimension)
- The full OECD topic taxonomy (category scheme and categorisations)
When a structure is missing, it is fetched on demand and merged into a user-level cache stored in the
OpenBB user cache directory as oecd_cache.msgpack.gz. If that directory cannot be resolved from OpenBB
settings, the fallback location is ~/.openbb_platform/cache/oecd_cache.msgpack.gz.
Coverage
All data available from https://data-explorer.oecd.org can be retrieved via obb.economy.indicators(provider='oecd', **kwargs).
The extension also exposes specialized fetchers for the most commonly used OECD datasets.
The extension creates a router path, oecd_utils, that exposes utility functions for UI integrations
and metadata lookup.
Endpoints
Economy
obb.economy.available_indicators— search all OECD indicator symbolsobb.economy.indicators— fetch data for any OECD indicator symbolobb.economy.balance_of_payments— Balance of Paymentsobb.economy.composite_leading_indicator— Composite Leading Indicatorsobb.economy.cpi— Consumer Price Indicesobb.economy.country_interest_rates— Short and long-term interest ratesobb.economy.gdp.nominal— Nominal GDPobb.economy.gdp.real— Real GDPobb.economy.gdp.forecast— GDP forecasts (Economic Outlook)obb.economy.house_price_index— Residential property price indicesobb.economy.share_price_index— Share price indicesobb.economy.unemployment— Unemployment rates
Utilities
obb.oecd_utils.list_topic_choices— topic dropdown choices for UI widgetsobb.oecd_utils.list_subtopic_choices— subtopic dropdown choices for a selected topicobb.oecd_utils.list_dataflows— list all OECD dataflows with topic breadcrumbsobb.oecd_utils.list_dataflow_choices— dropdown choices for UI widgetsobb.oecd_utils.list_topics— browse OECD topics and subtopics with dataflow countsobb.oecd_utils.get_dataflow_parameters— dimensions and valid codes for a dataflowobb.oecd_utils.list_tables— search OECD presentation tablesobb.oecd_utils.get_table_detail— inspect a table's dimensions and indicator hierarchyobb.oecd_utils.list_table_choices— table dropdown choices for UI widgetsobb.oecd_utils.presentation_table_choices— progressive choices for the presentation table widgetobb.oecd_utils.presentation_table— retrieve formatted OECD presentation tables
"Choices" endpoints are used by OpenBB Workspace to populate widget dropdown menus.
Example
from openbb import obb
# List all available OECD indicators to find what you need
indicators = obb.economy.available_indicators(provider="oecd", query="GDP")
print(indicators.to_df())
# Fetch real GDP growth for the US, UK, and Germany
data = obb.economy.indicators(
provider="oecd",
symbol="DF_QNA::B1GQ",
country="USA,GBR,DEU",
frequency="quarterly",
)
print(data.to_df())
# Fetch a presentation table directly
table = obb.economy.indicators(
provider="oecd",
symbol="DF_QNA::T0101",
country="USA",
frequency="Q",
limit=4,
)
print(table.to_df())
# Inspect all dimensions and valid values for a dataflow
params = obb.oecd_utils.get_dataflow_parameters(
dataflow_id="DF_PRICES_ALL", output_format="json"
)
print(params.results)
# Search available presentation tables
tables = obb.oecd_utils.list_tables(query="GDP")
print(tables.results)