Cryptocurency CoinTelegraph Newsfeed
All CoinTelegraph News from 2013 Until April. Data Set Will keep being updated.
@kaggle.asahicantu_cryptocurency_cointelegraph_newsfeed
All CoinTelegraph News from 2013 Until April. Data Set Will keep being updated.
@kaggle.asahicantu_cryptocurency_cointelegraph_newsfeed
Being unable to get a good dataset for cryptocurrency news, I decided to create my own python script to extract all the news from cointelegraph to perform a cryptomarket sentiment analysis and NLP about the news related to this technology.
This Dataset contains information of all the news published by CoinTelegraph from 2013 until early April 2020. Is divided in the header and the content.
The header has all the metadata concerning the news, whereas the content has the text.
CoinTelegraph and its amazing set of news that have resulted in a great source of knowledge for crytptocurrencies
I required for my Masters a data set for cryptocurrency news, which I could not find anywhere, this dataset will be used to perform NLP and sentiment analysis. Hope it can be useful for the community as well.
CREATE TABLE cointelegraph_news_head (
"unnamed_0" BIGINT -- Unnamed: 0,
"id" BIGINT,
"retina" VARCHAR,
"img" VARCHAR,
"thumb" VARCHAR,
"thumb370" VARCHAR,
"amp_thumb" VARCHAR,
"thumb150" VARCHAR,
"url" VARCHAR,
"title" VARCHAR,
"lead" VARCHAR,
"leadfull" VARCHAR,
"category_id" BIGINT,
"category_url" VARCHAR,
"category_title" VARCHAR,
"author_url" VARCHAR,
"author_hash" VARCHAR,
"author_title" VARCHAR,
"author_img" VARCHAR,
"date" VARCHAR,
"flash_date" TIMESTAMP,
"sponsored" BOOLEAN,
"press_release" BOOLEAN,
"sponsored_label" VARCHAR,
"explained" BOOLEAN,
"stat_uniqs" BIGINT,
"rss_date" VARCHAR,
"publishedw3" VARCHAR,
"badge_title" VARCHAR,
"badge_label" VARCHAR,
"published_date" TIMESTAMP,
"published_timezone_type" BIGINT,
"published_timezone" VARCHAR
);CREATE TABLE quandldata (
"unnamed_0" TIMESTAMP -- Unnamed: 0,
"costpertransaction" DOUBLE,
"difficulty" DOUBLE,
"estimatedtransactionvolume" DOUBLE,
"hashrate" DOUBLE,
"miningoperationmargin" DOUBLE,
"minerrevenue" DOUBLE,
"marketcapitalization" DOUBLE,
"transactionsperday" DOUBLE,
"uniqueaddress" DOUBLE,
"numberoftransactions" DOUBLE,
"totalnumberoftransactions" DOUBLE,
"mined" DOUBLE,
"exchangetradevolume" DOUBLE
);Anyone who has the link will be able to view this.