Giter VIP home page Giter VIP logo

financenewsdataset's Introduction

Crypto News Dataset

135k Cryptocurrency news fetched from Cryptopanic.com Perfect for Data Analysis projects.

Using their Api you can only fetch 200 news for each filter.

News are provided both in Excel and MySQL dump

These news are related to 400 highest ranked coins from coinmarketcap.com. News are labled with positive, negative, important and ... by users. Some news are related to 1 coins, some are related to multiple coins and some of them are not related to any specific coin.

Daily candlestick price data is also provided for most of currencies (not all). Fetched from https://www.alphavantage.co/


News Count for high ranked coins:

code count minDatetime maxDatetime
BTC 8575 9/29/2017 13:30 12/8/2023 5:35
ETH 6368 9/23/2017 10:00 12/8/2023 5:09
ADA 3217 1/11/2018 21:35 12/7/2023 21:00
XRP 3136 12/13/2017 16:00 12/7/2023 19:00
SHIB 2668 5/10/2021 10:02 12/7/2023 23:00
DOGE 2598 2/18/2018 10:00 12/8/2023 2:54
SOL 2586 2/10/2021 20:02 12/8/2023 4:56
MATIC 1751 5/22/2019 19:06 12/8/2023 0:00
BNB 1430 11/27/2018 17:17 12/7/2023 19:54
USDT 1415 1/27/2018 23:43 12/8/2023 2:00
LINK 1404 2/28/2020 13:00 12/7/2023 15:00
AVAX 1367 1/24/2021 22:15 12/8/2023 0:00
DOT 1349 8/29/2020 8:39 12/7/2023 11:39
TRX 1336 1/8/2018 6:00 12/7/2023 10:24
FTT 1246 4/16/2020 5:02 12/7/2023 14:27
SELECT t3.code, COUNT(t1.id) AS cnt, MIN(t1.newsDatetime) AS minDatetime, MAX(t1.newsDatetime) AS maxDatetime
FROM cryptopanic_news t1
         JOIN news__currency t2 ON t1.id = t2.newsId
         JOIN currency t3 ON t2.currencyId = t3.id
GROUP BY t3.code
ORDER BY cnt DESC;

Database Diagram:

image


News Example:

image

financenewsdataset's People

Contributors

soheilrahsaz avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.