Liquicomun / Table

archives_liquicomun.settlements

Electricity settlement settlements.

LiquicomunPer recordBy sourceReference data
Coverage— – —203,133 rows
SourceRed Eléctrica de EspañaOfficial source
In your planPublic accessSign in to check access

Source: Red Eléctrica de España. Latest data: —. Joltio normalizes the published values without altering them and is not affiliated with or endorsed by Red Eléctrica de España.

Sample

Sample from 2026-09-28 · 100 rows · Reference data

liq_versionLowCardinality(String)file_typeLowCardinality(String)geo_regionLowCardinality(String)atr_codeLowCardinality(String)yearUInt16monthUInt8dayUInt8concept_codeLowCardinality(String)concept_nameStringcol_1Nullable(Float64)col_2Nullable(Float64)col_3Nullable(Float64)col_4Nullable(Float64)col_5Nullable(Float64)col_6Nullable(Float64)col_7Nullable(Float64)col_8Nullable(Float64)col_9Nullable(Float64)source_fileStringpublished_atDateTimeingested_atDateTimeversionUInt64
C2liqcocurPENINSULA201211BS3Banda secundaria - CF————5201504.07-5201504.07———C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211BS3Banda secundaria - CF————5201730.06-5201730.06———C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211BS3Banda secundaria - CF————5136684.51-5136684.51———C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211BS3Banda secundaria - CF————5173591.07-5173591.07———C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201211CBMContratos bilaterales mercado—2646363.4-2646363.4——————C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211CBMContratos bilaterales mercado—2646363.4-2646363.4——————C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211CBMContratos bilaterales mercado—2646363.4-2646363.4——————C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211CBMContratos bilaterales mercado—2646363.4-2646363.4——————C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201211DSVDesv�os67311.21160274.723-92963.5132461967.129438852.65-6976885.5336.5858.89—C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211DSVDesv�os64164.116164695.894-100531.7782338418.079698409.14-7359991.0736.4458.89—C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211DSVDesv�os126908.493112449.12614459.3675769526.476267234.69-497708.2245.4655.73—C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211DSVDesv�os131450.27782924.7548525.5275563725.64761857.26801868.3442.3357.42—C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201211EXDSaldo desv�os———1032501.06267685.41764815.65———C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211EXDSaldo desv�os———1027267.5265546.02761721.48———C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211EXDSaldo desv�os———819384.841322423.85-503039.01———C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211EXDSaldo desv�os———944077.181438816.6-494739.42———C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201211IN7Saldo cuentas PO 14.6———125466.72299737.26-174270.54———C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211IN7Saldo cuentas PO 14.6———125474.03299750.6-174276.57———C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211IN7Saldo cuentas PO 14.6———123762.43295624.47-171862.04———C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211IN7Saldo cuentas PO 14.6———125257.54298173.07-172915.53———C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201211PC3Pagos capacidad (Financiaci�n)————53939244.87-53939244.87———C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211PC3Pagos capacidad (Financiaci�n)————54009882.23-54009882.23———C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211PC3Pagos capacidad (Financiaci�n)————51521721.58-51521721.58———C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211PC3Pagos capacidad (Financiaci�n)————51188983.6-51188983.6———C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201211RT3Restricciones PBF - Coste————12652505.42-12652505.42———C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211RT3Restricciones PBF - Coste————12652955.23-12652955.23———C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211RT3Restricciones PBF - Coste————12526476.38-12526476.38———C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211RT3Restricciones PBF - Coste————12602825.1-12602825.1———C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201211RT6Restricciones tiempo real (SC)———2128.541167010.58-1164882.04———C2_liqcocur_20120101_201201312026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201211RT6Restricciones tiempo real (SC)———2128.571167124.3-1164995.73———C3_liqcocur_20120101_201201312026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201211RT6Restricciones tiempo real (SC)———2112.981147905.97-1145792.99———C4_liqcocur_20120101_201201312026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201211RT6Restricciones tiempo real (SC)———2125.331157727.23-1155601.9———C5_liqcocur_20120101_201201312026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212BS3Banda secundaria - CF————416645.96-416645.96———C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212BS3Banda secundaria - CF————416654.08-416654.08———C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212BS3Banda secundaria - CF————396765.62-396765.62———C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212BS3Banda secundaria - CF————390608.07-390608.07———C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212CBMContratos bilaterales mercado—84063.2-84063.2——————C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212CBMContratos bilaterales mercado—84063.2-84063.2——————C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212CBMContratos bilaterales mercado—84063.2-84063.2——————C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212CBMContratos bilaterales mercado—84063.2-84063.2——————C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212DSVDesv�os800.6414371.307-3570.66615705.85122711.59-107005.7419.6228.07—C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212DSVDesv�os748.9344559.68-3810.74615018.09131217.35-116199.2620.0528.78—C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212DSVDesv�os22232.4913914.99918317.492500430.75177562.48322868.2722.5145.35—C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212DSVDesv�os25403.76381.00925322.754580045.453511.06576534.3922.8343.34—C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212EXDSaldo desv�os———80207.8231278.5648929.26———C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212EXDSaldo desv�os———81553.8231301.4750252.35———C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212EXDSaldo desv�os———247121.3128007.59219113.72———C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212EXDSaldo desv�os———265831.3428863.75236967.59———C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212IN7Saldo cuentas PO 14.6———1636.429224.69-7588.27———C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212IN7Saldo cuentas PO 14.6———1636.429224.61-7588.19———C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212IN7Saldo cuentas PO 14.6———1492.568521.91-7029.35———C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212IN7Saldo cuentas PO 14.6———1459.178373.02-6913.85———C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212PC3Pagos capacidad (Financiaci�n)————1716711.84-1716711.84———C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212PC3Pagos capacidad (Financiaci�n)————1719014.38-1719014.38———C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212PC3Pagos capacidad (Financiaci�n)————1489573.77-1489573.77———C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212PC3Pagos capacidad (Financiaci�n)————1420849.12-1420849.12———C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212RT3Restricciones PBF - Coste————616400.43-616400.43———C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212RT3Restricciones PBF - Coste————616415.5-616415.5———C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212RT3Restricciones PBF - Coste————576544.62-576544.62———C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212RT3Restricciones PBF - Coste————566107.54-566107.54———C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201212RT6Restricciones tiempo real (SC)———135.9912122.81-11986.82———C2_liqcocur_201201022026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201212RT6Restricciones tiempo real (SC)———13612122.99-11986.99———C3_liqcocur_201201022026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201212RT6Restricciones tiempo real (SC)———136.5411298.04-11161.5———C4_liqcocur_201201022026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201212RT6Restricciones tiempo real (SC)———135.611105.58-10969.98———C5_liqcocur_201201022026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213BS3Banda secundaria - CF————206765.79-206765.79———C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213BS3Banda secundaria - CF————206770.42-206770.42———C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213BS3Banda secundaria - CF————207891.96-207891.96———C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213BS3Banda secundaria - CF————204648.02-204648.02———C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213CBMContratos bilaterales mercado—74325-74325——————C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213CBMContratos bilaterales mercado—74325-74325——————C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213CBMContratos bilaterales mercado—74325-74325——————C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213CBMContratos bilaterales mercado—74325-74325——————C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213DSVDesv�os15.2018448.183-8432.982546.63449580.06-449033.4335.9653.22—C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213DSVDesv�os7.5868664.72-8657.134272.79461230.7-460957.9135.9653.23—C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213DSVDesv�os2192.1426952.956-4760.81497472.68374159.74-276687.0644.4653.81—C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213DSVDesv�os3014.818574.2242440.594140059.6329607.73110451.946.4651.56—C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213EXDSaldo desv�os———16816.8814562.782254.1———C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213EXDSaldo desv�os———16929.414390.232539.17———C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213EXDSaldo desv�os———9888.0671054.57-61166.51———C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213EXDSaldo desv�os———8171.2791314.98-83143.71———C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213IN7Saldo cuentas PO 14.6———212.6612950.91-12738.25———C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213IN7Saldo cuentas PO 14.6———212.5112951.49-12738.98———C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213IN7Saldo cuentas PO 14.6———212.913174-12961.1———C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213IN7Saldo cuentas PO 14.6———208.4712932.7-12724.23———C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213PC3Pagos capacidad (Financiaci�n)————1643630.85-1643630.85———C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213PC3Pagos capacidad (Financiaci�n)————1645760.53-1645760.53———C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213PC3Pagos capacidad (Financiaci�n)————1577628.12-1577628.12———C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213PC3Pagos capacidad (Financiaci�n)————1506918.96-1506918.96———C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213RT3Restricciones PBF - Coste————631199.3-631199.3———C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213RT3Restricciones PBF - Coste————631214.01-631214.01———C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213RT3Restricciones PBF - Coste————638711.08-638711.08———C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213RT3Restricciones PBF - Coste————626915.63-626915.63———C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201213RT6Restricciones tiempo real (SC)————3327.83-3327.83———C2_liqcocur_201201032026-05-17T13:35:502026-06-16T22:54:151779024950
C3liqcocurPENINSULA201213RT6Restricciones tiempo real (SC)————3327.86-3327.86———C3_liqcocur_201201032026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201213RT6Restricciones tiempo real (SC)————3306.56-3306.56———C4_liqcocur_201201032026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201213RT6Restricciones tiempo real (SC)————3265.5-3265.5———C5_liqcocur_201201032026-05-21T22:00:382026-05-21T22:38:501779400838
C2liqcocurPENINSULA201214BS3Banda secundaria - CF————181896.56-181896.56———C2_liqcocur_201201042026-05-17T13:35:502026-06-16T22:54:161779024950
C3liqcocurPENINSULA201214BS3Banda secundaria - CF————181902.3-181902.3———C3_liqcocur_201201042026-05-21T22:02:382026-06-16T22:52:001779400958
C4liqcocurPENINSULA201214BS3Banda secundaria - CF————183905.95-183905.95———C4_liqcocur_201201042026-05-21T22:01:322026-05-21T22:39:521779400892
C5liqcocurPENINSULA201214BS3Banda secundaria - CF————180895.65-180895.65———C5_liqcocur_201201042026-05-21T22:00:382026-05-21T22:38:501779400838
SQL
SELECT
    liq_version,
    file_type,
    geo_region,
    atr_code,
    year,
    month,
    day,
    concept_code,
    concept_name,
    col_1,
    col_2,
    col_3,
    col_4,
    col_5,
    col_6,
    col_7,
    col_8,
    col_9,
    source_file,
    published_at,
    ingested_at,
    version
FROM archives_liquicomun.settlements
LIMIT 100