TOP 50 Cryptocurrencies Historical Prices
Daily Prices(OPEN ,CLOSE , HIGH , LOW) of the TOP 50 Cryptocurrencies
@kaggle.odins0n_top_50_cryptocurrency_historical_prices
Daily Prices(OPEN ,CLOSE , HIGH , LOW) of the TOP 50 Cryptocurrencies
@kaggle.odins0n_top_50_cryptocurrency_historical_prices
The dataset contains all historical daily prices (open, high, low, close) for the top 50 Cryptocurrency
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
This data is taken from https://www.investing.com and is free to use. Check details here
Cover Image: Photo by Executium on Unsplash.
Some of the questions which could be inferred from this dataset are:
CREATE TABLE aave (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE algorand (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE all_combined (
"currency_name" VARCHAR,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE avalanche (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE axie_infinity (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE binance_coin (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE binance_usd (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE bitcoin (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE bitcoin_bep2 (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE bitcoin_cash (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE bitcoin_sv (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE bittorrent (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE cardano (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE chainlink (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE cosmos (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE crypto_com_coin (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE dai (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE dash (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE dogecoin (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE elrond (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE eos (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE ethereum (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE ethereum_classic (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE filecoin (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);CREATE TABLE ftx_token (
"sno" BIGINT,
"date" TIMESTAMP,
"price" DOUBLE,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"vol" DOUBLE -- Vol.,
"change" DOUBLE -- Change %
);Anyone who has the link will be able to view this.