- or download this
id => int primary key,
timestamp => bigint, # epoch timestamp in milliseconds
...
ask_amount => int,
data => varchar # lots of additional data that
# need not to be indexed nor normalized
- or download this
SELECT * FROM table WHERE timestamp > ? AND timestamp < ?
- or download this
SELECT MAX(bid), MIN(bid), MAX(ask), MIN(ask) FROM table
WHERE timestamp > ? AND timestamp < ?