SELECT xxx_price
FROM price_history
WHERE product_id = <query-product-id>
AND <query-date> BETWEEN start_date AND end_date