Cryptocurrency Timeseries 2020
Bitcoin, Ethereum and Litecoin value and volume data by the minute
@kaggle.roopahegde_cryptocurrency_timeseries_2020
Bitcoin, Ethereum and Litecoin value and volume data by the minute
@kaggle.roopahegde_cryptocurrency_timeseries_2020
This dataset is about the value of Bitcoin, Ethereum and Litecoin in USD and volume transacted of each currency between Jan-1-2020 and Apr-19-2021. Data is collected for ever minute between these two dates from the open of stock exchange to close.
Unix Timestamp - Date represented as epoc value
Date - date and time when the data point was collected
Symbol - Symbol of the currency
Open - Open value of the currency
High - Highest value of currency in the given minute
Low - Lowest value of currency in the given minute
Close - Close value of the currency in the given minute
Volume - Volume of the currency transacted in the given minute.
Thanks to the team @https://www.CryptoDataDownload.com for making this data available for public
An attempt to understand and learn timeseries data analysis.
CREATE TABLE gemini_btcusd_2020_1min (
"unix_timestamp" DOUBLE,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE gemini_ethusd_2020_1min (
"unix_timestamp" DOUBLE,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE gemini_ltcusd_2020_1min (
"unix_timestamp" DOUBLE,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.