SELECT

NFT_COLLECTION,

min(block_timestamp) as min_day

FROM flow.core.ez_nft_sales

GROUP BY 1

SELECT --DISTINCT mp

date_diff,

SPLIT(mp, '.')[2] as mp1,

count(DISTINCT tx_id) as sales,

count(DISTINCT BUYER) as buyers,

sum(price) as volume

from (

SELECT

tx_id,

tab1.NFT_COLLECTION as mp,

price,

buyer,

datediff('hour', min_day, block_timestamp) as date_diff

FROM flow.core.ez_nft_sales as a

LEFT outer JOIN tab1

on a.NFT_COLLECTION = tab1.NFT_COLLECTION

WHERE date_diff < 168

GROUP BY 1,2

having mp1 in ('Golazos', 'TopShot', 'AllDay', 'UFC_NFT', 'Basketballs', 'CricketMoments')