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

Xem

@kaggle.joebeachcapital_crypto_currencies.xem

113.78 KB
1567 rows
10 columns


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

Xlm

@kaggle.joebeachcapital_crypto_currencies.xlm

98.82 KB
1803 rows
8 columns


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

Xmr

@kaggle.joebeachcapital_crypto_currencies.xmr

178.77 KB
1912 rows
13 columns


CREATE TABLE xmr (
  "date" TIMESTAMP,
  "txcount" BIGINT,
  "marketcap_usd" DOUBLE,
  "price_usd" DOUBLE,
  "exchangevolume_usd" DOUBLE,
  "fees" DOUBLE,
  "generatedcoins" DOUBLE,
  "activeaddresses" BIGINT,
  "medianfee" DOUBLE,
  "averagedifficulty" DOUBLE,
  "paymentcount" BIGINT,
  "blockcount" BIGINT,
  "blocksize" BIGINT
);

Xrp

@kaggle.joebeachcapital_crypto_currencies.xrp

184.74 KB
2383 rows
11 columns


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

Xvg

@kaggle.joebeachcapital_crypto_currencies.xvg

192.41 KB
1739 rows
17 columns


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

Zec

@kaggle.joebeachcapital_crypto_currencies.zec

122.97 KB
989 rows
17 columns


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

Zil

@kaggle.joebeachcapital_crypto_currencies.zil

38.44 KB
547 rows
8 columns


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

Zrx

@kaggle.joebeachcapital_crypto_currencies.zrx

47.69 KB
701 rows
8 columns


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