Name: TOP 50 Cryptocurrencies Historical Prices
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

TOP 50 Cryptocurrencies Historical Prices

Context

The dataset contains all historical daily prices (open, high, low, close) for the top 50 Cryptocurrency

Content

The dataset has 50 different CSV files for each of the top 50 cryptocurrencies. Price history is available on a daily basis from the launch of that respective cryptocurrency. The dataset also contains an ALL_COMBINED CSV file, which contains the combined data for all the TOP50 cryptocurrencies in one CSV file.
Attribute Information:

SNo: Serial Number 
Date: Date of observation
Price: Price on the given day (Also the closing price for that day)
Open: Opening price on the given day
High: Highest price on the given day
Low: Lowest price on the given day
Volume: Volume of transactions on the given day
Change%: Percentage Change from the previous day

Acknowledgements

This data is taken from https://www.investing.com and is free to use. Check details here

Cover Image: Photo by Executium on Unsplash.

Inspiration

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

Which currencies are the most volatile?
Predicting the future price of the currencies
How does the price fluctuations of currencies correlate with each other?
What day of the week is best to buy/sell?
How does the price fluctuations of currencies correlate with each other?
Seasonal trend in the price fluctuations

Tables

Aave

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.aave

43.62 KB
1275 rows
8 columns


CREATE TABLE aave (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Algorand

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.algorand

46.09 KB
757 rows
8 columns


CREATE TABLE algorand (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

All Combined

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.all_combined

1.85 MB
53835 rows
8 columns


CREATE TABLE all_combined (
  "currency_name" VARCHAR,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Avalanche

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.avalanche

17.07 KB
243 rows
8 columns


CREATE TABLE avalanche (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Axie Infinity

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.axie_infinity

7.81 KB
34 rows
8 columns


CREATE TABLE axie_infinity (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Binance Coin

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.binance_coin

63.47 KB
1385 rows
8 columns


CREATE TABLE binance_coin (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Binance Usd

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.binance_usd

9.29 KB
124 rows
8 columns


CREATE TABLE binance_usd (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Bitcoin

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.bitcoin

175.1 KB
4056 rows
8 columns


CREATE TABLE bitcoin (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Bitcoin Bep2

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.bitcoin_bep2

11.5 KB
121 rows
8 columns


CREATE TABLE bitcoin_bep2 (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Bitcoin Cash

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.bitcoin_cash

75.9 KB
1483 rows
8 columns


CREATE TABLE bitcoin_cash (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Bitcoin Sv

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.bitcoin_sv

51.85 KB
1010 rows
8 columns


CREATE TABLE bitcoin_sv (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Bittorrent

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.bittorrent

44.97 KB
790 rows
8 columns


CREATE TABLE bittorrent (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Cardano

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.cardano

87.75 KB
1333 rows
8 columns


CREATE TABLE cardano (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Chainlink

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.chainlink

54.51 KB
1300 rows
8 columns


CREATE TABLE chainlink (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Cosmos

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.cosmos

53.78 KB
833 rows
8 columns


CREATE TABLE cosmos (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Crypto Com Coin

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.crypto_com_coin

50.6 KB
957 rows
8 columns


CREATE TABLE crypto_com_coin (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Dai

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.dai

68.32 KB
1297 rows
8 columns


CREATE TABLE dai (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Dash

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.dash

82.6 KB
1635 rows
8 columns


CREATE TABLE dash (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Dogecoin

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.dogecoin

90.4 KB
1544 rows
8 columns


CREATE TABLE dogecoin (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Elrond

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.elrond

22.8 KB
392 rows
8 columns


CREATE TABLE elrond (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Eos

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.eos

86.65 KB
1515 rows
8 columns


CREATE TABLE eos (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Ethereum

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.ethereum

96.91 KB
1994 rows
8 columns


CREATE TABLE ethereum (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Ethereum Classic

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.ethereum_classic

100.17 KB
1854 rows
8 columns


CREATE TABLE ethereum_classic (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Filecoin

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.filecoin

57.54 KB
1299 rows
8 columns


CREATE TABLE filecoin (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);

Ftx Token

@kaggle.odins0n_top_50_cryptocurrency_historical_prices.ftx_token

41.52 KB
614 rows
8 columns


CREATE TABLE ftx_token (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "price" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "vol" DOUBLE,
  "change" DOUBLE
);