--SQL by https://app.flipsidecrypto.com/velocity/queries/97e7e035-6aaf-48b4-9278-01a890e2a506
select address, label, sum(price_usd) as usd_volume , rank() over (order by usd_volume desc) as rank
from ethereum.core.ez_nft_sales a join ethereum.core.dim_labels b on a.nft_address = b.address
where block_timestamp >= '2022-01-01'
and (EVENT_TYPE = 'sale'
or event_type = 'bid_won')
and label <> 'uniswap'
and label <> 'curve finance'
and price_usd > 0
group by 1,2
order by 3 desc
limit 30