Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume	marketcap Marketcap
1	Binance Coin	BNB	Wed Jul 26 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1090129986405372	0.0992655009031295	0.10589300096035	0.1051379963755607	200395	10513800
2	Binance Coin	BNB	Thu Jul 27 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1084790006279945	0.1008879989385604	0.1051080003380775	0.1077369973063469	344499	10773700
3	Binance Coin	BNB	Fri Jul 28 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1090189963579177	0.1014730036258697	0.107632003724575	0.1040669977664947	342568	10406700
4	Binance Coin	BNB	Sat Jul 29 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1112639978528022	0.1011079996824264	0.1047820001840591	0.1078109964728355	340218	10781100
5	Binance Coin	BNB	Sun Jul 30 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1081380024552345	0.1031619980931282	0.1079349964857101	0.1064139977097511	224261	10641400
6	Binance Coin	BNB	Mon Jul 31 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1083490028977394	0.1015999987721443	0.1068279966711998	0.1042499989271164	240309	10425000
7	Binance Coin	BNB	Tue Aug 01 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1062659993767738	0.0961093977093696	0.1045949980616569	0.0998668000102043	300413	9986680
8	Binance Coin	BNB	Wed Aug 02 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1012109965085983	0.0973611995577812	0.0997212007641792	0.1004519984126091	256793	10045200
9	Binance Coin	BNB	Thu Aug 03 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.1069779992103576	0.0991197004914283	0.1003279983997345	0.1066420003771781	293008	10664200
10	Binance Coin	BNB	Fri Aug 04 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.107755996286869	0.1026989966630935	0.106684997677803	0.1074939966201782	287621	10749400


CREATE TABLE coin_binancecoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);