project_name,

date_trunc('month',block_timestamp) as date,

sum(CREATOR_FEE_USD) as royalties,

sum(price_usd) as volume,

count(distinct tx_hash) as sales

from ethereum.core.ez_nft_sales

where currency_symbol in ('WETH', 'ETH')

and block_timestamp >= '2022-01-01'

and price < 500

and nft_address in (

'0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d', --BAYC

'0x60e4d786628fea6478f785a6d7e704777c86a7c6', --MAYC

'0xed5af388653567af2f388e6224dc7c4b3241c544', --Azuki

'0x8a90cab2b38dba80c64b7734e58ee1db38b8992e', --Doodles

'0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b', --Clonex

'0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb', --Cryptopunks

'0xbd3531da5cf5857e7cfaa92426877b022e612cf8', --pudgy

'0x5af0d9827e0c53e4799bb226655a1de152a425a5', --milady

'0x8821bee2ba0df28761afff119d66390d594cd280' ---degods eth

group by 1, 2

order by 2 desc