example.sql

#schema
create table `first` (
  `market_id` int unsigned NOT NULL,
  `date` datetime NOT NULL,
  `value` double NOT NULL
);

#query
select `market_id`, min(`value`) as `min_value`
from `first`
where `date` between '2017-01-03 00:00:00' and '2017-01-04 00:00:00'
group by `market_id`;