I believe the SqlFile class method timeSeries is what you want, shown here, also here.

For an example of how it can be used, look into the BCL measure 'unmet load hours troubleshooting'.