Mityimpact
    Updated 2022-11-08
    select count( TX_ID)as sales_volume,count(distinct BUYER)as unique_buyer,count(distinct SELLER)as unique_seller
    , case
    when BLOCK_TIMESTAMP>'2022-05-15' and BLOCK_TIMESTAMP<='2022-05-30' then 'during the NBA Conference Finals'
    when BLOCK_TIMESTAMP>='2022-05-01' and BLOCK_TIMESTAMP<='2022-05-15' then 'before the NBA Conference Finals' end as nba_impact
    from flow.core.fact_nft_sales
    where NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'
    and nba_impact is not null
    group by 4