Popular Cryptocurrency Historical Data
Historical data on top 10 cryptocurrencies (as of Dec 04, 21)
@kaggle.nward7_popular_cryptocurrency_historical_data
Historical data on top 10 cryptocurrencies (as of Dec 04, 21)
@kaggle.nward7_popular_cryptocurrency_historical_data
These are historical datasets of the current top 10 most popular cryptocurrencies.
As of now:
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
Found all the historical data from website: https://coinmarketcap.com/
CREATE TABLE binance (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE bitcoin (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE cardano (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE ethereum (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE polkadot (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE solana (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE terra (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE tether (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE usd_coin (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);CREATE TABLE xrp (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"market_cap" BIGINT
);Anyone who has the link will be able to view this.