mysql> select * from HistoryBar limit 5 ; +-----+-----+-----+---------------------+------------+------------+------------+------------+-----+------------+----------+ | uid | cid | bid | time | open | high | low | close | vol | wap | has_gaps | +-----+-----+-----+---------------------+------------+------------+------------+------------+-----+------------+----------+ | 1 | 178 | 2 | 2007-05-09 16:30:10 | 13382.0000 | 13382.0000 | 13382.0000 | 13382.0000 | 0 | 13382.0000 | 0 | | 2 | 178 | 2 | 2007-05-09 16:30:15 | 13382.0000 | 13382.0000 | 13382.0000 | 13382.0000 | 0 | 13382.0000 | 0 | | 3 | 178 | 2 | 2007-05-09 16:30:20 | 13382.0000 | 13382.0000 | 13382.0000 | 13382.0000 | 0 | 13382.0000 | 0 | | 4 | 178 | 2 | 2007-05-09 16:30:25 | 13382.0000 | 13382.0000 | 13382.0000 | 13382.0000 | 3 | 13382.0000 | 0 | | 5 | 178 | 2 | 2007-05-09 16:30:30 | 13381.0000 | 13382.0000 | 13381.0000 | 13382.0000 | 10 | 13382.0000 | 0 | +-----+-----+-----+---------------------+------------+------------+------------+------------+-----+------------+----------+