Name: Top Crypto Exchanges BTC Cold Wallets Transactions
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Top Crypto Exchanges BTC Cold Wallets Transactions

Introduction

This is a collection of the Bitcoin cold wallets' and their transactions for the top 5 crypto exchanges: https://binance.com, https://coinbase.com, https://huobi.com, https://bittrex.com, and https://bitmex.com

Some exchanges have multiple known cold wallets (Binance, Bittrex, Huobi)

Period: some wallets' first transactions appear in 2017 and even earlier. The transactions are up to 3/11/2020. The dataset will be updated on a monthly basis.

Source: research on the exchanges' cold wallets and the data is from https://www.blockchain.com/explorer

Total BTC hold on these wallets is BTC 360k+ ($4,9bn valuation as of 4/11/2020)

Important note: there is no official confirmation from the exchanges that these wallets belong to them, but these wallets are known to belong to the mentioned exchanges in the crypto community. The addresses were found by the author's research

Content

Essentially, the exchange cold wallet is just a normal Bitcoin wallet that is not connected to the internet as there are large amounts of clients' BTC are kept on those for security purposes. You can read more on it here: https://academy.binance.com/en/articles/crypto-wallet-types-explained

For every wallet there is a number of blockchain transactions presented in the following way:

Inspiration

A potential use-case for this data could be an analysis of the Bitcoin price in line with the transactions on the exchanges' cold wallets. These cold wallets are different from most other Bitcoin blockchain wallets as the top exchanges are the only places with decent liquidity on the market. So whoever wants to buy/sell large amounts of BTC - the exchanges are the go-to places.

The Bitcoin price depends quite significantly on the amounts of BTC sold/bought by the large holders so-called "whales". Basically, when these "whales" think the BTC price is going to tank, they decide that it is time to sell their BTC and deposit them into the exchange to sell for stable coins like USDT/USDC. Once that happens the BTC price is usually heavily affected.

Alternatively, when they believe the BTC price is about to go up, they decide to hold it and withdraw their BTC into their own secure wallets. Probably the better analysis might be performed along with the USDT/USDC exchanges' cold wallets, because in the second scenario - people firstly purchase the BTC on the exchange for stable coins.

https://www.kaggle.com/search?q=bitcoin+in%3Adatasets - I am planning to use other datasets available for Bitcoin's variables like price, block sizes, etc. and see if they can be used together. Feel free to do the same. Other info on Bitcoin can be found at https://bitcoin.org

Tables

Binance Cold Wallet 1

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.binance_cold_wallet_1

46.1 kB
451 rows
6 columns

CREATE TABLE binance_cold_wallet_1 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Binance Cold Wallet 2

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.binance_cold_wallet_2

20.1 kB
160 rows
6 columns

CREATE TABLE binance_cold_wallet_2 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Binance Cold Wallet 3

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.binance_cold_wallet_3

25.66 kB
226 rows
6 columns

CREATE TABLE binance_cold_wallet_3 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Binance Cold Wallet 4

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.binance_cold_wallet_4

7.91 kB
29 rows
6 columns

CREATE TABLE binance_cold_wallet_4 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Bitmex Cold Wallet

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.bitmex_cold_wallet

14.61 kB
99 rows
6 columns

CREATE TABLE bitmex_cold_wallet (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Bittrex Cold Wallet 1

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.bittrex_cold_wallet_1

25.41 kB
226 rows
6 columns

CREATE TABLE bittrex_cold_wallet_1 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Bittrex Cold Wallet 2

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.bittrex_cold_wallet_2

14.47 kB
99 rows
6 columns

CREATE TABLE bittrex_cold_wallet_2 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Coinbase Cold Wallet

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.coinbase_cold_wallet

73.28 kB
751 rows
6 columns

CREATE TABLE coinbase_cold_wallet (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);

Huobi Cold Wallet 1

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.huobi_cold_wallet_1

27.32 kB
252 rows
6 columns

CREATE TABLE huobi_cold_wallet_1 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_satoshi" DOUBLE  -- MoneyIn (Satoshi),
  "moneyout_satoshi" DOUBLE  -- MoneyOut (Satoshi),
  "tx_hash" VARCHAR,
  "current_balance_satoshi" DOUBLE  -- Current Balance (Satoshi)
);

Huobi Cold Wallet 2

@kaggle.aagghh_top_crypto_exchanges_btc_cold_wallets_transactions.huobi_cold_wallet_2

33.24 kB
328 rows
6 columns

CREATE TABLE huobi_cold_wallet_2 (
  "date_utc" VARCHAR  -- Date (UTC),
  "description" VARCHAR,
  "moneyin_btc" DOUBLE  -- MoneyIn (BTC),
  "moneyout_btc" DOUBLE  -- MoneyOut (BTC),
  "tx_hash" VARCHAR,
  "current_balance_btc" DOUBLE  -- Current Balance (BTC)
);