articoloquintoTHORChain wallets with a balance of at least 1 RUNE
    Updated 2022-06-28
    select count(distinct "wallet") as "wallets" from(
    select "wallet", sum("amount") as "amount" from(
    select TO_ADDRESS as "wallet", sum(RUNE_AMOUNT) as "amount" from flipside_prod_db.thorchain.transfers
    where ASSET = 'THOR.RUNE'
    group by 1
    UNION
    select FROM_ADDRESS as "wallet", -(sum(RUNE_AMOUNT)) as "amount" from flipside_prod_db.thorchain.transfers
    where ASSET = 'THOR.RUNE'
    group by 1)
    group by 1)
    where "amount" >= 1

    Run a query to Download Data