AAPL On Reddit by Kaggle | Ecommerce and Consumer Trends

About this Dataset

AAPL On Reddit

AAPL on Reddit

Discussions about AAPL on reddit

By SocialGrep [source]

About this dataset

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?

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

Research Ideas

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

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

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.

Columns

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)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit SocialGrep.

Tables

Five Years Of Aapl On Reddit Comments

@kaggle.thedevastator_aapl_on_reddit_2005_2010.five_years_of_aapl_on_reddit_comments

63.72 MB
297533 rows
11 columns


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
);

Five Years Of Aapl On Reddit Posts

@kaggle.thedevastator_aapl_on_reddit_2005_2010.five_years_of_aapl_on_reddit_posts

2.94 MB
15483 rows
13 columns


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
);