RE: Using hiveSQL to find content
You are viewing a single comment's thread:
Great post! Thank you for the illustration!Wondering if it is possible to check power down power up metrics using hive SQL..
0
0
0.000
You are viewing a single comment's thread:
Great post! Thank you for the illustration!Wondering if it is possible to check power down power up metrics using hive SQL..
Yes I think that is there.
Power ups
select * from txtransfers where [from] = 'drniche'
and type = 'transfer_to_vesting'
order by timestamp asc
Power downs are in Vests, and so the HIVE amount is only approximate (as the number VESTS per HIVE is constantly increasing).
select , vesting_shares525/10000000 as approx_HIVE from TxWithdraws
where account = 'abh12345' and vesting_shares <> '0.000000'
order by timestamp asc
From the Market Info tab on https://hivetasks.com/@drniche
This is wonderful!! Thank you so much! I will try it out in the database tonight.