Bitcoin Data
bitcoin historical data
@kaggle.skanderhaddad_bitcoin_data
bitcoin historical data
@kaggle.skanderhaddad_bitcoin_data
CREATE TABLE btc_data_bi_day (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"close_time" BIGINT,
"quote_asset_volume" DOUBLE,
"number_of_trades" BIGINT,
"taker_buy_base_asset" DOUBLE,
"taker_buy_quote_asset_volume" DOUBLE,
"ignore" DOUBLE
);
CREATE TABLE btc_data_bi_hour (
"date" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"close_time" BIGINT,
"quote_asset_volume" DOUBLE,
"number_of_trades" BIGINT,
"taker_buy_base_asset" DOUBLE,
"taker_buy_quote_asset_volume" DOUBLE,
"ignore" DOUBLE
);
CREATE TABLE btc_data_bi_min (
"date" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"close_time" BIGINT,
"quote_asset_volume" DOUBLE,
"number_of_trades" BIGINT,
"taker_buy_base_asset" DOUBLE,
"taker_buy_quote_asset_volume" DOUBLE,
"ignore" DOUBLE
);
CREATE TABLE btc_day (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);
CREATE TABLE btc_week (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);
Anyone who has the link will be able to view this.