Cryptocurrency Historical Prices
Prices of top cryptocurrencies including BTC, ETH, ADA, DOT and BNB
@kaggle.sudalairajkumar_cryptocurrencypricehistory
Prices of top cryptocurrencies including BTC, ETH, ADA, DOT and BNB
@kaggle.sudalairajkumar_cryptocurrencypricehistory
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:
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.
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.
This data is taken from coinmarketcap and it is free to use the data.
Cover Image : Photo by Thomas Malama on Unsplash
Some of the questions which could be inferred from this dataset are:
CREATE TABLE coin_aave (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_binancecoin (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_bitcoin (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_cardano (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_chainlink (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_cosmos (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_cryptocomcoin (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_dogecoin (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_eos (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_ethereum (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_iota (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_litecoin (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_monero (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_nem (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_polkadot (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_solana (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_stellar (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_tether (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_tron (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_uniswap (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_usdcoin (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_wrappedbitcoin (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);CREATE TABLE coin_xrp (
"sno" BIGINT,
"name" VARCHAR,
"symbol" VARCHAR,
"date" TIMESTAMP,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"marketcap" DOUBLE
);Anyone who has the link will be able to view this.