Twitter Sentiment Data For Btc And Its Price
Correlating hourly BTC price with hourly sentiment sum of BTC-related tweets.
@kaggle.roysharma_dfdssfs
Correlating hourly BTC price with hourly sentiment sum of BTC-related tweets.
@kaggle.roysharma_dfdssfs
This dataset represents an hourly aggregation of sentiments of Tweets related to Bitcoin (BTC) during January of 2023, correlating with BTC price intervals. Each record includes the start and end times of hourly price data, alongside summarized Twitter interaction metrics such as retweets, replies, likes, quotes, and impressions. Additionally, the dataset encompasses total sentiment scores and weighted sentiment scores, providing insights into the public sentiment towards Bitcoin during each hour. This data is instrumental for analyzing the impact of social media dynamics on Bitcoin's price fluctuations.
all the extraction and aggregation notebooks :- https://github.com/raghav-sharma272381/BTC_sentiment
CREATE TABLE hourly_price (
  "priceend" DOUBLE,
  "pricestart" DOUBLE,
  "sumretweetcount" BIGINT,
  "sumreplycount" BIGINT,
  "sumlikecount" BIGINT,
  "sumquotecount" BIGINT,
  "sumimpressioncount" BIGINT,
  "sumvolume" DOUBLE,
  "sumsentimentscore" DOUBLE,
  "weightedsentimentscore" DOUBLE
);Anyone who has the link will be able to view this.