a as (

select

BLOCK_TIMESTAMP,

TX_HASH ,

SELLER_ADDRESS ,

BUYER_ADDRESS ,

NFT_ADDRESS ,

PROJECT_NAME ,

TOKENID ,

CURRENCY_SYMBOL ,

PRICE ,PRICE_USD ,PLATFORM_name

from ethereum.core.ez_nft_sales

where EVENT_TYPE='sale' and BLOCK_TIMESTAMP::date > '2022-05-01' AND PRICE >0 AND PRICE_USD >0

)

select

BLOCK_TIMESTAMP ::date as date ,

case when date between '2022-09-01' and '2022-09-14' then 'before'

when date between '2022-09-14' and '2022-09-15' then 'merge'

else 'after' end as dates ,

PLATFORM_name ,

count(distinct TX_HASH) as txs ,

count(distinct BUYER_ADDRESS) as buyers ,

count(distinct SELLER_ADDRESS) as sellers ,

count(distinct TOKENID) as token_id ,

count(distinct NFT_ADDRESS) as collections ,

------------------------------------------

sum(PRICE) as CURRENCY ,

sum(PRICE_USD) as USD ,

---------------------------------------

avg(PRICE) as avg_CURRENCY ,

avg(PRICE_USD) as avg_USD ,