Electricity market data
Spanish electricity market data
Explore REE's I90 operational data — ... records across ... market programs, ... programming units, updated daily. Interactive notebooks and SQL playground.
The dataset at a glance
Market programs
PDBF, PDVP, BS, PHF1-3, RTR, RR, BT
Programming units
Generation, demand, and interconnections
Records
Hourly and 15-minute resolution
Years of data
Historical archive, updated daily
Market programs
13 programs covering the full Spanish electricity dispatch cycle.
PDBF
Base operating schedule — the day-ahead market result that sets the initial dispatch for each hour.
Built for analysis
Real-time analytics on Spain's electricity market data.
ClickHouse analytics
... rows queried in milliseconds. Aggregated queries across programs, units, and time ranges.
Interactive notebooks
Build analysis pipelines visually — chain queries, define variables, and create charts. Need raw SQL? There's a playground too.
MCP integration
Connect Claude Desktop or any MCP-compatible AI assistant to query market data conversationally.
Query protection
Aggregated queries up to 10,000 rows. Raw data samples limited to 50 rows. Safe for public notebooks.
REST API
Programmatic access via simple HTTP endpoints. Health check, schema introspection, and query execution.
Daily updates
Data ingested daily from REE's ESIOS platform. Historical archive growing continuously.
Frequently asked questions
What is I90 data?
I90 is the definitive settlement data published by REE (Red Eléctrica de España) 90 days after each operating day. It contains the final energy allocations and prices for all market programs.
What can I query?
Any aggregated query across the operational_data table: energy volumes, prices, unit participation, program breakdowns, temporal patterns. Raw data is limited to 50-row samples for data protection.
Do I need an account?
Notebooks are public to view — no account needed. Editing and creating notebooks requires a free account.
How do I connect via MCP?
Add the ESIOS Data MCP server to your Claude Desktop configuration. It provides tools for querying market data, exploring the schema, and checking data availability.
What programs are included?
All 13 Spanish electricity market programs: PDBF (day-ahead), PDVP and RTR (constraints), PHF1-7 (intraday sessions), BS (secondary reserve), RR (replacement reserve), and BT (tertiary/mFRR).
Start exploring the market
Create a free account to build interactive notebooks — query market data, visualize results, and share insights.