BTC Minute Market Data 2 Million CANDLES

BTC Minute Market Data Paradize | 2M CANDLES

@kaggle.franoisgeorgesjulien_bitcoin_minute_data

Table List

1 table(336.61 MB)

Power Data

@kaggle.franoisgeorgesjulien_bitcoin_minute_data.power_data

336.61 MB
1997210 rows
27 columns

date Date	symbol Symbol	open Open	high High	low Low	close Close	volume_usdt Volume USDT	tradecount Tradecount	token Token	day Day	ema_5 Ema 5	ema_15 Ema 15	ema_30 Ema 30	ema_60 Ema 60	ema_100 Ema 100	ema_200 Ema 200	wma WMA	macd MACD	macd_signal MACD Signal	macd_hist MACD Hist	atr ATR	hma HMA	kama KAMA	cmo CMO	z_score Z-Score	qstick QStick
Wed Jan 01 2020 00:01:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7182.43	7182.44	7178.75	7179.01	509146	140	BTC	Wednesday	7178.557957509969	7178.357759933758	7177.701021517193	7179.328745827414	7184.27998995877	7194.752301445198	7179.07819047619	0.72870374946433	-0.1522194360645032	0.8809231855288333	4.684924732926287	7177.563636363637	7178.824356811398	4.193879012185541	0.6207177674178969	0.1199999999998345
Wed Jan 01 2020 00:02:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7179.01	7179.01	7175.25	7177.93	713540	148	BTC	Wednesday	7178.331936264954	7178.264582781437	7177.610747139069	7179.339550770716	7184.386454402381	7194.910515530074	7179.128476190476	0.7368874361927737	-0.1820906083521853	0.9189780445449592	4.698380481612978	7176.318505050505	7178.819893694768	0.8593600044964304	0.3594483207016383	0.5279999999998273
Wed Jan 01 2020 00:03:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7177.77	7182.6	7177	7181.11	497793	104	BTC	Wednesday	7178.53290439743	7178.312380321641	7177.588729700385	7179.387332152774	7184.51688782465	7195.081173977612	7179.299904761905	0.8465780699998504	-0.1179226266331548	0.9645006966330052	4.609025134044771	7175.562717171718	7178.843061345811	11.466626477083928	1.198367456101228	0.4929999999997909
Wed Jan 01 2020 00:04:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7179.1	7179.1	7172.94	7175.25	698627	193	BTC	Wednesday	7177.244356596144	7177.91272036759	7177.345883472824	7179.328936632531	7184.58571384131	7195.221587786432	7178.98161904762	0.6504875252239799	-0.3434938280673141	0.993981353291294	4.398180913586647	7175.694414141414	7178.783249815782	-7.962103991284235	-0.3212892262528447	-0.4250000000001472
Wed Jan 01 2020 00:05:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7174.71	7177.14	7173.28	7175.61	241980	124	BTC	Wednesday	7178.241534894217	7178.293108991531	7177.490427160606	7179.467205670921	7184.774314120933	7195.422307261673	7179.421904761905	0.9873975931604946	-0.0924572171476278	1.0798548103081225	4.262656368477868	7178.227646464647	7178.811841909186	-6.795306751324576	-0.2282702624704151	-0.1310000000000963
Wed Jan 01 2020 00:06:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7175.61	7177.04	7175.61	7177.04	287208	64	BTC	Wednesday	7179.557302341326	7178.676410276035	7177.620111792371	7179.597958405529	7184.959451779942	7195.62142592762	7179.795809523808	1.3664006603357848	0.2634315457407554	1.102969114595029	4.293629935283814	7181.171464646465	7178.863619367033	-2.223232887279712	0.1739172679148719	-0.0170000000000636
Wed Jan 01 2020 00:07:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7176.97	7178.27	7176.71	7177.7	97360	37	BTC	Wednesday	7180.815953511989	7178.910183172611	7177.66011950219	7179.684668859954	7185.11944070479	7195.808173926892	7179.924285714286	1.6846714746525322	0.647560246492692	1.0371112281598402	4.463139930305635	7183.8483838383845	7178.881287444413	-0.1235101951238731	0.3648182687953527	-0.4270000000001001
Wed Jan 01 2020 00:08:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7178.59	7182.06	7178.59	7182.06	141027	46	BTC	Wednesday	7182.373930267985	7179.083066482984	7177.657369123032	7179.751945770461	7185.269328395795	7195.99016562465	7179.946285714285	1.9991964562041176	1.1239752896674504	0.8752211665366672	4.394919924944502	7185.22897979798	7178.904894653247	15.02927718063707	1.567222858940713	-0.6420000000000636
Wed Jan 01 2020 00:09:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7182.06	7186.69	7182.05	7186.69	408864	74	BTC	Wednesday	7182.530895401977	7178.657790266267	7177.353739407378	7179.673706644036	7185.334163312881	7196.13016728922	7179.316761904764	1.927638211474914	1.3334108673551093	0.5942273441198046	4.10991376532489	7184.461585858587	7178.620532224712	35.26531735265756	3.010786578906491	-1.1750000000001477
Wed Jan 01 2020 00:10:00 GMT+0000 (Coordinated Universal Time)	BTC/USDT	7186.83	7188.1	7180.76	7181.88	562841	82	BTC	Wednesday	7180.451343102966	7177.510331732875	7176.709859366508	7179.435866191292	7185.306772672738	7196.225043342379	7177.955904761906	1.336847314217266	1.075972686936239	0.2608746272810271	4.056060978042229	7182.433808080808	7176.715432641733	22.03404727732145	2.121716338674604	-1.545000000000038


CREATE TABLE power_data (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume_usdt" BIGINT,
  "tradecount" BIGINT,
  "token" VARCHAR,
  "hour" BIGINT,
  "day" VARCHAR,
  "ema_5" DOUBLE,
  "ema_15" DOUBLE,
  "ema_30" DOUBLE,
  "ema_60" DOUBLE,
  "ema_100" DOUBLE,
  "ema_200" DOUBLE,
  "wma" DOUBLE,
  "macd" DOUBLE,
  "macd_signal" DOUBLE,
  "macd_hist" DOUBLE,
  "atr" DOUBLE,
  "hma" DOUBLE,
  "kama" DOUBLE,
  "cmo" DOUBLE,
  "z_score" DOUBLE,
  "qstick" DOUBLE
);