https://blog.timescale.com/analyzin...ryptocurrencies-using-postgresql-3958b3662e51
Breakdown of coins (summary):
Top 10 of the week this study was conducted...
currency_code | total_volume_in_usd
---------------+---------------------
BTC | 2040879023.54
ETH | 1617388472.94011
LTC | 287613541.293571
XRP | 269417667.514443
ETC | 165712729.612886
ANS | 126377042.5269
SC | 111623857.796786
DASH | 86875922.3588143
ZEC | 78836728.2129428
BTS | 69459051.5958428
Highest daily return and corresponding cryptocurrency (listed by descending date)
time | last | daily_return
------------------------+--------+------------------
2017-06-26 20:00:00+00 | CIN | 40.1428571428571
2017-06-25 20:00:00+00 | KC | 38
2017-06-24 20:00:00+00 | VOYA | 14.2747252747253
2017-06-23 20:00:00+00 | PAY | 3.18506315211422
2017-06-22 20:00:00+00 | YOVI | 119.607843137255
2017-06-21 20:00:00+00 | ION | 7.97665369649805
2017-06-20 20:00:00+00 | TES | 5.25157232704403
2017-06-19 20:00:00+00 | KNC | 150000
2017-06-18 20:00:00+00 | ZNY | 22.5217391304348
2017-06-17 20:00:00+00 | YOVI | 22.0590746115759
2017-06-16 20:00:00+00 | LTD | 9.50207468879668
2017-06-15 20:00:00+00 | AMIS | 168758.782201405
2017-06-14 20:00:00+00 | JANE | 6
2017-06-13 20:00:00+00 | YOVI | 690.636254501801
2017-06-12 20:00:00+00 | U | 5.21452145214522
2017-06-11 20:00:00+00 | JANE | 6
2017-06-10 20:00:00+00 | WGO | 3.58744394618834
2017-06-09 20:00:00+00 | BNT | 5000
2017-06-08 20:00:00+00 | XNC | 52.7704485488127
2017-06-07 20:00:00+00 | CBD | 14.3243243243243
2017-06-06 20:00:00+00 | CC | 72
2017-06-05 20:00:00+00 | BLAZR | 7.38461538461538
2017-06-04 20:00:00+00 | GREXIT | 13.0833333333333
2017-06-03 20:00:00+00 | EPY | 4.29880478087649
2017-06-02 20:00:00+00 | YOVI | 1257.67790262172
2017-06-01 20:00:00+00 | FCN | 8.57142857142857
2017-05-31 20:00:00+00 | EPY | 348.611111111111
2017-05-30 20:00:00+00 | BST | 14.1441860465116
2017-05-29 20:00:00+00 | FCN | 45.3086419753086
2017-05-28 20:00:00+00 | NOO | 56536.231884058