AAPL On Reddit
Discussions about AAPL on reddit
@kaggle.thedevastator_aapl_on_reddit_2005_2010
Discussions about AAPL on reddit
@kaggle.thedevastator_aapl_on_reddit_2005_2010
By SocialGrep [source]
What impact does public opinion have on the valuation of one of the world's biggest software companies - Apple? This dataset contains a collection of posts and comments from Reddit mentioning AAPL, labelled with their score. Can we use the wisdom of crowds to predict a company's performance?
For more datasets, click here.
- 🚨 Your notebook can be here! 🚨!
Using the ratings and dates of the posts, one could see if there is any sort of correlation between a change in public opinion and AAPL's stock price.
One could use the subreddit name to see which subreddits are more likely to be bullish or bearish on AAPL.
Use the body text to do a sentiment analysis on people's opinions of AAPL
If you use this dataset in your research, please credit the original authors.
Data SourceLicense
License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.
File: five-years-of-aapl-on-reddit-comments.csv
| Column name | Description |
|---|---|
| type | The type of post or comment. (String) |
| subreddit.name | The name of the subreddit the post or comment was made in. (String) |
| subreddit.nsfw | Whether or not the subreddit is NSFW. (Boolean) |
| created_utc | The timestamp of when the post or comment was made. (Integer) |
| permalink | The permalink of the post or comment. (String) |
| body | The body text of the post or comment. (String) |
| sentiment | The sentiment of the post or comment. (String) |
| score | The score of the post or comment. (Integer) |
File: five-years-of-aapl-on-reddit-posts.csv
| Column name | Description |
|---|---|
| type | The type of post or comment. (String) |
| subreddit.name | The name of the subreddit the post or comment was made in. (String) |
| subreddit.nsfw | Whether or not the subreddit is NSFW. (Boolean) |
| created_utc | The timestamp of when the post or comment was made. (Integer) |
| permalink | The permalink of the post or comment. (String) |
| score | The score of the post or comment. (Integer) |
| domain | The domain of the post or comment. (String) |
| url | The URL of the post or comment. (String) |
| selftext | The self-text of the post or comment. (String) |
| title | The title of the post or comment. (String) |
If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit SocialGrep.
CREATE TABLE five_years_of_aapl_on_reddit_comments (
"index" BIGINT,
"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 (
"index" BIGINT,
"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.