Coinmarketcap Historical Data

Historical ranking, price, market cap etc of all coins on coinmarketcap.com

@kaggle.bizzyvinci_coinmarketcap_historical_data

Table List

2 tables(396.78 MB)

Historical

@kaggle.bizzyvinci_coinmarketcap_historical_data.historical

391.99 MB
4441972 rows
19 columns

date Date	coin_id Coin Id	cmc_rank Cmc Rank	market_cap Market Cap	price Price	open Open	high High	low Low	close Close	time_high Time High	time_low Time Low	percent_change_1h Percent Change 1h	percent_change_24h Percent Change 24h	circulating_supply Circulating Supply	total_supply Total Supply	max_supply Max Supply
Sun Apr 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	1488566971.95587	134.210021972656					nan	nan	0.639231		11091325	11091325	21000000
Sun Apr 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2	2	74637021.5679073	4.34840488433838					nan	nan	0.799273		17164230	17164230	84000000
Sun Apr 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	5	3	7250186.64768828	0.386524856090546					nan	nan	-0.934763		18757362	18757362
Sun Apr 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	3	4	5995997.18538521	1.10723268985748					nan	nan	-0.0505028		5415300	5415300
Sun Apr 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	4	5	1503099.40113884	0.646892309188843					nan	nan	0.609159		2323569.75	2323569.75	42000000
Sun Apr 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	7	6	1424087.29757242	0.000326130335452					nan	nan	0.461694		4366620160	4366620160
Sun Apr 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	6	7	1162266.29565105	4.24640512466431					nan	nan	2.13819		273705.9375	273705.9375
Mon Apr 29 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	1603768790.00511	144.539993286133	134.444000244141	147.488006591797	134	144.539993286133	13:15:01	05:20:01	1.22996	7.63553	11095675	11095675	21000000
Mon Apr 29 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	2	2	75388933.8888073	4.38389825820923	4.36675977706909	4.57359981536865	4.22563982009888	4.38390016555786	13:15:01	19:25:02	0.16764	0.920718	17196780	17196780	84000000
Mon Apr 29 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	5	3	7673907.76031256	0.408860594034195	0.387199997901917	0.42476499080658	0.377907991409302	0.408861011266708	13:15:03	04:05:04	-1.22647		18769008	18769008


CREATE TABLE historical (
  "date" TIMESTAMP,
  "coin_id" BIGINT,
  "cmc_rank" BIGINT,
  "market_cap" DOUBLE,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "time_high" VARCHAR,
  "time_low" VARCHAR,
  "volume_24h" DOUBLE,
  "percent_change_1h" DOUBLE,
  "percent_change_24h" DOUBLE,
  "percent_change_7d" DOUBLE,
  "circulating_supply" DOUBLE,
  "total_supply" DOUBLE,
  "max_supply" DOUBLE,
  "num_market_pairs" DOUBLE
);