select
project_name as nft_collection,
sum(price_usd) as sales_volume
from ethereum.core.ez_nft_sales
where
event_type = 'sale' and
price_usd is not null and
nft_collection is not null and
block_timestamp::date >= '2022-01-01' and
platform_name ilike '%opensea%' and
nft_collection != '%opensea%'
group by 1
order by 2 desc
limit 5