Bitcoin Data

bitcoin historical data

@kaggle.skanderhaddad_bitcoin_data

Table List

5 tables(130.59 MB)

Btc Day

Btc Data Bi Hour

@kaggle.skanderhaddad_bitcoin_data.btc_data_bi_hour

2.81 MB
34198 rows
12 columns

date Date	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 Taker Buy Base Asset	taker_buy_quote_asset_volume Taker Buy Quote Asset Volume	ignore Ignore
2017-08-17 04:00:00.000	4261.48	4313.62	4261.32	4308.83	47.181009	1502945999999	202366.13839304	171	35.160503	150952.47794304	7887.63551305
2017-08-17 05:00:00.000	4308.83	4328.69	4291.37	4315.32	23.234916	1502949599999	100304.82356749	102	21.448071	92608.27972836	8039.26240152
2017-08-17 06:00:00.000	4330.29	4345.45	4309.37	4324.35	7.229691	1502953199999	31282.31266989	36	4.802861	20795.31722405	8041.76049845
2017-08-17 07:00:00.000	4316.62	4349.99	4287.41	4349.99	4.443249	1502956799999	19241.05829986	25	2.602292	11291.34701534	8048.12788573
2017-08-17 08:00:00.000	4333.32	4377.85	4333.32	4360.69	0.972807	1502960399999	4239.50358563	28	0.814655	3552.74681715	8018.0365001
2017-08-17 09:00:00.000	4360	4445.78	4360	4444	10.763623	1502963999999	47219.35594369	43	10.2584	44995.37815745	8037.26528855
2017-08-17 10:00:00.000	4441.1	4470	4399.81	4460	24.865399	1502967599999	110290.72898792	82	21.698693	96225.97305402	7981.74555518
2017-08-17 11:00:00.000	4460	4485.39	4427.3	4427.3	27.018053	1502971199999	120751.56923241	95	26.015885	116279.95312533	8020.6980958
2017-08-17 12:00:00.000	4436.06	4449.56	4411	4411	23.032398	1502974799999	102126.51858538	108	15.312994	67947.83408162	8088.62740433
2017-08-17 13:00:00.000	4411	4459	4411	4459	31.312436	1502978399999	138976.63943525	118	26.564042	117910.47559989	8062.53223091


CREATE TABLE btc_data_bi_hour (
  "date" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "close_time" BIGINT,
  "quote_asset_volume" DOUBLE,
  "number_of_trades" BIGINT,
  "taker_buy_base_asset" DOUBLE,
  "taker_buy_quote_asset_volume" DOUBLE,
  "ignore" DOUBLE
);