Bitcoin Price

A cryptocurrency, Bitcoin and now a mystery

@kaggle.aditeloo_bitcoin

Table List

1 table(459.33 KB)

Bitcoin

@kaggle.aditeloo_bitcoin.bitcoin

459.33 KB
2906 rows
24 columns

date Date	btc_total_bitcoins Btc Total Bitcoins	btc_avg_block_size Btc Avg Block Size	btc_n_transactions_per_block Btc N Transactions Per Block	btc_hash_rate Btc Hash Rate	btc_difficulty Btc Difficulty	btc_cost_per_transaction_percent Btc Cost Per Transaction Percent	btc_n_unique_addresses Btc N Unique Addresses	btc_n_transactions Btc N Transactions	btc_n_transactions_total Btc N Transactions Total	btc_n_transactions_excluding_popular Btc N Transactions Excluding Popular	btc_n_transactions_excluding_chains_longer_than_100 Btc N Transactions Excluding Chains Longer Than 100	btc_output_volume Btc Output Volume	btc_estimated_transaction_volume Btc Estimated Transaction Volume
2/17/2010	2043200	0.000234776	1	0.0000292	2.527738215	31.78102218	241	244	41240	244	244	65173.13	36500
2/18/2010	2054650	0.000240913	1	0.0000288	2.527738215	154.4638015	234	235	41475	235	235	18911.74	7413
2/19/2010	2063600	0.000227749	1	0.0000225	2.527738215	1278.516635	185	183	41658	183	183	9749.98	700
2/20/2010	2074700	0.000218369	1	0.0000279	2.527738215	22186.68799	224	224	41882	224	224	11150.03	50
2/21/2010	2085400	0.000233893	1	0.0000269	2.527738215	689.1798759	218	218	42100	218	218	12266.83	1553
2/22/2010	2098150	0.000383961	1	0.000032	2.527738215	65.21405555	262	261	42361	261	261	32350	19551
2/23/2010	2110700	0.000216335	1	0.0000315	2.527738215	25100	252	252	42613	252	252	12600	50
2/24/2010	2120200	0.000281721	1	0.0000357	3.781179252	179.245283	195	196	42809	196	196	14800	5300
2/25/2010	2127600	0.000226905	1	0.0000278	3.781179252	1057.142857	150	150	42959	150	150	8100	700
2/26/2010	2136100	0.000318676	1	0.000032	3.781179252	64.5820591	176	176	43135	176	176	29349	13162


CREATE TABLE bitcoin (
  "date" VARCHAR,
  "btc_market_price" DOUBLE,
  "btc_total_bitcoins" DOUBLE,
  "btc_market_cap" DOUBLE,
  "btc_trade_volume" DOUBLE,
  "btc_blocks_size" DOUBLE,
  "btc_avg_block_size" DOUBLE,
  "btc_n_orphaned_blocks" BIGINT,
  "btc_n_transactions_per_block" DOUBLE,
  "btc_median_confirmation_time" DOUBLE,
  "btc_hash_rate" DOUBLE,
  "btc_difficulty" DOUBLE,
  "btc_miners_revenue" DOUBLE,
  "btc_transaction_fees" DOUBLE,
  "btc_cost_per_transaction_percent" DOUBLE,
  "btc_cost_per_transaction" DOUBLE,
  "btc_n_unique_addresses" BIGINT,
  "btc_n_transactions" BIGINT,
  "btc_n_transactions_total" BIGINT,
  "btc_n_transactions_excluding_popular" BIGINT,
  "btc_n_transactions_excluding_chains_longer_than_100" BIGINT,
  "btc_output_volume" DOUBLE,
  "btc_estimated_transaction_volume" DOUBLE,
  "btc_estimated_transaction_volume_usd" DOUBLE
);