Can you query a specific segment? Like select the max and min date field for segment name. Something like this:

select max(epoch_enddatetime) 
from merged_1day_1713314780114_0_devIcetraydbEvents_1713132000000_1713135600000_0

Yep, add where $segmentName = ‘xxx’

@Mayank That is hot. Is that documented anywhere?

Yes: https://docs.pinot.apache.org/configuration-reference/schema#built-in-virtual-columns