Display last date grouped by warehouse and product
Does this work for you? I am testing in MySQL.

SELECT LatestStock.*
FROM daily_stock as LatestStock
JOIN (  
    SELECT warehouse, product, MAX([date]) as MAXdate
    FROM daily_stock 
    GROUP BY warehouse, product
    ) as LatestDate on LatestStock.warehouse = LatestDate.warehouse AND LatestStock.product = LatestDate.product AND LatestStock.date = LatestDate.MAXdate
ORDER BY LatestStock.product, LatestStock.warehouse