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

Nas

@kaggle.joebeachcapital_crypto_currencies.nas

43.17 KB
718 rows
8 columns


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

Neo

@kaggle.joebeachcapital_crypto_currencies.neo

62.31 KB
1037 rows
8 columns


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

Omg

@kaggle.joebeachcapital_crypto_currencies.omg

47.68 KB
737 rows
8 columns


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

Pax

@kaggle.joebeachcapital_crypto_currencies.pax

21.4 KB
306 rows
8 columns


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

Pay

@kaggle.joebeachcapital_crypto_currencies.pay

48.32 KB
746 rows
8 columns


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

Pivx

@kaggle.joebeachcapital_crypto_currencies.pivx

156.45 KB
1261 rows
17 columns


CREATE TABLE pivx (
  "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" DOUBLE,
  "mediantxvalue_usd" DOUBLE,
  "medianfee" DOUBLE,
  "blocksize" BIGINT,
  "blockcount" BIGINT
);

Poly

@kaggle.joebeachcapital_crypto_currencies.poly

37.15 KB
530 rows
8 columns


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

Powr

@kaggle.joebeachcapital_crypto_currencies.powr

44.06 KB
770 rows
8 columns


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

Ppt

@kaggle.joebeachcapital_crypto_currencies.ppt

44.95 KB
734 rows
8 columns


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

Qash

@kaggle.joebeachcapital_crypto_currencies.qash

40.11 KB
641 rows
8 columns


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

Rep

@kaggle.joebeachcapital_crypto_currencies.rep

68.75 KB
1355 rows
8 columns


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

Rhoc

@kaggle.joebeachcapital_crypto_currencies.rhoc

42.9 KB
844 rows
8 columns


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

Salt

@kaggle.joebeachcapital_crypto_currencies.salt

44.1 KB
711 rows
8 columns


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

Snt

@kaggle.joebeachcapital_crypto_currencies.snt

50.98 KB
754 rows
8 columns


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

Sp500

@kaggle.joebeachcapital_crypto_currencies.sp500

38.04 KB
2406 rows
2 columns


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

Srn

@kaggle.joebeachcapital_crypto_currencies.srn

38.67 KB
578 rows
8 columns


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

Trx

@kaggle.joebeachcapital_crypto_currencies.trx

53.1 KB
684 rows
9 columns


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

Tusd

@kaggle.joebeachcapital_crypto_currencies.tusd

31.75 KB
495 rows
8 columns


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

Usdc

@kaggle.joebeachcapital_crypto_currencies.usdc

21.42 KB
306 rows
8 columns


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

Usdt

@kaggle.joebeachcapital_crypto_currencies.usdt

79.17 KB
1742 rows
9 columns


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

Ven

@kaggle.joebeachcapital_crypto_currencies.ven

11.39 KB
319 rows
8 columns


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

Veri

@kaggle.joebeachcapital_crypto_currencies.veri

47.67 KB
809 rows
8 columns


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

Vtc

@kaggle.joebeachcapital_crypto_currencies.vtc

220.49 KB
2011 rows
17 columns


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

Waves

@kaggle.joebeachcapital_crypto_currencies.waves

75.68 KB
1136 rows
10 columns


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

Wtc

@kaggle.joebeachcapital_crypto_currencies.wtc

43.16 KB
722 rows
8 columns


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