Ethereum Effect Impact On PC Parts Prices

Data Warehouse for analysis of Ethereum Effect from 2013 to april 2018

@kaggle.raczeq_ethereum_effect_pc_parts

Fact Crypto Rate

@kaggle.raczeq_ethereum_effect_pc_parts.fact_crypto_rate

codeid CodeId	timeid TimeId	open Open	close Close	high High	low Low
1	20171103	0.021418	0.022628	0.023213	0.019827
1	20171104	0.022641	0.022022	0.023849	0.02197
1	20171105	0.022054	0.020635	0.023006	0.020635
1	20171106	0.020977	0.021881	0.023609	0.020534
1	20171107	0.021846	0.022195	0.023347	0.021414
1	20171108	0.021912	0.025186	0.026393	0.02166
1	20171109	0.02516	0.032053	0.03506	0.025006
1	20171110	0.032219	0.027119	0.033348	0.026451
1	20171111	0.026891	0.027437	0.029659	0.025684
1	20171112	0.027481	0.023977	0.027952	0.022591


CREATE TABLE fact_crypto_rate (
  "codeid" BIGINT,
  "timeid" BIGINT,
  "open" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE
);