Baselight
Sign In

BitCoin Historical Data

Historical Bitcoin data from the beginning in 2009

@kaggle.joebeachcapital_bitcoin

About this Dataset

BitCoin Historical Data

Summary

The Data is pulled from here:
https://coinmetrics.io/data-downloads/

On-chain data
BTC data collected from the blockchain and aggregated by CM Python tools

Tables

Btc

@kaggle.joebeachcapital_bitcoin.btc
  • 339.35 KB
  • 3844 rows
  • 17 columns
Loading...
 

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
);