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:

1. Who are the top market participants in terms of limit orders count
2. How is the count of limit orders trending month over month
3. 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

---