Binance Bitcoin Dataset - Dataworm
Merged and cleaned bitcoin dataset
@kaggle.tzelal_binance_bitcoin_dataset
Merged and cleaned bitcoin dataset
@kaggle.tzelal_binance_bitcoin_dataset
This dataset collected from https://data.binance.vision/ and merged.
You can explore byself and work on it.
Note: This is public data of binance everyone can access it. I only merge large files that you don't need to do it.
1. Quote Asset Volume: The total volume of the quote currency traded during the interval. Format: A floating-point number. The quote asset is the second currency in the trading pair (e.g., USDT in BTC/USDT).
2. Number of Trades: The total number of trades that took place during the interval. Format: An integer representing the number of trades.
3. Taker Buy Base Asset Volume: The amount of the base asset bought by takers during the interval. Format: A floating-point number. The base asset is the first currency in the trading pair (e.g., BTC in BTC/USDT).
4. Taker Buy Quote Asset Volume: The amount of the quote asset spent by takers to buy the base asset during the interval. Format: A floating-point number.
5. Ignore: This column is often present but usually contains no relevant data. It may be a placeholder for future data or included for backward compatibility. Format: This column typically contains zeros or null values.
CREATE TABLE combined_btcusdt_12h_2017_08_17_to_2024_08_27 (
  "open_time" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" TIMESTAMP,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset_volume" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" BIGINT
);CREATE TABLE combined_btcusdt_15m_2017_08_17_to_2024_08_27 (
  "open_time" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" TIMESTAMP,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset_volume" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" BIGINT
);CREATE TABLE combined_btcusdt_1d_2017_08_17_to_2024_08_27 (
  "open_time" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" TIMESTAMP,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset_volume" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" BIGINT
);CREATE TABLE combined_btcusdt_1h_2017_08_17_to_2024_08_27 (
  "open_time" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" TIMESTAMP,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset_volume" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" BIGINT
);CREATE TABLE combined_btcusdt_1m_2017_08_17_to_2024_08_27 (
  "open_time" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" TIMESTAMP,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset_volume" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" BIGINT
);CREATE TABLE combined_btcusdt_5m_2017_08_17_to_2024_08_27 (
  "open_time" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" TIMESTAMP,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset_volume" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" BIGINT
);Anyone who has the link will be able to view this.