import pandas as pd
import numpy as np
import io

#----------------------------------------------------------

preds = 'test_predictions.json'

data = pd.read_json(preds).values

df = pd.DataFrame(data)

coins = []
old = 'Poloniex_ETH_BTC'
print data[0]
#itterates through all rows in data array and prints the datatime for the first and last prediction for each asset
for i,coin in enumerate(data):
    current = coin[0]
    if current != old:
        print data[i-1][0], pd.to_datetime(int(data[i-1][2]), unit='s'), data[i-1][2]
        print coin[0], pd.to_datetime(int(coin[2]), unit='s'), coin[2]
        old = current