Some Statistics of RentSp 2024-08-20

justyy (82)in Witness Activities • 2 months ago

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

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)