BITCOIN Historical Datasets 2018-2025

BTCUSDT spot crypto Binance (Daily, 4h, 1h, 15m) update to current day

@kaggle.novandraanugrah_bitcoin_historical_datasets_2018_2024

Table List

4 tables(25.79 MB)

Btc 1d Data

@kaggle.novandraanugrah_bitcoin_historical_datasets_2018_2024.btc_1d_data

225.2 KB
2569 rows
12 columns

open_time Open Time	open Open	high High	low Low	close Close	volume Volume	close_time Close Time	quote_asset_volume Quote Asset Volume	number_of_trades Number Of Trades	taker_buy_base_asset_volume Taker Buy Base Asset Volume	taker_buy_quote_asset_volume Taker Buy Quote Asset Volume
2018-01-01	13715.65	13818.55	12750	13380	8609.915844	Mon Jan 01 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	114799747.44197056	105595	3961.938946	52809747.44038045
2018-01-02	13382.16	15473.49	12890.02	14675.11	20078.092111	Tue Jan 02 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	279717107.4337192	177728	11346.326739	158080088.68331683
2018-01-03	14690	15307.56	14150	14919.51	15905.667639	Wed Jan 03 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	236116868.33619007	162787	8994.953566	133587333.24534808
2018-01-04	14919.51	15280	13918.04	15059.54	21329.649574	Thu Jan 04 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	312781583.79830784	170310	12680.812951	186116793.0115893
2018-01-05	15059.56	17176.24	14600	16960.39	23251.491125	Fri Jan 05 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	369321956.4868375	192969	13346.622293	211829900.67898223
2018-01-06	16960.39	17143.13	16011.21	17069.79	18571.457508	Sat Jan 06 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	309216920.9864104	158242	11007.164056	183417769.0623772
2018-01-07	17069.79	17099.96	15610	16150.03	12493.125558	Sun Jan 07 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	206194706.37068355	120269	6779.320508	112151163.1274352
2018-01-08	16218.85	16322.3	12812	14902.54	26600.609912	Mon Jan 08 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	396569997.15746266	208642	13756.844389	206049582.13668823
2018-01-09	14902.54	15500	14011.05	14400	14315.004253	Tue Jan 09 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	210630187.45766863	156656	6841.233287	100698572.9000214
2018-01-10	14401	14955.66	13131.31	14907.09	17411.001655	Wed Jan 10 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	244011366.763028	161476	8529.554675	119570139.80645348


CREATE TABLE btc_1d_data (
  "open_time" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" TIMESTAMP,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset_volume" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" BIGINT
);