select distinct

avg(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as AVG_PRICE,

min(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MIN_PRICE,

MAX(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MAX_PRICE,

COUNT( price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as Sale_count,

date_trunc('day',block_timestamp ) day

from ethereum.nft_events

where contract_address = lower('0x521f9c7505005cfa19a8e5786a9c3c9c9f5e6f42')

and event_type = 'sale'

and date_trunc('day',block_timestamp ) > '2021-06-25T09:55:55Z'

order by day--price_usd desc