when BLOCK_NUMBER >= 15537393 then 'After Merge'

END as A,

date_trunc('day',block_timestamp) as day,COUNT(DISTINCT BUYER_ADDRESS) as NFT_buyer,COUNT(DISTINCT NFT_ADDRESS) as Total_NFTs_purchased,

COUNT(distinct TX_HASH) as tx_count,sum(PRICE_USD) as price_in_USD,sum(PRICE) as price

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp >= '2022-09-01'

GROUP BY 1,2

ORDER BY 2 ASC