Historical Prices Of Cryptocurrencies
Dataset containing the historical pricing details of top 20 cryptocurrencies
@kaggle.rishikeshavanr_historical_prices_of_cryptocurrencies
Dataset containing the historical pricing details of top 20 cryptocurrencies
@kaggle.rishikeshavanr_historical_prices_of_cryptocurrencies
CREATE TABLE avalanche_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE binanceusd_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE bitcoin_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE bnb_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE cardano_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE cosmos_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE cronos_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE dai_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE dogecoin_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE ethereum_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE polkadot_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE polygon_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE shibainu_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE solana_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE terrausd_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE terra_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE tether_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE usdcoin_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE wrappedbitcoin_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
CREATE TABLE xrp_hist (
"currency" VARCHAR,
"ticker" VARCHAR,
"date" TIMESTAMP,
"open_price" VARCHAR,
"high" VARCHAR,
"low" VARCHAR,
"close_price" VARCHAR,
"volume" VARCHAR,
"market_cap" VARCHAR
);
Anyone who has the link will be able to view this.