date_trunc('day', block_timestamp) as date,

count(*) as no_of_txs,

avg(price) as eth_price,

avg(price_usd) as usd_price

from ethereum.core.ez_nft_sales

where nft_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b'

and event_type <> 'redeem'

group by 1

order by 1 desc