[Feature] Support sub-daily granularities

[Jstein77]

Is this your first time submitting a feature request?

• [X] I have read the expectations for open source contributors
• [X] I have searched the existing issues, and I could not find an existing issue for this feature
• [X] I am requesting a straightforward extension of existing metricflow functionality, rather than a Big Idea better suited to a discussion

Describe the feature

We should support granularities finer than day! This is especially important for event-based analytics, or any sort of measure that happens at a high frequency.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[ocjuvkam]

Who will this benefit?

This feature is a must have for Eviny Fornybar, which is a producer of hydroelectricity in Europe.

One of the main reasons this is a critical feature is the way energy markets are designed in Europe (under Nordpool). Simplified, energy is sold and bought in auctions on hour-basis (f.ex an auction for 16:00, 17:00, 18:00 so on the next day). As a result of this, all analysis with regards to price formation and so forth is typically on the hour level. This is the same for all participants in the energy market, so I imagine this will be important for all companies acting in the energy market in Europe.

As a result of the market design, a lot of systems complementary to our market-specific software are also tuned into the hour level in order to support market actions.

NB: Note that as of 2025, the markets will increase their granularity to 15-minute intervals. So in near future, our requirement will be to operate on minute-level.