Crypto Subreddit User Count Data
Total & active user subreddit counts for 100+ crypto coins : 6/1/2021 - 1/6/2022
@kaggle.calenmcnickles_crypto_subreddit_user_count_data
Total & active user subreddit counts for 100+ crypto coins : 6/1/2021 - 1/6/2022
@kaggle.calenmcnickles_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.
CREATE TABLE btc_history_yahoo (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE luna_usd_max_coingecko (
"date" VARCHAR,
"price" DOUBLE,
"market_cap" DOUBLE,
"total_volume" DOUBLE
);CREATE TABLE reddit_coins_1062022 (
"date" TIMESTAMP,
"id" BIGINT,
"sub_coin_list" VARCHAR,
"subscriber_count_list" BIGINT,
"subscriber_count_active_list" BIGINT
);CREATE TABLE shib_usd_coingecko (
"date" VARCHAR,
"price" DOUBLE,
"market_cap" BIGINT,
"total_volume" DOUBLE
);Anyone who has the link will be able to view this.