Crypto Currencies

date Date	marketcap_usd Marketcap(USD)	price_usd Price(USD)	exchangevolume_usd ExchangeVolume(USD)	realizedcap_usd RealizedCap(USD)
Sun Jul 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		555.89	85013
Mon Jul 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		412.58	190952
Tue Jul 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		441.35	524908
Wed Jul 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		407.08	1784639.9999999998
Thu Jul 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		417.1	533207
Fri Jul 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		386.65	1230160
Sat Jul 29 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		410.57	737815
Sun Jul 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		385.14	606695
Mon Jul 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		346.36	1075960
Tue Aug 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	4855615612.790716	294.6	65988800.00000001	215325143.24102727


CREATE TABLE bch (
  "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
);