concept

CH column metadata: esios.archives_i90.datetime

Period start, tz-aware Europe/Madrid. Group with toStartOfHour/toDate (DST-correct, local hours). Resolution mixes 1h (pre-2025-10) and 15min (post-MTU) — see `source_interval`; SUM(energy) is safe across the change, COUNT/AVG are not. DST days are 23h/25h (two 02:00 in autumn). See the MCP 'Time handling' instructions.

# `esios.archives_i90.datetime` Period start, tz-aware Europe/Madrid. Group with toStartOfHour/toDate (DST-correct, local hours). Resolution mixes 1h (pre-2025-10) and 15min (post-MTU) — see `source_interval`; SUM(energy) is safe across the change, COUNT/AVG are not. DST days are 23h/25h (two 02:00 in autumn). See the MCP 'Time handling' instructions. - **category**: dimension