concept
CH column metadata: archives_i90.offer_rtr.energy
Offered energy in MWh. Sentinel 99999.99 = 'max cap'. Compra rows carry energy as a negative number — use abs(energy) when comparing magnitudes across sign.
# `archives_i90.offer_rtr.energy`
Offered energy in MWh. Sentinel 99999.99 = 'max cap'. Compra rows carry energy as a negative number — use abs(energy) when comparing magnitudes across sign.
- **unit**: MWh
- **common_pitfalls**:
- Filter `energy < 9999` to drop sentinel max-cap rows
- abs(energy) when aggregating across sign='Venta' AND sign='Compra' in the same query