BitCoin Historical Data
Historical Bitcoin data from the beginning in 2009
@kaggle.joebeachcapital_bitcoin
Historical Bitcoin data from the beginning in 2009
@kaggle.joebeachcapital_bitcoin
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
CREATE TABLE btc (
"date" TIMESTAMP,
"txvolume_usd" DOUBLE -- TxVolume(USD),
"adjustedtxvolume_usd" DOUBLE -- AdjustedTxVolume(USD),
"txcount" DOUBLE,
"marketcap_usd" DOUBLE -- Marketcap(USD),
"price_usd" DOUBLE -- Price(USD),
"exchangevolume_usd" DOUBLE -- ExchangeVolume(USD),
"realizedcap_usd" DOUBLE -- RealizedCap(USD),
"generatedcoins" DOUBLE,
"fees" DOUBLE,
"activeaddresses" DOUBLE,
"averagedifficulty" DOUBLE,
"paymentcount" DOUBLE,
"mediantxvalue_usd" DOUBLE -- MedianTxValue(USD),
"medianfee" DOUBLE,
"blocksize" DOUBLE,
"blockcount" DOUBLE
);
Anyone who has the link will be able to view this.