Does anyone have data on wakeups they can turn into a graph?

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Quote from: Vod on January 16, 2021, 06:51:11 PM

You could overlay the average price of bitcoin on that chart. I bet you the price wave would precede the wake up wave by a few days to a week.

Hang on. I can and I will do something like this soon.

Update (overlay it with BTC's daily close price -- taken from coinmarketcap.com. Multipliers are used to make plots are visually comparative).

I think woke-up counts are more correlated to sudden good campaigns or bounties on the forum. It is different than daily new members that are more correlated to bitcoin price.

Vod

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

Quote from: tranthidung on December 21, 2020, 10:28:34 PM

Time series plot

You could overlay the average price of bitcoin on that chart. I bet you the price wave would precede the wake up wave by a few days to a week.

tranthidung

legendary

Activity: 2310

Merit: 4085

Farewell o_e_l_e_o

Here: https://loyce.club/seclog/seclog.txt
In median: for 3 years (2018, 2019 and 2020) there are 177 wokeup accounts each day with the 50% of observed days have from 0 to 227 woke up accounts. If narrows down the window to 2019 and 2020, there are 208 wokeup accounts each day with the 50% of observed days have from 173 to 253 woke up accounts
All time high is at 5716, on 13 May 2019
I did not check prospectively but I recalled the Yobit campaign was run in middle months of 2019 so the all time high of wokeup probably was triggered by that spam campaign

Time series plot

Summary stats

Code:

Summary for variables: wokeup
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
   2018 | 344.0 31.8 64.1 0.0 0.0 0.0 0.0 362.0
   2019 | 365.0 258.6 458.8 200.0 11.0 274.0 1.0 5716.0
   2020 | 307.0 244.8 188.3 211.0 190.0 242.0 139.0 2612.0
----------+--------------------------------------------------------------------------------
   Total | 1016.0 177.6 313.9 177.0 0.0 227.0 0.0 5716.0
-------------------------------------------------------------------------------------------

Code:

Summary for variables: wokeup
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
----------+--------------------------------------------------------------------------------
   2019 | 365.0 258.6 458.8 200.0 11.0 274.0 1.0 5716.0
   2020 | 307.0 244.8 188.3 211.0 190.0 242.0 139.0 2612.0
----------+--------------------------------------------------------------------------------
   Total | 672.0 252.3 361.2 208.0 173.0 252.5 1.0 5716.0
-------------------------------------------------------------------------------------------

Top 50 days of most wokeups

Code:

+---------------------------+
   | rank wokeup date |
   |---------------------------|
   1. | 1 5716 13may2019 |
   2. | 2 3136 28apr2019 |
   3. | 3 3070 19oct2019 |
   4. | 4 2612 06feb2020 |
   5. | 5 2291 20oct2019 |
   6. | 6 2278 14may2019 |
   7. | 7 1901 30oct2020 |
   8. | 8 1747 17jun2019 |
   9. | 9 1652 30oct2019 |
  10. | 10 1489 13aug2019 |
  11. | 11 1378 12aug2019 |
  12. | 12 1358 15may2019 |
  13. | 13 1319 16may2019 |
  14. | 14 1247 14aug2019 |
  15. | 15 1072 18jun2019 |
  16. | 16 1020 11feb2020 |
  17. | 17 1014 21oct2019 |
  18. | 18 1011 01nov2019 |
  19. | 19 996 29apr2019 |
  20. | 20 927 12may2019 |
  21. | 21 839 02nov2019 |
  22. | 22 816 27apr2019 |
  23. | 23 770 14nov2019 |
  24. | 24 686 15aug2019 |
  25. | 25 680 15mar2020 |
  26. | 26 668 14mar2020 |
  27. | 27 624 16mar2020 |
  28. | 28 600 16jun2019 |
  29. | 29 600 17mar2020 |
  30. | 30 590 22feb2020 |
  31. | 31 567 03feb2020 |
  32. | 32 549 05jun2019 |
  33. | 33 537 03jun2019 |
  34. | 34 535 10feb2020 |
  35. | 35 517 04nov2019 |
  36. | 36 498 23feb2020 |
  37. | 37 490 02jun2019 |
  38. | 38 479 06jun2019 |
  39. | 39 471 10dec2019 |
  40. | 40 471 11may2019 |
  41. | 41 425 09sep2020 |
  42. | 42 416 22oct2020 |
  43. | 43 415 18mar2020 |
  44. | 44 413 24jun2019 |
  45. | 45 410 31oct2020 |
  46. | 46 398 11jun2019 |
  47. | 47 398 26jun2019 |
  48. | 48 386 17oct2019 |
  49. | 49 386 29oct2020 |
  50. | 50 384 28may2019 |
   +---------------------------+

I plan to make a year-end analysis in that thread Forum observations - new accounts, posts, topics, wokeups, merits, ad stats

jackg

copper member

Activity: 2856

Merit: 3071

https://bit.ly/387FXHi lightning theory

If anyone has a years' worth of the seclog I'll be interested to take a copy.

I want a graph that plots the number of account wakeups for a given day with a label for when the ath was crossed as I suspect a lot of people from the last bull run could've just been waiting for the mainstream media to cover bitcoin again (which I assume it has).

Topic: Does anyone have data on wakeups they can turn into a graph? (Read 165 times)