concept

CH table metadata: archives_i90.offer_rtr

OFFER_RTR / OFFER_RTR_BUY / OFFER_RTR_UPDATE — order-book offers for restricciones técnicas en tiempo real. Multi-source table: `program` discriminates direction-of-restriction (sell vs buy side), `sign` discriminates direction-of-energy (Venta = ofrece subir generación; Compra = ofrece bajar generación / consumir). NOT 'Subir/Bajar' like the rest of the I90 tables — this is the only program that uses Venta/Compra. Sentinels: `price=9999.99` ('no offer'), `energy=99999.99` ('max cap') — filter `

# `archives_i90.offer_rtr` OFFER_RTR / OFFER_RTR_BUY / OFFER_RTR_UPDATE — order-book offers for restricciones técnicas en tiempo real. Multi-source table: `program` discriminates direction-of-restriction (sell vs buy side), `sign` discriminates direction-of-energy (Venta = ofrece subir generación; Compra = ofrece bajar generación / consumir). NOT 'Subir/Bajar' like the rest of the I90 tables — this is the only program that uses Venta/Compra. Sentinels: `price=9999.99` ('no offer'), `energy=99999.99` ('max cap') — filter `WHERE price < 9999 AND energy < 9999` for real offers. DIA42 (OFFER_RTR_BUY) is mostly empty by design — real buy-side restricciones offers are rare.