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

[jackg]

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).

[1713308765]

1713308765

[tranthidung]

• 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

[Vod]

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]

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.