with nfts as (
select
asset_id,
asset_name,
creator_address
from flipside_prod_db.algorand.asset
where total_supply = 1
and decimals = 0
)
select
nfts.creator_address as nft_creator,
sum(transfers.asset_amount) as amount_algos
from flipside_prod_db.algorand.asset_transfer_transaction as transfers
inner join nfts on transfers.asset_id = nfts.asset_id
where transfers.block_timestamp >= '2022-05-01'
and transfers.block_timestamp < '2022-06-01'
and transfers.asset_amount is not null
group by nfts.creator_address
order by amount_algos desc
limit 5