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

Dxy

@kaggle.joebeachcapital_crypto_currencies.dxy

40.8 KB
2399 rows
2 columns


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

Elf

@kaggle.joebeachcapital_crypto_currencies.elf

39.03 KB
572 rows
8 columns


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

Eng

@kaggle.joebeachcapital_crypto_currencies.eng

41.72 KB
639 rows
8 columns


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

Eos

@kaggle.joebeachcapital_crypto_currencies.eos

56.67 KB
753 rows
10 columns


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

Etc

@kaggle.joebeachcapital_crypto_currencies.etc

141.28 KB
1444 rows
15 columns


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

Eth

@kaggle.joebeachcapital_crypto_currencies.eth

176.49 KB
1444 rows
16 columns


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

Ethos

@kaggle.joebeachcapital_crypto_currencies.ethos

47.26 KB
746 rows
8 columns


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

Fun

@kaggle.joebeachcapital_crypto_currencies.fun

48.82 KB
746 rows
8 columns


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

Gas

@kaggle.joebeachcapital_crypto_currencies.gas

51.97 KB
999 rows
8 columns


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

Gno

@kaggle.joebeachcapital_crypto_currencies.gno

49.06 KB
816 rows
8 columns


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

Gnt

@kaggle.joebeachcapital_crypto_currencies.gnt

63.75 KB
974 rows
8 columns


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

Gold

@kaggle.joebeachcapital_crypto_currencies.gold

34.93 KB
2406 rows
2 columns


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

Gusd

@kaggle.joebeachcapital_crypto_currencies.gusd

20.42 KB
307 rows
8 columns


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

Icn

@kaggle.joebeachcapital_crypto_currencies.icn

60.74 KB
1016 rows
8 columns


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

Icx

@kaggle.joebeachcapital_crypto_currencies.icx

25.98 KB
406 rows
8 columns


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

Kcs

@kaggle.joebeachcapital_crypto_currencies.kcs

39.03 KB
690 rows
8 columns


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

Knc

@kaggle.joebeachcapital_crypto_currencies.knc

43.91 KB
669 rows
8 columns


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

Liborusd

@kaggle.joebeachcapital_crypto_currencies.liborusd

38.38 KB
2420 rows
2 columns


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

Loom

@kaggle.joebeachcapital_crypto_currencies.loom

34 KB
497 rows
8 columns


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

Lrc

@kaggle.joebeachcapital_crypto_currencies.lrc

46.53 KB
711 rows
8 columns


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

Lsk

@kaggle.joebeachcapital_crypto_currencies.lsk

86.96 KB
1193 rows
11 columns


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

Ltc

@kaggle.joebeachcapital_crypto_currencies.ltc

294.26 KB
2837 rows
17 columns


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

Maid

@kaggle.joebeachcapital_crypto_currencies.maid

110.76 KB
1909 rows
8 columns


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

Mana

@kaggle.joebeachcapital_crypto_currencies.mana

45.1 KB
675 rows
8 columns


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

Mtl

@kaggle.joebeachcapital_crypto_currencies.mtl

29.51 KB
442 rows
8 columns


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