select label, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(nft_address)) as total_collection, count(DISTINCT(tokenid)) as total_nft,

sum(mint_price_usd) as volume , rank() over (order by volume desc) as rank

from ethereum.core.ez_nft_mints a join ethereum.core.dim_labels b on a.nft_address = b.address

where block_timestamp::date >= '2022-01-01' and block_timestamp::date < '2023-01-01'

and mint_price_usd > 0 and label not in ('uniswap','curve finance')

group by 1

qualify rank <= 30