Filtering datetime index by minute in QueryBuilder

[0xtflow]

I have a DataFrame of prices with a DatetimeIndex. I’m trying to filter rows in QueryBuilder based on a specific minute value from the index.

Example:

q = adb.QueryBuilder()

q = q[q["index"].dt.minute == 10]
# AttributeError: 'ExpressionNode' object has no attribute 'dt'

q = q[q["index"].minute == 10]
# AttributeError: 'ExpressionNode' object has no attribute 'minute'

It seems that datetime accessors like .dt or .minute are not supported on ExpressionNode.

Question:
What is the correct way to filter a datetime index by time components (e.g., minute, hour, time, or exact timestamp) when using QueryBuilder? Is this functionality supported, or is there an alternative recommended approach?

[poodlewars]

Thanks for the ticket @0xtflow .

There's nothing built in to ArcticDB to do this yet. It would be possible for us to implement this with a modulo operator in our processing pipeline, I've added this feature request to our backlog.

The only ways to do this at the moment would be:

• isin with a long list of minutes, which is unlikely to be practical
• Reading the data in to memory (in date_range chunks if necessary to prevent OOM crashes) and performing the filtering in Pandas