case when BLOCK_TIMESTAMP>'2023-02-14' then 'after airdrop' else 'before aordrop' end as type ,

sum(PRICE_USD) as volume ,

count(distinct BUYER_ADDRESS) as active_users,

count(distinct NFT_ADDRESS) as unique_NFT ,

date_trunc(day,BLOCK_TIMESTAMP) as date ,

avg(PRICE_USD) as daily_NFT_price ,

min(PRICE_USD) as daily_NFT_min_price,

max(PRICE_USD) as daily_NFT_max_price

from

ethereum.core.ez_nft_sales

where

PLATFORM_NAME='blur'

group by 2 ,3, date