Crypto Currencies

date Date	txcount TxCount	generatedcoins GeneratedCoins	fees Fees	activeaddresses ActiveAddresses	averagedifficulty AverageDifficulty	paymentcount PaymentCount	medianfee MedianFee	blocksize BlockSize	blockcount BlockCount
Fri Jan 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)		100		2	0.000244140625			372	2
Sat Jan 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1428	477450	0.117	5867	0.0086517694205133	191		2235295	9549
Sun Jan 12 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2279	144500	0.811	3611	0.186774280631794	1739		1335176	2890
Mon Jan 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1637	55600	1.031	2135	0.61129974068615	1569	0.001	743900	1112
Tue Jan 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1456	57250	3.44604701	2208	1.03501732232792	1400	0.001	873737	1145
Wed Jan 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1744	48800	5.33900769	2707	1.43780166739795	1513	0.001	874694	976
Thu Jan 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1307	35400	2.007	2048	1.7328275105616	1310	0.001	625917	708
Fri Jan 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	617	19350	1.31800002	915	2.25693224371105	567	0.001	284326	387
Sat Jan 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	980	22100	0.705	1453	2.25693224371105	925	0.001	525851	442
Sun Jan 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1621	38050	2.966	1949	2.2569322437111	1599	0.001	679812	761


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