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

Dim Time

@kaggle.raczeq_ethereum_effect_pc_parts.dim_time

id Id	year Year	month Month	day Day	week Week
20130322	2013	3	22	12
20130323	2013	3	23	12
20130326	2013	3	26	13
20130327	2013	3	27	13
20130328	2013	3	28	13
20130329	2013	3	29	13
20130330	2013	3	30	13
20130331	2013	3	31	13
20130401	2013	4	1	14
20130402	2013	4	2	14


CREATE TABLE dim_time (
  "id" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "week" BIGINT
);