Name: Crypto Currencies
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Crypto Currencies

Description
A dataset containing the closing prices for the last day. Data source: https://coinmetrics.io.

Summary

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

Data sources and methodology
For UTXO coins daily on-chain transaction volume is calculated as the sum of all transaction outputs belonging to the blocks mined on the given day. Known “change” outputs are not included. Estimation difficulties remain and the measure is imprecise. We discuss this here. Methodology behind adjusted transaction volume figures is described in this post.
XRP transaction volume includes only transfers of XRP tokens.

Transaction count figure doesn’t include coinbase and coinstake transactions.

Active addresses is the number of unique sending and receiving addresses participating in transactions on the given day. For Monero, we report an upper bound for this metric (calculated as sum of input and output count), as the precise value is unknowable due to stealth addresses technology.

Payment count for UTXO coins is defined as sum of outputs’ count minus one for each transaction. We assume that transaction with N outputs pays to N – 1 addresses and the last N-th output is change. Transactions with only one output do not contribute to payment count, as they are likely to be a self-churn.
Payment count for smart contract assets such as ETH or LSK is calculated as the amount of transfer transactions (i.e. contract creation, invocation, destruction transactions are not included).
Payment count for Ripple is the amount of XRP token transfers.

NEO and GAS transaction count figures reflect the amount of transactions that have at least one output of given asset type. If transaction sends both NEO and GAS, it will be included in transaction count for both assets. Fees figure is denominated in GAS and calculated by summing the fees of all transactions that have at least one output of a given asset type.

Ripple data includes only transactions of Payment type that transfer XRP tokens.

Stellar transaction volume data covers only operations of Payment and CreateAccount types that transfer XLM tokens. Transaction count is the number of transactions that include at least one operation of aforementioned types. Lumens inflation data is currently unavailable.

XEM data includes only transactions of “Transfer” type.

Zcash figures for on-chain volume and transaction count reflect data collected for transparent transactions only. In the last month, 9.1% (14/06/18) of ZEC transactions were shielded, and these are excluded from the analysis due to their private nature. Thus transaction volume figures in reality are higher than the estimate presented here, and NVT and exchange to transaction value lower. Data on shielded and transparent transactions can be found here and here.

Monero transaction volume is impossible to calculate due to RingCT which hides transaction amounts.

EOS and TRX transaction volume figures include only transactions of transfer type. Median transaction value for EOS and TRX is actually median transfer value.

WAVES transaction volume figure includes only transactions of transfer and mass transfer types. Median transaction value for WAVES is actually median value of WAVES token transfer.

Price data
All coins: coinmarketcap.com

On-chain data
BTC, BCH, LTC, DCR, DASH, ZEC, DOGE, PIVX, XVG, VTC, DGB, BTG, USDT, MAID: data collected from blockchains and aggregated by CM Python tools
ETH and ERC20 tokens, ETC, XMR, XEM, ADA, LSK, NEO, GAS: data collected from blockchains by CM Haskell tools and aggregated by companion analytics scripts
XRP: data collected from data.ripple.com by CM Haskell tools and aggregated by companion analytics scripts
XLM: data collected from history.stellar.org by CM Haskell tools and aggregated by companion analytics scripts

Tables

Ada

@kaggle.joebeachcapital_crypto_currencies.ada

64.7 KB
657 rows
12 columns


CREATE TABLE ada (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "adjustedtxvolume_usd" DOUBLE,
  "txcount" BIGINT,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "fees" DOUBLE,
  "activeaddresses" BIGINT,
  "mediantxvalue_usd" DOUBLE,
  "medianfee" DOUBLE,
  "paymentcount" BIGINT
);

Ae

@kaggle.joebeachcapital_crypto_currencies.ae

46.7 KB
772 rows
8 columns


CREATE TABLE ae (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" DOUBLE,
  "mediantxvalue_usd" DOUBLE
);

Aion

@kaggle.joebeachcapital_crypto_currencies.aion

38.37 KB
594 rows
8 columns


CREATE TABLE aion (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" DOUBLE,
  "mediantxvalue_usd" DOUBLE
);

Ant

@kaggle.joebeachcapital_crypto_currencies.ant

48.45 KB
789 rows
8 columns


CREATE TABLE ant (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" DOUBLE,
  "mediantxvalue_usd" DOUBLE
);

B10

@kaggle.joebeachcapital_crypto_currencies.b10

15.13 KB
746 rows
2 columns


CREATE TABLE b10 (
  "date" TIMESTAMP,
  "value" DOUBLE
);

B20

@kaggle.joebeachcapital_crypto_currencies.b20

15.13 KB
746 rows
2 columns


CREATE TABLE b20 (
  "date" TIMESTAMP,
  "value" DOUBLE
);

B40

@kaggle.joebeachcapital_crypto_currencies.b40

12.66 KB
604 rows
2 columns


CREATE TABLE b40 (
  "date" TIMESTAMP,
  "value" DOUBLE
);

Bat

@kaggle.joebeachcapital_crypto_currencies.bat

52.28 KB
775 rows
8 columns


CREATE TABLE bat (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" DOUBLE,
  "mediantxvalue_usd" DOUBLE
);

Bch

@kaggle.joebeachcapital_crypto_currencies.bch

94.44 KB
721 rows
17 columns


CREATE TABLE bch (
  "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
);

Bnb

@kaggle.joebeachcapital_crypto_currencies.bnb

46.34 KB
736 rows
8 columns


CREATE TABLE bnb (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" BIGINT,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" BIGINT,
  "mediantxvalue_usd" DOUBLE
);

Bsv

@kaggle.joebeachcapital_crypto_currencies.bsv

39.24 KB
247 rows
17 columns


CREATE TABLE bsv (
  "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
);

Btc

@kaggle.joebeachcapital_crypto_currencies.btc

339.35 KB
3844 rows
17 columns


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

Btcp

@kaggle.joebeachcapital_crypto_currencies.btcp

56.25 KB
425 rows
17 columns


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

Btg

@kaggle.joebeachcapital_crypto_currencies.btg

83.32 KB
629 rows
17 columns


CREATE TABLE btg (
  "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
);

Btkn

@kaggle.joebeachcapital_crypto_currencies.btkn

14.79 KB
727 rows
2 columns


CREATE TABLE btkn (
  "date" TIMESTAMP,
  "value" DOUBLE
);

Btm

@kaggle.joebeachcapital_crypto_currencies.btm

47.67 KB
730 rows
8 columns


CREATE TABLE btm (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" DOUBLE,
  "mediantxvalue_usd" DOUBLE
);

Cennz

@kaggle.joebeachcapital_crypto_currencies.cennz

33.32 KB
549 rows
8 columns


CREATE TABLE cennz (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" DOUBLE,
  "mediantxvalue_usd" DOUBLE
);

Ctxc

@kaggle.joebeachcapital_crypto_currencies.ctxc

31.98 KB
490 rows
8 columns


CREATE TABLE ctxc (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" DOUBLE,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" DOUBLE,
  "mediantxvalue_usd" DOUBLE
);

Cvc

@kaggle.joebeachcapital_crypto_currencies.cvc

49.1 KB
731 rows
8 columns


CREATE TABLE cvc (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" BIGINT,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" BIGINT,
  "mediantxvalue_usd" DOUBLE
);

Dai

@kaggle.joebeachcapital_crypto_currencies.dai

37.94 KB
572 rows
8 columns


CREATE TABLE dai (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" BIGINT,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" BIGINT,
  "mediantxvalue_usd" DOUBLE
);

Dash

@kaggle.joebeachcapital_crypto_currencies.dash

239.11 KB
2002 rows
17 columns


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

Dcr

@kaggle.joebeachcapital_crypto_currencies.dcr

158.76 KB
1252 rows
17 columns


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

Dgb

@kaggle.joebeachcapital_crypto_currencies.dgb

244.33 KB
2011 rows
17 columns


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

Doge

@kaggle.joebeachcapital_crypto_currencies.doge

244.21 KB
2044 rows
17 columns


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

Drgn

@kaggle.joebeachcapital_crypto_currencies.drgn

40.24 KB
589 rows
8 columns


CREATE TABLE drgn (
  "date" TIMESTAMP,
  "txvolume_usd" DOUBLE,
  "txcount" BIGINT,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "activeaddresses" BIGINT,
  "mediantxvalue_usd" DOUBLE
);