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

@kaggle.raczeq_ethereum_effect_pc_parts.fact_ram_price

41.94 MB
3412331 rows
6 columns

prodid ProdId	timeid TimeId	regionid RegionId	merchantid MerchantId	price_usd Price USD	price_original Price Original
1	20130322	4	32	13.7490317583	10.65
1	20130323	4	32	13.8287083986	10.65
1	20130326	4	32	13.6942970003	10.65
1	20130327	4	32	13.6905297528	10.65
1	20130328	4	32	13.6052162271	10.65
1	20130329	4	32	13.6526209186	10.65
1	20130330	4	32	13.6468477703	10.65
1	20130331	4	32	13.6559470688	10.65
1	20130401	4	32	13.6559470688	10.65
1	20130402	4	32	13.6880663196	10.65


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