Skip to main content

Workshop: Cryptocurrency Insight

CoinMarketCap is the world's most-referenced price-tracking website for cryptoassets in the rapidly growing cryptocurrency space. Its mission is to make crypto discoverable and efficient globally by empowering retail users with unbiased, high quality and accurate information for drawing their own informed conclusions.

Step 1: Find Data Source

API endpoint overview: https://coinmarketcap.com/api/documentation/v1/#section/Endpoint-Overview:

The CoinMarketCap API is divided into 8 top-level categories

Endpoint CategoryDescription
/cryptocurrency/*Endpoints that return data around cryptocurrencies such as ordered cryptocurrency lists or price and volume data.
/exchange/*Endpoints that return data around cryptocurrency exchanges such as ordered exchange lists and market pair data.
/global-metrics/*Endpoints that return aggregate market data such as global market cap and BTC dominance.
/tools/*Useful utilities such as cryptocurrency and fiat price conversions.
/blockchain/*Endpoints that return block explorer related data for blockchains.
/fiat/*Endpoints that return data around fiats currencies including mapping to CMC IDs.
/partners/*Endpoints for convenient access to 3rd party crypto data.
/key/*API key administration endpoints to review and manage your usage.

OK, there do have posibility to get insights from CoinMarketCap.

Step 2: Load Data to TiDB

Not ready, you can try it.

Step 3: Get Insights with SQL

Not ready, you can try it.

Video Thumbnail