Liquicomun / Table

archives_liquicomun.compodem

Electricity settlement compodem.

LiquicomunPer recordBy sourceCadence not defined
Coverage2011-12-31 – 2026-09-16338,814 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: 2026-09-16. 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 · 24 rows · 2026-09-16 – 2026-09-17

liq_versionLowCardinality(String)datetimeDateTime('Europe/Madrid')source_intervalLowCardinality(String)BS3Float64BALXFloat64CFPFloat64DSVFloat64EXDFloat64IN7Float64RT3Float64RT6Float64RAD3Float64CT3Float64AJOMFloat64AJOSFloat64MAJ3Float64MIFloat64PC3Float64RAD1Float64RAD1XFloat64IN3Float64ERADXFloat64CT2Float64ERADFloat64SECXFloat64source_fileStringpublished_atDateTimeingested_atDateTimeversionUInt64
A22026-09-16T00:00:00+02:001h0.8936562721-0.7593795944000.2878492713-0.30276115036.98423584033.02897520400.03218065990000.08550757070000000-0.4388170961A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T01:00:00+02:001h0.4424856337-1.486026820900-1.3025314181-0.21813810049.6510223243.072267077700.03845692710000.04114939390000000-0.4580008045A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T02:00:00+02:001h0.4905971454-0.514723844400-8.0910776869-0.29656326389.82359006753.406906049800.04317650340000.04979914090000000-0.2602388921A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T03:00:00+02:001h0.5744059697-0.271406617800-4.425049435-0.001602509210.27235160162.398078192200.04008421860000.02309486320000000-0.0270134542A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T04:00:00+02:001h0.5671173242-1.014887381200-2.6331966996-0.291780573610.657449991.823525281300.0362694560000.00117618070000000-0.0157074533A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T05:00:00+02:001h0.5246218734-0.966107087700-6.0018961703-0.320699501510.07475750121.969710335100.03348567160000.02808973110000000-0.0687927335A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T06:00:00+02:001h0.8079778405-0.134035901600-2.3548400746-0.74561700569.72327871161.353800468100.0259730919000-0.06942698720000000-0.0301240842A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T07:00:00+02:001h2.8020739379-0.18572787300-1.4359112909-0.163081025216.48954118059.54304311232.43129700240.0222160716000-0.36997905310-2.92272911630.04037125720000-0.191882756A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T08:00:00+02:001h2.6567373014-0.322226118500-3.27479841870.254516213617.38488989758.74202430192.31047893920.0368779304000-0.08141807080.1391804289-2.8383988820.03203073510000-0.1787564151A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T09:00:00+02:001h4.0630482347-0.466171183500-2.8911672312-0.078360712914.03952034870.89077446662.19682358680.0440357499000-0.77179567070.1741246365-2.84551220180.09753892470000-1.4812596708A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T10:00:00+02:001h0.5329876453-0.239730942400-9.48201619480.244776642419.61088749081.41978758622.23194804110.0470183672000-0.67289692120.3466325461-2.86396852710.05607170380000-0.0226189553A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T11:00:00+02:001h0.1689991497-0.003987455800-1.43836043750.030091227323.50622024931.80936720862.20434830670.0396110745000-0.3315567110.3461462166-2.86388515160.06886528810000-0.0989561369A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T12:00:00+02:001h0.1261817659-0.00001020400-0.91824693070.010053256422.72031913131.91019544422.17173052710.0432542105000-0.09859683740.3463734411-2.85904243010.05471373620000-0.010380164A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T13:00:00+02:001h0.1336660371-0.000002264600-0.00841295950.001065490622.44925634192.76727904512.13192622650.043311833000-0.02649354750.3491181943-2.85529203840.08610394220000-0.007774722A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T14:00:00+02:001h0.1265395706-0.000002680800-2.07523961430.000454579122.70578712093.58961674012.17855850490.0408772664000-0.02774769590.1400034597-2.89714690930.08060908540000-0.2317453282A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T15:00:00+02:001h0.1199019905-0.000001927300-2.28494615680.061453894522.26692331464.6890260872.22777585280.0412142856000-0.02530228650.13976308-2.91600620110.02437711110000-0.2085206256A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T16:00:00+02:001h0.1573124355-0.003177707300-7.42857209740.054224403222.1012365894.64178766052.17535303310.0422434376000-0.03983263370.1395094466-2.90297240540.0262770030000-0.837268501A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T17:00:00+02:001h0.3525152094-0.235548771700-17.02818052690.002110998721.885764953115.04983482392.19534024570.0366315244000-0.05405699170.1395087395-2.86351278590.00909126180000-0.1323978875A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T18:00:00+02:001h1.9659193904-0.144149876200-18.39533038140.041323238917.064521123814.23530048232.1886093680.0366615295000-0.2537245070.3510799388-2.78035832610.01599402960000-0.0826214861A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T19:00:00+02:001h4.5830446861-0.28102579600-15.5044874904-0.026278622116.56137388458.3217464122.18257550290.03846929390000.01098206110.3538041209-2.72301410080.00772193460000-2.3306042661A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T20:00:00+02:001h2.0823952403-0.531346665500-6.22408450840.251147488719.167657746111.3665810482.13596656020.0269357085000-0.06302119470.3603751595-2.63064783580.02047788450000-1.1409181613A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T21:00:00+02:001h0.7778986635-0.281304272900-16.00779079720.213828988719.444934983417.11610760442.1790109040.01970469190000.02345594170.364532253-2.75168403590.04387533920000-0.7401690145A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T22:00:00+02:001h0.3961848842-0.488958279100-4.20521756710.087819363420.23559135864.77544477982.39170506260.0264428840000.17612857790.1389337464-3.07142237990.02904210620000-0.0689415071A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
A22026-09-16T23:00:00+02:001h0.6886939671-0.834381512900-10.1335803683-0.162535512218.9766524123.2526832092.55450146110.03875129750000.10346131650.1382688757-3.35180424460.03194494230000-0.0259538257A2_compodem_202609162026-09-18T03:02:422026-09-18T03:02:511789700562
SQL
SELECT
    liq_version,
    datetime,
    source_interval,
    BS3,
    BALX,
    CFP,
    DSV,
    EXD,
    IN7,
    RT3,
    RT6,
    RAD3,
    CT3,
    AJOM,
    AJOS,
    MAJ3,
    MI,
    PC3,
    RAD1,
    RAD1X,
    IN3,
    ERADX,
    CT2,
    ERAD,
    SECX,
    source_file,
    published_at,
    ingested_at,
    version
FROM archives_liquicomun.compodem
WHERE datetime >= '2026-09-16' AND datetime < '2026-09-17'
LIMIT 100