Crypto Currencies

date Date	txcount TxCount	generatedcoins GeneratedCoins	fees Fees	activeaddresses ActiveAddresses	averagedifficulty AverageDifficulty	paymentcount PaymentCount	medianfee MedianFee	blocksize BlockSize	blockcount BlockCount
Sat Jan 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	192	145751	0.0094954	236	10.9647530239293	333	0.0000374	169423	344
Sun Jan 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1097	342250	0.12707451	1196	67.4139194689226	14727	0.00009099	1586306	1369
Mon Feb 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1010	340250	0.21612536	1128	71.7907314364253	11683	0.00008175000000000001	2425551	1361
Tue Feb 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	725	341500	0.17238578	900	112.380197194003	8236	0.00008868	1936186	1366
Wed Feb 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	666	338500	0.11885602	858	68.1294118303333	4440	0.00005805	1490463	1354
Thu Feb 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	778	338250	0.10105215	986	80.0642987470476	1837	0.0000373	1174990	1353
Fri Feb 05 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	617	335500	0.09982895	840	91.9190054238271	1687	0.00003776	1282189	1342
Sat Feb 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	766	332250	0.11007532	985	55.3641773788715	1156	0.00002297	1332803	1329
Sun Feb 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	886	344500	0.05766032	1113	44.256366282219	1140	0.00002312	838219	1378
Mon Feb 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	363	340250	0.04415228	618	90.9443467415988	568	0.00005218	732754	1361


CREATE TABLE pivx (
  "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" DOUBLE,
  "mediantxvalue_usd" DOUBLE,
  "medianfee" DOUBLE,
  "blocksize" BIGINT,
  "blockcount" BIGINT
);