RE: Using hiveSQL to find content

[drniche]

Great post! Thank you for the illustration!Wondering if it is possible to check power down power up metrics using hive SQL..

Comments

[abh12345]

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

[drniche]

This is wonderful!! Thank you so much! I will try it out in the database tonight.