Top Cryptocurrencies Prices (minute Interval)
Open, High, Low, Close, Volume, Trade count from Binance Exchange (15-Dec-2021)
@kaggle.prasertk_top_cryptocurrencies_prices_minute_interval
Open, High, Low, Close, Volume, Trade count from Binance Exchange (15-Dec-2021)
@kaggle.prasertk_top_cryptocurrencies_prices_minute_interval
CREATE TABLE aaveusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_aave" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE adausdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_ada" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE batusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_bat" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE bnbusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_bnb" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE btcusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btc" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE bttusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_btt" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE celrusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_celr" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE cvcusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_cvc" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE daiusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_dai" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE dashusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_dash" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE dotusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_dot" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE eosusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_eos" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE etcusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_etc" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE ethusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_eth" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE filusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_fil" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE icpusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_icp" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE icxusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_icx" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE linkusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_link" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE lrcusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_lrc" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE ltcusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_ltc" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE maticusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_matic" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE mkrusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_mkr" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE neousdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_neo" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE oneusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_one" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE paxusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_pax" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE qtumusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_qtum" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE scusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_sc" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE solusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_sol" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE trxusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_trx" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE tusdusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_tusd" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE uniusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_uni" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE usdcusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_usdc" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE vetusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_vet" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE xlmusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_xlm" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE xmrusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_xmr" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE xrpusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_xrp" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
CREATE TABLE zecusdt (
"unix" BIGINT,
"date" TIMESTAMP,
"symbol" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume_zec" DOUBLE,
"volume_usdt" DOUBLE,
"tradecount" BIGINT
);
Anyone who has the link will be able to view this.