You are viewing a single comment's thread from:

RE: Using hiveSQL to find content

in STEMGeeks • 4 years ago

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

image.png

4 years ago in STEMGeeks by
$0.00
    1 vote
    Reply 1
    Sort:  
  • Trending
    • [-]
     4 years ago  

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

    $0.00
      Reply