CREATE TABLE trades (
	id INTEGER NOT NULL,
	exchange VARCHAR NOT NULL,
	pair VARCHAR NOT NULL,
	is_open BOOLEAN NOT NULL,
	fee FLOAT NOT NULL,
	open_rate FLOAT,
	close_rate FLOAT,
	close_profit FLOAT,
	stake_amount FLOAT NOT NULL,
	amount FLOAT,
	open_date DATETIME NOT NULL,
	close_date DATETIME,
	open_order_id VARCHAR,
	PRIMARY KEY (id),
	CHECK (is_open IN (0, 1))
);

SELECT * FROM trades;

UPDATE trades
SET is_open=0, close_date=<close_date>, close_rate=<close_rate>, close_profit=close_rate/open_rate  
WHERE id=<trade_ID_to_update>;

UPDATE trades
SET is_open=0, close_date='2017-12-20 03:08:45.103418', close_rate=0.19638016, close_profit=0.0496  
WHERE id=31;

UPDATE trades SET fee=0.0025 WHERE fee=0.005;