Crypto Currencies

date Date	price_usd Price(USD)	exchangevolume_usd ExchangeVolume(USD)
Mon Oct 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	479.82	7652060
Tue Oct 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	498.44	23301700
Wed Oct 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	143.15	16040700
Thu Oct 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	137.03	11556600
Fri Oct 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	137.24	8217860
Sat Oct 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	120.52	5635800
Sun Oct 29 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	115.92	11295300
Mon Oct 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	138.65	6730380
Tue Oct 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	133.84	18906800
Wed Nov 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	157.02	14898100


CREATE TABLE btg (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "adjustedtxvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "realizedcap_usd" DOUBLE,
  "generatedcoins" DOUBLE,
  "fees" DOUBLE,
  "activeaddresses" DOUBLE,
  "averagedifficulty" DOUBLE,
  "paymentcount" DOUBLE,
  "mediantxvalue_usd" DOUBLE,
  "medianfee" DOUBLE,
  "blocksize" DOUBLE,
  "blockcount" DOUBLE
);