queries: add observation date range query
schema: add index on Observation.observed_at

This index speeds the observation_date_range query.
db: add covering index on observation time and link id