An Analysis of Ethereum & Bitcoin Markets

Medium Article

Technology : Python(Beautifulsoup, Pandas, Matplotlib, Seaborn), Ruby on Rails (Web), JavaScript (D3.js)

Data transformation : html -> Jupyter/Python -> D3/JavaScript


Table 1: Bitcoin data (2013-05-01 to 2017-12-31)

var data = [{Date: 'string', Open: 'String', ... MarketCapPercentDiff: 'STRING'}, object, object, ...];

`Close Diff` = Today closing price - Yesterday closing price

Date Open High Low Close Volume MarketCap Price Spread Close Diff Close Diff (%) MarketCap Diff (%)

Table 2: Ethereum data (2015-08-08 to 2017-12-31)

var data = [{Date: 'string', Open: 'String', ... MarketCapPercentDiff: 'STRING'}, object, object, ...];

`Close Diff` = Today closing price - Yesterday closing price

Date Open High Low Close Volume MarketCap Price Spread Close Diff Close Diff (%) MarketCap Diff (%)

Heatmap 1: Bitcoin calendar heatmap for closing price difference % (2013-05-01 to 2017-12-31)

Days with at least 15% jump: ['2013-05-04', '2013-11-18', '2013-11-21', '2013-11-26', '2013-12-19', '2014-03-03', '2014-04-11', '2014-11-12', '2015-01-15', '2017-07-17', '2017-07-20', '2017-09-15', '2017-12-06', '2017-12-07']

Days with at least 15% drop: ['2013-07-05', '2013-11-19', '2013-12-01', '2013-12-06', '2013-12-07', '2013-12-16', '2013-12-18', '2014-01-07', '2014-03-27', '2014-04-10', '2015-01-13', '2015-01-14', '2015-08-18', '2016-01-15', '2017-09-14']


Heatmap 2: Ethereum calendar heatmap for closing price difference % (2015-08-08 to 2017-12-31)

Days with at least 15% jump: ['2015-08-11', '2015-08-13', '2015-08-19', '2015-08-20', '2015-10-22', '2015-10-26', '2015-10-27', '2015-10-29', '2015-11-01', '2016-01-23', '2016-01-25', '2016-02-07', '2016-02-09', '2016-02-11', '2016-02-18', '2016-02-22', '2016-03-01', '2016-03-09', '2016-03-12', '2016-04-30', '2016-07-22', '2016-08-03', '2016-12-06', '2017-01-03', '2017-01-04', '2017-02-14', '2017-03-13', '2017-03-15', '2017-03-16', '2017-03-19', '2017-03-24', '2017-04-27', '2017-04-30', '2017-05-04', '2017-05-19', '2017-05-21', '2017-05-30', '2017-06-10', '2017-06-12', '2017-07-12', '2017-07-17', '2017-07-18', '2017-09-15', '2017-09-18', '2017-11-24', '2017-12-11', '2017-12-12']

Days with at least 15% drop: ['2015-08-17', '2015-09-11', '2015-09-28', '2015-11-11', '2016-02-16', '2016-03-07', '2016-06-17', '2016-06-18', '2016-08-02', '2017-03-18', '2017-09-04', '2017-09-14', '2017-12-22']


Table 3: Bitcoin and Ethereum growth rate (2015-08-08 to 2017-12-31)

How growth rate is calculated: Closing price of each day / closing price of 2015-08-08

Date Bitcoin growth Ethereum growth