Dataset: Bitcoin Blockchain Data

About this Dataset

Bitcoin Blockchain Data

Is it possible to generate income with digital mining without having to do anything?

Actually yes, but still, this relative everything depends on your expectation and pocket. Satoshy Nakamoto created Bitcoin by starting a method that is digital mining, which works to prevent the system from being corrupt, and the only way to be corrupt is for a company or group of people to have 51% of the Total Hash-Rate that miners spend in finding a hash to obtaining their precious reward, generating income for large corporations, such as those who venture to buy a quantity of equipment and to mine at their homes, in a certain space, but not all can mine, too brings its disadvantages, the computing power of these machines requires electrical power, which in many countries digital mining could be somewhat crazy, as for example in Antigua and Barbuda, which is the country with the highest bill cost in electricity or Venezuela where only pennies are required to pay for a month of electricity.

Is mining profitable?

There are many factors, for example the currency you are mining, the mining power of your machine or farm, and also the way you manage your finances. Everything influences. Let's also consider that the profit margin for some is more profitable than others in terms of electricity service expense. Which leads us to ask ourselves some questions that we will answer after doing certain analyzes.

Which is the history of profit that miners have obtained over time?
What is the real value of a TH/s and what will happen in the course of time, is there any correlation or dependency between the Market-Price or Block-Rewards?
Which are the best countries to mine Bitcoins?
Profitability between the Profit of Various Models VS Monthly Electric Cost
Investment Reward Machine Price VS Profit
Conclusion
What will happen after the next Halving?

Tables

Country Model Dataset

@kaggle.jventrone_bitcoin_blockchain_data.country_model_dataset

11.6 KB
1179 rows
7 columns


CREATE TABLE country_model_dataset (
  "country" VARCHAR,
  "model" VARCHAR,
  "m_b_c_usd" DOUBLE,
  "power_consumtion" BIGINT,
  "th_s" BIGINT,
  "usd_profit" DOUBLE,
  "btc_profit" DOUBLE
);

Data Update 2021–05–08

@kaggle.jventrone_bitcoin_blockchain_data.data_update_2021_05_08

126.34 MB
682676 rows
19 columns


CREATE TABLE data_update_2021_05_08 (
  "unnamed_0" BIGINT,
  "hash" VARCHAR,
  "confirmations" BIGINT,
  "timestamp" TIMESTAMP,
  "height" BIGINT,
  "number_of_transactions" DOUBLE,
  "difficulty" DOUBLE,
  "merkle_root" VARCHAR,
  "version" VARCHAR,
  "bits" BIGINT,
  "weight" VARCHAR,
  "size" VARCHAR,
  "nonce" BIGINT,
  "transaction_volume" VARCHAR,
  "block_reward" VARCHAR,
  "fee_reward" VARCHAR,
  "miner_name" VARCHAR,
  "url_miner" VARCHAR,
  "n_0" VARCHAR
);

Electricity Bill Cost

@kaggle.jventrone_bitcoin_blockchain_data.electricity_bill_cost

5.36 KB
131 rows
3 columns


CREATE TABLE electricity_bill_cost (
  "unnamed_0" BIGINT,
  "countrys" VARCHAR,
  "n__kw_h_usd" DOUBLE
);

History Data Miners Rewards

@kaggle.jventrone_bitcoin_blockchain_data.history_data_miners_rewards

259.86 KB
4197 rows
9 columns


CREATE TABLE history_data_miners_rewards (
  "unnamed_0" BIGINT,
  "timestamp" TIMESTAMP,
  "block_reward" DOUBLE,
  "fee_reward" DOUBLE,
  "market_price" DOUBLE,
  "total_reward_usd" DOUBLE,
  "hash_rate" DOUBLE,
  "number_of_transactions" DOUBLE,
  "th_s_rewards_usd" DOUBLE
);

History Data Rewards

@kaggle.jventrone_bitcoin_blockchain_data.history_data_rewards

271.63 KB
3593 rows
10 columns


CREATE TABLE history_data_rewards (
  "unnamed_0" BIGINT,
  "timestamp" TIMESTAMP,
  "block_reward" DOUBLE,
  "fee_reward" DOUBLE,
  "number_of_transactions" DOUBLE,
  "market_price" DOUBLE,
  "hash_rate" DOUBLE,
  "th_usd_value" DOUBLE,
  "total_miners_rewards_usd" DOUBLE,
  "sum_reward" DOUBLE
);

Models Prices Th

@kaggle.jventrone_bitcoin_blockchain_data.models_prices_th

5.08 KB
9 rows
6 columns


CREATE TABLE models_prices_th (
  "unnamed_0" BIGINT,
  "models" VARCHAR,
  "price" DOUBLE,
  "power_consumtion" BIGINT,
  "th_s" BIGINT,
  "time" TIMESTAMP
);

Model Used

@kaggle.jventrone_bitcoin_blockchain_data.model_used

4.14 KB
6 rows
5 columns


CREATE TABLE model_used (
  "unnamed_0" BIGINT,
  "models" VARCHAR,
  "price" BIGINT,
  "th_s" BIGINT,
  "time" TIMESTAMP
);