Baselight

Crypto Currencies

Historical data for all major crypto currencies including Bitcoin & Ethereum

@kaggle.joebeachcapital_crypto_currencies

Btcp
@kaggle.joebeachcapital_crypto_currencies.btcp

  • 56.25 KB
  • 425 rows
  • 17 columns
date

Date

txvolume_usd

TxVolume(USD)

adjustedtxvolume_usd

AdjustedTxVolume(USD)

txcount

TxCount

marketcap_usd

Marketcap(USD)

price_usd

Price(USD)

exchangevolume_usd

ExchangeVolume(USD)

realizedcap_usd

RealizedCap(USD)

generatedcoins

GeneratedCoins

fees

Fees

activeaddresses

ActiveAddresses

averagedifficulty

AverageDifficulty

paymentcount

PaymentCount

mediantxvalue_usd

MedianTxValue(USD)

medianfee

MedianFee

blocksize

BlockSize

blockcount

BlockCount

Fri Mar 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
Sat Mar 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)540518995946.717939516.054423232461454716786.711719416622280.00028851129500506610
Sun Mar 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)8875900.460117065.4951287419448568843.275126498150610.00028810045126577
Mon Mar 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)4884898.191691642.1679579111788467466.232526715195010.00016623724575
Tue Mar 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)3908904.45350072.1309311414222534188.965928077158750.000127697542579
Wed Mar 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)5967832.45374485.7616734838815529249.490944444175430.000288146436387533
Thu Mar 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)3388898.389336360.996090199061435645.884793975180690.000086575256464575
Fri Mar 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)3602885.85013162000011.8900106110213416773.828121437224130.00015373847567
Sat Mar 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)5995066.4922213794400417.968116442243565.82290526904.65696440.57545699000000016992360217.37016748621092118.349165518199980.00014229047579
Sun Mar 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)4527840.6576637752649518.654890681246062.04298409876.530612230.871159726558346232.8471336482294196.6044041380.00014774504561

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

Share link

Anyone who has the link will be able to view this.