Dataset Name: reddit_stocks_posts
Group: social_media
Vendor: Reddit powered by CloudQuant
Data Starts at: 2021-01-01 00:00:00
Symbol Set: Meme Securities
Asset Class: Equity
Data Update Time(s): live
Data Update Frequency: intraday
The posts from Reddit's r/stocks with multiple NLP sentiment scores and mapped to cash tags and stock trading symbols. This dataset is free of charge to licensed CloudQuant users. R/Stocks - Investing and trading for all. Almost any post related to stocks is welcome on /r/stocks. Don't hesitate to tell us about a ticker we should know about, but read the sidebar rules before you post.
Data Contained in this Dataset
| Column | Type | Description |
|---|---|---|
| _seq | uint | Internal sequence number used to keep data rows in order |
| timestamp | string | Timestamp of the Data - America/New York Time. |
| muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
| symbol | string | Trading Symbol or Ticker |
| approved_at_utc | string | timestamp of approval. null if nobody or you are not a mod |
| subreddit | string | subreddit the post/comment belongs to |
| selftext | string | Submission Text |
| author_fullname | string | The comment author’s ID prepended with t2_. |
| saved | bool | true if this post is saved by the logged in user |
| mod_reason_title | string | The mod reason’s title if applicable. |
| gilded | int | the number of times this comment received reddit gold |
| clicked | bool | Bool - Clicked |
| title | string | The Reddit post title |
| link_flair_richtext | string | String - Link flair Rich Text |
| subreddit_name_prefixed | string | subreddit_name_prefixed The name of the subreddit the submission was posted on, prefixed with “r/”. |
| hidden | bool | Hidden (bool) |
| pwls | int | Reddit PWLS code |
| link_flair_css_class | string | Flair applied to the reddit link |
| downs | int | the number of downvotes. (includes own) |
| thumbnail_height | int | Height of the thumbnail |
| top_awarded_type | string | post/comment highest (most expensive) reward |
| hide_score | bool | Bool - Hide Score |
| name | string | Full name of the submission. |
| quarantine | bool | Whether the submission was posted in a quarantined subreddit |
| link_flair_text_color | string | The submission’s flair text color if applicable. |
| upvote_ratio | double | Reddit Up Vote Ratio |
| author_flair_background_color | string | The submission/comment author’s flair background color. |
| subreddit_type | string | the subreddit's type - one of public, private, restricted, or in very special cases gold_restricted or archived |
| ups | int | the number of upvotes. (includes own) |
| total_awards_received | int | The number of awards on the submission |
| media_embed | string | Media Embedded in Post or Comment |
| thumbnail_width | int | The width of the submission’s thumbnail if applicable |
| author_flair_template_id | string | The comment author’s flair template ID if applicable. |
| is_original_content | bool | Whether the submission has been marked as original content |
| user_reports | string | A list of the user reports on the submission |
| secure_media | string | Secure media flag |
| is_reddit_media_domain | bool | Whether the media has been uploaded to Reddit. |
| is_meta | bool | Whether the submission is a meta post. |
| category | string | The submission’s category. |
| secure_media_embed | string | Secure media embedded in post or comment |
| link_flair_text | string | The submission’s flair text |
| can_mod_post | string | Whether the logged-in user can modify the post. |
| score | int | the net-score of the comment |
| approved_by | string | who approved this comment. null if nobody or you are not a mod |
| author_premium | bool | bool - Author Premium |
| thumbnail | string | A URL to the submission’s thumbnail if applicable |
| edited | string | Whether or not the submission has been edited |
| author_flair_css_class | string | the CSS class of the author's flair. subreddit specific |
| author_flair_richtext | string | The comment author’s flair text if applicable |
| gildings | string | The gild awards the submission has received. |
| content_categories | string | The content categories assigned to the submission |
| is_self | bool | Whether the submission is a self post. |
| mod_note | string | Moderator notes added to the submission. |
| created | string | the time of creation in local epoch-second format. ex: 1331042771.0 |
| link_flair_type | string | The type of flair applied to the submission |
| wls | int | Reddit WLS Code |
| removed_by_category | string | removed by category |
| banned_by | string | moderator that banned this post/comment |
| author_flair_type | string | The type of flair used by the submission’s author. |
| domain | string | The domain of the submission. |
| allow_live_comments | bool | Whether live comments have been enabled on this submission. |
| selftext_html | string | The submission text as HTML |
| likes | string | how the logged-in user has voted on the link - True = upvoted, False = downvoted, null = no vote |
| suggested_sort | string | The suggested sort method for comments |
| banned_at_utc | string | The UTC timestamp at which the author was banned. |
| view_count | string | The number of views on the submission. |
| archived | bool | Whether the submission has been archived by Reddit. |
| no_follow | bool | Bool - No Follow indicator |
| is_crosspostable | bool | Whether the submission can be cross-posted to other subreddits |
| pinned | bool | Whether the submission has been pinned on the subreddit. |
| over_18 | bool | Whether the submission/comment has been marked NSFW. |
| all_awardings | string | A list of awards added to the submission/comment |
| awarders | string | List of users who gave this post/comment an award |
| media_only | bool | Whether the submission only consists of media |
| link_flair_template_id | string | The submission’s flair template ID if applicable |
| can_gild | bool | Whether the logged-in user can gild the submission |
| spoiler | bool | Whether the submission contains a spoiler. |
| locked | bool | whether the link is locked (closed to new comments) or not. |
| author_flair_text | string | the text of the author's flair. subreddit specific |
| treatment_tags | string | Community content tags are tags that moderators add to their communities to let redditors know what kind of mature content is in that community. In the past, Reddit used a Not Safe for Work (NSFW) tag to distinguish communities and content most people wou |
| visited | bool | Whether the logged-in user has visited the submission previously. |
| removed_by | string | reddit id of who removed the content |
| num_reports | string | how many times this comment has been reported, null if not a mod |
| distinguished | string | to allow determining whether they have been distinguished by moderators/admins. null = not distinguished. moderator = the green [M]. admin = the red [A]. special = various other special distinguishes |
| subreddit_id | string | subreddit_id: The subreddit’s ID prepended with t5_. |
| mod_reason_by | string | The moderator who added the removal reason if applicable. |
| removal_reason | string | A removal reason set by moderators if applicable. |
| link_flair_background_color | string | The submission’s flair background color |
| id | string | unique id for post/comment |
| is_robot_indexable | bool | Whether the submission can be indexed by robots |
| report_reasons | string | A list of report reasons on the submission. |
| author | string | User information who wrote the post/comment |
| discussion_type | string | reddit discussion type indicators |
| num_comments | int | The number of comments on the submission. |
| send_replies | bool | Whether the author of the submission will receive reply notifications |
| whitelist_status | string | Submission whitelist status |
| contest_mode | bool | Whether the moderators of the subreddit have enabled contest mode on the submission |
| mod_reports | string | A list of moderator reports on the submission/comment |
| author_patreon_flair | bool | The comment author’s Patreon flair if applicable. |
| author_flair_text_color | string | The submission/comment author flair text color if applicable. |
| permalink | string | The collection’s permalink (to view on the web). |
| parent_whitelist_status | string | Parent Whitelist Status (string) |
| stickied | bool | true if the post is set as the sticky in its subreddit. |
| url | string | The full URL of the submission |
| subreddit_subscribers | int | The number of subscribers to the submission’s subreddit |
| created_utc | string | the time of creation in UTC epoch-second format. Note that neither of these ever have a non-zero fraction. |
| num_crossposts | int | The number of times the submission has been cross-posted |
| media | string | Post/Comment media |
| is_video | bool | Whether the submission is a video post. |
| comment_limit | int | comment limit |
| comment_sort | string | comment sort |
| symbols | string | Symbols found in title and body and parent of a post or a comment which includes cashtags |
| cashtags | string | Cashtags found in title and body of a post or a comment as well as a comment's parents |
| symbol_src | string | where the symbol was found. Either: title, body, or parent |
| vader_body_sentiment_neg | double | Percentage (%) of the body text that is negative |
| vader_body_sentiment_neu | double | Percentage (%) of the body text that is neutral |
| vader_body_sentiment_pos | double | Percentage (%) of the body text that is positive |
| vader_body_sentiment_compound | double | sum of all the body text sentiment ratings |
| vader_title_sentiment_neg | double | Percentage (%) of the title text that is negative (always 0 for a comment) |
| vader_title_sentiment_neu | double | Percentage (%) of the title text that is neutral (always 0 for a comment) |
| vader_title_sentiment_pos | double | Percentage (%) of the body text that is positive (always 0 for a comment) |
| vader_title_sentiment_compound | double | sum of all the body text sentiment ratings |
| textblob_body_sentiment_polarity | double | The polarity score is a float within the range [-1.0, 1.0]. The subjectivity is a float within the range [0.0, 1.0] where 0.0 is very objective and 1.0 is very subjective. |
| textblob_body_sentiment_subjectivity | double | The subjectivity is a float within the range [0.0, 1.0] where 0.0 is very objective and 1.0 is very subjective. |
| textblob_title_sentiment_polarity | double | The polarity score is a float within the range [-1.0, 1.0]. The subjectivity is a float within the range [0.0, 1.0] where 0.0 is very objective and 1.0 is very subjective. |
| textblob_title_sentiment_subjectivity | double | The subjectivity is a float within the range [0.0, 1.0] where 0.0 is very objective and 1.0 is very subjective. |