Crypto Market Data 2023
Explore the Evolution of Cryptocurrencies
@kaggle.spoorthiuk_crypto_market_data_2023
Explore the Evolution of Cryptocurrencies
@kaggle.spoorthiuk_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.
CREATE TABLE bch_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE bnb_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE btc_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE coinmarketcap_06012018 (
"unnamed_0" BIGINT -- Unnamed: 0,
"n_24h_volume_usd" BIGINT -- 24h Volume Usd,
"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
);CREATE TABLE coinmarketcap_06122017 (
"unnamed_0" BIGINT -- Unnamed: 0,
"n_24h_volume_usd" DOUBLE -- 24h Volume Usd,
"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
);CREATE TABLE coinmarketcap_12302023 (
"unnamed_0" BIGINT -- Unnamed: 0,
"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
);CREATE TABLE eth_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE iota_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE sol_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE usdt_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE xrp_usd (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);Anyone who has the link will be able to view this.