How to get the latest price update using Google Spreadsheet Query?

i have some problem when using query to get latest price, click Query screenshoot I tried using max method on date, but its not working, how i should do it properly? I want the query result showing newest data based on most recent date