Complete Historical Cryptocurrency Financial Data

Top 200 Cryptocurrencies by Marketcap

@kaggle.philmohun_cryptocurrency_financial_data

Table List

1 table(809.93 KB)

Consolidated Coin Data

@kaggle.philmohun_cryptocurrency_financial_data.consolidated_coin_data

809.93 KB
28944 rows
8 columns

currency Currency	date Date	open Open	high High	low Low	close Close	volume Volume	market_cap Market Cap
tezos	Wed Dec 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.29	1.32	1.25	1.25	46048752	824588509
tezos	Tue Dec 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.24	1.32	1.21	1.29	41462224	853213342
tezos	Mon Dec 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.25	1.26	1.2	1.24	27574097	817872179
tezos	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.33	1.34	1.25	1.25	24127567	828296390
tezos	Sat Nov 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.31	1.37	1.31	1.33	28706667	879181680
tezos	Fri Nov 29 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.28	1.34	1.28	1.31	32270224	867085098
tezos	Thu Nov 28 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.26	1.35	1.22	1.28	44240281	845073679
tezos	Wed Nov 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.24	1.27	1.16	1.26	47723271	829672736
tezos	Tue Nov 26 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.24	1.28	1.23	1.24	54828808	822065277
tezos	Mon Nov 25 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1.33	1.33	1.21	1.24	64954006	815688075


CREATE TABLE consolidated_coin_data (
  "currency" VARCHAR,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "market_cap" BIGINT
);