Bitcoin 17.7 Million Tweets And Price

Bitcoin Tweets sentiment analysis and the price

@kaggle.jaimebadiola_bitcoin_tweets_and_price

Table List

2 tables(2.04 MB)

Df Final

@kaggle.jaimebadiola_bitcoin_tweets_and_price.df_final

1.05 MB
12936 rows
16 columns

date Date	compound_score Compound Score	total_volume_of_tweets Total Volume Of Tweets	count_negatives Count Negatives	count_positives Count Positives	count_neutrals Count Neutrals	sent_negatives Sent Negatives	sent_positives Sent Positives	count_news Count News	count_bots Count Bots	open Open	high High	low Low	close Close	volume_btc Volume (BTC)	volume_currency Volume (Currency)
Tue Aug 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	0.0828933182332956	1027	139	347	397	-0.5166201438848912	0.4178818443804035	695	144	2855.81	2863.06	2823	2825.92	184.02	52295100
Tue Aug 01 2017 01:00:00 GMT+0000 (Coordinated Universal Time)	0.0531597756410256	778	111	193	320	-0.4234018018018017	0.4153849740932644	493	154	2823.01	2860.02	2821.01	2853.38	77.3	219605.16
Tue Aug 01 2017 02:00:00 GMT+0000 (Coordinated Universal Time)	0.1242507987220447	836	89	273	264	-0.440938202247191	0.4286611721611719	510	210	2846.27	2858.04	2837.31	2841.6	135.83	386739.15
Tue Aug 01 2017 03:00:00 GMT+0000 (Coordinated Universal Time)	-0.0210365	984	250	236	314	-0.4411731999999985	0.3960343220338981	683	184	2841.84	2863.88	2837.73	2862.93	143.2	408360.03
Tue Aug 01 2017 04:00:00 GMT+0000 (Coordinated Universal Time)	0.0554374592833876	751	114	195	305	-0.4149780701754385	0.4171594871794867	517	137	2862.92	2876	2848.11	2874.99	222.53	637045.88
Tue Aug 01 2017 05:00:00 GMT+0000 (Coordinated Universal Time)	0.0934437235543019	842	120	286	303	-0.4249658333333329	0.4099562937062938	563	133	2872.03	2929.17	2865.01	2900	415.97	1208323.94
Tue Aug 01 2017 06:00:00 GMT+0000 (Coordinated Universal Time)	0.0554697819314641	777	125	227	290	-0.4573007999999995	0.4086969162995596	525	135	2895.02	2914.67	2851	2878.99	289.04	835105.41
Tue Aug 01 2017 07:00:00 GMT+0000 (Coordinated Universal Time)	0.0745836647727271	863	120	236	348	-0.4180508333333332	0.4350550847457622	595	159	2876.88	2880	2754	2754	693.76	1965698.67
Tue Aug 01 2017 08:00:00 GMT+0000 (Coordinated Universal Time)	0.0448776551724137	1079	142	215	368	-0.3577584507042254	0.3876186046511625	589	354	2753.1	2815.15	2615	2684	1270.21	3438593.1
Tue Aug 01 2017 09:00:00 GMT+0000 (Coordinated Universal Time)	0.0241951935914552	987	134	188	427	-0.4537895522388058	0.4198404255319145	636	238	2685	2731.03	2646.01	2713.04	823.05	2217805.31


CREATE TABLE df_final (
  "date" TIMESTAMP,
  "compound_score" DOUBLE,
  "total_volume_of_tweets" DOUBLE,
  "count_negatives" DOUBLE,
  "count_positives" DOUBLE,
  "count_neutrals" DOUBLE,
  "sent_negatives" DOUBLE,
  "sent_positives" DOUBLE,
  "count_news" DOUBLE,
  "count_bots" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume_btc" DOUBLE,
  "volume_currency" DOUBLE
);