Top Cryptocurrencies By Volume
“Daily Historical Price & Volume Data for the Top Traded Cryptocurrencies”
@kaggle.albertobircoci_top_cryptocurrencies_by_volume
“Daily Historical Price & Volume Data for the Top Traded Cryptocurrencies”
@kaggle.albertobircoci_top_cryptocurrencies_by_volume
This dataset provides a comprehensive, daily time series of closing prices and trading volumes for the cryptocurrencies fetched online by 24-hour trading volume. Each row corresponds to a calendar date (in ISO YYYY-MM-DD format), and for each coin you’ll find two columns:
CREATE TABLE top100cryptobyvolume (
"date" TIMESTAMP,
"usdt_usd_close" DOUBLE,
"usdt_usd_volume" DOUBLE,
"eth_usd_close" DOUBLE,
"eth_usd_volume" DOUBLE,
"btc_usd_close" DOUBLE,
"btc_usd_volume" BIGINT,
"usdc_usd_close" DOUBLE,
"usdc_usd_volume" DOUBLE,
"sol_usd_close" DOUBLE,
"sol_usd_volume" DOUBLE,
"fdusd_usd_close" DOUBLE,
"fdusd_usd_volume" DOUBLE,
"xrp_usd_close" DOUBLE,
"xrp_usd_volume" DOUBLE,
"doge_usd_close" DOUBLE,
"doge_usd_volume" DOUBLE,
"ada_usd_close" DOUBLE,
"ada_usd_volume" DOUBLE,
"bnb_usd_close" DOUBLE,
"bnb_usd_volume" DOUBLE,
"trx_usd_close" DOUBLE,
"trx_usd_volume" DOUBLE,
"avax_usd_close" DOUBLE,
"avax_usd_volume" DOUBLE,
"link_usd_close" DOUBLE,
"link_usd_volume" DOUBLE,
"ena_usd_close" DOUBLE,
"ena_usd_volume" DOUBLE,
"arb_usd_close" DOUBLE,
"arb_usd_volume" DOUBLE,
"weth_usd_close" DOUBLE,
"weth_usd_volume" DOUBLE,
"ltc_usd_close" DOUBLE,
"ltc_usd_volume" BIGINT,
"okb_usd_close" DOUBLE,
"okb_usd_volume" DOUBLE,
"aave_usd_close" DOUBLE,
"aave_usd_volume" DOUBLE,
"trump_usd_close" DOUBLE,
"trump_usd_volume" DOUBLE,
"wbnb_usd_close" DOUBLE,
"wbnb_usd_volume" DOUBLE,
"xlm_usd_close" DOUBLE,
"xlm_usd_volume" DOUBLE,
"skl_usd_close" DOUBLE,
"skl_usd_volume" DOUBLE,
"bonk_usd_close" DOUBLE,
"bonk_usd_volume" DOUBLE,
"dot_usd_close" DOUBLE,
"dot_usd_volume" DOUBLE,
"hbar_usd_close" DOUBLE,
"hbar_usd_volume" DOUBLE,
"bch_usd_close" DOUBLE,
"bch_usd_volume" DOUBLE,
"wavax_usd_close" DOUBLE,
"wavax_usd_volume" DOUBLE,
"wif_usd_close" DOUBLE,
"wif_usd_volume" DOUBLE,
"shib_usd_close" DOUBLE,
"shib_usd_volume" DOUBLE,
"op_usd_close" DOUBLE,
"op_usd_volume" DOUBLE,
"ldo_usd_close" DOUBLE,
"ldo_usd_volume" DOUBLE,
"wbtc_usd_close" DOUBLE,
"wbtc_usd_volume" DOUBLE,
"fartcoin_usd_close" DOUBLE,
"fartcoin_usd_volume" DOUBLE,
"ton_usd_close" DOUBLE,
"ton_usd_volume" DOUBLE,
"ip_usd_close" DOUBLE,
"ip_usd_volume" DOUBLE,
"sei_usd_close" DOUBLE,
"sei_usd_volume" DOUBLE,
"etc_usd_close" DOUBLE,
"etc_usd_volume" DOUBLE,
"whype_usd_close" DOUBLE,
"whype_usd_volume" DOUBLE,
"near_usd_close" DOUBLE,
"near_usd_volume" DOUBLE,
"floki_usd_close" DOUBLE,
"floki_usd_volume" DOUBLE,
"crv_usd_close" DOUBLE,
"crv_usd_volume" DOUBLE,
"pendle_usd_close" DOUBLE,
"pendle_usd_volume" DOUBLE,
"ray_usd_close" DOUBLE,
"ray_usd_volume" DOUBLE,
"pnut_usd_close" DOUBLE,
"pnut_usd_volume" DOUBLE,
"inj_usd_close" DOUBLE,
"inj_usd_volume" DOUBLE,
"bgb_usd_close" DOUBLE,
"bgb_usd_volume" DOUBLE,
"wtrx_usd_close" DOUBLE,
"wtrx_usd_volume" DOUBLE,
"ens_usd_close" DOUBLE,
"ens_usd_volume" DOUBLE,
"wld_usd_close" DOUBLE
);
CREATE TABLE top_cryptos_by_volume (
"date" TIMESTAMP,
"usdt_usd_close" DOUBLE,
"usdt_usd_volume" DOUBLE,
"btc_usd_close" DOUBLE,
"btc_usd_volume" DOUBLE,
"eth_usd_close" DOUBLE,
"eth_usd_volume" DOUBLE,
"usdc_usd_close" DOUBLE,
"usdc_usd_volume" DOUBLE,
"zkj_usd_close" DOUBLE,
"zkj_usd_volume" DOUBLE,
"fdusd_usd_close" DOUBLE,
"fdusd_usd_volume" DOUBLE,
"koge_usd_close" DOUBLE,
"koge_usd_volume" DOUBLE,
"sol_usd_close" DOUBLE,
"sol_usd_volume" DOUBLE,
"xrp_usd_close" DOUBLE,
"xrp_usd_volume" DOUBLE,
"doge_usd_close" DOUBLE,
"doge_usd_volume" DOUBLE,
"trx_usd_close" DOUBLE,
"trx_usd_volume" DOUBLE,
"bnb_usd_close" DOUBLE,
"bnb_usd_volume" DOUBLE,
"weth_usd_close" DOUBLE,
"weth_usd_volume" DOUBLE,
"ada_usd_close" DOUBLE,
"ada_usd_volume" DOUBLE,
"aave_usd_close" DOUBLE,
"aave_usd_volume" DOUBLE,
"link_usd_close" DOUBLE,
"link_usd_volume" DOUBLE,
"avax_usd_close" DOUBLE,
"avax_usd_volume" DOUBLE,
"wif_usd_close" DOUBLE,
"wif_usd_volume" DOUBLE,
"virtual_usd_close" DOUBLE,
"virtual_usd_volume" DOUBLE,
"wbnb_usd_close" DOUBLE,
"wbnb_usd_volume" DOUBLE,
"fartcoin_usd_close" DOUBLE,
"fartcoin_usd_volume" DOUBLE,
"ltc_usd_close" DOUBLE,
"ltc_usd_volume" BIGINT,
"trump_usd_close" DOUBLE,
"trump_usd_volume" DOUBLE,
"rvn_usd_close" DOUBLE,
"rvn_usd_volume" DOUBLE,
"bch_usd_close" DOUBLE,
"bch_usd_volume" DOUBLE,
"dot_usd_close" DOUBLE,
"dot_usd_volume" DOUBLE,
"ena_usd_close" DOUBLE,
"ena_usd_volume" DOUBLE,
"op_usd_close" DOUBLE,
"op_usd_volume" DOUBLE,
"bonk_usd_close" DOUBLE,
"bonk_usd_volume" DOUBLE,
"arb_usd_close" DOUBLE,
"arb_usd_volume" DOUBLE,
"nxpc_usd_close" DOUBLE,
"nxpc_usd_volume" DOUBLE,
"usd1_usd_close" DOUBLE,
"usd1_usd_volume" DOUBLE,
"anime_usd_close" DOUBLE,
"anime_usd_volume" DOUBLE,
"ton_usd_close" DOUBLE,
"ton_usd_volume" DOUBLE,
"wld_usd_close" DOUBLE,
"wld_usd_volume" DOUBLE,
"egl1_usd_close" DOUBLE,
"egl1_usd_volume" DOUBLE,
"xlm_usd_close" DOUBLE,
"xlm_usd_volume" DOUBLE,
"rune_usd_close" DOUBLE,
"rune_usd_volume" DOUBLE,
"near_usd_close" DOUBLE,
"near_usd_volume" DOUBLE,
"wbtc_usd_close" DOUBLE,
"wbtc_usd_volume" DOUBLE,
"mev_usd_close" DOUBLE,
"mev_usd_volume" DOUBLE,
"pendle_usd_close" DOUBLE,
"pendle_usd_volume" DOUBLE,
"fet_usd_close" DOUBLE,
"fet_usd_volume" DOUBLE,
"shib_usd_close" DOUBLE,
"shib_usd_volume" DOUBLE,
"kaia_usd_close" DOUBLE,
"kaia_usd_volume" DOUBLE,
"la_usd_close" DOUBLE,
"la_usd_volume" DOUBLE,
"apt_usd_close" DOUBLE,
"apt_usd_volume" DOUBLE,
"crv_usd_close" DOUBLE,
"crv_usd_volume" DOUBLE,
"hbar_usd_close" DOUBLE,
"hbar_usd_volume" DOUBLE,
"seraph_usd_close" DOUBLE
);
Anyone who has the link will be able to view this.