signal_heartbeat=# select * from ohlcs order by timestamp_start limit 10;
     timestamp_start      |      timestamp_end       | symbol |  open  |  high  |  low   | close  |      ha_open      |      ha_high      |      ha_low       |     ha_close
--------------------------+--------------------------+--------+--------+--------+--------+--------+-------------------+-------------------+-------------------+-------------------
 2016-12-31T23:00:00.000Z | 2017-01-01T00:00:00.000Z | XBTUSD | 964.62 | 968.36 | 963.5  | 968.29 |                   |                   |                   |
 2017-01-01T00:00:00.000Z | 2017-01-01T01:00:00.000Z | XBTUSD | 968.29 | 968.76 | 964.54 | 968    | 968.145           | 968.76            | 964.54            | 967.3975
 2017-01-01T01:00:00.000Z | 2017-01-01T02:00:00.000Z | XBTUSD | 968    | 968.1  | 963.4  | 963.4  | 967.77125         | 968.1             | 963.4             | 965.725
 2017-01-01T02:00:00.000Z | 2017-01-01T03:00:00.000Z | XBTUSD | 963.4  | 964.6  | 963.16 | 964.26 | 966.7481250000001 | 966.7481250000001 | 963.16            | 963.855
 2017-01-01T03:00:00.000Z | 2017-01-01T04:00:00.000Z | XBTUSD | 964.26 | 965    | 961.69 | 961.69 | 965.3015625       | 965.3015625       | 961.69            | 963.16
 2017-01-01T04:00:00.000Z | 2017-01-01T05:00:00.000Z | XBTUSD | 961.69 | 962.1  | 960.9  | 961.99 | 964.2307812500001 | 964.2307812500001 | 960.9             | 961.6700000000001
 2017-01-01T05:00:00.000Z | 2017-01-01T06:00:00.000Z | XBTUSD | 961.99 | 968.86 | 961.99 | 964.47 | 962.9503906250001 | 968.86            | 961.99            | 964.3275000000001
 2017-01-01T06:00:00.000Z | 2017-01-01T07:00:00.000Z | XBTUSD | 964.47 | 967.77 | 964    | 967.77 | 963.6389453125    | 967.77            | 963.6389453125    | 966.0024999999999
 2017-01-01T07:00:00.000Z | 2017-01-01T08:00:00.000Z | XBTUSD | 967.77 | 968.23 | 966.64 | 967.5  | 964.8207226562499 | 968.23            | 964.8207226562499 | 967.535
 2017-01-01T08:00:00.000Z | 2017-01-01T09:00:00.000Z | XBTUSD | 967.5  | 967.09 | 965.43 | 965.56 | 966.1778613281249 | 967.09            | 965.43            | 966.395
(10 rows)

(END)