Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	marketcap Marketcap
1	Bitcoin	BTC	Mon Apr 29 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	147.48800659179688	134	134.44400024414062	144.5399932861328	1603768864.5
2	Bitcoin	BTC	Tue Apr 30 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	146.92999267578125	134.0500030517578	144	139	1542813125
3	Bitcoin	BTC	Wed May 01 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	139.88999938964844	107.72000122070312	139	116.98999786376952	1298954593.75
4	Bitcoin	BTC	Thu May 02 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	125.5999984741211	92.28189849853516	116.37999725341795	105.20999908447266	1168517495.25
5	Bitcoin	BTC	Fri May 03 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	108.12799835205078	79.0999984741211	106.25	97.75	1085995168.75
6	Bitcoin	BTC	Sat May 04 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	115	92.5	98.0999984741211	112.5	1250316562.5
7	Bitcoin	BTC	Sun May 05 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	118.8000030517578	107.14299774169922	112.9000015258789	115.91000366210938	1288693175.5
8	Bitcoin	BTC	Mon May 06 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	124.66300201416016	106.63999938964844	115.9800033569336	112.3000030517578	1249023060
9	Bitcoin	BTC	Tue May 07 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	113.44400024414062	97.6999969482422	112.25	111.5	1240593600
10	Bitcoin	BTC	Wed May 08 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	115.77999877929688	109.5999984741211	109.5999984741211	113.56600189208984	1264049202.15


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