select *

from ethereum.chainlink.ez_oracle_feeds

where feed_category = 'NFT Floor Prices (ETH pairs)'

and feed_name not in ('Cryptoadz Floor Price',

'World of Women Floor Price',

'CoolCats Floor Price')

and latest_answer_adj <> 0

and block_timestamp > '2022-11-18'

block_timestamp::date as date_day,

replace(feed_name,'Floor Price','') as feed_name,

avg(latest_answer_adj) as avg_floor_price

from base

group by 1,2

order by 1 desc, 3 asc