block_timestamp::date as date,

avg(price) as avg_price,

median(price) as median_price,

mode(price) as mode_price,

min(price) as floor_price,

max(price) as ceiling_price

FROM flow.core.ez_nft_sales a

LEFT JOIN flow.core.dim_contract_labels b

ON a.nft_collection = b.event_contract

WHERE b.contract_name = 'UFC_NFT'

AND date >= current_date - 90

AND date < current_date

group by 1, 2