extract candlestick data via SQL - original suggestion http://textuploader.com/IzDbe

gistfile1.txt

// schema is
// trades(tid integer,amount real,price real,date integer);

SELECT 
    strftime('%Y-%m-%dT%H:%M:%S', (cast(date as integer)/86400) * 86400, 'unixepoch'),
    MIN(date),
    MAX(date),
    MIN(price),
    MAX(price),
    SUM(amount)
FROM trades 
    WHERE date >= strftime('%s', '2013-01-01 00:00') 
    AND date <  strftime('%s', '2013-01-04 00:00') 
GROUP BY date/(86400)
ORDER BY date ASC;