Precios simples y transparentes

SELECT count() FROM esios_indicators
WHERE indicator_id = 600
  AND datetime BETWEEN '2026-04-01' AND '2026-05-01'

SELECT toDate(datetime) AS day, avg(value) AS eur_mwh
FROM esios_indicators
WHERE indicator_id = 600
  AND datetime >= now() - INTERVAL 30 DAY
GROUP BY 1

SELECT technology, sum(energy) AS mwh
FROM operational_data
WHERE program = 'PDBF'
  AND datetime >= today() - 1
GROUP BY 1

SELECT unit, datetime, energy
FROM operational_data
WHERE program = 'PDBF'
  AND datetime >= today() - 7
LIMIT 1000

SELECT unit, datetime, energy,
       offer_id, offer_type, offer_block, precedencia
FROM operational_data
WHERE program = 'PDVP'
  AND datetime >= today() - 1
LIMIT 100

{
  allUnits {
    nodes {
      ufCode
      companyByLinkedSm { name }
    }
  }
}