Bitcoin-Daily-WithTA-Lifetime

Historical Data for Bitcoin to 2022/10/3. Includes Technical Analysis Data

@kaggle.shaneaabshire_bitcoindailywithta

Table List

1 table(1.85 MB)

Btc Usd 86400 Ta

@kaggle.shaneaabshire_bitcoindailywithta.btc_usd_86400_ta

1.85 MB
2633 rows
93 columns

time Time	date Date	open Open	high High	low Low	close Close	volume Volume	volume_adi Volume Adi	volume_obv Volume Obv	volume_cmf Volume Cmf	volume_fi Volume Fi	volume_em Volume Em	volume_sma_em Volume Sma Em	volume_vpt Volume Vpt	volume_vwap Volume Vwap	volume_mfi Volume Mfi	volume_nvi Volume Nvi	volatility_bbm Volatility Bbm	volatility_bbh Volatility Bbh	volatility_bbl Volatility Bbl	volatility_bbw Volatility Bbw	volatility_bbp Volatility Bbp	volatility_kcc Volatility Kcc	volatility_kch Volatility Kch	volatility_kcl Volatility Kcl	volatility_kcw Volatility Kcw	volatility_kcp Volatility Kcp	volatility_dcl Volatility Dcl	volatility_dch Volatility Dch	volatility_dcm Volatility Dcm	volatility_dcw Volatility Dcw	volatility_dcp Volatility Dcp	volatility_atr Volatility Atr	trend_macd Trend Macd	trend_macd_signal Trend Macd Signal	trend_macd_diff Trend Macd Diff	trend_sma_fast Trend Sma Fast	trend_sma_slow Trend Sma Slow	trend_ema_fast Trend Ema Fast	trend_ema_slow Trend Ema Slow	trend_vortex_ind_pos Trend Vortex Ind Pos	trend_vortex_ind_neg Trend Vortex Ind Neg	trend_vortex_ind_diff Trend Vortex Ind Diff	trend_trix Trend Trix	trend_mass_index Trend Mass Index	trend_dpo Trend Dpo	trend_kst Trend Kst	trend_kst_sig Trend Kst Sig	trend_kst_diff Trend Kst Diff	trend_ichimoku_conv Trend Ichimoku Conv	trend_ichimoku_base Trend Ichimoku Base	trend_ichimoku_a Trend Ichimoku A	trend_ichimoku_b Trend Ichimoku B	trend_cci Trend Cci	trend_visual_ichimoku_a Trend Visual Ichimoku A	trend_visual_ichimoku_b Trend Visual Ichimoku B	trend_aroon_up Trend Aroon Up	trend_aroon_down Trend Aroon Down	trend_aroon_ind Trend Aroon Ind	trend_psar_up Trend Psar Up	trend_psar_down Trend Psar Down	trend_psar_up_indicator Trend Psar Up Indicator	trend_psar_down_indicator Trend Psar Down Indicator	momentum_rsi Momentum Rsi	momentum_tsi Momentum Tsi	momentum_uo Momentum Uo	momentum_stoch Momentum Stoch	momentum_stoch_signal Momentum Stoch Signal	momentum_wr Momentum Wr	momentum_ao Momentum Ao	momentum_ppo Momentum Ppo	momentum_ppo_signal Momentum Ppo Signal	momentum_ppo_hist Momentum Ppo Hist	momentum_pvo Momentum Pvo	momentum_pvo_signal Momentum Pvo Signal	momentum_pvo_hist Momentum Pvo Hist	momentum_kama Momentum Kama	others_dr Others Dr	others_dlr Others Dlr	others_cr Others Cr
1664755200	Mon Oct 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19059.1	19319.34	18958.29	19196.87	7899.0967874	2540.269015330264	7899.0967874	0.3215898075058778				2806.543274824219	19158.166666666668	50	1000	19196.87	19196.87	19196.87			19158.166666666668	19519.216666666664	18797.11666666667	3.76914979686641	0.5535983012509808	18958.29	19319.34	19138.815	1.8807753555657736	0.6607949037529389					19196.87	19196.87	19196.87	19196.87				34.381831887085134	1	-5062.467360425373	358.1663469987103	358.1663469987103		19138.815	19138.815	19138.815	19138.815		14135.00695974174	14366.465953285226	4	4		18958.29	20182.72			100			66.07949037529389	66.07949037529389	-33.92050962470611								19196.87	35.816634699871045
1664668800	Sun Oct 02 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19315.26	19398.94	18923.81	19059.17	12951.42404465	-3031.680954082247	-5052.327257250001	-0.1454007302024874	-1783411.0909483146	82762580.87949406	82762580.87949406	2736.2895017909614	19138.99779557528		1000	19128.02	19265.719999999998	18990.32	1.439772647665541	0.25	19142.736666666668	19560.826666666664	18724.646666666667	4.368131968591725	0.4000613902907653	18923.81	19398.94	19161.375	2.4839476328443686	0.2848904510344489		-10.984615384615608	-2.1969230769231216	-8.787692307692486	19128.02	19128.02	19175.685384615383	19186.67	0.0778524303581577	0.0698807937809195	0.0079716365772381	-0.0014009852257089	2.049923799250136	-4993.617360425371	353.29525327401143	355.73080013636087	-2.4355468623494403	19161.375	19161.375	19161.375	19161.375	-66.66666666666667	14135.00695974174	14366.465953285226	4	8	-4	18958.29	20182.72				-100	16.187902126336134	28.489045103444887	47.28426773936938	-71.51095489655512		-0.05725128635983	-0.011450257271966	-0.045801029087864	4.8714847284519145	0.9742969456903828	3.897187782761532	19137.3476561345	-0.7173044355668456	-0.7198894327840932	-0.7173044355668456
1664582400	Sat Oct 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19423.57	19486.43	19160	19315.27	7337.45595566	-3388.8545445470727	2285.128698409999	-0.120223404825018	-1260192.0107779067	719996569.9180558	401379575.3987749	5.693000595303516	19186.26098174098	36.39732171985253	1013.43710140578	19190.436666666665	19399.739275876927	18981.1340574564	2.181322007891737	0.7982125588504484	19202.01333333333	19589.55	18814.47666666667	4.036417014604702	0.6461238076397072	18923.81	19486.43	19205.120000000003	2.9317727875221133	0.6957804557250006		0.964014902478084	-1.5647354810428806	2.528750383520965	19190.436666666665	19190.436666666665	19197.1599408284	19196.195925925924	0.1648128875937254	0.1042280072080207	0.0605848803857047	-0.0010719925481811	3.064673054713144	-5056.034027092039	357.7111927557344	356.3909310094853	1.3202617462490591	19205.120000000003	19205.120000000003	19205.120000000003	19205.120000000003	100.00000000000152	14135.00695974174	14366.465953285226	12	8	4	18958.29	20182.72	1		66.69891172914154	-95.95070004980592	30.98366364845181	69.57804557250006	54.71552701707961	-30.42195442749994		0.0050219059348946	-0.0081558246305938	0.0131777305654885	3.246843646087517	1.4288062857698098	1.8180373603177071	19214.29641313484	1.343710140578014	1.334762421029545	0.616767212571645
1664496000	Fri Sep 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19595.59	20182.72	19154.38	19426.11	34243.66392923	-19535.33116318009	36528.79262764	-0.3129075407733027	-537940.6221073689	1037043800.6689848	613267650.4888449	295.1002051406455	19406.46980970828	76.63504814693499	1013.43710140578	19249.355	19522.324094770825	18976.385905229177	2.8361375720986213	0.823763758216658	19298.444166666668	19846.181666666667	18750.70666666667	5.676493869346023	0.6165392485755793	18923.81	20182.72	19553.265	6.540011340639724	0.398995956819788		19.15642877524442	2.57949737021458	16.576931405029843	19249.355	19249.355	19232.3830268548	19213.22659807956	0.2847224156749908	0.1358298457535286	0.1488925699214621	0.0015316914290516	4.341840962424209	-5114.952360425374	361.8796273783883	357.7631051017111	4.116522276677188	19553.265	19553.265	19553.265	19553.265	123.8615138427288	14135.00695974174	14366.465953285226	16	8	8	18923.81	20182.72			74.59635347586965	-91.08499705245386	28.937768895792747	39.8995956819788	45.98889545264125	-60.1004043180212		0.0997043816532054	0.0134162166261659	0.0862881650270394	22.72431803581312	5.687908635778473	17.036409400034646	19305.919749831388	0.5738464955447276	0.5722062684744955	1.1941530051513771
1664409600	Thu Sep 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19412.37	19646.66	18845.3	19595.57	34783.53737085	10813.018715714406	71312.32999849	0.1112276799611448	380967.7871742852	-973537255.8277744	216566423.90969008	499.9336812706943	19390.741013918567	46.86508248883407	1013.43710140578	19318.598	19687.81770443626	18949.378295563736	3.822427532642504	0.8750774900040783	19311.25733333333	19909.71933333333	18712.79533333333	6.198063540554544	0.7375361064417332	18845.3	20182.72	19514.01	6.92296614899281	0.5609830868388385		46.709614245068224	11.40552074518531	35.30409349988291	19318.598	19318.598	19288.25794580021	19241.548331555143	0.3180827708879729	0.2910107411674033	0.0270720297205696	0.0072684240588654	5.65739170272135	-5184.195360425372	366.7785256032151	359.5661892020119	7.212336401203174	19514.01	19514.01	19514.01	19514.01	25.344402203223325	14135.00695974174	14366.465953285226	20	8	12	18923.81	20182.72		1	81.73012208398964	-84.74892591799856	45.69660603787735	56.09830868388385	55.19198331278758	-43.90169131611615		0.2427539272838395	0.0592837587577007	0.1834701685261388	32.7356723723781	11.097461383098398	21.6382109892797	19431.29121276293	0.8723311048892457	0.8685482803583611	2.0769010781445107
1664323200	Wed Sep 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19077.56	19773.67	18487	19412.07	43710.30467197	29955.025114802764	27602.025326519997	0.2125593223325551	-819290.5977515404	-340416186.2212299	105169901.88350607	-105.89147550479596	19339.10011475665	31.56593290747449	1013.43710140578	19334.176666666663	19678.3518481594	18990.00148517393	3.5602776102290763	0.6131594279917274	19296.755555555555	20009.91888888889	18583.592222222225	7.391536170732199	0.5808471489311303	18487	20182.72	19334.86	8.770582938364937	0.5455322812728511		53.12638788387631	19.749694172923512	33.37669371095279	19334.176666666663	19334.176666666663	19307.305954138643	19254.179566254767	0.3744842822429246	0.376327019931468	-0.0018427376885433	0.0129754917620834	7.119829097067331	-5199.77402709204	367.88070636485895	360.9519420624864	6.928764302372599	19334.86	19334.86	19334.86	19334.86	-38.10775142193148	14135.00695974174	14366.465953285226	20	8	12	18923.81	20182.72			61.56816391439708	-80.02608310295157	53.39341204298817	54.55322812728511	50.18371083104925	-45.44677187271489	27.84599999999773	0.2759213276320877	0.1026112725325781	0.1733100550995096	40.84611736662922	17.047192579804566	23.798924786824657	19423.249335171444	-0.9364361434752831	-0.9408482728481716	1.1210160823092563
1664236800	Tue Sep 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19226.94	20383.15	18821.55	19077.57	51860.03004114	-4900.388006341502	-24258.00471462001	-0.0254188602408231	-3180417.6621815106	1421323172.0368664	324528780.24239945	-1302.9476456040577	19362.859393668063	50.81677435423814	1013.43710140578	19297.518571428573	19663.285947217937	18931.751195639208	3.7908228919225975	0.1993327098215077	19315.42238095238	20149.79095238095	18481.05380952381	8.639402804376358	0.3574656398280074	18487	20383.15	19435.075	9.825874725714186	0.311457426891332		30.86458503241738	21.97267234482229	8.891912687595095	19297.518571428573	19297.518571428573	19271.96196119424	19241.09737616182	0.4962974845117409	0.4101809594440703	0.0861165250676705	0.0149882467673778	8.680580278540488	-5163.115931853947	365.2871694342314	361.57126025845	3.715909175781462	19435.075	19435.075	19435.075	19435.075	59.86422310432534	14135.00695974174	14366.465953285226	20	8	12	18487	20182.72	1		41.48019312021216	-76.90538176755094	43.66892707286653	31.145742689133204	47.26575983343405	-68.8542573108668	69.71171428571324	0.1604096919682769	0.1141709564197178	0.046238735548559	46.462592958260494	22.930272655495752	23.53232030276474	19287.14644868486	-1.7231547176576267	-1.7381738134570668	-0.6214554768563807
1664150400	Mon Sep 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	18806.3	19320.86	18681.02	19228	33108.05445715	18597.7204115144	8850.04974252999	0.0823295706790501	-2014580.191585712	-1162273593.8713472	112128441.08329284	-632.5657127915899	19320.907739940118	43.19884747592381	1021.428231469225	19288.82875	19634.048847102924	18943.60865289708	3.5794822130184896	0.4118985967061686	19285.572916666668	20095.625416666662	18475.520416666663	8.400606022960813	0.4644634658453211	18487	20383.15	19435.075	9.830301386236329	0.3907918677319829		25.071382399135477	22.592414355684927	2.4789680434505463	19288.82875	19288.82875	19265.19858254897	19240.127200149836	0.5122340762217796	0.5364117771372305	-0.0241777009154509	0.01594104034574	10.028230554576297	-5154.426110425375	364.672370093208	361.9588989877947	2.713471105413248	19435.075	19435.075	19435.075	19435.075	-100.22394301594662	14135.00695974174	14366.465953285226	20	8	12	18487	20182.72			49.46548801027858	-72.54391335919655	49.317829085661614	39.079186773198295	41.59271919653887	-60.920813226801705	45.68600000000151	0.130307778832877	0.1173983209023497	0.0129094579305273	43.752505536801465	27.09471923175689	16.65778630504457	19263.838462327287	0.7885176151889439	0.7854250612920666	0.1621618524269896
1664064000	Sun Sep 25 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	18920.93	19184.3	18619.88	18808.61	14499.16320537	13794.97856523686	-5649.113462840009	0.057385173580929	-2595469.3151734835	-384800944.7837391	50012267.84991384	-55.18450912591357	19293.767565286755	40.56447850083536	999.1494304500926	19235.47111111111	19679.36326021887	18791.57896200335	4.615349907924548	0.0191837567198287	19239.50148148148	20022.26148148148	18456.741481481484	8.13700917098528	0.2247614329542372	18487	20383.15	19435.075	9.857569846078352	0.169612108746671		-13.208777867952447	15.43217591095745	-28.6409537789099	19235.47111111111	19235.47111111111	19194.954185233742	19208.16296310169	0.5281981239245935	0.5676087505178156	-0.039410626593222	0.0118470192195153	11.226832256846064	-5101.068471536484	360.8973510669709	361.84094921881433	-0.9435981518433892	19435.075	19435.075	19435.075	19435.075	-149.3742942015583	14135.00695974174	14366.465953285226	20	36	-16	18524.923	20182.72			35.089597416640885	-70.09231048249693	48.58835615588566	16.961210874667106	29.06204677899953	-83.0387891253329	-65.17766666666648	-0.0687664816949237	0.080165360382895	-0.1489318420778188	35.92210690888421	28.86019676718236	7.061910141701851	19097.69062805457	-2.181142084460164	-2.2052806312654383	-2.0225172124413997
1663977600	Sat Sep 24 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19286.03	19311.4	18808.13	18923.2	17644.76169841	4218.978083017104	11995.64823556999	0.0163502522353268	-1935843.2354314425	449726092.119177	94424914.99094307	-208.7480062229513	19274.65352716606	44.69962696403923	999.1494304500926	19204.244	19665.157207552136	18743.33079244786	4.800118219203396	0.1951226441388024	19216.975666666665	19971.786666666667	18462.164666666667	7.855668999043153	0.305397863394501	18487	20383.15	19435.075	9.873598773271167	0.2300450913693539	769.2639999999999	-33.90874642059498	5.563991444646964	-39.472737865241946	19204.244	19204.244	19153.145849043936	19187.05459546453	0.5622086539952923	0.5748399530327455	-0.0126312990374531	0.0056921337482823	12.316029405844596	-5069.841360425373	358.6880528102708	361.8989165312099	-3.2108637209391304	19435.075	19435.075	19435.075	19435.075	-80.67937087821186	14135.00695974174	14366.465953285226	20	36	-16	18562.08754	20182.72			40.2031648959272	-66.88283554669866	46.337437936966815	23.00450913693539	26.348302261600267	-76.9954908630646	-84.24550000000454	-0.1767272107966503	0.0287868461469859	-0.2055140569436362	30.28289086697724	29.144735587141337	1.1381552798358996	19033.94928876921	0.6092422566048139	0.6073938795655209	-1.4255969853418704


CREATE TABLE btc_usd_86400_ta (
  "time" BIGINT,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "volume_adi" DOUBLE,
  "volume_obv" DOUBLE,
  "volume_cmf" DOUBLE,
  "volume_fi" DOUBLE,
  "volume_em" DOUBLE,
  "volume_sma_em" DOUBLE,
  "volume_vpt" DOUBLE,
  "volume_vwap" DOUBLE,
  "volume_mfi" DOUBLE,
  "volume_nvi" DOUBLE,
  "volatility_bbm" DOUBLE,
  "volatility_bbh" DOUBLE,
  "volatility_bbl" DOUBLE,
  "volatility_bbw" DOUBLE,
  "volatility_bbp" DOUBLE,
  "volatility_bbhi" DOUBLE,
  "volatility_bbli" DOUBLE,
  "volatility_kcc" DOUBLE,
  "volatility_kch" DOUBLE,
  "volatility_kcl" DOUBLE,
  "volatility_kcw" DOUBLE,
  "volatility_kcp" DOUBLE,
  "volatility_kchi" DOUBLE,
  "volatility_kcli" DOUBLE,
  "volatility_dcl" DOUBLE,
  "volatility_dch" DOUBLE,
  "volatility_dcm" DOUBLE,
  "volatility_dcw" DOUBLE,
  "volatility_dcp" DOUBLE,
  "volatility_atr" DOUBLE,
  "volatility_ui" DOUBLE,
  "trend_macd" DOUBLE,
  "trend_macd_signal" DOUBLE,
  "trend_macd_diff" DOUBLE,
  "trend_sma_fast" DOUBLE,
  "trend_sma_slow" DOUBLE,
  "trend_ema_fast" DOUBLE,
  "trend_ema_slow" DOUBLE,
  "trend_vortex_ind_pos" DOUBLE,
  "trend_vortex_ind_neg" DOUBLE,
  "trend_vortex_ind_diff" DOUBLE,
  "trend_trix" DOUBLE,
  "trend_mass_index" DOUBLE,
  "trend_dpo" DOUBLE,
  "trend_kst" DOUBLE,
  "trend_kst_sig" DOUBLE,
  "trend_kst_diff" DOUBLE,
  "trend_ichimoku_conv" DOUBLE,
  "trend_ichimoku_base" DOUBLE,
  "trend_ichimoku_a" DOUBLE,
  "trend_ichimoku_b" DOUBLE,
  "trend_stc" DOUBLE,
  "trend_adx" DOUBLE,
  "trend_adx_pos" DOUBLE,
  "trend_adx_neg" DOUBLE,
  "trend_cci" DOUBLE,
  "trend_visual_ichimoku_a" DOUBLE,
  "trend_visual_ichimoku_b" DOUBLE,
  "trend_aroon_up" DOUBLE,
  "trend_aroon_down" DOUBLE,
  "trend_aroon_ind" DOUBLE,
  "trend_psar_up" DOUBLE,
  "trend_psar_down" DOUBLE,
  "trend_psar_up_indicator" DOUBLE,
  "trend_psar_down_indicator" DOUBLE,
  "momentum_rsi" DOUBLE,
  "momentum_stoch_rsi" DOUBLE,
  "momentum_stoch_rsi_k" DOUBLE,
  "momentum_stoch_rsi_d" DOUBLE,
  "momentum_tsi" DOUBLE,
  "momentum_uo" DOUBLE,
  "momentum_stoch" DOUBLE,
  "momentum_stoch_signal" DOUBLE,
  "momentum_wr" DOUBLE,
  "momentum_ao" DOUBLE,
  "momentum_roc" DOUBLE,
  "momentum_ppo" DOUBLE,
  "momentum_ppo_signal" DOUBLE,
  "momentum_ppo_hist" DOUBLE,
  "momentum_pvo" DOUBLE,
  "momentum_pvo_signal" DOUBLE,
  "momentum_pvo_hist" DOUBLE,
  "momentum_kama" DOUBLE,
  "others_dr" DOUBLE,
  "others_dlr" DOUBLE,
  "others_cr" DOUBLE
);