OMIE / Table

omie.interconnection_capacities

Cross-border capacity for market sessions.

OMIEPer recordBy sourceUp to date
Coverage2017-12-31 – 2026-09-303,663,888 rows
In your planPublic accessSign in to check access

Source: OMIE. Latest data: 2026-09-30. Joltio normalizes the published values without altering them and is not affiliated with or endorsed by OMIE.

Sample

Sample from 2026-09-28 · 100 rows · 2026-09-29 – 2026-09-30

datetimeDateTime('Europe/Madrid')periodLowCardinality(String)period_indexUInt16source_intervalLowCardinality(String)programLowCardinality(String)published_atDateTime('Europe/Madrid')frontierLowCardinality(String)countryLowCardinality(String)directionLowCardinality(String)capacity_mwFloat64occupied_mwNullable(Float64)available_mwNullable(Float64)source_fileStringfile_dateDateinserted_atDateTime
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:002Franciaexport45459993546capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:002Franciaimport468005679capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H1Q1115minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H01Q1115minPHF12026-09-28T15:11:00+02:002Franciaexport3546217.83328.2capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H01Q1115minPHF12026-09-28T15:11:00+02:002Franciaimport567905896.8capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H01Q1115minPHF12026-09-28T15:11:00+02:003Portugalexport460004600capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:00:00+02:00H01Q1115minPHF12026-09-28T15:11:00+02:003Portugalimport000capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:002Franciaexport45451155.43389.6capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:002Franciaimport468005835.4capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H1Q2215minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H01Q2215minPHF12026-09-28T15:11:00+02:002Franciaexport3389.6151.73237.9capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H01Q2215minPHF12026-09-28T15:11:00+02:002Franciaimport5835.405987.1capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H01Q2215minPHF12026-09-28T15:11:00+02:003Portugalexport460004600capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:15:00+02:00H01Q2215minPHF12026-09-28T15:11:00+02:003Portugalimport000capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:002Franciaexport454513643181capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:002Franciaimport468006044capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H1Q3315minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H01Q3315minPHF12026-09-28T15:11:00+02:002Franciaexport3181108.43072.6capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H01Q3315minPHF12026-09-28T15:11:00+02:002Franciaimport604406152.4capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H01Q3315minPHF12026-09-28T15:11:00+02:003Portugalexport4600117.34482.7capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:30:00+02:00H01Q3315minPHF12026-09-28T15:11:00+02:003Portugalimport00117.3capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:002Franciaexport45451187.43357.6capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:002Franciaimport468005867.4capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H1Q4415minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H01Q4415minPHF12026-09-28T15:11:00+02:002Franciaexport3357.685.63272capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H01Q4415minPHF12026-09-28T15:11:00+02:002Franciaimport5867.405953capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H01Q4415minPHF12026-09-28T15:11:00+02:003Portugalexport460004600capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T00:45:00+02:00H01Q4415minPHF12026-09-28T15:11:00+02:003Portugalimport000capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:002Franciaexport4545650.43894.6capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:002Franciaimport468005330.4capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H2Q1515minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H02Q1515minPHF12026-09-28T15:11:00+02:002Franciaexport3894.6212.73681.9capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H02Q1515minPHF12026-09-28T15:11:00+02:002Franciaimport5330.405543.1capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H02Q1515minPHF12026-09-28T15:11:00+02:003Portugalexport460059.84540.2capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:00:00+02:00H02Q1515minPHF12026-09-28T15:11:00+02:003Portugalimport0059.8capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:002Franciaexport45458493696capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:002Franciaimport468005529capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H2Q2615minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H02Q2615minPHF12026-09-28T15:11:00+02:002Franciaexport36961593537capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H02Q2615minPHF12026-09-28T15:11:00+02:002Franciaimport552905688capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H02Q2615minPHF12026-09-28T15:11:00+02:003Portugalexport460097.54502.5capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:15:00+02:00H02Q2615minPHF12026-09-28T15:11:00+02:003Portugalimport0097.5capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:002Franciaexport4545810.33734.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:002Franciaimport468005490.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H2Q3715minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H02Q3715minPHF12026-09-28T15:11:00+02:002Franciaexport3734.7160.83573.9capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H02Q3715minPHF12026-09-28T15:11:00+02:002Franciaimport5490.305651.1capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H02Q3715minPHF12026-09-28T15:11:00+02:003Portugalexport4600155.24444.8capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:30:00+02:00H02Q3715minPHF12026-09-28T15:11:00+02:003Portugalimport00155.2capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:002Franciaexport45456303915capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:002Franciaimport468005310capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:004Andorraexport111.70111.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:004Andorraimport1070107capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:005Marruecosexport915.385065.3capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H2Q4815minPDBF2026-09-28T14:18:00+02:005Marruecosimport60001435.7capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H02Q4815minPHF12026-09-28T15:11:00+02:002Franciaexport3915166.83748.2capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H02Q4815minPHF12026-09-28T15:11:00+02:002Franciaimport531005476.8capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H02Q4815minPHF12026-09-28T15:11:00+02:003Portugalexport460062.74537.3capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T01:45:00+02:00H02Q4815minPHF12026-09-28T15:11:00+02:003Portugalimport0062.7capacidad_inter_phf_2026092901.12026-09-292026-09-28T16:26:32
2026-09-29T02:00:00+02:00H3Q1915minPDBF2026-09-28T14:18:00+02:002Franciaexport4545512.54032.5capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T02:00:00+02:00H3Q1915minPDBF2026-09-28T14:18:00+02:002Franciaimport468005192.5capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T02:00:00+02:00H3Q1915minPDBF2026-09-28T14:18:00+02:003Portugalexport230004600capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
2026-09-29T02:00:00+02:00H3Q1915minPDBF2026-09-28T14:18:00+02:003Portugalimport230023000capacidad_inter_pbc_20260929.12026-09-292026-09-28T16:26:32
SQL
SELECT
    datetime,
    period,
    period_index,
    source_interval,
    program,
    published_at,
    frontier,
    country,
    direction,
    capacity_mw,
    occupied_mw,
    available_mw,
    source_file,
    file_date,
    inserted_at
FROM omie.interconnection_capacities
WHERE datetime >= '2026-09-29' AND datetime < '2026-09-30'
LIMIT 100