date_trunc('day', s.BLOCK_TIMESTAMP) AS day,

AVG(s.PRICE_USD) AS average_price_usd

FROM

ethereum.nft.ez_nft_sales AS s

JOIN

ethereum.nft.ez_nft_transfers AS t ON s.TX_HASH = t.TX_HASH

WHERE

t.PROJECT_NAME = 'Radbro Webring V2'

GROUP BY

day

ORDER BY

day DESC;