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

Table List

10 tables(74.41 MB)

Fact Gpu Price

@kaggle.raczeq_ethereum_effect_pc_parts.fact_gpu_price

12.33 MB
997156 rows
6 columns

prodid ProdId	timeid TimeId	regionid RegionId	merchantid MerchantId	price_usd Price USD	price_original Price Original
1	20140917	4	32	601.7384130657	463.9
1	20140918	4	32	551.8852764934	425.87
1	20140919	4	32	548.0988961332	424.53
1	20140920	4	32	545.093859942	424.53
1	20140921	4	32	544.6742449514	424.53
1	20140922	4	32	547.9330784429	427.07
1	20140923	4	32	548.146817479	427.19
1	20140924	4	32	547.7821774798	426.22
1	20140926	4	32	548.2555100896	430.09
1	20140927	4	32	545.6783074825	430.09


CREATE TABLE fact_gpu_price (
  "prodid" BIGINT,
  "timeid" BIGINT,
  "regionid" BIGINT,
  "merchantid" BIGINT,
  "price_usd" DOUBLE,
  "price_original" DOUBLE
);