Steemit Business Intelligence: Internal Market Participants & Transaction Trends
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
Hey @steemitph I am @utopian-io. I have just upvoted you at 22% Power!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x
wow I love this. One of the tables I had not yet studies is the limitorders table. Nice work
Thanks @paulag, the appreciation of my BI work from yourself may be more rewarding than the upvote. I am new in doing SQL queries and am wondering if there's a way I can reach you for questions when you have time.
yes, we have a community on discord were all the BI people meet up. Would love to see you over there https://discordapp.com/invite/JN7Yv7j
Thank you for the contribution. It has been approved.
[utopian-moderator]
Interesting to know, thanks for sharing @steemitph
The mm in @teamsmooth-mm means "market maker." This is a traditional role in order financial markets, now usually performed by large financial entities with sophisticated trading algorithms.
The role of the market maker is to ensure that orderly markets exist. The software automatically adjusts the bid and ask limit orders so as to keep a balanced book. As you pointed out, the Steem and SBD held are very similar amounts. This means that the software is working.
Compare that 0.55% spread to the spread on bittrex... And ask yourself, why should Steem/SBD have a lower spread on the low volume internal market compared to the spread on Steem/BTC on bittrex...
You can trade between Steem and SBD with very low spread because of the service the market maker performs. And as you pointed out, it can be very lucrative.