Company Ticker Tweets 2018-2023 NLP

Tweets, affecting companies from 2018 to 2023. Good for NLP researches.

@kaggle.h4t3h4k3rs_ticker_tweets_2018_2023

Table List

5 tables(63.12 MB)

Tweets Merged

Tweets Preprocessed

Tweets Segmented

Tweets Segmented Toned

Tweets Segmented Toned Priced

Tweets Segmented Toned Priced

@kaggle.h4t3h4k3rs_ticker_tweets_2018_2023.tweets_segmented_toned_priced

14.19 MB
104509 rows
13 columns

id ID	date Date	text Text	likes Likes	retweets Retweets	replies Replies	quotes Quotes	ticker Ticker	hashtag Hashtag	segmentedtext SegmentedText#	segmented Segmented#	tone Tone	price Price
1608941517649096705	1672358400	['mine', 'thankful', 'ibm', 'avgo', 'tjx', 'dg', 'unh', 'ba', 'cat', 'de', 'ctva', 'wfc', 'brk', 'b', 'pretty', 'much', 'energy', 'esp', 'slb', 'fang', 'cvxsure', 'didnt', 'catch', 'positive', 'take', 'aways', 'keep', 'faith', 'happy', 'new', 'year']	208	7	25	1	DE	[]	mine thankful ibm avgo tjx dg unh ba cat de ctva wfc brk b pretty much energy esp slb fang cvx sure didnt catch positive take aways keep faith happy new year	nan	Positive	427.422791
1609196318089412609	1672444800	['bill', 'gates', 'top', 'dividend', 'stocks', 'de', 'ko', 'wm', 'cni', 'ecl', 'cat', 'fdx', 'wcn', 'wmt', 'msft', 'top', 'holdings']	46	12	2		DE	['Finance', 'dividend', 'stocks']	bill gates top dividend stocks de ko wm cni ecl cat fdx wcn wmt msft top holdings	finance dividend stocks	Neutral	427.422791
1609203444971352068	1672444800	['stayaway', 'market', 'said', 'fridays', 'thats', 'esp', 'true', 'speculative', 'growth', 'head', 'wait', 'evidence', 'sustained', 'uptrend', '15', 'tsla', 'nio', 'medp', 'xom', 'de', 'celh', 'bmrn', 'li', 'xpev']	38	4	2	2	DE	['IBDLive', 'BYD']	stay away market said friday s thats esp true speculative growth head wait evidence sustained uptrend 1 5 tsla nio medp xom de celh bmrn li xpev	ibd live byd	Neutral	427.422791
1608673073892556800	1672358400	['checking', 'dividend', 'growth', 'pie', 'turns', 'im', 'due', 'receive', '003', 'dividend', 'de', 'got', '125', 'm1', 'pie', 'total', 'funny', 'see', 'stuff', 'like']	19		3		DE	['Dividends', 'DivTwit']	checking dividend growth pie turns im due receive 003 dividend de got 125 m1 pie total funny see stuff like	dividends div twit	Neutral	427.422791
1609332176713318401	1672444800	['great', 'list', 'ig', 'schw', 'bac', 'sbux', 'pep', 'aapl', 'msft', 'abbv', 'mrk', 'nnn', 'vz', 'amt', 'fdx', 'ups', 'cat', 'de', 'cni', 'unp']	83	15	2	1	DE	[]	great list ig schw bac sb ux pep aapl msft abb v mrk nnn vz amt fdx ups cat de cni unp	nan	Positive	427.422791
1609197948067532800	1672444800	['avgo', 'mrk', 'pg', 'cat', 'de', 'tmf', 'nugt', 'gld']	31		1		DE	[]	avgo mrk pg cat de t mf nugt gld	nan	Neutral	427.422791
1604295386197217281	1671321600	['de', 'weekly', 'tw', 'pivot', 'sell', 'signal', 'fired', 'potential', 'double', 'top', 'making', 'aths']	65	11	10	1	DE	[]	de weekly tw pivot s ell signal fired potential double top making a ths	nan	Neutral	428.546722
1606103496616443905	1671753600	['lly', 'hum', 'jnj', 'cat', 'de', 'tjx', 'ms']	54	2	1		DE	[]	lly hum jnj cat de tjx ms	nan	Neutral	434.352264
1604665321729695746	1671408000	['weekly', 'tw', 'pivot', 'sell', 'signals', 'worth', 'keeping', 'eye', 'de', 'nue', 'fmc', 'mnst', 'trv']	23	2	2		DE	[]	weekly tw pivot sell signals worth keeping eye d e nue fmc mnst trv	nan	Neutral	430.117401
1604143011814072320	1671235200	['dividend', 'growth', 'v', 'de', 'hd', 'nke', 'low', 'unh', 'spgi', 'sbux', 'cost', 'avgo', 'msftdividend', 'staples', 'k', 'cl', 'ko', 'pg', 'jnj', 'pep', 'abt', 'fdx', 'hsy', 'sjm', 'mmmetfs', 'vti', 'jepi', 'voo', 'vym', 'qqq', 'schd', 'dgro', 'vdytoreits', 'vici', 'spg', 'amt', 'mpw', 'stagwhat…	92	18	7		DE	['investing']	dividend growth v de hd nke low unh spgi sbux cost avgo msftdividend staples k cl ko pg jnj pep abt fdx hsy sjm mm me tfs vti jepi voo vym qqq schd dgro vdy to reits vici spg amt m pw stagwhat top choices	investing	Neutral	428.546722


CREATE TABLE tweets_segmented_toned_priced (
  "id" BIGINT,
  "date" BIGINT,
  "text" VARCHAR,
  "likes" BIGINT,
  "retweets" BIGINT,
  "replies" BIGINT,
  "quotes" BIGINT,
  "ticker" VARCHAR,
  "hashtag" VARCHAR,
  "segmentedtext" VARCHAR,
  "segmented" VARCHAR,
  "tone" VARCHAR,
  "price" DOUBLE
);