block_timestamp::date as date,

avg(price) as eth_price

from ethereum.core.ez_nft_sales

where nft_address = lower('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb')

and price > 0 and event_type = 'sale'

and tx_hash != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0' -- Falsely raise the price transaction hash.

and year(date) >= 2022

group by 1