In a previous analysis I explored the SmartCash API and the CRAVE API and made a comparison on the blockchains data.

If you missed the previous analysis you can read it here
https://steemit.com/utopian-io/@paulag/exploring-smartcash-and-crave-blockchain-data-blockchain-business-intelligence

In today’s analysis I will continue to analyse and compare masternode data but this time we will explore the SmartCash API and ZCoin API.

Both coins have a public API making it easy to compare blockchain transaction data once the API Json data has been extracted and transformed to a usable format.

Both coins are also listed on Coinmarketcap and on Masternodes.online.  This allows for further analysis and comparison in addition to the blockchain data.

Both coins have a similar Market Cap value.

## Aim of Analysis

•	To Explore and present ZCoin API data in a meaningful way

•	To Explore and present SmartCash API data in a meaningful way

•	Reveal insights hidden in the data

•	Compare SmartCash and ZCoin blockchain data

## ZCoin Data

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1521221365/tzpowiahrjec9bkshpum.png)

 
The last 100 transaction on the ZCoin blockchain were made up of 238 line items. These 100 transactions moved 29.42 BTC worth of ZCoins from 87 unique addresses to 30 unique addresses.
These 100 transactions took place over 1509 seconds. That equates to 0.066 transactions per second.

The values shown in light purple relate to data from Coinmarketcap. At the time of analysis the price of ZCoin was 0.00434 BTC or $35.56 USD.

1000 coins are required for a masternode with a value of $35,561 US$.  The marketcap. for ZCoin is 153.49M and the volume traded in the last 24 hours is $1.31M USD

Stats from Masternodes.online are shown below

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1521221380/aybveo9b3kwxnmkkamwm.png)
 

## SmartCash Data

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1521221393/ia7qeqhpec2deswv01fa.png)

 
The last 100 transaction on the SmartCash blockchain were made up of 449 line items. These 100 transactions moved 37.99 BTC worth of Smart from 61 unique addresses to 154 unique addresses.
These 100 transactions took place over 3489 seconds. That equates to 0.02866 transactions per second.

The values shown in light purple relate to data from Coinmarketcap. At the time of analysis the price of Smart was 0.00002237 BTC or $0.183 USD.

10000 coins are required for a masternode with a value of $1,841 US$.  The marketcap. for SMART is 146.27M and the volume traded in the last 24 hours is $135.17 USD.

Stats from Masternodes.online are shown below

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1521221410/gxji5dv2lubf0hm3qpi5.png)

 
## Comparison

The marketcap of ZCoin is 5% greater than SMART, however the volume of SMART traded is 90% less than that of ZCoin.

SMART move 23% more in BTC equivalent on the block in 100 transactions than ZCoin, however the non masternode rewards transactions on SMART were only 18% greater in BTC value than ZCoin.

In terms of transactions per second, ZCoin has 57% more transactions per second than SMART.

A ZCoin masternode will cost you 95% more than a SMART masternode.

Both the circulating supply and the total supply of ZCoin is almost 99% greater than SMART
 

## Conclusion
The ZCoin API proved easy enough to transform into meaningful data.  It was interesting to see when the data was captured that only 1.48% of the transaction on the block relate to Masternode rewards compared to almost 7% with SMART.

I chose these coins to analyse and compare as the Marketcap only has a small different.  However it seems that this is the only aspect with a small difference.

There is 90% or more difference in the Volumn traded, the coin price, the masternode price, the circulating supply and the total supply.

However although ZCoin is up 90% on all of these metrics, when it comes to activity on the block, SMART move more in terms of BTC value than ZCoin in 100 transactions. 18% more when it comes to excluding Masternode rewards.

If it takes 3489 seconds for SMART to move 35.47 BTC then SMART moves 0.01BTC per second
If it takes 1509 seconds for ZCoin to move 29.99 BTC then ZCoin move 0.02 BTC per second.  Twice that of SMART.

What makes one coin better than the other?  That I am still trying to work out.  In this case it seems that ZCoin is the more active blockchain as it moves more BTC per hour and has more transactions per hour than SMART.

In addition to this, ZCoin has 98% lower total supply, with almost 54% available supply locked in.  This makes ZCoin harder to get your hands on, increasing the value.

What would you make of this analysis and conclusion? Please do leave your comments and feedback
Would you like to see a comparison of your two favorite Masternode Coins?  If so and they have an API I can work with, then do leave your comments below. 

Analyzing coins in this way adds to the information already available for those considering investing in masternode coin.  However this is not meant as investment advice.  There are also other things to consider when investing in a masternode, such as the team, the road map, the community.

## The Data and Queries
Data snaps were taken at 11:30 GMT 16 March 2018

A number of queries were used to carry out this analysis.  Below are each of the MCodes used to both get the data and carry out transformations on the data so it can be used in a meaningful way.
1.	The code used to get data from coin marketcap for ZCoin was

``` language
let
    Source = Json.Document(Web.Contents("https://api.coinmarketcap.com/v1/ticker/zcoin/")),
    #"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}})
in
    #"Changed Type"
```


A similar code was used to get coinmarketcap for SmartCash however the url for the api was 
https://api.coinmarketcap.com/v1/ticker/smartcash/

2.	 The code used to get ZCoin sending and reciving transactions is made up of two queries, which are then appended together.  The append is included in the code

``` language
let
    Source = Json.Document(Web.Contents("https://explorer.zcoin.io/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 vin" = Table.ExpandListColumn(#"Expanded Value1", "vin"),
    #"Expanded vin1" = Table.ExpandRecordColumn(#"Expanded vin", "vin", {"addresses", "amount"}, {"addresses.1", "amount.1"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded vin1",{"vout"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"addresses.1", "sending address"}, {"amount.1", "sending amount"}}),
    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "sending amt ZCoin", each [sending amount]/100000000),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Coin", each "ZCoin")
in
    #"Added Custom1"
```


``` language
let
    Source = Json.Document(Web.Contents("https://explorer.zcoin.io/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"}}),
    #"Added Custom2" = Table.AddColumn(#"Renamed Columns", "Coin", each "ZCoin"),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom2",{"vin"}),
    #"Added Custom" = Table.AddColumn(#"Removed Columns", "Rec Amt ZCoin", each [amount]/100000000),
    #"Appended Query" = Table.Combine({#"Added Custom", zcoin}),
    #"Changed Type" = Table.TransformColumnTypes(#"Appended Query",{{"amount", type number}, {"Rec Amt ZCoin", type number}, {"sending amount", type number}, {"sending amt ZCoin", type number}})
in
    #"Changed Type"
```

3.	The M Code used to extract and transform the data from the SMART API was
``` language
let
    Source = Json.Document(Web.Contents("https://explorer3.smartcash.cc/ext/getlasttxs/10/1000")),
    #"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"
```




<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@paulag/3eibbc-exploring-and-comparing-zcoin-and-smartcash-blockchain-data-blockchain-business-intelligence">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>