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,

round( SUM(round(price,4)) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )),4) as ETH_Sales,

round( SUM(round(price,4)) over (partition by contract_address order by contract_address),4) as Total_ETH_Sales,

'FVCK_CRYSTALS' AS NTF,

date_trunc('day',block_timestamp ) day,

avg(price) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as AVG_PRICE_ETH,

min(price) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MIN_PRICE_ETH,

MAX(price) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MAX_PRICE_ETH

from ethereum.nft_events

where contract_address = lower('0x7afeda4c714e1c0a2a1248332c100924506ac8e6')

and event_type = 'sale'

and date_trunc('day',block_timestamp ) > '2021-08-01T09:55:55Z'

and tx_currency <> 'CK' -- someone has part exed a crypto kitty and .9 eth which creates unhandlable number -- tx_id = '0x3316cc0239294d5676e98de49e4ca42222575412c101cb84ad35cde320091f2c' date_trunc('day',block_timestamp ) = '2021-08-10T18:00:00Z'

order by day--price_usd desc