Name: Cryptocurrency Historical Prices
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Cryptocurrency Historical Prices

Context

Things like Block chain, Bitcoin, Bitcoin cash, Ethereum, Ripple etc are constantly coming in the news articles I read. So I wanted to understand more about it and this post helped me get started. Once the basics are done, the data scientist inside me started raising questions like:

How many cryptocurrencies are there and what are their prices and valuations?
Why is there a sudden surge in the interest in recent days?

So what next?
Now that we have the price data, I wanted to dig a little more about the factors affecting the price of coins. I started of with Bitcoin and there are quite a few parameters which affect the price of Bitcoin. Thanks to Blockchain Info, I was able to get quite a few parameters on once in two day basis.

This will help understand the other factors related to Bitcoin price and also help one make future predictions in a better way than just using the historical price.

Content

The dataset has one csv file for each currency. Price history is available on a daily basis from April 28, 2013. This dataset has the historical price information of some of the top crypto currencies by market capitalization.

Date : date of observation
Open : Opening price on the given day
High : Highest price on the given day
Low : Lowest price on the given day
Close : Closing price on the given day
Volume : Volume of transactions on the given day
Market Cap : Market capitalization in USD

Acknowledgements

This data is taken from coinmarketcap and it is free to use the data.

Cover Image : Photo by Thomas Malama on Unsplash

Inspiration

Some of the questions which could be inferred from this dataset are:

How did the historical prices / market capitalizations of various currencies change over time?
Predicting the future price of the currencies
Which currencies are more volatile and which ones are more stable?
How does the price fluctuations of currencies correlate with each other?
Seasonal trend in the price fluctuations

Tables

Coin Aave

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_aave

25.36 KB
275 rows
10 columns


CREATE TABLE coin_aave (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Binancecoin

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_binancecoin

102.38 KB
1442 rows
10 columns


CREATE TABLE coin_binancecoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Bitcoin

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_bitcoin

191.42 KB
2991 rows
10 columns


CREATE TABLE coin_bitcoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Cardano

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_cardano

98.93 KB
1374 rows
10 columns


CREATE TABLE coin_cardano (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Chainlink

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_chainlink

98.24 KB
1385 rows
10 columns


CREATE TABLE coin_chainlink (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Cosmos

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_cosmos

63.82 KB
845 rows
10 columns


CREATE TABLE coin_cosmos (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Cryptocomcoin

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_cryptocomcoin

70.38 KB
935 rows
10 columns


CREATE TABLE coin_cryptocomcoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Dogecoin

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_dogecoin

194.77 KB
2760 rows
10 columns


CREATE TABLE coin_dogecoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Eos

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_eos

104.01 KB
1466 rows
10 columns


CREATE TABLE coin_eos (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Ethereum

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_ethereum

146.38 KB
2160 rows
10 columns


CREATE TABLE coin_ethereum (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Iota

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_iota

105.1 KB
1484 rows
10 columns


CREATE TABLE coin_iota (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Litecoin

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_litecoin

194.1 KB
2991 rows
10 columns


CREATE TABLE coin_litecoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Monero

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_monero

173.03 KB
2602 rows
10 columns


CREATE TABLE coin_monero (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Nem

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_nem

161.46 KB
2288 rows
10 columns


CREATE TABLE coin_nem (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Polkadot

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_polkadot

28.25 KB
320 rows
10 columns


CREATE TABLE coin_polkadot (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Solana

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_solana

36.72 KB
452 rows
10 columns


CREATE TABLE coin_solana (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Stellar

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_stellar

176.67 KB
2527 rows
10 columns


CREATE TABLE coin_stellar (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Tether

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_tether

128.39 KB
2318 rows
10 columns


CREATE TABLE coin_tether (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Tron

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_tron

101.16 KB
1392 rows
10 columns


CREATE TABLE coin_tron (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Uniswap

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_uniswap

26.5 KB
292 rows
10 columns


CREATE TABLE coin_uniswap (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Usdcoin

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_usdcoin

74.65 KB
1002 rows
10 columns


CREATE TABLE coin_usdcoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Wrappedbitcoin

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_wrappedbitcoin

65.44 KB
888 rows
10 columns


CREATE TABLE coin_wrappedbitcoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);

Coin Xrp

@kaggle.sudalairajkumar_cryptocurrencypricehistory.coin_xrp

194.18 KB
2893 rows
10 columns


CREATE TABLE coin_xrp (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);