with nft as (select
address,
address_name,
project_name
from polygon.core.dim_labels
where label_type = 'nft'
and (label_subtype = 'token_contract' or label_subtype = 'general_contract'))
select
from_address as nft_seller,
sum(amount_usd) as volume
from flipside_prod_db.polygon.udm_events a
join nft b on a.contract_address = b.address
where date(block_timestamp) >='2022-06-06'
and amount_usd is not null
group by 1
order by 2 desc
limit 10