amirozatop 10 asset swappers hold
    Updated 2022-07-06
    with swappers as (select distinct SWAPPER user
    from flipside_prod_db.algorand.swaps
    where 1=1
    and year(BLOCK_TIMESTAMP)=2022 and month(BLOCK_TIMESTAMP) in (5,6))
    select ASSET_NAME,count(*) asset_count
    from flipside_prod_db.algorand.account_asset
    where 1=1
    and ADDRESS in ( select user from swappers)
    and AMOUNT>0
    and ASSET_CLOSED=FALSE
    group by 1
    order by 2 desc
    limit 10
    Run a query to Download Data