BitCoin Historical Data

Historical Bitcoin data from the beginning in 2009

@kaggle.joebeachcapital_bitcoin

Table List

1 table(339.35 KB)

Btc

@kaggle.joebeachcapital_bitcoin.btc

339.35 KB
3844 rows
17 columns

date Date	txcount TxCount	generatedcoins GeneratedCoins	activeaddresses ActiveAddresses	averagedifficulty AverageDifficulty	paymentcount PaymentCount	blocksize BlockSize	blockcount BlockCount
Sat Jan 03 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
Sun Jan 04 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
Mon Jan 05 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
Tue Jan 06 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
Wed Jan 07 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
Thu Jan 08 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
Fri Jan 09 2009 00:00:00 GMT+0000 (Coordinated Universal Time)		700	14	1		3010	14
Sat Jan 10 2009 00:00:00 GMT+0000 (Coordinated Universal Time)		3050	61	1		13129	61
Sun Jan 11 2009 00:00:00 GMT+0000 (Coordinated Universal Time)		4650	93	1		20033	93
Mon Jan 12 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	7	4700	102	1	5	22031	94


CREATE TABLE btc (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "adjustedtxvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "realizedcap_usd" DOUBLE,
  "generatedcoins" DOUBLE,
  "fees" DOUBLE,
  "activeaddresses" DOUBLE,
  "averagedifficulty" DOUBLE,
  "paymentcount" DOUBLE,
  "mediantxvalue_usd" DOUBLE,
  "medianfee" DOUBLE,
  "blocksize" DOUBLE,
  "blockcount" DOUBLE
);