Dataset: Crypto Market Data 2023

About this Dataset

Crypto Market Data 2023

Delve into the World of Cryptocurrencies with this comprehensive dataset, featuring a rich collection of information on various crypto coins. Explore key details including names, symbols, market pairs, date added, max supply, ranks, and prices in USD. Additionally, unlock the historical journey of the top 5 cryptocurrencies—Bitcoin, Ethereum, Bitcoin Cash, and Solana—with weekly time series data capturing high, low, closing prices, and volume. Uncover valuable insights into market trends, trading patterns, and the dynamic landscape of the crypto market, making informed analyses and strategic decisions.

Tables

Bch Usd

@kaggle.spoorthiuk_crypto_market_data_2023.bch_usd

24.92 KB
322 rows
7 columns


CREATE TABLE bch_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Bnb Usd

@kaggle.spoorthiuk_crypto_market_data_2023.bnb_usd

25.03 KB
322 rows
7 columns


CREATE TABLE bnb_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Btc Usd

@kaggle.spoorthiuk_crypto_market_data_2023.btc_usd

31.27 KB
471 rows
7 columns


CREATE TABLE btc_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Coinmarketcap 06012018

@kaggle.spoorthiuk_crypto_market_data_2023.coinmarketcap_06012018

21.82 KB
100 rows
16 columns


CREATE TABLE coinmarketcap_06012018 (
  "unnamed_0" BIGINT,
  "n_24h_volume_usd" BIGINT,
  "available_supply" BIGINT,
  "id" VARCHAR,
  "last_updated" BIGINT,
  "market_cap_usd" BIGINT,
  "max_supply" DOUBLE,
  "name" VARCHAR,
  "percent_change_1h" DOUBLE,
  "percent_change_24h" DOUBLE,
  "percent_change_7d" DOUBLE,
  "price_btc" DOUBLE,
  "price_usd" DOUBLE,
  "rank" BIGINT,
  "symbol" VARCHAR,
  "total_supply" BIGINT
);

Coinmarketcap 06122017

@kaggle.spoorthiuk_crypto_market_data_2023.coinmarketcap_06122017

134.12 KB
1326 rows
16 columns


CREATE TABLE coinmarketcap_06122017 (
  "unnamed_0" BIGINT,
  "n_24h_volume_usd" DOUBLE,
  "available_supply" DOUBLE,
  "id" VARCHAR,
  "last_updated" BIGINT,
  "market_cap_usd" DOUBLE,
  "max_supply" DOUBLE,
  "name" VARCHAR,
  "percent_change_1h" DOUBLE,
  "percent_change_24h" DOUBLE,
  "percent_change_7d" DOUBLE,
  "price_btc" DOUBLE,
  "price_usd" DOUBLE,
  "rank" BIGINT,
  "symbol" VARCHAR,
  "total_supply" DOUBLE
);

Coinmarketcap 12302023

@kaggle.spoorthiuk_crypto_market_data_2023.coinmarketcap_12302023

1.11 MB
5000 rows
31 columns


CREATE TABLE coinmarketcap_12302023 (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "slug" VARCHAR,
  "num_market_pairs" BIGINT,
  "date_added" VARCHAR,
  "tags" VARCHAR,
  "max_supply" DOUBLE,
  "circulating_supply" DOUBLE,
  "total_supply" DOUBLE,
  "infinite_supply" BOOLEAN,
  "platform" VARCHAR,
  "cmc_rank" BIGINT,
  "self_reported_circulating_supply" DOUBLE,
  "self_reported_market_cap" DOUBLE,
  "tvl_ratio" DOUBLE,
  "last_updated" VARCHAR,
  "price" DOUBLE,
  "volume_24h" DOUBLE,
  "volume_change_24h" DOUBLE,
  "percent_change_1h" DOUBLE,
  "percent_change_24h" DOUBLE,
  "percent_change_7d" DOUBLE,
  "percent_change_30d" DOUBLE,
  "percent_change_60d" DOUBLE,
  "percent_change_90d" DOUBLE,
  "market_cap" DOUBLE,
  "market_cap_dominance" DOUBLE,
  "fully_diluted_market_cap" DOUBLE,
  "tvl" DOUBLE
);

Eth Usd

@kaggle.spoorthiuk_crypto_market_data_2023.eth_usd

24.84 KB
322 rows
7 columns


CREATE TABLE eth_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Iota Usd

@kaggle.spoorthiuk_crypto_market_data_2023.iota_usd

6.03 KB
15 rows
7 columns


CREATE TABLE iota_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Sol Usd

@kaggle.spoorthiuk_crypto_market_data_2023.sol_usd

17.13 KB
196 rows
7 columns


CREATE TABLE sol_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Usdt Usd

@kaggle.spoorthiuk_crypto_market_data_2023.usdt_usd

24.86 KB
322 rows
7 columns


CREATE TABLE usdt_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Xrp Usd

@kaggle.spoorthiuk_crypto_market_data_2023.xrp_usd

25.1 KB
322 rows
7 columns


CREATE TABLE xrp_usd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);