ABSTRACT
(1) Last two months, Bitcoin increased ~11% in price, while figures for total replies, total pages, total views between last two periods (31/8/2019-30-9/2019 and 30/9/2019-31/10/2019) fell 11.5%, 27.1%, and 11.6%, respectively. (Details, please see in the last table in the bottom of the post).
(2) In medians, figures for monthly new replies, views, and pages are 6099, 52920, and 268, respectively
Data source (from @VB1001):
https://bitcointalksearch.org/topic/m.52028093
https://bitcointalksearch.org/topic/m.52029308
https://bitcointalksearch.org/topic/m.52325977
https://bitcointalksearch.org/topic/m.52614459
https://bitcointalksearch.org/topic/m.52946959
Converted dataset:
. list id day month2 year date rep repchange prep2 views viewchange pview2 pages pagechange ppages2 btc pbtc, abb(30)
+-----------------------------------------------------------------------------------------------------------------------------------------------------+
| id day month2 year date rep repchange prep2 views viewchange pview2 pages pagechange ppages2 btc pbtc |
|-----------------------------------------------------------------------------------------------------------------------------------------------------|
1. | 1 31 10 2017 31oct2017 361446 . . 19386138 . . 18703 . . 6380 . |
2. | 2 30 11 2017 30nov2017 368288 6842 . 19749672 363534 . 18415 -288 . 9786 53.39 |
3. | 3 31 12 2017 31dec2017 380800 12512 82.87 20076512 326840 -10.09 19041 626 . 13186 34.74 |
4. | 4 31 1 2018 31jan2018 386480 5680 -54.6 20118498 41986 -87.15 19325 284 -54.63 10138 -23.12 |
5. | 5 28 2 2018 28feb2018 396480 10000 76.06 20185277 66779 59.05 19825 500 76.06 10629 4.84 |
|-----------------------------------------------------------------------------------------------------------------------------------------------------|
6. | 6 31 3 2018 31mar2018 402460 5980 -40.2 20222795 37518 -43.82 20109 284 -43.2 7119 -33.02 |
7. | 7 30 4 2018 30apr2018 407457 4997 -16.44 20247143 24348 -35.1 20288 179 -36.97 9275 30.29 |
8. | 8 31 5 2018 31may2018 410507 3050 -38.96 20280891 33748 38.61 20526 238 32.96 7559 -18.5 |
9. | 9 30 6 2018 30jun2018 416730 6223 104.03 20315481 34590 2.49 20787 261 9.66 6457 -14.58 |
10. | 10 31 7 2018 31jul2018 419443 2713 -56.4 20341078 25597 -26 20975 188 -27.97 7848 21.54 |
|-----------------------------------------------------------------------------------------------------------------------------------------------------|
11. | 11 31 8 2018 31aug2018 424622 5179 90.9 20413924 72846 184.59 21132 157 -16.49 6935 -11.63 |
12. | 12 30 9 2018 30sep2018 426942 2320 -55.2 20474102 60178 -17.39 21288 156 -.64 6633 -4.35 |
13. | 13 30 10 2018 30oct2018 430939 3997 72.28 20650285 176183 192.77 21447 159 1.92 6642 .14 |
14. | 14 30 11 2018 30nov2018 437199 6260 56.62 20782977 132692 -24.69 21810 363 128.3 4015 -39.55 |
15. | 15 31 12 2018 31dec2018 446510 9311 48.74 20926425 143448 8.11 22296 486 33.88 3800 -5.35 |
|-----------------------------------------------------------------------------------------------------------------------------------------------------|
16. | 16 31 1 2019 31jan2019 452916 6406 -31.2 21006158 79733 -44.42 22563 267 -45.06 3459 -8.97 |
17. | 17 28 2 2019 28feb2019 459605 6689 4.42 21042628 36470 -54.26 22974 411 53.93 3901 12.78 |
18. | 18 31 3 2019 31mar2019 465823 6218 -7.04 21079099 36471 0 23292 318 -22.63 4103 5.18 |
19. | 19 30 4 2019 30apr2019 473225 7402 19.04 21133357 54258 48.77 23662 370 16.35 5270 28.44 |
20. | 20 31 5 2019 31may2019 480783 7558 2.11 21193583 60226 11 24040 378 2.16 8501 61.31 |
|-----------------------------------------------------------------------------------------------------------------------------------------------------|
21. | 21 30 6 2019 30jun2019 488192 7409 -1.97 21256108 62525 3.82 24410 370 -2.12 11262 32.48 |
22. | 22 31 7 2019 31jul2019 493567 5375 -27.45 21307690 51582 -17.5 24679 269 -27.3 10052 -10.74 |
23. | 23 31 8 2019 31aug2019 497611 4044 -24.76 21343127 35437 -31.3 24881 202 -24.91 9605 -4.45 |
24. | 24 30 9 2019 30sep2019 502612 5001 23.66 21386769 43642 23.15 25131 250 23.76 8247 -14.14 |
25. | 25 31 10 2019 31oct2019 507039 4427 -11.48 21418588 31819 -27.09 25352 221 -11.6 9154 11 |
+-----------------------------------------------------------------------------------------------------------------------------------------------------+
Notes on variables:
- rep: total replies
- repchange: change of total replies between two months
- prep2: percent of change in rep (replies) between two continuous months.
- views: total views
- viewchange: change of total views between two months
- pview2: percent of change in total views (views) between two continuous months.
- pages: total pages
- pagechange: change of total pages between two months
- ppages2: percent of change in total pages (pages) between two continuous months.
- btc: BTC price
- pbtc: percent of change in BTC price (btc) between two continuous months.
Since this update, I use new variables, pview2, prep2, ppages2, because variables for percentage of changes between two months in OP look stupid, so I decided to change.
Now, let I explain the formula for variable prep2:
To make it simple, I have a simple dataset like:
month rep repchange prep2
1 10 na na
2 50 40 na
3 80 30 x
x = (80-50)/(50-10)*100
It means I calculate percentage of changes in two period: period 1 (from month 1 to month 2), period 2 (from month 2 to month 3)
Results:
Period of observations (24 months, Oct. 2017 - 31th Oct. 2019)
In medians, figures for monthly new replies, views, and pages are 6099 (repchange), 52920 (viewchange) and 268 (pagechange), respectively
. tabstat repchange viewchange pagechange, s(n mean sd p50 p25 p75 min max) c(s)
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
repchange | 24 6066.375 2318.993 6099 4712 7122 2320 12512
viewchange | 24 84685.42 89092.09 52920 35953.5 76289.5 24348 363534
pagechange | 24 277.0417 169.5245 268 195 370 -288 626
----------------------------------------------------------------------------------------------
Plots
. list id day month2 year date prep2 pview2 ppages2 pbtc, abb(30)
+---------------------------------------------------------------------------+
| id day month2 year date prep2 pview2 ppages2 pbtc |
|---------------------------------------------------------------------------|
1. | 1 31 10 2017 31oct2017 . . . . |
2. | 2 30 11 2017 30nov2017 . . . 53.39 |
3. | 3 31 12 2017 31dec2017 82.87 -10.09 . 34.74 |
4. | 4 31 1 2018 31jan2018 -54.6 -87.15 -54.63 -23.12 |
5. | 5 28 2 2018 28feb2018 76.06 59.05 76.06 4.84 |
|---------------------------------------------------------------------------|
6. | 6 31 3 2018 31mar2018 -40.2 -43.82 -43.2 -33.02 |
7. | 7 30 4 2018 30apr2018 -16.44 -35.1 -36.97 30.29 |
8. | 8 31 5 2018 31may2018 -38.96 38.61 32.96 -18.5 |
9. | 9 30 6 2018 30jun2018 104.03 2.49 9.66 -14.58 |
10. | 10 31 7 2018 31jul2018 -56.4 -26 -27.97 21.54 |
|---------------------------------------------------------------------------|
11. | 11 31 8 2018 31aug2018 90.9 184.59 -16.49 -11.63 |
12. | 12 30 9 2018 30sep2018 -55.2 -17.39 -.64 -4.35 |
13. | 13 30 10 2018 30oct2018 72.28 192.77 1.92 .14 |
14. | 14 30 11 2018 30nov2018 56.62 -24.69 128.3 -39.55 |
15. | 15 31 12 2018 31dec2018 48.74 8.11 33.88 -5.35 |
|---------------------------------------------------------------------------|
16. | 16 31 1 2019 31jan2019 -31.2 -44.42 -45.06 -8.97 |
17. | 17 28 2 2019 28feb2019 4.42 -54.26 53.93 12.78 |
18. | 18 31 3 2019 31mar2019 -7.04 0 -22.63 5.18 |
19. | 19 30 4 2019 30apr2019 19.04 48.77 16.35 28.44 |
20. | 20 31 5 2019 31may2019 2.11 11 2.16 61.31 |
|---------------------------------------------------------------------------|
21. | 21 30 6 2019 30jun2019 -1.97 3.82 -2.12 32.48 |
22. | 22 31 7 2019 31jul2019 -27.45 -17.5 -27.3 -10.74 |
23. | 23 31 8 2019 31aug2019 -24.76 -31.3 -24.91 -4.45 |
24. | 24 30 9 2019 30sep2019 23.66 23.15 23.76 -14.14 |
25. | 25 31 10 2019 31oct2019 -11.48 -27.09 -11.6 11 |
+---------------------------------------------------------------------------+