SELECT marketdaily.marketdaily_id , marketdaily.date , marketdaily.closing_price FROM marketdaily INNER JOIN ( SELECT marketdaily_id FROM marketdaily WHERE symbol = 'ARBK' AND DAY(date) <= 3 ORDER BY date DESC ) sub ON marketdaily.marketdaily_id = sub.marketdaily_id GROUP BY YEAR(marketdaily.date) DESC, MONTH(marketdaily.date) DESC;