Some Statistics of RentSp 2024-08-20

in steem •  3 months ago 

I 've run some queries on the Rent SP Tool and here we go:

image.png

So TLDR; 25 SP Leases, average rate is 0.14478, total interests received are 19434.472, and this includes 24.78 STEEM one-time fee. Total SP rented out (including completed/leasing) are 1259814.

mysql> select count(1), avg(rate),sum(amount),sum(fee),sum(sp_to_delegate)  from rentsp where result="completed" or result="leasing";
+----------+---------------------+-------------+-------------------+---------------------+
| count(1) | avg(rate)           | sum(amount) | sum(fee)          | sum(sp_to_delegate) |
+----------+---------------------+-------------+-------------------+---------------------+
|       25 | 0.14478799999999997 |   19434.472 | 24.77999999999999 |             1259814 |
+----------+---------------------+-------------+-------------------+---------------------+
1 row in set (0.00 sec)

mysql> select count(1), avg(rate),sum(amount),sum(fee),sum(sp_to_delegate) from rentsp where result="leasing";
+----------+---------------------+-------------+----------+---------------------+
| count(1) | avg(rate) | sum(amount) | sum(fee) | sum(sp_to_delegate) |
+----------+---------------------+-------------+----------+---------------------+
| 15 | 0.14281999999999997 | 16800.472 | 15.56 | 516291 |
+----------+---------------------+-------------+----------+---------------------+
1 row in set (0.01 sec)

mysql> select count(1), avg(rate),sum(amount),sum(fee),sum(sp_to_delegate) from rentsp where result="completed";
+----------+-----------+-------------+----------+---------------------+
| count(1) | avg(rate) | sum(amount) | sum(fee) | sum(sp_to_delegate) |
+----------+-----------+-------------+----------+---------------------+
| 10 | 0.14774 | 2634 | 9.22 | 743523 |
+----------+-----------+-------------+----------+---------------------+
1 row in set (0.00 sec)

TODO: I'll integrate these data into the page directedly soon.

Steem to the Moon🚀!

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE BLURT!