Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume
1	TRON	TRX	Thu Sep 14 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0024788100272417	0.0012984899803996	0.0020060299430042	0.0014268299564719	58769.69921875
2	TRON	TRX	Fri Sep 15 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.001830660039559	0.001091259997338	0.0014192200032994	0.0018008600454777	26474.80078125
3	TRON	TRX	Sat Sep 16 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0176710002124309	0.0013714199885725	0.0018152199918404	0.0018311199964955	54534.69921875
4	TRON	TRX	Sun Sep 17 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0038786400109529	0.001781339989975	0.0018356599612161	0.003319920040667	124998
5	TRON	TRX	Mon Sep 18 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0034380799625068	0.0025343899615108	0.0033236199524253	0.0032625100575387	159158
6	TRON	TRX	Tue Sep 19 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0232378002256155	0.0017455200431868	0.0032728700898587	0.0022913101129233	158416
7	TRON	TRX	Wed Sep 20 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0031990299466997	0.0020388399716466	0.0023057200014591	0.0026474099140614	83399.296875
8	TRON	TRX	Thu Sep 21 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0031731699127703	0.0019350299844518	0.0026381500065326	0.0020792998839169	99852.5
9	TRON	TRX	Fri Sep 22 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0021721399389207	0.0018523399485275	0.0020788100082427	0.0019509800476953	38829.30078125
10	TRON	TRX	Sat Sep 23 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0023456800263375	0.0019244600553065	0.0019340600119903	0.0023456800263375	42314.30078125


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