project_name,

sum(price) as volume_eth,

avg(price) as avg_nft_price

FROM ethereum.core.ez_nft_sales

block_timestamp::date >= '2022-10-19'

AND platform_name = 'opensea'

AND not project_name is NULL

group by 1

order by 2 desc

limit 10