K线数据库表结构

 

--
-- 数据库: `bittrex`
--

-- --------------------------------------------------------

--
-- 表的结构 `ltc`
--

DROP TABLE IF EXISTS `ltc`;
CREATE TABLE IF NOT EXISTS `ltc` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `timestamp` varchar(10) NOT NULL,
  `datetime` datetime NOT NULL,
  `open` float(20,8) NOT NULL,
  `close` float(20,8) NOT NULL,
  `high` float(20,8) NOT NULL,
  `low` float(20,8) NOT NULL,
  `volume` float(20,8) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1440 ;

--
-- 转存表中的数据 `ltc`
--

INSERT INTO `ltc` (`id`, `timestamp`, `datetime`, `open`, `close`, `high`, `low`, `volume`) VALUES
(1, '1504231200', '2017-09-01 10:00:00', 0.0152578, 0.01535, 0.01535, 0.0151101, 7564.68),
(2, '1504234800', '2017-09-01 11:00:00', 0.0153596, 0.015645, 0.0156665, 0.015305, 14360.2),
(3, '1504238400', '2017-09-01 12:00:00', 0.015645, 0.01585, 0.01605, 0.01561, 20670.2);

 

转载于:https://www.cnblogs.com/fangbei/p/kline-table.html