Five Years Of AAPL On Reddit
All AAPL mentions on Reddit, from Nov 2016 to Oct 2021
@kaggle.pavellexyr_five_years_of_aapl_on_reddit
All AAPL mentions on Reddit, from Nov 2016 to Oct 2021
@kaggle.pavellexyr_five_years_of_aapl_on_reddit
Apple is one of the biggest software companies in the world, with its wealth eclipsing many nations. How easily can public opinion sway its valuation? That's the question we hope to find an answer to with this dataset.
This dataset contains a comprehensive collection of posts and comments mentioning AAPL in their title and body text respectively. The data is procured using SocialGrep.
The posts and the comments are labelled with their score.
This dataset was created using SocialGrep Reddit Exports. If social data analysis is your thing, we also have a good tool for Reddit search.
We would also like to thank Bangyu Wang for providing us with the background image for this dataset.
Social media is notoriously fickle, but it does have its unique insights. Can we use wisdom of crowds to predict a company's performance?
CREATE TABLE five_years_of_aapl_on_reddit_comments (
"type" VARCHAR,
"id" VARCHAR,
"subreddit_id" VARCHAR,
"subreddit_name" VARCHAR,
"subreddit_nsfw" BOOLEAN,
"created_utc" BIGINT,
"permalink" VARCHAR,
"body" VARCHAR,
"sentiment" DOUBLE,
"score" BIGINT
);CREATE TABLE five_years_of_aapl_on_reddit_posts (
"type" VARCHAR,
"id" VARCHAR,
"subreddit_id" VARCHAR,
"subreddit_name" VARCHAR,
"subreddit_nsfw" BOOLEAN,
"created_utc" BIGINT,
"permalink" VARCHAR,
"domain" VARCHAR,
"url" VARCHAR,
"selftext" VARCHAR,
"title" VARCHAR,
"score" BIGINT
);Anyone who has the link will be able to view this.