Exploring SmartCash and Shekel (JEW) BlockChain Data - BlockChain Business Intelligence

Both SmartCash and Shekel are POS coins allowing you to stake coins in your wallet or lock coins in and host a masternode.

Both Blockchains are open source.

Both Blockchains offer a Public API.

Shekel offers Zerocoin.

Zerocoin which has been implemented by Shekel Core, is a protocol that does what Bitcoin can not. Zerocoin provides full privacy to the users of JEW. The JEW implementation of the Zerocoin protocol converts publicly view-able JEW into anonymous zJEW (dubbed by the JEW team as Zerocoin JEW or zJEW for short). When a user wishes to spend zJEW, the JEW appear in the receivers wallet as regular JEW without history of where that JEW originated from”

Whereas SmartCash is what I call a workers platform, where one can submit a worker proposal to the Hive team, and those with a stake can vote on projects they would like to see funded.

The aim of this analysis was to explore the data presented in the public API for each coin and see what insights this data can provide.

SmartCash Blockchain Overview

The last 100 transactions on the SmartCash blockchain were made up of 4826 line items. The movement of coins in this 100 transactions was 1.05K BTC. Of this 1.67 BTC related to masternode Rewards. 99.84% of transactions did not relate to masternode rewards and can be classed as ‘True’ transactions.

It took 28K seconds for 100 transactions to happen equating to 0.00361 transactions per second.

The values in light purple have been taken from Coinmarketcap.

At the time of analysis a SmartCash masternode will cost you 0.23BTC or $2.45K USD.

Shekel Blockchain Overview

The last 100 transactions on the Shekel blockchain were made up of 286 line items. The movement of coins in this 100 transactions was 5.13 BTC. Of this 0.069 BTC related to masternode rewards.

98.65% of transactions did not relate to masternode rewards and can be classed as ‘True’ transactions.

It took 3246K seconds for 100 transactions to happen equating to 0.031 transactions per second.

The values in light purple have been taken from Coinmarketcap.

At the time of analysis a Shekel masternode will cost you 0.09BTC or $890 USD.

Comparisons

It costs 156% more to hold a masternode with SmartCash than with Shekel. There is also 882% more volume traded on exchanges of SmartCash than Shekel.

In terms of the blockchain, both SmartCash and Shekel have similar % of value in transactions that relate only to the masternodes and rewards. However, in 100 transactions the BTC equivalent value moved on SmartCash was 20K% higher than that of Shekel.

Further calculations based on the above data show that in 24 Hours Smartcash would move 3265 BTC and Shekel would move 134 BTC, which is 2.3K% higher.

The average value per transaction on SmartCash was 10.5 BTC and with Shekel it is was 0.05 BTC
On the Shekel blockchain, 100 transactions took place over 3246 seconds (0.03 transactions per second), compared with 28K seconds for SmartCash (0.0036 transactions per second). Transaction-wise, that make Shekel 10x more active.

Conclusion

As both Shekel and SmartCash are masternode coins, comparing their blockchains reveals a very interesting insight. I am surprised to see that SmartCash is 8x more expensive than Shekel per coin, while Shekel’s blockchain is 10x more active. The volume traded on exchanges seems to have more impact than the activity on the block.

Your Opinion Matters

I am using this as a base for a masternode review system and I want to hear from you.

What details are of importance to you when choosing a masternode?

What stats would you like to see?

Do you think block activity or block movement value are important factors in the future price of a masternode coin?

Based on the data and analysis above, which coin do you think is worth more and why?

Please do leave your comments and feedback below.

The Data and Queries

This analysis required connecting to the Shekel and SmartCash APIs. Both of these APIs return a JSON file. Using Power BI, I have extracted the data from the JSON file and sorted it into a meaningful format.

The query was pulled at 21 Feb 2018 17:15 GMT.

The complete M code used in Power BI query editor for SmartCash was:

let
Source = Json.Document(Web.Contents("https://explorer3.smartcash.cc/ext/getlasttxs/10/100")),
#"Converted to Table" = Record.ToTable(Source),
#"Expanded Value" = Table.ExpandListColumn(#"Converted to Table", "Value"),
#"Expanded Value1" = Table.ExpandRecordColumn(#"Expanded Value", "Value", {"_id", "txid", "blockhash", "__v", "blockindex", "timestamp", "total", "vout", "vin"}, {"_id", "txid", "blockhash", "__v", "blockindex", "timestamp", "total", "vout", "vin"}),
#"Expanded vout" = Table.ExpandListColumn(#"Expanded Value1", "vout"),
#"Expanded vout1" = Table.ExpandRecordColumn(#"Expanded vout", "vout", {"addresses", "amount"}, {"addresses", "amount"}),
#"Expanded addresses" = Table.ExpandListColumn(#"Expanded vout1", "addresses"),
#"Renamed Columns" = Table.RenameColumns(#"Expanded addresses",{{"addresses", "Rec address"}}),
#"Expanded vin" = Table.ExpandListColumn(#"Renamed Columns", "vin"),
#"Expanded vin1" = Table.ExpandRecordColumn(#"Expanded vin", "vin", {"addresses", "amount"}, {"addresses.1", "amount.1"}),
#"Renamed Columns1" = Table.RenameColumns(#"Expanded vin1",{{"addresses.1", "Sending address"}, {"amount", "sent amt"}, {"amount.1", "rec amt"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns1", "total SMART sent value", each [sent amt]/100000000),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "total SMART Rec value", each [rec amt]/100000000),
#"Changed Type" = Table.TransformColumnTypes(#"Added Custom1",{{"total SMART Rec value", type number}, {"total SMART sent value", type number}, {"rec amt", type number}, {"sent amt", type number}, {"total", type number}, {"timestamp", type number}, {"blockindex", type number}}),
#"Added Custom2" = Table.AddColumn(#"Changed Type", "coin", each "SMART")
in
#"Added Custom2"

The complete M code used in Power BI query editor for Shekel was:

let
Source = Json.Document(Web.Contents("http://jew.lchain.cc/ext/getlasttxs/10/100")),
#"Converted to Table" = Record.ToTable(Source),
#"Expanded Value" = Table.ExpandListColumn(#"Converted to Table", "Value"),
#"Expanded Value1" = Table.ExpandRecordColumn(#"Expanded Value", "Value", {"_id", "txid", "blockhash", "__v", "blockindex", "timestamp", "total", "vout", "vin"}, {"_id", "txid", "blockhash", "__v", "blockindex", "timestamp", "total", "vout", "vin"}),
#"Expanded vout" = Table.ExpandListColumn(#"Expanded Value1", "vout"),
#"Expanded vout1" = Table.ExpandRecordColumn(#"Expanded vout", "vout", {"addresses", "amount"}, {"addresses", "amount"}),
#"Renamed Columns" = Table.RenameColumns(#"Expanded vout1",{{"addresses", "rec. address"}}),
#"Expanded vin" = Table.ExpandListColumn(#"Renamed Columns", "vin"),
#"Expanded vin1" = Table.ExpandRecordColumn(#"Expanded vin", "vin", {"addresses", "amount"}, {"addresses.1", "amount.1"}),
#"Renamed Columns1" = Table.RenameColumns(#"Expanded vin1",{{"addresses.1", "sending address"}, {"amount", "sent amt"}, {"amount.1", "rec amt"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns1", "total Jew Sent Amount", each [sent amt]/100000000),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "total Jew rec Amount", each [rec amt]/100000000),
#"Changed Type" = Table.TransformColumnTypes(#"Added Custom1",{{"total Jew rec Amount", type number}, {"total Jew Sent Amount", type number}}),
#"Added Custom2" = Table.AddColumn(#"Changed Type", "Coin", each "JEW")
in
#"Added Custom2"

To get live data from Coinmarketcap, I also connected to the live ticker API for each of the coins and then carried out an append on each of the tables.

The full M code used in Power BI query editor was:

let
Source = Json.Document(Web.Contents("https://api.coinmarketcap.com/v1/ticker/shekel/")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "name", "symbol", "rank", "price_usd", "price_btc", "24h_volume_usd", "market_cap_usd", "available_supply", "total_supply", "max_supply", "percent_change_1h", "percent_change_24h", "percent_change_7d", "last_updated"}, {"id", "name", "symbol", "rank", "price_usd", "price_btc", "24h_volume_usd", "market_cap_usd", "available_supply", "total_supply", "max_supply", "percent_change_1h", "percent_change_24h", "percent_change_7d", "last_updated"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"rank", type number}, {"price_usd", type number}, {"price_btc", type number}, {"total_supply", type number}, {"24h_volume_usd", type number}, {"market_cap_usd", type number}}),
#"Appended Query" = Table.Combine({#"Changed Type", #"ticker (2)", #"ticker (3)"}),
#"Appended Query1" = Table.Combine({#"Appended Query", #"ticker (4)"})
in
#"Appended Query1"

Once I had gathered all of the data, I then carried out many calculations using DAX.

I am part of a Blockchain Business Intelligence community. We all post under the tag #blockchainbi. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #blockchainbi team and we will do our best to help you...

You can find #blockchainbi on discord https://discordapp.com/invite/JN7Yv7j

---

Posted on Utopian.io - Rewarding Open Source Contributors

---