The Reddit Ethereum Dataset

All the mentions of Ethereum on Reddit, up to 1st of November, 2021.

@kaggle.pavellexyr_the_reddit_ethereum_dataset

Table List

2 tables(475.75 MB)

The Reddit Ethereum Dataset Posts

@kaggle.pavellexyr_the_reddit_ethereum_dataset.the_reddit_ethereum_dataset_posts

81.94 MB
479260 rows
12 columns

type Type	id Id	subreddit_id Subreddit.id	subreddit_name Subreddit.name	created_utc Created Utc	permalink Permalink	domain Domain	url Url	selftext Selftext	title Title	score Score
post	qkrfg9	2qiux	riddles	1635811168	https://old.reddit.com/r/riddles/comments/qkrfg9/ethereum_extasy_someone_please_solve_this_for_me/	self.riddles	nan	[removed]	Ethereum Extasy SOMEONE PLEASE SOLVE THIS FOR ME 1 SOLANA IN PRIZE MONEY
post	qkr8mn	2ruj5	xrp	1635810613	https://old.reddit.com/r/XRP/comments/qkr8mn/anyone_have_any_insight_on_the_davis_schwartz/	self.xrp	nan	[removed]	Anyone have any insight on the Davis Schwartz tweet from today about Wrapping XRP for Ethereum?	1
post	qkr4zo	55kwhl	cryptooguide	1635810303	https://old.reddit.com/r/CryptooGuide/comments/qkr4zo/how_and_where_to_buy_ethereum_meta_ethm_step_by/	cryptooguide.com	https://cryptooguide.com/how-to-buy-ethereum-meta-ethm/	nan	How And Where To Buy Ethereum Meta (ETHM) - Step By Step Guide	1
post	qkr3i6	2g94rz	cryptocurrencyclassic	1635810172	https://old.reddit.com/r/CryptoCurrencyClassic/comments/qkr3i6/ethereum_name_service_is_launching_a_governance/	reddit.com	https://www.reddit.com/r/CryptoCurrency/comments/qkqvog/ethereum_name_service_is_launching_a_governance/	nan	Ethereum Name Service Is Launching a Governance Token (x-post from /r/Cryptocurrency)	1
post	qkr3bl	2wlj3	cryptocurrency	1635810155	https://old.reddit.com/r/CryptoCurrency/comments/qkr3bl/red_laser_eyes_for_btc_what_about_ethereum/	self.cryptocurrency	nan	[removed]	Red Laser Eyes for BTC, what about Ethereum?	1
post	qkr0tc	4pp1k7	krypto_deutsch	1635809944	https://old.reddit.com/r/krypto_deutsch/comments/qkr0tc/institutionelle_investoren_gießen_kapital_in/	self.krypto_deutsch	nan	Institutionelle Investoren gießen Kapital in Bitcoin, Ethereum, Solana und zwei weitere Altcoins: CoinShares - Der Digital Asset Manager CoinShares beschreibt eine Veränderung in der Art und Weise, wie Institutionen Kapital an Bitcoin und die Altcoin-Märkte zuweisen. Laut dem jüngsten Bericht des U…	Institutionelle Investoren gießen Kapital in Bitcoin, Ethereum, Solana und zwei weitere Altcoins: CoinShares
post	qkr0p7	3d95h	ethereumnoobies	1635809934	https://old.reddit.com/r/ethereumnoobies/comments/qkr0p7/the_best_time_to_buy_cryptocurrency_was_2009_is/	d-core.net	https://d-core.net/best-time-to-buy-cryptocurrency/	nan	The Best Time To Buy Cryptocurrency Was 2009. Is Now The Near Best? Will Ethereum Eventually Surpass Bitcoin in Value?	2
post	qkr0kw	4pis4h	u_krypto-news-deutsch	1635809925	https://old.reddit.com/r/u_krypto-news-deutsch/comments/qkr0kw/institutionelle_investoren_gießen_kapital_in/	self.krypto-news-deutsch	nan	Institutionelle Investoren gießen Kapital in Bitcoin, Ethereum, Solana und zwei weitere Altcoins: CoinShares - Der Digital Asset Manager CoinShares beschreibt eine Veränderung in der Art und Weise, wie Institutionen Kapital an Bitcoin und die Altcoin-Märkte zuweisen. Laut dem jüngsten Bericht des U…	Institutionelle Investoren gießen Kapital in Bitcoin, Ethereum, Solana und zwei weitere Altcoins: CoinShares	1
post	qkqzzq	3clf5	ethinvestor	1635809881	https://old.reddit.com/r/ethinvestor/comments/qkqzzq/the_best_time_to_buy_cryptocurrency_was_2009_is/	d-core.net	https://d-core.net/best-time-to-buy-cryptocurrency/	nan	The Best Time To Buy Cryptocurrency Was 2009. Is Now The Near Best? When Will Ethereum Surpass Bitcoin in Value?	5
post	qkqyu4	4y1e6p	u_hyper4563	1635809788	https://old.reddit.com/r/u_hyper4563/comments/qkqyu4/visit_our_web_for_more_info_httpsumachitfund/	i.redd.it	https://i.redd.it/oy58re4tmxw71.jpg	nan	Visit our web for more info: https://umachit.fund #umachitfund #ethereum #blockchain #umachitfund #startup #blockchain #ethereum #chitfunds	1


CREATE TABLE the_reddit_ethereum_dataset_posts (
  "type" VARCHAR,
  "id" VARCHAR,
  "subreddit_id" VARCHAR,
  "subreddit_name" VARCHAR,
  "subreddit_nsfw" BOOLEAN,
  "created_utc" BIGINT,
  "permalink" VARCHAR,
  "domain" VARCHAR,
  "url" VARCHAR,
  "selftext" VARCHAR,
  "title" VARCHAR,
  "score" BIGINT
);