Dataset: Crypto Subreddit User Count Data

About this Dataset

Crypto Subreddit User Count Data

I thought it would be interesting to see the relationship between the price movement of the top 100 crypto coins and the user activity of their respective subreddits.

The dataset is made up of the daily total subreddit user count and current active subreddit users from 6/1/2021 - 1/6/2022.

Tables

Btc History Yahoo

@kaggle.calenmcnickles_crypto_subreddit_user_count_data.btc_history_yahoo

15.96 KB
220 rows
7 columns


CREATE TABLE btc_history_yahoo (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Luna Usd Max Coingecko

@kaggle.calenmcnickles_crypto_subreddit_user_count_data.luna_usd_max_coingecko

32.2 KB
951 rows
4 columns


CREATE TABLE luna_usd_max_coingecko (
  "date" VARCHAR,
  "price" DOUBLE,
  "market_cap" DOUBLE,
  "total_volume" DOUBLE
);

Reddit Coins 1062022

@kaggle.calenmcnickles_crypto_subreddit_user_count_data.reddit_coins_1062022

105.39 KB
13810 rows
5 columns


CREATE TABLE reddit_coins_1062022 (
  "date" TIMESTAMP,
  "id" BIGINT,
  "sub_coin_list" VARCHAR,
  "subscriber_count_list" BIGINT,
  "subscriber_count_active_list" BIGINT
);

Shib Usd Coingecko

@kaggle.calenmcnickles_crypto_subreddit_user_count_data.shib_usd_coingecko

9.97 KB
220 rows
4 columns


CREATE TABLE shib_usd_coingecko (
  "date" VARCHAR,
  "price" DOUBLE,
  "market_cap" BIGINT,
  "total_volume" DOUBLE
);