id => int primary key,
timestamp => bigint,           # epoch timestamp in milliseconds
bid => decimal,
ask => decimal,
bid_amount => int,
ask_amount => int,
data => varchar                # lots of additional data that 
                               # need not to be indexed nor normalized

##</code><code>##

SELECT * FROM table WHERE timestamp > ? AND timestamp < ?

##</code><code>##

SELECT MAX(bid), MIN(bid), MAX(ask), MIN(ask) FROM table 
WHERE timestamp > ? AND timestamp < ?