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 Preprocessed

@kaggle.h4t3h4k3rs_ticker_tweets_2018_2023.tweets_preprocessed

8.26 MB
104509 rows
10 columns

unnamed_0 Unnamed: 0	id ID	date Date	text Text	likes Likes	retweets Retweets	replies Replies	quotes Quotes	ticker Ticker	hashtag Hashtag
185	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	[]
192	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']
195	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']
196	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']
203	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	[]
205	1609197948067532800	1672444800	['avgo', 'mrk', 'pg', 'cat', 'de', 'tmf', 'nugt', 'gld']	31		1		DE	[]
206	1604295386197217281	1671321600	['de', 'weekly', 'tw', 'pivot', 'sell', 'signal', 'fired', 'potential', 'double', 'top', 'making', 'aths']	65	11	10	1	DE	[]
207	1606103496616443905	1671753600	['lly', 'hum', 'jnj', 'cat', 'de', 'tjx', 'ms']	54	2	1		DE	[]
208	1604665321729695746	1671408000	['weekly', 'tw', 'pivot', 'sell', 'signals', 'worth', 'keeping', 'eye', 'de', 'nue', 'fmc', 'mnst', 'trv']	23	2	2		DE	[]
209	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']


CREATE TABLE tweets_preprocessed (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "date" DOUBLE,
  "text" VARCHAR,
  "likes" BIGINT,
  "retweets" BIGINT,
  "replies" BIGINT,
  "quotes" BIGINT,
  "ticker" VARCHAR,
  "hashtag" VARCHAR
);