Dataset: Bitcoin Network On-Chain Blockchain Data

About this Dataset

Bitcoin Network On-Chain Blockchain Data

About This Dataset

This dataset aims to collect and collate information about activity on the Bitcoin blockchain, with a focus directed at on-chain data which describes the state of the network at any given time. Some examples of these metrics include:

Total Supply
Hashrate
Difficulty
Block Size
Transaction Rate
Mempool Size
Miner Revenue
Fear and Greed Index
Net Unrealized Profit/Loss (NUPL)
Coin Days Destroyed (CDD)

Descriptions of all column headers are included as part of the .csv files in this dataset and are also viewable below.

The current iteration of the dataset leverages the blockchain.com API to provide both daily and half-hourly data about the state of the chain, as well as daily metrics provided by lookintobitcoin.com. Future iterations of this dataset expect to utilise other sources of information as well. Please see the linked Kaggle Notebook under the Provenance section of this page for more information.

Current sources of information include:

Blockchain.com
LookIntoBitcoin.com

Please recommend other sources of information that should also be added to this dataset.

Note: The 1st Bitcoin block was mined on 3rd January 2009 by Satoshi, but the second was not mined until January 9th, 6 days later, hence the period of null data for many metrics between 3rd-9th January 2009.

Disclaimer

This is information – not financial advice or recommendation. The content and materials featured or linked to in this dataset are for your information and education only and are not attended to address your particular personal requirements.

The information does not constitute financial advice or recommendation and should not be considered as such. The owner of this dataset is not regulated by the Financial Conduct Authority (FCA) is not a financial advisor and is therefore not authorised to offer financial advice.

Do your own research and seek independent advice when required. Always do your own research and seek independent financial advice when required. Any arrangement made between you and any third party named or linked to from the site is at your sole risk and responsibility. The owner of this dataset and its associated curators assume no liability for your actions.

Investing carries risk. The value of investments and any income derived from them can fall as well as rise and you may not get back the original amount you invested.

Tables

Blockchain Dot Com Column Desc

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.blockchain_dot_com_column_desc

3.72 KB
11 rows
2 columns


CREATE TABLE blockchain_dot_com_column_desc (
  "unnamed_0" VARCHAR,
  "description" VARCHAR
);

Blockchain Dot Com Daily Data

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.blockchain_dot_com_daily_data

404 KB
5356 rows
12 columns


CREATE TABLE blockchain_dot_com_daily_data (
  "datetime" TIMESTAMP,
  "mempool_size" DOUBLE,
  "transaction_rate" DOUBLE,
  "market_cap_usd" DOUBLE,
  "average_block_size" DOUBLE,
  "market_price_usd" DOUBLE,
  "exchange_volume_usd" DOUBLE,
  "average_confirmation_time" DOUBLE,
  "hash_rate" DOUBLE,
  "difficulty" DOUBLE,
  "miners_revenue" DOUBLE,
  "total_transaction_fees" DOUBLE
);

Blockchain Dot Com Half Hourly Data

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.blockchain_dot_com_half_hourly_data

4.61 MB
257110 rows
4 columns


CREATE TABLE blockchain_dot_com_half_hourly_data (
  "datetime" TIMESTAMP,
  "transaction_rate" DOUBLE,
  "mempool_size" DOUBLE,
  "market_cap_usd" DOUBLE
);

Look Into Bitcoin Address Balances Data

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.look_into_bitcoin_address_balances_data

228.26 KB
4765 rows
8 columns


CREATE TABLE look_into_bitcoin_address_balances_data (
  "unnamed_0" TIMESTAMP,
  "market_price_usd" DOUBLE,
  "addresses_with_1000_btc" DOUBLE,
  "addresses_with_100_btc" DOUBLE,
  "addresses_with_10_btc" DOUBLE,
  "addresses_with_1_btc" DOUBLE,
  "addresses_with_0_01_btc_x" DOUBLE,
  "addresses_with_0_01_btc_y" DOUBLE
);

Look Into Bitcoin Column Desc

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.look_into_bitcoin_column_desc

3.81 KB
11 rows
2 columns


CREATE TABLE look_into_bitcoin_column_desc (
  "unnamed_0" VARCHAR,
  "description" VARCHAR
);

Look Into Bitcoin Daily Data

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.look_into_bitcoin_daily_data

343.37 KB
4764 rows
12 columns


CREATE TABLE look_into_bitcoin_daily_data (
  "datetime" TIMESTAMP,
  "market_price_usd" DOUBLE,
  "total_supply" BIGINT,
  "market_cap_usd" DOUBLE,
  "realised_cap_usd" DOUBLE,
  "nupl" DOUBLE,
  "coin_days_destroyed" DOUBLE,
  "active_addresses" DOUBLE,
  "fear_greed_value" DOUBLE,
  "fear_greed_category" VARCHAR,
  "lightning_nodes" DOUBLE,
  "lightning_capacity_usd" DOUBLE
);

Look Into Bitcoin Hodl Waves Data

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.look_into_bitcoin_hodl_waves_data

553.13 KB
4765 rows
14 columns


CREATE TABLE look_into_bitcoin_hodl_waves_data (
  "datetime" TIMESTAMP,
  "market_price_usd" DOUBLE,
  "n_24h" DOUBLE,
  "n_1d_1w" DOUBLE,
  "n_1w_1m" DOUBLE,
  "n_1m_3m" DOUBLE,
  "n_3m_6m" DOUBLE,
  "n_6m_12m" DOUBLE,
  "n_1y_2y" DOUBLE,
  "n_2y_3y" DOUBLE,
  "n_3y_5y" DOUBLE,
  "n_5y_7y" DOUBLE,
  "n_7y_10y" DOUBLE,
  "n_10y" DOUBLE
);

Look Into Bitcoin Realised Cap Hodl Waves Data

@kaggle.aleexharris_bitcoin_network_on_chain_blockchain_data.look_into_bitcoin_realised_cap_hodl_waves_data

553.13 KB
4765 rows
14 columns


CREATE TABLE look_into_bitcoin_realised_cap_hodl_waves_data (
  "datetime" TIMESTAMP,
  "market_price_usd" DOUBLE,
  "n_24h" DOUBLE,
  "n_1d_1w" DOUBLE,
  "n_1w_1m" DOUBLE,
  "n_1m_3m" DOUBLE,
  "n_3m_6m" DOUBLE,
  "n_6m_12m" DOUBLE,
  "n_1y_2y" DOUBLE,
  "n_2y_3y" DOUBLE,
  "n_3y_5y" DOUBLE,
  "n_5y_7y" DOUBLE,
  "n_7y_10y" DOUBLE,
  "n_10y" DOUBLE
);