Crypto Currencies

date Date	txvolume_usd TxVolume(USD)	adjustedtxvolume_usd AdjustedTxVolume(USD)	txcount TxCount	marketcap_usd Marketcap(USD)	price_usd Price(USD)	exchangevolume_usd ExchangeVolume(USD)	realizedcap_usd RealizedCap(USD)	generatedcoins GeneratedCoins	fees Fees	activeaddresses ActiveAddresses	averagedifficulty AverageDifficulty	paymentcount PaymentCount	mediantxvalue_usd MedianTxValue(USD)	medianfee MedianFee	blocksize BlockSize	blockcount BlockCount
Fri Oct 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			406				2120522.78233888	123.02365136	0.0387728	964	3089.31104812903	880		0.0001	1677725	629
Sat Oct 29 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	8233044.748950409	2162291.667813354	5366	2044703.1038068545	4293.37	2532790	1771699.61994867	349.73217668	0.25014267	8245	28788.9746052999	8567	767.8801725935	0.0000116	5464079	608
Sun Oct 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	8473726.453769626	1928766.8493782156	7198	2093165.1695487285	2014.38	1009210	1721756.05383726	554.91290726	0.2590202	12549	49127.073770675	20764	737.5770009792001	0.00001159	5706404	586
Mon Oct 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4866266.259593758	828426.3119779323	5830	1033211.8735611666	570.91	4333820	3130605.29420483	767.92263534	0.25981363	13352	52372.6807117671	31110	428.564952609	0.00001159	5941939	586
Tue Nov 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	11592612.461093413	2800461.614478318	5588	4464784.528318863	1599.72	4802060	4338745.88053683	972.24066653	0.30023121	15724	73176.4627571175	35890	1254.82556709	0.00001159	5741042	581
Wed Nov 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	11768232.089284908	2824510.296409266	6922	5257220.942818049	1326.29	3936160	5245888.21339326	1165.93871891	0.41087831	19183	88350.6341473656	46342	1248.5428536742	0.00004407	6554648	572
Thu Nov 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	10083564.886857832	2303827.893796251	6844	5017614.192976129	940.66	2783300	6376202.64552576	1369.4076097	0.55510851	20269	102690.444099769	53458	857.0925839742	0.00008708	6343244	572
Fri Nov 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	7872807.432870693	2531896.421579326	7208	6170747.835590581	887.66	2469390	7196602.13080179	1613.23521831	0.33327751	21782	125429.544687378	67212	796.174254143	0.00001159	7729436	586
Sat Nov 05 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2928623.0650865138	1993165.0293735648	3925	5257719.228015935	599.52	1984150	7975159.60407969	1799.58306901	0.3127255	19099	163863.301827818	91492	182.9175268176	0.0001	8446351	579
Sun Nov 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2513930.4425424733	2138500.866935429	3185	5428943.960284658	504.27	2390590	8289650.69223427	1987.56421187	0.33259283	18802	182194.161948332	99627	51.1684029675	0.0001	8687900	571


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