Dataset Name: reddit_daytrading_comments
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 comments from Reddit's r/daytrading 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/Daytrading covers intraday trading of futures, forex, stocks, etc.
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 |
| total_awards_received | int | The number of awards on the submission |
| approved_at_utc | string | timestamp of approval. null if nobody or you are not a mod |
| comment_type | string | Reddit comment type |
| awarders | string | List of users who gave this post/comment an award |
| mod_reason_by | string | The moderator who added the removal reason if applicable. |
| banned_by | string | moderator that banned this post/comment |
| author_flair_type | string | The type of flair used by the submission’s author. |
| removal_reason | string | A removal reason set by moderators if applicable. |
| link_id | string | ID of the link this comment is in |
| author_flair_template_id | string | The comment author’s flair template ID if applicable. |
| likes | string | how the logged-in user has voted on the link - True = upvoted, False = downvoted, null = no vote |
| user_reports | string | A list of the user reports on the submission |
| saved | bool | true if this post is saved by the logged in user |
| id | string | unique id for post/comment |
| banned_at_utc | string | The UTC timestamp at which the author was banned. |
| mod_reason_title | string | The mod reason’s title if applicable. |
| gilded | int | the number of times this comment received reddit gold |
| archived | bool | Whether the submission has been archived by Reddit. |
| no_follow | bool | Bool - No Follow indicator |
| author | string | User information who wrote the post/comment |
| edited | string | Whether or not the submission has been edited |
| can_mod_post | bool | Whether the logged-in user can modify the post. |
| created_utc | string | the time of creation in UTC epoch-second format. Note that neither of these ever have a non-zero fraction. |
| send_replies | string | Whether the author of the submission will receive reply notifications |
| parent_id | string | link to the either a comment or post that is the immediate parent of this comment |
| score | int | the net-score of the comment |
| author_fullname | string | The comment author’s ID prepended with t2_. |
| 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 |
| approved_by | string | who approved this comment. null if nobody or you are not a mod |
| mod_note | string | Moderator notes added to the submission. |
| all_awardings | string | A list of awards added to the submission/comment |
| subreddit_id | string | subreddit_id: The subreddit’s ID prepended with t5_. |
| body | string | comment raw text |
| author_flair_css_class | string | the CSS class of the author's flair. subreddit specific |
| name | string | Full name of the submission. |
| author_patreon_flair | string | The comment author’s Patreon flair if applicable. |
| downs | int | the number of downvotes. (includes own) |
| author_flair_richtext | string | The comment author’s flair text if applicable |
| is_submitter | bool | Whether the logged-in user is the submitter of this comment. |
| body_html | string | the formatted HTML text as displayed on reddit. |
| gildings | string | The gild awards the submission has received. |
| collapsed_reason | string | reason comment is minimized |
| 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 |
| associated_award | string | Associated Award |
| stickied | bool | true if the post is set as the sticky in its subreddit. |
| author_premium | bool | bool - Author Premium |
| can_gild | bool | Whether the logged-in user can gild the submission |
| top_awarded_type | string | post/comment highest (most expensive) reward |
| author_flair_text_color | string | The submission/comment author flair text color if applicable. |
| score_hidden | bool | Whether the comment's score is currently hidden. |
| permalink | string | The collection’s permalink (to view on the web). |
| num_reports | string | how many times this comment has been reported, null if not a mod |
| report_reasons | string | A list of report reasons on the submission. |
| subreddit | string | subreddit the post/comment belongs to |
| author_flair_text | string | the text of the author's flair. subreddit specific |
| created | string | the time of creation in local epoch-second format. ex: 1331042771.0 |
| collapsed | bool | Whether the comment should be collapsed by clients |
| subreddit_name_prefixed | string | subreddit_name_prefixed The name of the subreddit the submission was posted on, prefixed with “r/”. |
| controversiality | int | A score on the comment’s controversiality based on its up- and downvotes. |
| locked | bool | whether the link is locked (closed to new comments) or not. |
| author_flair_background_color | string | The submission/comment author’s flair background color. |
| collapsed_because_crowd_control | string | thread collapsed because of volume of replies (comments replying to post/comment) |
| mod_reports | string | A list of moderator reports on the submission/comment |
| 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) |
| 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. |