Bitcoin Tweets 1.4M

Containing Sentiment

@kaggle.paul92s_bitcoin_tweets_14m

Table List

1 table(145.71 MB)

Cleanprep

@kaggle.paul92s_bitcoin_tweets_14m.cleanprep

145.71 MB
1413000 rows
5 columns

n_2018_07_11_19_35_15_363270 2018-07-11–19:35:15.363270	b_tj B\u0027tj\u0027	b_next_two_weeks_prob_v_boring_climb_up_to_9k_unless_t_067b34e1 B\"Next Two Weeks Prob V Boring (climb Up To 9k) Unless There\u0027s A New Good Listing To Flip That Isn\u0027t Absolute Garbage\\xe2\\x80\\xa6 Https://t.co/ji4dWYaBXA\"	n_0_007272727272727264 0.007272727272727264	n_0_5909090909090909 0.5909090909090909
Wed Jul 11 2018 19:35:15 GMT+0000 (Coordinated Universal Time)	b'Kool_Kheart'	b'@Miss_rinola But you\xe2\x80\x99ve heard about BITCOIN?'
Wed Jul 11 2018 19:35:15 GMT+0000 (Coordinated Universal Time)	b'Gary Lang'	b'Duplicate skilled traders automatically with Bitcoin! \xf0\x9f\x92\xb0\xf0\x9f\x92\xb0\n\nI copy "wangzai888". Do you?\n\n\xe2\x9e\xa1\xef\xb8\x8f https://t.co/VAkIs5LRvI\xe2\x80\xa6 https://t.co/uEeRuwul6m'	0.625	0.5
Wed Jul 11 2018 19:35:15 GMT+0000 (Coordinated Universal Time)	b'Jobs in Fintech'	b'Project Manager - Technical - FinTech - Central London. - Energon People - [ \xe2\x9e\xa1 https://t.co/Jguy5G4MOT ] #IoT\xe2\x80\xa6 https://t.co/xj3GXTHfQp'		0.175
Wed Jul 11 2018 19:35:16 GMT+0000 (Coordinated Universal Time)	b'ERC20'	b'Coinbase App Downloads Drop, Crypto Hype Fading Quick #ERC20 #Bounty #Bitcoin #Etherium #Crypto #ICO #Blockchain https://t.co/DQW1V3gTjh'	0.3333333333333333	0.5
Wed Jul 11 2018 19:35:16 GMT+0000 (Coordinated Universal Time)	b'Lake_Ocean_Pond'	b'If you don\xe2\x80\x99t understand Bitcoin, you don\xe2\x80\x99t understand money'
Wed Jul 11 2018 19:35:17 GMT+0000 (Coordinated Universal Time)	b'Cexy Cocoa'	b'August 10th is an important day. #Bitcoin #ETF $BTC https://t.co/w9JNFmXm6N'	0.4	1
Wed Jul 11 2018 19:35:17 GMT+0000 (Coordinated Universal Time)	b'Nick Slater'	b'With No One Price Law for Bitcoin, Japan\xe2\x80\x99s FSA\nhttps://t.co/8CPHvlk159'
Wed Jul 11 2018 19:35:18 GMT+0000 (Coordinated Universal Time)	b'Coinvered'	b'Crypto Theft Rising and May Reach $1.5 Billion This Year\n\nhttps://t.co/XRw9NUmaJO\n\n$btc $ltc $eth $neo $eos $dgb\xe2\x80\xa6 https://t.co/lHkKpEeZGn'
Wed Jul 11 2018 19:35:18 GMT+0000 (Coordinated Universal Time)	b'CyberWar Books'	b'#Cyberwar #Anonymous Cryptocurrency: Cryptocurrency Basics, Bitcoin, Blockchain and Trading Cryptocurrency \xe2\x80\x93 How\xe2\x80\xa6 https://t.co/mQlEbLuTZX'
Wed Jul 11 2018 19:35:19 GMT+0000 (Coordinated Universal Time)	b'\xef\xbc\xa1\xef\xbd\x89\xef\xbd\x92\xe3\x83\x9e\xe3\x83\xb3'	b'BTC\xe5\xa3\xb2\xe3\x82\x8a\xe3\x81\xbe\xe3\x81\x97\xe3\x81\x97\xe3\x81\x9f\xe3\x81\x84\xe3\x81\x91\xe3\x81\xa9\xe3\x82\x81\xe3\x82\x93\xe3\x81\xa9\xe3\x81\x84\xef\xbd\x97'


CREATE TABLE cleanprep (
  "n_2018_07_11_19_35_15_363270" TIMESTAMP,
  "b_tj" VARCHAR,
  "b_next_two_weeks_prob_v_boring_climb_up_to_9k_unless_t_067b34e1" VARCHAR,
  "n_0_007272727272727264" DOUBLE,
  "n_0_5909090909090909" DOUBLE
);