Hello Friends of Hive, $BEER and some other tokens,
Last week I had crashed my elasticsearch database. The result was, that I was not able to serve you with the weekly token statistics.
The good news is, it is repaired now.
Next friday I am going to create the weekly/monthly reports for $BEER, $LEO, $POB, $SIM and $CHARY
What I did to repair the database
Two things:
- I added the following statement into the elasticsearch config file:
pi@raspberrypi:/usr/share/elasticsearch/config $ cat elasticsearch.yml
...
path.data: /usr/share/elasticsearch/data
...
- I added the -v path parameter to the docker starting command:
docker run -p 9200:9200 -p 9300:9300 -e "discovery.type=single-node" -v /usr/share/elasticsearch/data:/usr/share/elasticsearch/data comworkio/elasticsearch:latest-arm
Now, the database is persistant, even when the docker container gets stopped.
Here, as an indemnification, I give you the
Beer Statistics for the last 18 days:
The timeframe is from 2021/05/11 - 2021/05/29.
Bought $BEER By Time
This figure shows who has bought how many $BEER at wich time:
Top Ten $BEER Buyers and $HIVE Sellers
The inside of the circle shows the Buyers of $BEER, ordered by $HIVE they have spent. The outside shows the recipients of that $HIVE (recipients of $BEER):
Commulated Amount Of Bought $BEER Per Person
This figure shows the top ten $BEER buyers, how much they got and how much $HIVE they spend for this. It is sorted by $HIVE, that was spent:
Table Of Top 10 $BEER Buyers
This table shows the top ten buyers of $TOKEN sorted by the $HIVE, they have spent:
| buyer.keyword: Descending | Sold $HIVE | Bought $BEER | Avg. Price |
|---|---|---|---|
| @primersion | 36.527084082365036 | 133.49999737739563 | 0.270090000970023 |
| @scottshots | 31.184499808761757 | 125.00000021280721 | 0.24997143021651677 |
| @saulos | 15.570724991790485 | 78.085000035353 | 0.18750000248352686 |
| @sharkthelion | 11.074080398805549 | 41.85578984496567 | 0.25535333156585693 |
| @rentmoney | 10.965338883237564 | 60.67448963996139 | 0.18132442768130982 |
| @cloudblade | 9.854529666830786 | 54.43359683593735 | 0.1809875157972177 |
| @biti | 8.875218638102524 | 35.00000074552372 | 0.23130658144752184 |
| @zoe24 | 8.426478085748386 | 45.62199898483232 | 0.18556281721050089 |
| @detlev | 7.301621619146317 | 32.020848363637924 | 0.2356917621458278 |
| @absolutfreedom | 7.2468788623809814 | 26.3833966255188 | 0.27470000584920246 |
| @other | 54.55316669383137 | 224.59732569081825 | 0.2156276700195965 |
Commulated Amount Of Sold $BEER Per Person
This figure shows the top ten $BEER Sellers, how much they sold and how much $HIVE they got for this, sorted by $HIVE:
Table Of Top 10 $BEER Sellers
This table shows the top ten sellers of $BEER Sorted by the $HIVE, they have got:
| seller.keyword: Descending | Earned $HIVE | Sold $BEER | Avg. Price |
|---|---|---|---|
| @cloudblade | 36.48846238479018 | 135.3135468661785 | 0.26516363566572015 |
| @methus | 15.043888539075851 | 58.67543637752533 | 0.23809249699115753 |
| @scottshots | 15 | 75 | 0.20000000298023224 |
| @rentmoney | 14.719683328643441 | 58.84683880954981 | 0.26255250349640846 |
| @atomcollector | 13.744499802589417 | 50.00000035762787 | 0.2748900055885315 |
| @bitandi | 12.78156728297472 | 55.19896135479212 | 0.2432001680135727 |
| @zoe24 | 7.5096874088048935 | 28.47065830230713 | 0.2602880001068115 |
| @fon | 6.979703426361084 | 25.390896320343018 | 0.2748900055885315 |
| @exator | 5.921064019203186 | 22.695631504058838 | 0.2612166702747345 |
| @heyantomei | 5.901875019073486 | 32.599117279052734 | 0.18104399740695953 |
| @other | 67.4891905194845 | 314.9813571853159 | 0.2009171364995522 |
Price of the $BEER
This figure shows the smoothed price of $BEER:
$BEER Summarize Metrics
Here one can see the sum of $TOKEN that was bought, the sum of $HIVE, that was sold and the average price (by count) of $TOKEN for the last period:
The price of $USD/$HIVE = 0.25006122 . The price of $HIVE/$BEER = 0.18500100 . The price of $USD/$BEER = .04626157
Disclaimer
All stats are without warranty.
They are taken from:
curl -XPOST -H "Content-type: application/json" -d '{ "jsonrpc": "2.0", "method": "find", "params": { "contract": "market", "table": "tradesHistory", "query": { "symbol": "TOKEN"}, "limit":1000, "offset": 0 }, "id": 1 }' 'https://api.hive-engine.com/rpc/contracts'
I have put them into logfiles and uploaded them to Kibana, from which I took the screenshots.
If you find errors, please tell me!
If you want to see other token statistics, please contact me. I can create them weekly or monthly if I get some upvotes for it.
For more details see here: How I Have Set Up Elasticsearch And Kibana On My Raspberry Pi To Monitor Token Activities and here: Do You Want To See Statistics Of Your Favorite HIVE Token? or on github.
Regards, Achim Mertens