Analyzing Ethereum, Bitcoin, and 1200+ other Cryptocurrencies using PostgreSQL

in #postgresql7 years ago

Cryptocurrencies are fueling a modern day gold rush. Can data help us better understand this evolving market?

Lately it seems like money has been growing on trees.
With trade volumes reaching billions of dollars a day and market caps hitting tens of billions of dollars, it’s no wonder that cryptocurrencies fuel the gold rush of the modern day.

For this analysis*, we looked at historical OHLCV price data on over 1200 cryptocurrencies (as of 6/26/2017; courtesy of CryptoCompare).

Here’s what you should take away from this post:

  • Several high-level insights into the cryptocurrency market
  • A better understanding of how TimescaleDB + PostgreSQL make time-series data analysis easier
  • Instructions on how to load this dataset yourself and draw your own insights (and perhaps find your own arbitrage opportunities!)

What about the 1200 other cryptocurrencies??

Who’s at the head of the cryptocurrency long tail?

What are the most profitable cryptocurrencies?

So money grows on… Merkle Trees?

https://blog.timescale.com/analyzing-ethereum-bitcoin-and-1200-cryptocurrencies-using-postgresql-3958b3662e51

Sort:  

I'm writing my first post from a newbies perspective and in my research saw around 950+ cryptocurrencies. Where can I find more information besides your blog post?

Thanks very much for this information btw,

Coin Marketplace

STEEM 0.21
TRX 0.19
JST 0.034
BTC 91427.29
ETH 3128.51
USDT 1.00
SBD 2.92