In an earlier contribution where I made a tutorial on how to access and use the Internal Currency Market, I mentioned that the contribution is motivated by educating more users to drive utilization of this feature. I have since been figuring out how to derive data points from arcange's Steem SQL around the activities in the Internal Currency Market.
I wanted to know:
- Who are the top market participants in terms of limit orders count
- How is the count of limit orders trending month over month
- How many users have done trading in the Internal Currency Market
Top 20 Internal Currency Market Participants
The chat above show how eight users make up seventy percent of all the transactions ever done in the Internal Currency Market. teamsmooth-mm in fact has done more transactions than the 13995 users I plotted as others in the chart. The data in table form for the Top 20 Participants and Others is shown below:
| User | Transaction Count | Percentage Share |
|---|---|---|
| teamsmooth-mm | 482754 | 32.44% |
| fnait | 166202 | 11.16% |
| paco-steem | 150009 | 10.08% |
| enki | 84030 | 5.64% |
| exec | 67580 | 4.54% |
| adm | 32956 | 2.21% |
| smooth-f | 30358 | 2.04% |
| cvk | 28145 | 1.89% |
| happychau123 | 23388 | 1.57% |
| jaewoocho | 18437 | 1.23% |
| adiel | 15806 | 1.06% |
| taker | 14021 | 0.94% |
| positive | 13048 | 0.87% |
| abit | 9941 | 0.66% |
| qonq99 | 9149 | 0.61% |
| emerge | 7001 | 0.47% |
| fermion | 5052 | 0.33% |
| alittle | 4820 | 0.32% |
| michelle.gent | 4772 | 0.32% |
| inphiknit | 3137 | 0.21% |
| others | 317352 | 21.32% |
Monthly Trend of Limit Order Transactions
As I called out in an earlier contribution, the Internal Currency Market is extremely under utilized. With the rate of growth in the user-base and new account created daily, there's hardly any movement to the count of trades done in the Internal Market over the last six months. Here is the data in table form on monthly limit orders count:
| Month-Year | Transaction Count |
|---|---|
| May-16 | 9 |
| Jun-16 | 28 |
| Jul-16 | 84886 |
| Aug-16 | 60987 |
| Sep-16 | 69869 |
| Oct-16 | 65088 |
| Nov-16 | 40087 |
| Dec-16 | 51137 |
| Jan-17 | 33627 |
| Feb-17 | 25413 |
| Mar-17 | 59729 |
| Apr-17 | 54437 |
| May-17 | 99469 |
| Jun-17 | 85744 |
| Jul-17 | 91306 |
| Aug-17 | 95942 |
| Sep-17 | 102439 |
| Oct-17 | 98194 |
With about 450,000++ users registered and 250,000++ active users, there are only 14,000++ users participating in the Internal Currency Market. That's only 3% of the registered users and <6% of the active users. Seventy percent of the Limit Order Transactions are done by only 0.0028% of the user-base. Two of my earlier contributions are suggested improvements in the Internal Currency Market, and a simplified tutorial on how to access and trade in the Internal Market; both in hope to increase utilization of the feature, and filling orders faster.
The top market participant teamsmooth-mm as shown in the below screenshot using SteemD has made 0 post, stayed at 25 reputation score while the account's been created fourteen months ago, have nearly 54,000 Steem and over 57,000 SBD. It can also be seen that the user has both a sell and buy order made at the same time.
The user is buying 150.137 Steem with 140.000 SBD
The user is selling 149.314 Steem for 140.00 SBD
The user teamsmooth-mm is effectively trading the 0.55% spread of the Internal Currency Market and has done it ten times in the last 3 hours according to Steemd getting him/her 5.5% of his capital.
The next top market participant fnait has gone inactive with last activity showing 51 days ago as shown in SteemD in the screenshot below.
The third top market participant paco-steem employ a different strategy than teamsmooth-mm. He is not trading the spread by having both a buy and sell order at the same time.
In the screenshot he bought 335.639 Steem with 312.959 SDB in 4 transactions (0.932427 SBD/Steem), then he sold 542.083 Steem for 506.962 SBD (0.935211 SBD/Steem) making 0.3%.
Thanks to arcange's Steem SQL, analysis like this is possible. I used the TxLimitOrders table to get the data for both Market Participants and Trend of Trades.
I used these queries:
SELECT COUNT(owner), Owner
FROM TxLimitOrders
GROUP BY Owner
SELECT
DATEADD(MONTH, DATEDIFF(MONTH, 0, timestamp), 0) AS [year_month_date_field], COUNT(amount_to_sell) COUNT
FROM
TxLimitOrders
GROUP BY timestamp
Posted on Utopian.io - Rewarding Open Source Contributors