Revision history [back]

Assuming you have a table with columns "timestamp" and "quote", you can use the following code to obtain the timestamp of the day's highest quote:

select max[quote], timestamp from table where date(timestamp) = today() 

This code will filter the table to only include rows with a timestamp on the current date (determined by today()), and then select the maximum quote value and corresponding timestamp using the max function.