Help for this page

Select Code to Download


  1. 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
    
  2. or download this
    SELECT * FROM table WHERE timestamp > ? AND timestamp < ?
    
  3. or download this
    SELECT MAX(bid), MIN(bid), MAX(ask), MIN(ask) FROM table 
    WHERE timestamp > ? AND timestamp < ?