Dataset: Crypto Currencies

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

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

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

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