Bitcoin Historical Dataset
BITCOIN(BTC-USD) Minute, Hourly and Daily interval data.
@kaggle.prasoonkottarathil_btcinusd
BITCOIN(BTC-USD) Minute, Hourly and Daily interval data.
@kaggle.prasoonkottarathil_btcinusd
CREATE TABLE btc_2017min (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usd" DOUBLE
);
CREATE TABLE btc_2018min (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usd" DOUBLE
);
CREATE TABLE btc_2019min (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usd" DOUBLE
);
CREATE TABLE btc_2020min (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usd" DOUBLE
);
CREATE TABLE btc_2021min (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usd" DOUBLE
);
CREATE TABLE btc_daily (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usd" DOUBLE
);
CREATE TABLE btc_hourly (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usd" DOUBLE
);
Anyone who has the link will be able to view this.