select count (distinct A.address) as holders,ASSET_ID,ASSET_NAME
from flipside_prod_db.algorand.account
inner join flipside_prod_db.algorand.account_asset A on A.address=flipside_prod_db.algorand.account.ADDRESS
inner join flipside_prod_db.algorand.block B on B.block_id=flipside_prod_db.algorand.account.CREATED_AT
--inner join flipside_prod_db.algorand.swaps s on s.SWAPPER=flipside_prod_db.algorand.account.ADDRESS
where balance >1
and b.block_timestamp>= '2022-05-01' and b.block_timestamp <'2022-06-01'
group by ASSET_ID,ASSET_NAME
order by holders DESC
limit 50