Name: Coinmarketcap Historical Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Coinmarketcap Historical Data

Have you ever wondered what the ranking on coinmarketcap was like in 2013 or on the Christmas of 2017?
Or how Bitcoin, Ethereum, or Doge has evolved over their lifetime.

Coinmarketcap started ranking cryptocurrencies on 2013-04-28, and this dataset contains all that ranking, price, OHLCV, supplies. It also has metadata of each coin in the coins table. Be careful, id is used because 2 or more cryptocurrencies can have the same symbol, and or a coin could change symbol over time. This dataset would be updated monthly to stay up to date.

Historical

The dataset contains historical csv&table, which is scraped from coinmarketcap historical snapshot and OHLC columns were scraped from each coin's historical-data page. One thing to note is that the rows scraped for each date are not just the top 100 or 200 but everything. Some days have over 4000 coins.

The columns are date, coin_id, cmc_rank, market_cap, price, open, high, low, close, time_high, time_low, volume_24h, percent_change_1h, percent_change_24h, percent_change_7d, circulating_supply, total_supply, max_supply, num_market_pairs.

Coins

This contains almost all the available data about each coin. There's id, name, slug, symbol, status, category, description, subreddit, notice. status==extinct are for coins that are no longer on coimarketcap and therefore the data are gotten from historical. description seems to be in markdown.

Then there's tags, tag_names, website, twitter, message_board, chat, explorer, reddit, technical_doc, source_code, announcement, which are ", " (comma space) seperated list. Then platform_id, date_added, date_launched.

Upvote if you like the dataset. Thanks and enjoy.

Tables

Coins

@kaggle.bizzyvinci_coinmarketcap_historical_data.coins

4.79 MB
8927 rows
23 columns


CREATE TABLE coins (
  "id" BIGINT,
  "name" VARCHAR,
  "slug" VARCHAR,
  "symbol" VARCHAR,
  "status" VARCHAR,
  "category" VARCHAR,
  "description" VARCHAR,
  "subreddit" VARCHAR,
  "notice" VARCHAR,
  "tags" VARCHAR,
  "tag_names" VARCHAR,
  "website" VARCHAR,
  "twitter" VARCHAR,
  "message_board" VARCHAR,
  "chat" VARCHAR,
  "explorer" VARCHAR,
  "reddit" VARCHAR,
  "technical_doc" VARCHAR,
  "source_code" VARCHAR,
  "announcement" VARCHAR,
  "platform_id" DOUBLE,
  "date_added" VARCHAR,
  "date_launched" VARCHAR
);

Historical

@kaggle.bizzyvinci_coinmarketcap_historical_data.historical

391.99 MB
4441972 rows
19 columns


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
);