Many of you would have seen my tips ;] from last year, but i've had to stop tipping newbies and just provided an upvote here an there. It doesn't mean I won't restart the service again in the future. Thanks to the beauty of the blockchain I can show you how much I've tipped.
Thanks a lot to for his brilliant service http://www.steemsql.com which allows querying of the Steem blockchain using SQL Server.
Here is the query
DECLARE VARCHAR(50) = 'bottymcbotface'
select [FROM], sum(amount) 'Total SBD'
FROM [DBSteem].[dbo].[TxTransfers] tr
where [from] = and amount_symbol = 'SBD'
and ( [to] <> 'poloniex' and [to] <> 'bittrex' and [to] <> 'blocktrades' and [to] <> 'changelly')
group by [from]
select [FROM], sum(amount) 'Total STEEM'
FROM [DBSteem].[dbo].[TxTransfers] tr
where [from] = and amount_symbol = 'STEEM'
and ( [to] <> 'poloniex' and [to] <> 'bittrex' and [to] <> 'blocktrades' and [to] <> 'changelly')
group by [from]
This gives the following results
| FROM | Total SBD |
|---|---|
| bottymcbotface | 32.893 |
| FROM | Total STEEM |
|---|---|
| bottymcbotface | 348.325 |
Which using today's valuation from coinmarketcap.com is
32.893 *7.94 = $261.17
348.325 *5.92 = $2062.08
$261.17+ $2062.08 = $2323.25
I don't expect anything back by the way, they are a gift to the community. If you follow or upvote, that's a bonus for me :]
Image Source By