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 Cpu Price

@kaggle.raczeq_ethereum_effect_pc_parts.fact_cpu_price

19.67 MB
1605191 rows
6 columns

prodid ProdId	timeid TimeId	regionid RegionId	merchantid MerchantId	price_usd Price USD	price_original Price Original
1	20160410	1	33	30.2286038164	40
1	20160410	3	80	28.8665825045	37.5
1	20160410	4	43	36.3114165555	31.86
1	20160410	10	30	32.4629000473	22.98
1	20160410	10	45	37.3930793844	26.47
1	20160410	10	62	49.4006794889	34.97
1	20160410	11	55	29.98	29.98
1	20160410	11	78	25.99	25.99
1	20160411	4	43	36.2430334735	31.8
1	20160412	4	43	36.2026252036	31.74


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