For a "quickest lookup", one would use a lookup table.
Considering your query with second precisions, you'd need
to store 62400 entries per day, so if you have to query data
from lots of days, you might need to invest in memory.
But it gives you the quickest lookup time.