nitsFlipside bounty receivers top ASA held
    Updated 2022-04-09
    with flipside as (SELECT * from algorand.payment_transaction
    where amount < 10000 and sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE')
    SELECT asset_name, count(DISTINCT address) as unique_holders from algorand.account_asset
    where address in (SELECT receiver from flipside) and amount > '0'
    GROUP by 1
    ORDER by 2 desc
    LIMIT 10
    Run a query to Download Data